DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_APPROVAL_WF

Line 723: hr_approval_wf.create_item_attrib_if_notexist

719: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,lv_item_name)): '|| l_proc);
720: FETCH csr_wiav into lv_dummy;
721: IF csr_wiav%notfound then
722: -- item attribute does not exist so create it
723: hr_approval_wf.create_item_attrib_if_notexist
724: (p_item_type => p_item_type,
725: p_item_key => p_item_key,
726: p_name => lv_item_name);
727: wf_engine.SetItemAttrNumber

Line 764: hr_approval_wf.create_item_attrib_if_notexist

760: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,ADDITIONAL_APPROVERS_NUMBER)): '|| l_proc);
761: FETCH csr_wiav into lv_dummy;
762: IF csr_wiav%notfound THEN
763: -- create new wf_item_attribute_value to hold the additional approvers number
764: hr_approval_wf.create_item_attrib_if_notexist
765: (p_item_type => p_item_type
766: ,p_item_key => p_item_key
767: ,p_name => 'ADDITIONAL_APPROVERS_NUMBER');
768:

Line 811: hr_approval_wf.create_item_attrib_if_notexist

807: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,lv_item_name)): '|| l_proc);
808: FETCH csr_wiav into lv_dummy;
809: IF csr_wiav%notfound then
810: -- item attribute does not exist so create it
811: hr_approval_wf.create_item_attrib_if_notexist
812: (p_item_type => p_item_type,
813: p_item_key => p_item_key,
814: p_name => lv_item_name);
815: wf_engine.SetItemAttrNumber

Line 881: hr_approval_wf.create_item_attrib_if_notexist

877: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,NOTIFIERS_NUMBER) ): '|| l_proc);
878: FETCH csr_wiav into lv_dummy;
879: IF csr_wiav%notfound THEN
880: -- create new wf_item_attribute_value to hold the additional approvers number
881: hr_approval_wf.create_item_attrib_if_notexist
882: (p_item_type => p_item_type
883: ,p_item_key => p_item_key
884: ,p_name => 'NOTIFIERS_NUMBER');
885:

Line 906: hr_approval_wf.create_item_attrib_if_notexist

902: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,APPROVAL_ENTRY_MODE) ): '|| l_proc);
903: FETCH csr_wiav into lv_dummy;
904: IF csr_wiav%notfound THEN
905: -- create new wf_item_attribute_value to hold
906: hr_approval_wf.create_item_attrib_if_notexist
907: (p_item_type => p_item_type
908: ,p_item_key => p_item_key
909: ,p_name => 'APPROVAL_ENTRY_MODE');
910:

Line 935: hr_approval_wf.create_item_attrib_if_notexist

931: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,LAST_DEFAULT_APPROVER)): '|| l_proc);
932: FETCH csr_wiav into lv_dummy;
933: IF csr_wiav%notfound THEN
934: -- create new wf_item_attribute_value to hold
935: hr_approval_wf.create_item_attrib_if_notexist
936: (p_item_type => p_item_type
937: ,p_item_key => p_item_key
938: ,p_name => 'LAST_DEFAULT_APPROVER');
939:

Line 977: hr_approval_wf.create_item_attrib_if_notexist

973: OPEN csr_wiav(p_item_type,p_item_key,'APPROVAL_LEVEL');
974: FETCH csr_wiav into lv_dummy;
975: IF csr_wiav%notfound THEN
976: -- create new wf_item_attribute_value to hold
977: hr_approval_wf.create_item_attrib_if_notexist
978: (p_item_type => p_item_type
979: ,p_item_key => p_item_key
980: ,p_name => 'APPROVAL_LEVEL');
981:

Line 1000: hr_approval_wf.create_item_attrib_if_notexist

996: OPEN csr_wiav(p_item_type,p_item_key,'CURRENT_DEF_APPR_INDEX');
997: FETCH csr_wiav into lv_dummy;
998: IF csr_wiav%notfound THEN
999: -- create new wf_item_attribute_value to hold
1000: hr_approval_wf.create_item_attrib_if_notexist
1001: (p_item_type => p_item_type
1002: ,p_item_key => p_item_key
1003: ,p_name => 'CURRENT_DEF_APPR_INDEX');
1004:

Line 1028: hr_approval_wf.create_item_attrib_if_notexist

1024: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(p_item_type,p_item_key,CURRENT_APPROVER_INDEX) ): '|| l_proc);
1025: FETCH csr_wiav into lv_dummy;
1026: IF csr_wiav%notfound THEN
1027: -- create new wf_item_attribute_value to hold
1028: hr_approval_wf.create_item_attrib_if_notexist
1029: (p_item_type => p_item_type
1030: ,p_item_key => p_item_key
1031: ,p_name => 'CURRENT_APPROVER_INDEX');
1032:

Line 1053: hr_approval_wf.create_item_attrib_if_notexist

1049: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,CURRENT_ONSUBMIT_INDEX) ): '|| l_proc);
1050: FETCH csr_wiav into lv_dummy;
1051: IF csr_wiav%notfound THEN
1052: -- create new wf_item_attribute_value to hold
1053: hr_approval_wf.create_item_attrib_if_notexist
1054: (p_item_type => p_item_type
1055: ,p_item_key => p_item_key
1056: ,p_name => 'CURRENT_ONSUBMIT_INDEX');
1057:

Line 1078: hr_approval_wf.create_item_attrib_if_notexist

1074: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(p_item_type,p_item_key,CURRENT_ONAPPROVAL_INDEX) ): '|| l_proc);
1075: FETCH csr_wiav into lv_dummy;
1076: IF csr_wiav%notfound THEN
1077: -- create new wf_item_attribute_value to hold
1078: hr_approval_wf.create_item_attrib_if_notexist
1079: (p_item_type => p_item_type
1080: ,p_item_key => p_item_key
1081: ,p_name => 'CURRENT_ONAPPROVAL_INDEX');
1082:

Line 3550: hr_approval_wf.create_item_attrib_if_notexist

3546: hr_utility.trace('Going into Fetch after (OPEN csr_wiav(itemtype,itemkey,CURRENT_APPROVER_INDEX)):'|| l_proc);
3547: FETCH csr_wiav into lv_dummy;
3548: IF csr_wiav%notfound THEN
3549: -- create new wf_item_attribute_value to hold
3550: hr_approval_wf.create_item_attrib_if_notexist
3551: (p_item_type => itemtype
3552: ,p_item_key => itemkey
3553: ,p_name => 'CURRENT_APPROVER_INDEX');
3554:

Line 3647: hr_approval_wf.create_item_attrib_if_notexist

3643: hr_utility.trace('Going into FETCH after(OPEN csr_wiav(itemtype,itemkey,CURRENT_DEF_APPR_INDEX)):'|| l_proc);
3644: FETCH csr_wiav into lv_dummy;
3645: IF csr_wiav%notfound THEN
3646: -- create new wf_item_attribute_value to hold
3647: hr_approval_wf.create_item_attrib_if_notexist
3648: (p_item_type => itemtype
3649: ,p_item_key => itemkey
3650: ,p_name => 'CURRENT_DEF_APPR_INDEX');
3651:

Line 3899: hr_approval_wf.create_item_attrib_if_notexist

3895: hr_utility.trace('Going into FETCH after(OPEN csr_wiav(p_item_type,p_item_key,LAST_DEFAULT_APPROVER)): '|| l_proc);
3896: FETCH csr_wiav into l_dummy;
3897: IF csr_wiav%notfound THEN
3898: -- create new wf_item_attribute_value to hold
3899: hr_approval_wf.create_item_attrib_if_notexist
3900: (p_item_type => p_item_type
3901: ,p_item_key => p_item_key
3902: ,p_name => 'LAST_DEFAULT_APPROVER');
3903:

Line 4449: hr_approval_wf.create_item_attrib_if_notexist

4445: ,p_name => l_forward_to_username
4446: ,p_display_name => l_forward_to_disp_name);
4447:
4448: --
4449: hr_approval_wf.create_item_attrib_if_notexist
4450: (p_item_type => itemtype
4451: ,p_item_key => itemkey
4452: ,p_name => 'ONSUB_FWD_TO_PERSON_ID');
4453:

Line 4460: hr_approval_wf.create_item_attrib_if_notexist

4456: ,itemkey => itemkey
4457: ,aname => 'ONSUB_FWD_TO_PERSON_ID'
4458: ,avalue => l_forward_to_person_id);
4459: --
4460: hr_approval_wf.create_item_attrib_if_notexist
4461: (p_item_type => itemtype
4462: ,p_item_key => itemkey
4463: ,p_name => 'ONSUB_FWD_TO_USERNAME');
4464:

Line 4472: hr_approval_wf.create_item_attrib_if_notexist

4468: ,aname => 'ONSUB_FWD_TO_USERNAME'
4469: ,avalue => l_forward_to_username);
4470: --
4471:
4472: hr_approval_wf.create_item_attrib_if_notexist
4473: (p_item_type => itemtype
4474: ,p_item_key => itemkey
4475: ,p_name => 'ONSUB_FWD_TO_DISPLAY_NAME');
4476: wf_engine.SetItemAttrText

Line 4655: hr_approval_wf.create_item_attrib_if_notexist

4651: ,p_name => l_forward_to_username
4652: ,p_display_name => l_forward_to_disp_name);
4653:
4654: --
4655: hr_approval_wf.create_item_attrib_if_notexist
4656: (p_item_type => itemtype
4657: ,p_item_key => itemkey
4658: ,p_name => 'ONAPPR_FWD_TO_PERSON_ID');
4659: wf_engine.SetItemAttrNumber

Line 4665: hr_approval_wf.create_item_attrib_if_notexist

4661: ,itemkey => itemkey
4662: ,aname => 'ONAPPR_FWD_TO_PERSON_ID'
4663: ,avalue => l_forward_to_person_id);
4664: --
4665: hr_approval_wf.create_item_attrib_if_notexist
4666: (p_item_type => itemtype
4667: ,p_item_key => itemkey
4668: ,p_name => 'ONAPPR_FWD_TO_USERNAME');
4669: wf_engine.SetItemAttrText

Line 4675: hr_approval_wf.create_item_attrib_if_notexist

4671: ,itemkey => itemkey
4672: ,aname => 'ONAPPR_FWD_TO_USERNAME'
4673: ,avalue => l_forward_to_username);
4674: --
4675: hr_approval_wf.create_item_attrib_if_notexist
4676: (p_item_type => itemtype
4677: ,p_item_key => itemkey
4678: ,p_name => 'ONAPPR_FWD_TO_DISPLAY_NAME');
4679: wf_engine.SetItemAttrText

Line 4955: hr_approval_wf.create_item_attrib_if_notexist

4951: --
4952: -- Test that all new attributes exist and if they don't create them
4953:
4954: -- create new wf_item_attribute_value to hold the additional approvers number
4955: hr_approval_wf.create_item_attrib_if_notexist
4956: (p_item_type => itemtype
4957: ,p_item_key => itemkey
4958: ,p_name => 'ADDITIONAL_APPROVERS_NUMBER');
4959:

Line 4968: hr_approval_wf.create_item_attrib_if_notexist

4964: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(itemtype,itemkey,APPROVAL_LEVEL)): '|| l_proc);
4965: FETCH csr_wiav into l_dummy;
4966: IF csr_wiav%notfound THEN
4967: -- create new wf_item_attribute_value to hold
4968: hr_approval_wf.create_item_attrib_if_notexist
4969: (p_item_type => itemtype
4970: ,p_item_key => itemkey
4971: ,p_name => 'APPROVAL_LEVEL');
4972:

Line 4983: hr_approval_wf.create_item_attrib_if_notexist

4979: hr_utility.trace('Going into Fetch after ( OPEN csr_wiav(itemtype,itemkey,CURRENT_DEF_APPR_INDEX)): '|| l_proc);
4980: FETCH csr_wiav into l_dummy;
4981: IF csr_wiav%notfound THEN
4982: -- create new wf_item_attribute_value to hold
4983: hr_approval_wf.create_item_attrib_if_notexist
4984: (p_item_type => itemtype
4985: ,p_item_key => itemkey
4986: ,p_name => 'CURRENT_DEF_APPR_INDEX');
4987:

Line 5011: hr_approval_wf.create_item_attrib_if_notexist

5007: -- onsubmit and onapproval
5008:
5009: -- attributes for the onsubmit notification process
5010: -- CURRENT_ONSUBMIT_INDEX
5011: hr_approval_wf.create_item_attrib_if_notexist
5012: (p_item_type => itemtype
5013: ,p_item_key => itemkey
5014: ,p_name => 'CURRENT_ONSUBMIT_INDEX');
5015:

Line 5017: hr_approval_wf.create_item_attrib_if_notexist

5013: ,p_item_key => itemkey
5014: ,p_name => 'CURRENT_ONSUBMIT_INDEX');
5015:
5016: -- ONSUBMIT_START_INDEX
5017: hr_approval_wf.create_item_attrib_if_notexist
5018: (p_item_type => itemtype
5019: ,p_item_key => itemkey
5020: ,p_name => 'ONSUBMIT_START_INDEX');
5021:

Line 5023: hr_approval_wf.create_item_attrib_if_notexist

5019: ,p_item_key => itemkey
5020: ,p_name => 'ONSUBMIT_START_INDEX');
5021:
5022: -- ONSUBMIT_START_PERSON_ID
5023: hr_approval_wf.create_item_attrib_if_notexist
5024: (p_item_type => itemtype
5025: ,p_item_key => itemkey
5026: ,p_name => 'ONSUBMIT_START_PERSON_ID');
5027:

Line 5029: hr_approval_wf.create_item_attrib_if_notexist

5025: ,p_item_key => itemkey
5026: ,p_name => 'ONSUBMIT_START_PERSON_ID');
5027:
5028: -- ONSUBMIT_FORWARD_FROM_USERNAME
5029: hr_approval_wf.create_item_attrib_if_notexist
5030: (p_item_type => itemtype
5031: ,p_item_key => itemkey
5032: ,p_name => 'ONSUB_FWD_FROM_USERNAME');
5033: --

Line 5035: hr_approval_wf.create_item_attrib_if_notexist

5031: ,p_item_key => itemkey
5032: ,p_name => 'ONSUB_FWD_FROM_USERNAME');
5033: --
5034: -- ONSUBMIT_FORWARD_FROM_PERSON_ID
5035: hr_approval_wf.create_item_attrib_if_notexist
5036: (p_item_type => itemtype
5037: ,p_item_key => itemkey
5038: ,p_name => 'ONSUB_FWD_FROM_PERSON_ID');
5039: --

Line 5041: hr_approval_wf.create_item_attrib_if_notexist

5037: ,p_item_key => itemkey
5038: ,p_name => 'ONSUB_FWD_FROM_PERSON_ID');
5039: --
5040: -- ONSUBMIT_FORWARD_FROM_DISPLAY_NAME
5041: hr_approval_wf.create_item_attrib_if_notexist
5042: (p_item_type => itemtype
5043: ,p_item_key => itemkey
5044: ,p_name => 'ONSUB_FWD_FROM_DISPLAY_NAME');
5045: --

Line 5047: hr_approval_wf.create_item_attrib_if_notexist

5043: ,p_item_key => itemkey
5044: ,p_name => 'ONSUB_FWD_FROM_DISPLAY_NAME');
5045: --
5046: -- ONSUBMIT_FORWARD_TO_USERNAME
5047: hr_approval_wf.create_item_attrib_if_notexist
5048: (p_item_type => itemtype
5049: ,p_item_key => itemkey
5050: ,p_name => 'ONSUB_FWD_TO_USERNAME');
5051: --

Line 5053: hr_approval_wf.create_item_attrib_if_notexist

5049: ,p_item_key => itemkey
5050: ,p_name => 'ONSUB_FWD_TO_USERNAME');
5051: --
5052: -- FORWARD_TO_PERSON_ID
5053: hr_approval_wf.create_item_attrib_if_notexist
5054: (p_item_type => itemtype
5055: ,p_item_key => itemkey
5056: ,p_name => 'ONSUB_FWD_TO_PERSON_ID');
5057: --

Line 5059: hr_approval_wf.create_item_attrib_if_notexist

5055: ,p_item_key => itemkey
5056: ,p_name => 'ONSUB_FWD_TO_PERSON_ID');
5057: --
5058: -- FORWARD_TO_DISPLAY_NAME
5059: hr_approval_wf.create_item_attrib_if_notexist
5060: (p_item_type => itemtype
5061: ,p_item_key => itemkey
5062: ,p_name => 'ONSUB_FWD_TO_DISPLAY_NAME');
5063: --

Line 5067: hr_approval_wf.create_item_attrib_if_notexist

5063: --
5064: -- for onapproval notification process
5065:
5066: -- CURRENT_ONAPPROVAL_INDEX
5067: hr_approval_wf.create_item_attrib_if_notexist
5068: (p_item_type => itemtype
5069: ,p_item_key => itemkey
5070: ,p_name => 'CURRENT_ONAPPROVAL_INDEX');
5071:

Line 5073: hr_approval_wf.create_item_attrib_if_notexist

5069: ,p_item_key => itemkey
5070: ,p_name => 'CURRENT_ONAPPROVAL_INDEX');
5071:
5072: -- ONAPPROVAL_START_INDEX
5073: hr_approval_wf.create_item_attrib_if_notexist
5074: (p_item_type => itemtype
5075: ,p_item_key => itemkey
5076: ,p_name => 'ONAPPROVAL_START_INDEX');
5077: -- ONAPPROVAL_START_PERSON_ID

Line 5078: hr_approval_wf.create_item_attrib_if_notexist

5074: (p_item_type => itemtype
5075: ,p_item_key => itemkey
5076: ,p_name => 'ONAPPROVAL_START_INDEX');
5077: -- ONAPPROVAL_START_PERSON_ID
5078: hr_approval_wf.create_item_attrib_if_notexist
5079: (p_item_type => itemtype
5080: ,p_item_key => itemkey
5081: ,p_name => 'ONAPPROVAL_START_PERSON_ID');
5082:

Line 5084: hr_approval_wf.create_item_attrib_if_notexist

5080: ,p_item_key => itemkey
5081: ,p_name => 'ONAPPROVAL_START_PERSON_ID');
5082:
5083: -- ONAPPROVAL_FORWARD_FROM_USERNAME
5084: hr_approval_wf.create_item_attrib_if_notexist
5085: (p_item_type => itemtype
5086: ,p_item_key => itemkey
5087: ,p_name => 'ONAPPR_FWD_FROM_USERNAME');
5088: --

Line 5090: hr_approval_wf.create_item_attrib_if_notexist

5086: ,p_item_key => itemkey
5087: ,p_name => 'ONAPPR_FWD_FROM_USERNAME');
5088: --
5089: -- ONAPPROVAL_FORWARD_FROM_PERSON_ID
5090: hr_approval_wf.create_item_attrib_if_notexist
5091: (p_item_type => itemtype
5092: ,p_item_key => itemkey
5093: ,p_name => 'ONAPPR_FWD_FROM_PERSON_ID');
5094: --

Line 5096: hr_approval_wf.create_item_attrib_if_notexist

5092: ,p_item_key => itemkey
5093: ,p_name => 'ONAPPR_FWD_FROM_PERSON_ID');
5094: --
5095: -- ONAPPROVAL_FORWARD_FROM_DISPLAY_NAME
5096: hr_approval_wf.create_item_attrib_if_notexist
5097: (p_item_type => itemtype
5098: ,p_item_key => itemkey
5099: ,p_name => 'ONAPPR_FWD_FROM_DISPLAY_NAME');
5100: --

Line 5102: hr_approval_wf.create_item_attrib_if_notexist

5098: ,p_item_key => itemkey
5099: ,p_name => 'ONAPPR_FWD_FROM_DISPLAY_NAME');
5100: --
5101: -- ONAPPROVAL_FORWARD_TO_USERNAME
5102: hr_approval_wf.create_item_attrib_if_notexist
5103: (p_item_type => itemtype
5104: ,p_item_key => itemkey
5105: ,p_name => 'ONAPPR_FWD_TO_USERNAME');
5106: --

Line 5108: hr_approval_wf.create_item_attrib_if_notexist

5104: ,p_item_key => itemkey
5105: ,p_name => 'ONAPPR_FWD_TO_USERNAME');
5106: --
5107: -- ONAPPROVAL_FORWARD_TO_PERSON_ID
5108: hr_approval_wf.create_item_attrib_if_notexist
5109: (p_item_type => itemtype
5110: ,p_item_key => itemkey
5111: ,p_name => 'ONAPPR_FWD_TO_PERSON_ID');
5112: --

Line 5114: hr_approval_wf.create_item_attrib_if_notexist

5110: ,p_item_key => itemkey
5111: ,p_name => 'ONAPPR_FWD_TO_PERSON_ID');
5112: --
5113: -- ONAPPROVAL_FORWARD_TO_DISPLAY_NAME
5114: hr_approval_wf.create_item_attrib_if_notexist
5115: (p_item_type => itemtype
5116: ,p_item_key => itemkey
5117: ,p_name => 'ONAPPR_FWD_TO_DISPLAY_NAME');
5118: --