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.
ÉóÅúÁ´½ö½ö°üº¬×îÖÕÉóÅúÈË£¬¿ÉÒÔͨ¹ýÒ»¸öÀ
Ïà¹ØÎĵµ£º
Oracle ÊÓͼ
ÊÓͼ: Äã¿ÉÒÔͨ¹ý´´½¨±íµÄÊÓͼÀ´±íÏÖÊý¾ÝµÄÂß¼×Ó¼¯»òÊý¾ÝµÄ×éºÏ.ÊÓͼÊÇ»ùÓÚ±í»òÕßÁíÒ»¸ö
ÊÓͼµÄÂß¼±í,Ò»¸öÊÓͼ²¢²»°üº¬Ëü×Ô¼ºµÄÊý¾Ý,ËüÏóÒ»¸ö´°¿Ú,ͨ¹ý¸Ã´°¿Ú¿ÉÒԲ鿴»ò¸Ä±ä
  ......
Ò»¸öÔµĵÚÒ»Ìì
´úÂë (Ë«»÷´úÂ븴ÖƵ½Õ³Ìù°å)
SELECT to_date(to_char(SYSDATE,'yyyy-mm')||'-01','yyyy-mm-dd')
from dual
sysdate ΪÊý¾Ý¿â·þÎñÆ÷µÄµ±Ç°ÏµÍ³Ê±¼ä¡£
to_char Êǽ«ÈÕÆÚÐÍתΪ×Ö·ûÐ͵ĺ¯Êý¡£
to_date Êǽ«×Ö·ûÐÍתΪÈÕÆÚÐ͵ĺ¯Êý£¬Ò»°ãʹÓà yyyy-mm-dd hh24:mi:ss¸ñʽ£¬µ±Ã»ÓÐÖ¸¶¨Ê±¼ä²¿·Öʱ£¬ÔòÄ ......
ORACLE º¯Êý¿ª·¢
1¡¢½¨Á¢º¯ÊýµÄÓï·¨£º
CREATE [OR REPLACE] FUNCTION º¯ÊýÃû
[ (arg1 [mode] datatype[,........])] --µ±Ö¸¶¨²ÎÊýÊý¾ÝÀàÐÍʱ£¬²»ÄÜÖ¸¶¨Æ䳤¶È¡£modeÖµ£ºIN¡¢OUT¡¢IN OUT£¬µ±mode δָ¶¨Ê±£¬±íʾΪIN
RETURN datatype ......
ÔµÆðÒ»¸ö±í¿Õ¼äÌ«´ó,ɾ³ýÊý¾ÝºóÓÉÓÚÎļþβ±»ÓÃ,ÎÞ·¨resize,´òËã°ÑËùÓбí¿Õ¼äÉϵĶÔÏómoveµ½Ò»¸öÁÙʱ´æ´¢µÄ±í¿Õ¼ä×öÕûÀí¡£
moveÒ»¸ö±íµ½ÁíÍâÒ»¸ö±í¿Õ¼äʱ,Ë÷Òý²»»á¸ú×ÅÒ»Æðmove£¬¶øÇÒ»áʧЧ¡££¨LOBÀàÐÍÀýÍ⣩±ímove£¬ÎÒÃÇ·ÖΪ£º
*ÆÕͨ±ímove
*·ÖÇø±ímove
*LONG,LOB´ó×Ö¶ÎÀàÐÍmoveÀ´½øÐвâÊÔºÍ˵Ã÷¡£
Ë÷ÒýµÄmove£¬ÎÒÃÇÍ ......
Oracle 10gÖеÄEM²ÉÓÃWebµÄÐÎʽÀ´¹ÜÀíÊý¾Ý¿â¼°Ïà¹Ø·þÎñ£¬µ«Ê¹Óùý³ÌÖлáÅöµ½Ò»Ð©¸úEMÓйصÄÎÊÌ⣬¸ù¾ÝͬÐеÄÌáʾ¼°±ÊÕßµÄʵ¼Ê¾Ñ飬½øÐÐÁËһЩ¹éÄÉ£¬Ï£Íû¶ÔÏà¹Ø°®ºÃÕßÓÐËù°ïÖú£º
£¨1£©Êý¾Ý¿â¿ØÖÆ̨Æô¶¯ºó£¬¿´µ½1£©Êý¾Ý¿âʵÀýÎÞÐÅÏ¢2£©¼àÌý³ÌÐòΪ״̬Ϊ²»¿ÉÓÃ3£©µ½ÊµÀýµÄ´úÀíÁ¬½Ó״̬Ϊ²»¿ÉÓá£
ÎÊÌâ·ÖÎö£º
´Ëʱ·þÎñ¸ÕÆô ......