DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_APPROVAL_WF

Line 759: hr_approval_wf.create_item_attrib_if_notexist

755: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,lv_item_name)): '|| l_proc);
756: FETCH csr_wiav into lv_dummy;
757: IF csr_wiav%notfound then
758: -- item attribute does not exist so create it
759: hr_approval_wf.create_item_attrib_if_notexist
760: (p_item_type => p_item_type,
761: p_item_key => p_item_key,
762: p_name => lv_item_name);
763: wf_engine.SetItemAttrNumber

Line 800: hr_approval_wf.create_item_attrib_if_notexist

796: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,ADDITIONAL_APPROVERS_NUMBER)): '|| l_proc);
797: FETCH csr_wiav into lv_dummy;
798: IF csr_wiav%notfound THEN
799: -- create new wf_item_attribute_value to hold the additional approvers number
800: hr_approval_wf.create_item_attrib_if_notexist
801: (p_item_type => p_item_type
802: ,p_item_key => p_item_key
803: ,p_name => 'ADDITIONAL_APPROVERS_NUMBER');
804:

Line 847: hr_approval_wf.create_item_attrib_if_notexist

843: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,lv_item_name)): '|| l_proc);
844: FETCH csr_wiav into lv_dummy;
845: IF csr_wiav%notfound then
846: -- item attribute does not exist so create it
847: hr_approval_wf.create_item_attrib_if_notexist
848: (p_item_type => p_item_type,
849: p_item_key => p_item_key,
850: p_name => lv_item_name);
851: wf_engine.SetItemAttrNumber

Line 917: hr_approval_wf.create_item_attrib_if_notexist

913: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,NOTIFIERS_NUMBER) ): '|| l_proc);
914: FETCH csr_wiav into lv_dummy;
915: IF csr_wiav%notfound THEN
916: -- create new wf_item_attribute_value to hold the additional approvers number
917: hr_approval_wf.create_item_attrib_if_notexist
918: (p_item_type => p_item_type
919: ,p_item_key => p_item_key
920: ,p_name => 'NOTIFIERS_NUMBER');
921:

Line 942: hr_approval_wf.create_item_attrib_if_notexist

938: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,APPROVAL_ENTRY_MODE) ): '|| l_proc);
939: FETCH csr_wiav into lv_dummy;
940: IF csr_wiav%notfound THEN
941: -- create new wf_item_attribute_value to hold
942: hr_approval_wf.create_item_attrib_if_notexist
943: (p_item_type => p_item_type
944: ,p_item_key => p_item_key
945: ,p_name => 'APPROVAL_ENTRY_MODE');
946:

Line 971: hr_approval_wf.create_item_attrib_if_notexist

967: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,LAST_DEFAULT_APPROVER)): '|| l_proc);
968: FETCH csr_wiav into lv_dummy;
969: IF csr_wiav%notfound THEN
970: -- create new wf_item_attribute_value to hold
971: hr_approval_wf.create_item_attrib_if_notexist
972: (p_item_type => p_item_type
973: ,p_item_key => p_item_key
974: ,p_name => 'LAST_DEFAULT_APPROVER');
975:

Line 1013: hr_approval_wf.create_item_attrib_if_notexist

1009: OPEN csr_wiav(p_item_type,p_item_key,'APPROVAL_LEVEL');
1010: FETCH csr_wiav into lv_dummy;
1011: IF csr_wiav%notfound THEN
1012: -- create new wf_item_attribute_value to hold
1013: hr_approval_wf.create_item_attrib_if_notexist
1014: (p_item_type => p_item_type
1015: ,p_item_key => p_item_key
1016: ,p_name => 'APPROVAL_LEVEL');
1017:

Line 1036: hr_approval_wf.create_item_attrib_if_notexist

1032: OPEN csr_wiav(p_item_type,p_item_key,'CURRENT_DEF_APPR_INDEX');
1033: FETCH csr_wiav into lv_dummy;
1034: IF csr_wiav%notfound THEN
1035: -- create new wf_item_attribute_value to hold
1036: hr_approval_wf.create_item_attrib_if_notexist
1037: (p_item_type => p_item_type
1038: ,p_item_key => p_item_key
1039: ,p_name => 'CURRENT_DEF_APPR_INDEX');
1040:

Line 1064: hr_approval_wf.create_item_attrib_if_notexist

1060: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,CURRENT_APPROVER_INDEX) ): '|| l_proc);
1061: FETCH csr_wiav into lv_dummy;
1062: IF csr_wiav%notfound THEN
1063: -- create new wf_item_attribute_value to hold
1064: hr_approval_wf.create_item_attrib_if_notexist
1065: (p_item_type => p_item_type
1066: ,p_item_key => p_item_key
1067: ,p_name => 'CURRENT_APPROVER_INDEX');
1068:

Line 1089: hr_approval_wf.create_item_attrib_if_notexist

1085: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,CURRENT_ONSUBMIT_INDEX) ): '|| l_proc);
1086: FETCH csr_wiav into lv_dummy;
1087: IF csr_wiav%notfound THEN
1088: -- create new wf_item_attribute_value to hold
1089: hr_approval_wf.create_item_attrib_if_notexist
1090: (p_item_type => p_item_type
1091: ,p_item_key => p_item_key
1092: ,p_name => 'CURRENT_ONSUBMIT_INDEX');
1093:

Line 1114: hr_approval_wf.create_item_attrib_if_notexist

1110: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,CURRENT_ONAPPROVAL_INDEX) ): '|| l_proc);
1111: FETCH csr_wiav into lv_dummy;
1112: IF csr_wiav%notfound THEN
1113: -- create new wf_item_attribute_value to hold
1114: hr_approval_wf.create_item_attrib_if_notexist
1115: (p_item_type => p_item_type
1116: ,p_item_key => p_item_key
1117: ,p_name => 'CURRENT_ONAPPROVAL_INDEX');
1118:

Line 3622: hr_approval_wf.create_item_attrib_if_notexist

3618: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(itemtype,itemkey,CURRENT_APPROVER_INDEX)):'|| l_proc);
3619: FETCH csr_wiav into lv_dummy;
3620: IF csr_wiav%notfound THEN
3621: -- create new wf_item_attribute_value to hold
3622: hr_approval_wf.create_item_attrib_if_notexist
3623: (p_item_type => itemtype
3624: ,p_item_key => itemkey
3625: ,p_name => 'CURRENT_APPROVER_INDEX');
3626:

Line 3719: hr_approval_wf.create_item_attrib_if_notexist

3715: hr_utility.trace('Going into FETCH after(OPEN csr_wiav(itemtype,itemkey,CURRENT_DEF_APPR_INDEX)):'|| l_proc);
3716: FETCH csr_wiav into lv_dummy;
3717: IF csr_wiav%notfound THEN
3718: -- create new wf_item_attribute_value to hold
3719: hr_approval_wf.create_item_attrib_if_notexist
3720: (p_item_type => itemtype
3721: ,p_item_key => itemkey
3722: ,p_name => 'CURRENT_DEF_APPR_INDEX');
3723:

Line 4015: hr_approval_wf.create_item_attrib_if_notexist

4011: hr_utility.trace('Going into FETCH after(OPEN csr_wiav(p_item_type,p_item_key,LAST_DEFAULT_APPROVER)): '|| l_proc);
4012: FETCH csr_wiav into l_dummy;
4013: IF csr_wiav%notfound THEN
4014: -- create new wf_item_attribute_value to hold
4015: hr_approval_wf.create_item_attrib_if_notexist
4016: (p_item_type => p_item_type
4017: ,p_item_key => p_item_key
4018: ,p_name => 'LAST_DEFAULT_APPROVER');
4019:

Line 4565: hr_approval_wf.create_item_attrib_if_notexist

4561: ,p_name => l_forward_to_username
4562: ,p_display_name => l_forward_to_disp_name);
4563:
4564: --
4565: hr_approval_wf.create_item_attrib_if_notexist
4566: (p_item_type => itemtype
4567: ,p_item_key => itemkey
4568: ,p_name => 'ONSUB_FWD_TO_PERSON_ID');
4569:

Line 4576: hr_approval_wf.create_item_attrib_if_notexist

4572: ,itemkey => itemkey
4573: ,aname => 'ONSUB_FWD_TO_PERSON_ID'
4574: ,avalue => l_forward_to_person_id);
4575: --
4576: hr_approval_wf.create_item_attrib_if_notexist
4577: (p_item_type => itemtype
4578: ,p_item_key => itemkey
4579: ,p_name => 'ONSUB_FWD_TO_USERNAME');
4580:

Line 4588: hr_approval_wf.create_item_attrib_if_notexist

4584: ,aname => 'ONSUB_FWD_TO_USERNAME'
4585: ,avalue => l_forward_to_username);
4586: --
4587:
4588: hr_approval_wf.create_item_attrib_if_notexist
4589: (p_item_type => itemtype
4590: ,p_item_key => itemkey
4591: ,p_name => 'ONSUB_FWD_TO_DISPLAY_NAME');
4592: wf_engine.SetItemAttrText

Line 4771: hr_approval_wf.create_item_attrib_if_notexist

4767: ,p_name => l_forward_to_username
4768: ,p_display_name => l_forward_to_disp_name);
4769:
4770: --
4771: hr_approval_wf.create_item_attrib_if_notexist
4772: (p_item_type => itemtype
4773: ,p_item_key => itemkey
4774: ,p_name => 'ONAPPR_FWD_TO_PERSON_ID');
4775: wf_engine.SetItemAttrNumber

Line 4781: hr_approval_wf.create_item_attrib_if_notexist

4777: ,itemkey => itemkey
4778: ,aname => 'ONAPPR_FWD_TO_PERSON_ID'
4779: ,avalue => l_forward_to_person_id);
4780: --
4781: hr_approval_wf.create_item_attrib_if_notexist
4782: (p_item_type => itemtype
4783: ,p_item_key => itemkey
4784: ,p_name => 'ONAPPR_FWD_TO_USERNAME');
4785: wf_engine.SetItemAttrText

Line 4791: hr_approval_wf.create_item_attrib_if_notexist

4787: ,itemkey => itemkey
4788: ,aname => 'ONAPPR_FWD_TO_USERNAME'
4789: ,avalue => l_forward_to_username);
4790: --
4791: hr_approval_wf.create_item_attrib_if_notexist
4792: (p_item_type => itemtype
4793: ,p_item_key => itemkey
4794: ,p_name => 'ONAPPR_FWD_TO_DISPLAY_NAME');
4795: wf_engine.SetItemAttrText

Line 5071: hr_approval_wf.create_item_attrib_if_notexist

5067: --
5068: -- Test that all new attributes exist and if they don't create them
5069:
5070: -- create new wf_item_attribute_value to hold the additional approvers number
5071: hr_approval_wf.create_item_attrib_if_notexist
5072: (p_item_type => itemtype
5073: ,p_item_key => itemkey
5074: ,p_name => 'ADDITIONAL_APPROVERS_NUMBER');
5075:

Line 5084: hr_approval_wf.create_item_attrib_if_notexist

5080: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(itemtype,itemkey,APPROVAL_LEVEL)): '|| l_proc);
5081: FETCH csr_wiav into l_dummy;
5082: IF csr_wiav%notfound THEN
5083: -- create new wf_item_attribute_value to hold
5084: hr_approval_wf.create_item_attrib_if_notexist
5085: (p_item_type => itemtype
5086: ,p_item_key => itemkey
5087: ,p_name => 'APPROVAL_LEVEL');
5088:

Line 5099: hr_approval_wf.create_item_attrib_if_notexist

5095: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(itemtype,itemkey,CURRENT_DEF_APPR_INDEX)): '|| l_proc);
5096: FETCH csr_wiav into l_dummy;
5097: IF csr_wiav%notfound THEN
5098: -- create new wf_item_attribute_value to hold
5099: hr_approval_wf.create_item_attrib_if_notexist
5100: (p_item_type => itemtype
5101: ,p_item_key => itemkey
5102: ,p_name => 'CURRENT_DEF_APPR_INDEX');
5103:

Line 5127: hr_approval_wf.create_item_attrib_if_notexist

5123: -- onsubmit and onapproval
5124:
5125: -- attributes for the onsubmit notification process
5126: -- CURRENT_ONSUBMIT_INDEX
5127: hr_approval_wf.create_item_attrib_if_notexist
5128: (p_item_type => itemtype
5129: ,p_item_key => itemkey
5130: ,p_name => 'CURRENT_ONSUBMIT_INDEX');
5131:

Line 5133: hr_approval_wf.create_item_attrib_if_notexist

5129: ,p_item_key => itemkey
5130: ,p_name => 'CURRENT_ONSUBMIT_INDEX');
5131:
5132: -- ONSUBMIT_START_INDEX
5133: hr_approval_wf.create_item_attrib_if_notexist
5134: (p_item_type => itemtype
5135: ,p_item_key => itemkey
5136: ,p_name => 'ONSUBMIT_START_INDEX');
5137:

Line 5139: hr_approval_wf.create_item_attrib_if_notexist

5135: ,p_item_key => itemkey
5136: ,p_name => 'ONSUBMIT_START_INDEX');
5137:
5138: -- ONSUBMIT_START_PERSON_ID
5139: hr_approval_wf.create_item_attrib_if_notexist
5140: (p_item_type => itemtype
5141: ,p_item_key => itemkey
5142: ,p_name => 'ONSUBMIT_START_PERSON_ID');
5143:

Line 5145: hr_approval_wf.create_item_attrib_if_notexist

5141: ,p_item_key => itemkey
5142: ,p_name => 'ONSUBMIT_START_PERSON_ID');
5143:
5144: -- ONSUBMIT_FORWARD_FROM_USERNAME
5145: hr_approval_wf.create_item_attrib_if_notexist
5146: (p_item_type => itemtype
5147: ,p_item_key => itemkey
5148: ,p_name => 'ONSUB_FWD_FROM_USERNAME');
5149: --

Line 5151: hr_approval_wf.create_item_attrib_if_notexist

5147: ,p_item_key => itemkey
5148: ,p_name => 'ONSUB_FWD_FROM_USERNAME');
5149: --
5150: -- ONSUBMIT_FORWARD_FROM_PERSON_ID
5151: hr_approval_wf.create_item_attrib_if_notexist
5152: (p_item_type => itemtype
5153: ,p_item_key => itemkey
5154: ,p_name => 'ONSUB_FWD_FROM_PERSON_ID');
5155: --

Line 5157: hr_approval_wf.create_item_attrib_if_notexist

5153: ,p_item_key => itemkey
5154: ,p_name => 'ONSUB_FWD_FROM_PERSON_ID');
5155: --
5156: -- ONSUBMIT_FORWARD_FROM_DISPLAY_NAME
5157: hr_approval_wf.create_item_attrib_if_notexist
5158: (p_item_type => itemtype
5159: ,p_item_key => itemkey
5160: ,p_name => 'ONSUB_FWD_FROM_DISPLAY_NAME');
5161: --

Line 5163: hr_approval_wf.create_item_attrib_if_notexist

5159: ,p_item_key => itemkey
5160: ,p_name => 'ONSUB_FWD_FROM_DISPLAY_NAME');
5161: --
5162: -- ONSUBMIT_FORWARD_TO_USERNAME
5163: hr_approval_wf.create_item_attrib_if_notexist
5164: (p_item_type => itemtype
5165: ,p_item_key => itemkey
5166: ,p_name => 'ONSUB_FWD_TO_USERNAME');
5167: --

Line 5169: hr_approval_wf.create_item_attrib_if_notexist

5165: ,p_item_key => itemkey
5166: ,p_name => 'ONSUB_FWD_TO_USERNAME');
5167: --
5168: -- FORWARD_TO_PERSON_ID
5169: hr_approval_wf.create_item_attrib_if_notexist
5170: (p_item_type => itemtype
5171: ,p_item_key => itemkey
5172: ,p_name => 'ONSUB_FWD_TO_PERSON_ID');
5173: --

Line 5175: hr_approval_wf.create_item_attrib_if_notexist

5171: ,p_item_key => itemkey
5172: ,p_name => 'ONSUB_FWD_TO_PERSON_ID');
5173: --
5174: -- FORWARD_TO_DISPLAY_NAME
5175: hr_approval_wf.create_item_attrib_if_notexist
5176: (p_item_type => itemtype
5177: ,p_item_key => itemkey
5178: ,p_name => 'ONSUB_FWD_TO_DISPLAY_NAME');
5179: --

Line 5183: hr_approval_wf.create_item_attrib_if_notexist

5179: --
5180: -- for onapproval notification process
5181:
5182: -- CURRENT_ONAPPROVAL_INDEX
5183: hr_approval_wf.create_item_attrib_if_notexist
5184: (p_item_type => itemtype
5185: ,p_item_key => itemkey
5186: ,p_name => 'CURRENT_ONAPPROVAL_INDEX');
5187:

Line 5189: hr_approval_wf.create_item_attrib_if_notexist

5185: ,p_item_key => itemkey
5186: ,p_name => 'CURRENT_ONAPPROVAL_INDEX');
5187:
5188: -- ONAPPROVAL_START_INDEX
5189: hr_approval_wf.create_item_attrib_if_notexist
5190: (p_item_type => itemtype
5191: ,p_item_key => itemkey
5192: ,p_name => 'ONAPPROVAL_START_INDEX');
5193: -- ONAPPROVAL_START_PERSON_ID

Line 5194: hr_approval_wf.create_item_attrib_if_notexist

5190: (p_item_type => itemtype
5191: ,p_item_key => itemkey
5192: ,p_name => 'ONAPPROVAL_START_INDEX');
5193: -- ONAPPROVAL_START_PERSON_ID
5194: hr_approval_wf.create_item_attrib_if_notexist
5195: (p_item_type => itemtype
5196: ,p_item_key => itemkey
5197: ,p_name => 'ONAPPROVAL_START_PERSON_ID');
5198:

Line 5200: hr_approval_wf.create_item_attrib_if_notexist

5196: ,p_item_key => itemkey
5197: ,p_name => 'ONAPPROVAL_START_PERSON_ID');
5198:
5199: -- ONAPPROVAL_FORWARD_FROM_USERNAME
5200: hr_approval_wf.create_item_attrib_if_notexist
5201: (p_item_type => itemtype
5202: ,p_item_key => itemkey
5203: ,p_name => 'ONAPPR_FWD_FROM_USERNAME');
5204: --

Line 5206: hr_approval_wf.create_item_attrib_if_notexist

5202: ,p_item_key => itemkey
5203: ,p_name => 'ONAPPR_FWD_FROM_USERNAME');
5204: --
5205: -- ONAPPROVAL_FORWARD_FROM_PERSON_ID
5206: hr_approval_wf.create_item_attrib_if_notexist
5207: (p_item_type => itemtype
5208: ,p_item_key => itemkey
5209: ,p_name => 'ONAPPR_FWD_FROM_PERSON_ID');
5210: --

Line 5212: hr_approval_wf.create_item_attrib_if_notexist

5208: ,p_item_key => itemkey
5209: ,p_name => 'ONAPPR_FWD_FROM_PERSON_ID');
5210: --
5211: -- ONAPPROVAL_FORWARD_FROM_DISPLAY_NAME
5212: hr_approval_wf.create_item_attrib_if_notexist
5213: (p_item_type => itemtype
5214: ,p_item_key => itemkey
5215: ,p_name => 'ONAPPR_FWD_FROM_DISPLAY_NAME');
5216: --

Line 5218: hr_approval_wf.create_item_attrib_if_notexist

5214: ,p_item_key => itemkey
5215: ,p_name => 'ONAPPR_FWD_FROM_DISPLAY_NAME');
5216: --
5217: -- ONAPPROVAL_FORWARD_TO_USERNAME
5218: hr_approval_wf.create_item_attrib_if_notexist
5219: (p_item_type => itemtype
5220: ,p_item_key => itemkey
5221: ,p_name => 'ONAPPR_FWD_TO_USERNAME');
5222: --

Line 5224: hr_approval_wf.create_item_attrib_if_notexist

5220: ,p_item_key => itemkey
5221: ,p_name => 'ONAPPR_FWD_TO_USERNAME');
5222: --
5223: -- ONAPPROVAL_FORWARD_TO_PERSON_ID
5224: hr_approval_wf.create_item_attrib_if_notexist
5225: (p_item_type => itemtype
5226: ,p_item_key => itemkey
5227: ,p_name => 'ONAPPR_FWD_TO_PERSON_ID');
5228: --

Line 5230: hr_approval_wf.create_item_attrib_if_notexist

5226: ,p_item_key => itemkey
5227: ,p_name => 'ONAPPR_FWD_TO_PERSON_ID');
5228: --
5229: -- ONAPPROVAL_FORWARD_TO_DISPLAY_NAME
5230: hr_approval_wf.create_item_attrib_if_notexist
5231: (p_item_type => itemtype
5232: ,p_item_key => itemkey
5233: ,p_name => 'ONAPPR_FWD_TO_DISPLAY_NAME');
5234: --