Oracle Approvals Management Actions
Actions
Every action belongs to an action type. An action type is a collection of actions having similar functionality. For example, actions in the absolute-job-level action type all require approvals up to a certain job level in the HR supervisory hierarchy.
ÿ¸öÐÐΪ¶¼ÊôÓÚÒ»ÖÖÐÐΪÀàÐÍ¡£Ã¿ÖÖÐÐΪÀàÐͶ¼ÊǾßÓÐÏàËÆ¹¦ÄܵÄÐÐΪ¼¯ºÏ¡£ÀýÈ磬ÊôÓÚ¾ø¶Ôְλ¼¶±ðµÄÐÐΪ¶¼ÐèÒªÏòÉÏͨ¹ýÈËÁ¦×ÊÔ´¹ÜÀí²ã´ÎÖеÄij¸ö¹Ì¶¨Ö°Î»¼¶±ðµÄÉóÅú
Ò»£®Action Type ÐÐΪÀàÐÍ
1£® Action-Type Name ÐÐΪÀàÐÍÃû×Ö
2£® Action-Type Handlers ÐÐΪÀàÐ;ä±ú
3£® Action-Type Descriptions ÐÐΪÀàÐÍÃèÊö
4£® Allowed Rule Types ÔÊÐíµÄ¹æÔòÀàÐÍ
5£® Allowed Approver Types ÔÊÐíµÄÉóÅúÀàÐÍ
6£® Order Numbers ÐòºÅ
7£® Chain-of-Authority Ordering Modes ÉóÅúÁ´µÄÅÅÐòģʽ
8£® Voting Regimes ͶƱ¹æÔò
¶þ£®Required Attributes ÐèÒªµÄÊôÐÔ
Èý£®Actions ÐÐΪ
Action Type
Chain Structure for HR Employee (Person) Approver Type
absolute job level ¾ø¶Ôְλ¼¶±ð
The chain ends with one or more approvers at, just under, or above a fixed job level.
ÉóÅúÁ´ÔÚijһ¹Ì¶¨Ö°Î»ÉÏϵÄÒ»¸ö»ò¶à¸öÉóÅúÈ˽áÊø
relative job level Ïà¶Ôְλ¼¶±ð
The chain ends with one or more approvers at, just under, or above a job level a fixed number of levels above the requestor's job level.
ÉóÅúÁ´ÔÚÇëÇóÈËÖ®ÉϵĶà¸ö¹Ì¶¨Ö°Î»ÉÏϵÄÒ»¸ö»ò¶à¸öÉóÅúÈ˽áÊø
manager then final approver ¾Àí—×îÖÕÉóÅúÈË
The chain includes the first and last approvers in the chain that would be generated by a similar absolute or relative-job-level action.
ÉóÅúÁ´°üº¬µÚÒ»ÉóÅúÈ˺Í×îÖÕÉóÅúÈË£¬¿ÉÒÔͨ¹ý´´½¨Ò»¸öÀàËÆµÄ¾ø¶Ô»òÏà¶Ôְλ¼¶±ðÀ´ÊµÏÖ¡£
final approver only ½ö½ö×îÖÕÉóÅúÈË
The chain includes just the last approver in the chain that would be generated by a similar absolute or relative-job-level action.
ÉóÅúÁ´½ö½ö°üº¬×îÖÕÉóÅúÈË£¬¿ÉÒÔͨ¹ýÒ»¸öÀ
Ïà¹ØÎĵµ£º
http://inthirties.com:90/thread-918-3-1.html
This article describes the installation of
Oracle 10g release 2 (10.2.0.1) RAC on Linux (Oracle Enterprise Linux
4.5) using NFS to provide the shared storage.
Introduction
Download Software
Operating System Installation
Oracle Installation Prereq ......
ƽʱ½Ó´¥mysql½Ï¶à£¬ÒòΪmysqlÔÚÒ»°ãµÄСÏîÄ¿Öй»ÓÃÁË ¿ªÔ´¶øÇÒÃâ·Ñ¡£
ºÜ¶à¹«Ë¾ÐèÒªoracleά»¤µÄ£¬¿ª·¢oracleÉõÖÁÊǶþ´Î¿ª·¢ÔÚ¹úÄÚÒ²±È½ÏÉٵģ¬Óм׹ÇÎĹ«Ë¾£¬Ë¸ÒºÍËûÃÇÇÀ·¹Íë°¡ ¹þ¹þ ²»¹ýÈ˼ҵÄÊÕ·ÑÂù¹óµÄ£¬ÄãÈç¹ûÓÐˮƽ£¬³Ôµã²Ð¸þµÄ»ú»áÂù¶à¡£ oracleµÄÅàѵÐÅÏ¢±í´ïÁËÊг¡ÐèÇó¡£
£¨ÎÒÔÚѧУ»·¾³µÄ²ÂÏ룬רҵÈËÊ¿À´ÅÄש ......
ÓÃdistinct¹Ø¼ü×ÖÖ»ÄܹýÂ˲éѯ×Ö¶ÎÖÐËùÓмǼÏàͬµÄ£¨¼Ç¼¼¯Ïàͬ£©£¬¶øÈç¹ûÒªÖ¸¶¨Ò»¸ö×Ö¶ÎȴûÓÐЧ¹û£¬ÁíÍâdistinct¹Ø¼ü×Ö»áÅÅÐò£¬Ð§Âʺܵ͡£
select distinct name from t1 ÄÜÏû³ýÖØ¸´¼Ç¼£¬µ«Ö»ÄÜȡһ¸ö×ֶΣ¬ÏÖÔÚҪͬʱȡid,nameÕâ2¸ö×ֶεÄÖµ¡£
select distinct id,name from t1 ¿ÉÒÔÈ¡¶à¸ö×ֶΣ¬µ«Ö»ÄÜÏû³ýÕâ2¸ö×Ö¶ ......
±íÊÇOracleÊý¾Ý¿â×î»ù±¾¶ÔÏñÖ®Ò»£¬Ëü´æ´¢Êµ¼ÊÊý¾Ý£¬ÓÉÐкÍÁÐ×é³ÉÒ»¸ö¶þά±í¡£
±íºÍÁеÄÃüÃûÒªÇó:
1.³¤¶È±ØÐëÔÚ30¸ö×Ö½ÚÖ®ÄÚ£¬×î¶Ì³¤¶È²»ÄÜÉÙ1¸ö×Ö½Ú
2.±ØÐëÊÇ×Öĸ¿ªÍ·
3.ÄܰüÀ¨×Öĸ¡¢ÊýÖµ¡¢Ï»®Ïß¡¢»õ±Ò·ûºÅ¡£½¨Òé×îºÃ²»ÒªÓûõ±Ò·ûºÅ
&n ......
ORACLE º¯Êý¿ª·¢
1¡¢½¨Á¢º¯ÊýµÄÓï·¨£º
CREATE [OR REPLACE] FUNCTION º¯ÊýÃû
[ (arg1 [mode] datatype[,........])] --µ±Ö¸¶¨²ÎÊýÊý¾ÝÀàÐÍʱ£¬²»ÄÜÖ¸¶¨Æä³¤¶È¡£modeÖµ£ºIN¡¢OUT¡¢IN OUT£¬µ±mode δָ¶¨Ê±£¬±íʾΪIN
RETURN datatype ......