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.
ÉóÅúÁ´½ö½ö°üº¬×îÖÕÉóÅúÈË£¬¿ÉÒÔͨ¹ýÒ»¸öÀ
Ïà¹ØÎĵµ£º
1 Ä¿µÄ
¹æ·¶Êý¾Ý¿â¸÷ÖÖ¶ÔÏóµÄÃüÃû¹æÔò¡£
2 Êý¾Ý¿âÃüÃûÔÔò
2.1 Êý¾ÝÎļþ
Èç¹ûÊý¾Ý¿â²ÉÓÃÎļþϵͳ£¬¶ø²»ÊÇÂãÉ豸£¬Ô¼¶¨ÏÂÁÐÃüÃû¹æÔò£º
1)Êý¾ÝÎļþÒÔ±í¿Õ¼äÃûΪ¿ªÊ¼£¬ÒÔ.dbfΪ½áβ£¬È«²¿²ÉÓÃСдӢÎÄ×Öĸ¼ÓÊý×ÖÃüÃû¡£Èç¸Ã±í¿Õ¼äÓжà¸öÊý¾ÝÎļþ£¬Ôò´ÓµÚ2¸öÊý¾ÝÎļþ¿ªÊ¼£¬ÔÚ±í¿Õ¼äÃûºó¼Ó_¡£
Àý£º¶Ôsystem±í¿Õ¼äµÄÊý ......
ÔÚÊý¾Ý¿âÆô¶¯2Сʱºó£¬¿ÉÒÔͨ¹ýÒÔÏÂSQLÀ´²âÊÔÊý¾Ý¿âÐÔÄÜ
1. »º³åÇøÃüÖÐÂÊ:
»º³åÇøÃüÖÐÂʱíʾÔÚ²»ÐèÒª½øÐдÅÅÌ·ÃÎʵÄÇé¿öÏÂÔÚÄÚ´æ½á¹¹ÖÐÕÒµ½³£ÓÃÊý¾Ý¿éµÄƵÂÊ
select (1-(sum(decode(name, 'physical reads',value,0))/(sum(decode(name, 'db block gets',value,0))
......
ojdbc14.jarÓëclasses12.jarÓÐÊ²Ã´Çø±ð??
×î½üÓÃclasses12.jar£¬hibernate3.1ÀÏÊdzöÎÊÌ⣿
ÎÒµÄoracle9.2.0.10!
ÔÚÍøÉÏÕÒ£¬·¢ÏÖÓÐÈËÓÃojdbc14.jar¿ª·¢£¬Ã»ÓÐÓùýÄØ£¿¿´oracleµÄreadme.txtҲûÓп´Ê²Ã´ÄØ£¿
ÄÇλ´ó¸çÖªµÀ˵һÏ£¡Ê®·Ö¸Ðл£¡
------------------------------------------------------------------------- ......
ÏîÄ¿ÖÐÓõ½µÄpartition£¬×ܽáÕûÀíÒ»ÏÂÏà¹ØÖªÊ¶¡££¨ÍøÉϲɼ¯£¬ÈçÓÐÇÖȨ£¬Ç뼰ʱÁªÏµ¡££©
Ò»¡¢Oracle·ÖÇø¼ò½é
ORACLEµÄ·ÖÇøÊÇÒ»ÖÖ´¦Àí³¬´óÐÍ±í¡¢Ë÷ÒýµÈµÄ¼¼Êõ¡£·ÖÇøÊÇÒ»ÖÖ“·Ö¶øÖÎÖ®”µÄ¼¼Êõ£¬Í¨¹ý½«´ó±íºÍË÷Òý·Ö³É¿ÉÒÔ¹ÜÀíµÄС¿é£¬´Ó¶ø±ÜÃâÁ˶Ôÿ¸ö±í×÷Ϊһ¸ö´óµÄ¡¢µ¥¶ÀµÄ¶ÔÏó½øÐйÜÀí£¬Îª´óÁ¿Êý¾ÝÌṩ ......
oracle·ÖÎöº¯ÊýÊ®·ÖÇ¿´ó£¬ÎÒÃÇÖ»ÒªÕÆÎÕÕâЩ·½·¨£¬¸üÖ±½ÓµÄ˵·¨¾ÍÊÇÖªµÀÕâЩ·ÖÎöº¯ÊýµÄ×÷ÓþÍÄÜÍê³ÉºÜ¶à¹¤×÷¡£
ϱßÌù³öÕâЩº¯Êý£¬¼°¼òµ¥Ó¦Óá£
ÆäÖÐÎÒÏë¶Ôlag£¨£©ºÍlead£¨£©º¯Êý×øÏÂ˵Ã÷£ºlag£¨£©±¾ÉíÊÇÑÓºóµÄÒâ˼Ҳ¾ÍÊÇÑÓºó³öÏÖijÁеÄÊý£¬¶ølead£¨£©ÓÐÒýÁì¡¢ÁìÏȵÄÒâ˼Ҳ¾ÍÊÇÌáǰ¼¸ÐÐÏÔʾijÁÐÊý¾Ý
RANK()
dense_rank() ......