DBA Data[Home] [Help]

APPS.HR_APPROVAL_WF dependencies on HR_APPROVAL_CUSTOM

Line 62: hr_approval_custom.g_itemtype := p_itemtype;

58: procedure set_custom_wf_globals
59: (p_itemtype in varchar2
60: ,p_itemkey in varchar2) is
61: begin
62: hr_approval_custom.g_itemtype := p_itemtype;
63: hr_approval_custom.g_itemkey := p_itemkey;
64: end set_custom_wf_globals;
65: --
66: -- --------------------------------------------------------------------

Line 63: hr_approval_custom.g_itemkey := p_itemkey;

59: (p_itemtype in varchar2
60: ,p_itemkey in varchar2) is
61: begin
62: hr_approval_custom.g_itemtype := p_itemtype;
63: hr_approval_custom.g_itemkey := p_itemkey;
64: end set_custom_wf_globals;
65: --
66: -- --------------------------------------------------------------------
67: -- |------------------------< Set_Routing_Details >--------------------|

Line 547: l_approval_routing_id := hr_approval_custom.get_routing_details1

543: ,p_itemkey => itemkey);
544: --
545: -- get the routing id
546: --
547: l_approval_routing_id := hr_approval_custom.get_routing_details1
548: (p_person_id => l_creator_person_id);
549: --
550: -- Set the routing details
551: set_routing_details

Line 601: l_approval_routing_id := hr_approval_custom.get_routing_details2

597: ,p_itemkey => itemkey);
598: --
599: -- get the routing id
600: --
601: l_approval_routing_id := hr_approval_custom.get_routing_details2
602: (p_person_id => l_creator_person_id);
603: --
604: -- Set the routing details
605: set_routing_details

Line 657: l_approval_routing_id := hr_approval_custom.get_routing_details3

653: ,p_itemkey => itemkey);
654: --
655: -- get the routing id
656: --
657: l_approval_routing_id := hr_approval_custom.get_routing_details3
658: (p_person_id => l_creator_person_id);
659: -- Set the routing details
660: set_routing_details
661: (p_item_type => itemtype

Line 710: l_approval_routing_id := hr_approval_custom.get_routing_details4

706: aname => 'CREATOR_PERSON_ID' );
707: --
708: -- get the routing id
709: --
710: l_approval_routing_id := hr_approval_custom.get_routing_details4
711: (p_person_id => l_creator_person_id);
712: -- -----------------------------------------------------------------------
713: -- expose the wf control variables to the custom package
714: -- -----------------------------------------------------------------------

Line 771: l_approval_routing_id := hr_approval_custom.get_routing_details5

767: ,p_itemkey => itemkey);
768: --
769: -- get the routing id
770: --
771: l_approval_routing_id := hr_approval_custom.get_routing_details5
772: (p_person_id => l_creator_person_id);
773: --
774: -- Set the routing details
775: set_routing_details

Line 819: l_url := hr_approval_custom.get_URL1;

815: ,p_itemkey => itemkey);
816: --
817: -- get the url
818: --
819: l_url := hr_approval_custom.get_URL1;
820: --
821: -- Set the routing details
822: set_URL
823: (p_item_type => itemtype

Line 866: l_url := hr_approval_custom.get_URL2;

862: ,p_itemkey => itemkey);
863: --
864: -- get the url
865: --
866: l_url := hr_approval_custom.get_URL2;
867: --
868: -- Set the routing details
869: set_URL
870: (p_item_type => itemtype

Line 913: l_url := hr_approval_custom.get_URL3;

909: ,p_itemkey => itemkey);
910: --
911: -- get the url
912: --
913: l_url := hr_approval_custom.get_URL3;
914: --
915: -- Set the routing details
916: set_URL
917: (p_item_type => itemtype

Line 960: l_url := hr_approval_custom.get_URL4;

956: ,p_itemkey => itemkey);
957: --
958: -- get the url
959: --
960: l_url := hr_approval_custom.get_URL4;
961: --
962: -- Set the routing details
963: set_URL
964: (p_item_type => itemtype

Line 1009: l_url := hr_approval_custom.get_URL5;

1005: ,p_itemkey => itemkey);
1006: --
1007: -- get the url
1008: --
1009: l_url := hr_approval_custom.get_URL5;
1010: -- Set the routing details
1011: set_URL
1012: (p_item_type => itemtype
1013: ,p_item_key => itemkey

Line 1056: l_url := hr_approval_custom.get_URL6;

1052: ,p_itemkey => itemkey);
1053: --
1054: -- get the url
1055: --
1056: l_url := hr_approval_custom.get_URL6;
1057: if l_url is null then
1058: l_url := icx_sec.jumpintofunction
1059: (p_application_id => 800
1060: ,p_function_code => 'PER_CALL_ON_FLOW_FUN'

Line 1119: l_url := hr_approval_custom.get_URL7;

1115: ,p_itemkey => itemkey);
1116: --
1117: -- get the url
1118: --
1119: l_url := hr_approval_custom.get_URL7;
1120: if l_url is null then
1121: l_vacancy_id := to_number(wf_engine.getitemattrtext
1122: (itemtype => itemtype,
1123: itemkey => itemkey,

Line 1186: l_url := hr_approval_custom.get_URL8;

1182: ,p_itemkey => itemkey);
1183: --
1184: -- get the url
1185: --
1186: l_url := hr_approval_custom.get_URL8;
1187: if l_url is null then
1188: l_person_id := wf_engine.getitemattrnumber
1189: (itemtype => itemtype,
1190: itemkey => itemkey,

Line 1248: l_url := hr_approval_custom.get_URL9;

1244: ,p_itemkey => itemkey);
1245: --
1246: -- get the url
1247: --
1248: l_url := hr_approval_custom.get_URL9;
1249: if l_url is null then
1250: l_person_id := wf_engine.GetItemAttrNumber
1251: (itemtype => itemtype,
1252: itemkey => itemkey,

Line 1313: l_url := hr_approval_custom.get_URL10;

1309: ,p_itemkey => itemkey);
1310: --
1311: -- get the url
1312: --
1313: l_url := hr_approval_custom.get_URL10;
1314: if l_url is null then
1315: l_person_id := wf_engine.GetItemAttrNumber
1316: (itemtype => itemtype,
1317: itemkey => itemkey,

Line 1374: l_url := hr_approval_custom.get_URL11;

1370: ,p_itemkey => itemkey);
1371: --
1372: -- get the url
1373: --
1374: l_url := hr_approval_custom.get_URL11;
1375: if l_url is null then
1376: l_event_id := to_number(wf_engine.getitemattrtext
1377: (itemtype => itemtype
1378: ,itemkey => itemkey

Line 1444: l_url := hr_approval_custom.get_URL12;

1440: ,p_itemkey => itemkey);
1441: --
1442: -- get the url
1443: --
1444: l_url := hr_approval_custom.get_URL12;
1445: if l_url is null then
1446: l_person_id := wf_engine.GetItemAttrNumber
1447: (itemtype => itemtype
1448: ,itemkey => itemkey

Line 1516: l_url := hr_approval_custom.get_URL13;

1512: ,p_itemkey => itemkey);
1513: --
1514: -- get the url
1515: --
1516: l_url := hr_approval_custom.get_URL13;
1517: if l_url is null then
1518: l_person_id := wf_engine.GetItemAttrNumber
1519: (itemtype => itemtype,
1520: itemkey => itemkey,

Line 1580: l_url := hr_approval_custom.get_URL14;

1576: ,p_itemkey => itemkey);
1577: --
1578: -- get the url
1579: --
1580: l_url := hr_approval_custom.get_URL14;
1581: --
1582: if l_url is null then
1583: l_url :=
1584: 'ota_class_signup_wf.url?'||

Line 1653: hr_approval_custom.Check_Final_approver

1649: --
1650: -- call a custom check final approver. Returns a 'Yes', 'No' or 'Error'
1651: --
1652: result := 'COMPLETE:'||
1653: hr_approval_custom.Check_Final_approver
1654: (p_forward_to_person_id => nvl(l_forward_to_person_id,l_creator_person_id)
1655: ,p_person_id => l_creator_person_id );
1656: --
1657: elsif ( funmode = 'CANCEL' ) then

Line 1720: hr_approval_custom.Get_Next_Approver

1716: --
1717: -- set the next forward to
1718: --
1719: l_forward_to_person_id :=
1720: hr_approval_custom.Get_Next_Approver
1721: (p_person_id => l_current_forward_to_id);
1722: --
1723: if ( l_forward_to_person_id is null ) then
1724: --

Line 2004: hr_approval_custom.Get_Next_Approver

2000: --
2001: -- set the next forward to
2002: --
2003: personid :=
2004: hr_approval_custom.Get_Next_Approver
2005: (p_person_id => currentapproverid);
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN