DBA Data[Home] [Help]

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_APPROVAL_CUSTOM

Line 182: hr_approval_custom.g_itemtype := p_itemtype;

178: -- Local Variables
179: l_proc constant varchar2(100) := g_package || ' SET_CUSTOM_WF_GLOBALS';
180: BEGIN
181: hr_utility.set_location('Entering: '|| l_proc,5);
182: hr_approval_custom.g_itemtype := p_itemtype;
183: hr_approval_custom.g_itemkey := p_itemkey;
184: hr_utility.set_location('Leaving: '|| l_proc,10);
185: END SET_CUSTOM_WF_GLOBALS;
186: --

Line 183: hr_approval_custom.g_itemkey := p_itemkey;

179: l_proc constant varchar2(100) := g_package || ' SET_CUSTOM_WF_GLOBALS';
180: BEGIN
181: hr_utility.set_location('Entering: '|| l_proc,5);
182: hr_approval_custom.g_itemtype := p_itemtype;
183: hr_approval_custom.g_itemkey := p_itemkey;
184: hr_utility.set_location('Leaving: '|| l_proc,10);
185: END SET_CUSTOM_WF_GLOBALS;
186: --
187:

Line 2121: lv_result := hr_approval_custom.Check_Final_approver

2117: LOOP
2118: lv_job_title:=NULL;
2119: -- Check for final approver
2120: BEGIN
2121: lv_result := hr_approval_custom.Check_Final_approver
2122: (p_forward_to_person_id => lv_forward_to_id
2123: ,p_person_id => lv_creator_person_id );
2124: EXCEPTION WHEN OTHERS THEN
2125: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 2142: lv_forward_to_id := hr_approval_custom.Get_Next_Approver

2138: END IF;
2139:
2140: -- get the next approver from the custom package
2141:
2142: lv_forward_to_id := hr_approval_custom.Get_Next_Approver
2143: (p_person_id => lv_current_forward_to_id);
2144:
2145:
2146:

Line 3628: hr_approval_custom.Get_Next_Approver

3624: -- fix for bug #2087458
3625: -- the l_current_forward_to_id resetting was removed for default approver.
3626: -- now the from column will show the last approver approved.
3627: l_forward_to_person_id :=
3628: hr_approval_custom.Get_Next_Approver
3629: (p_person_id => NVL(ln_last_default_approver_id,
3630: wf_engine.GetItemAttrNumber
3631: (itemtype => itemtype
3632: ,itemkey => itemkey

Line 3932: lv_response := hr_approval_custom.Check_Final_approver

3928: ,p_itemkey => p_item_key);
3929:
3930:
3931: -- check if we have default approvers
3932: lv_response := hr_approval_custom.Check_Final_approver
3933: (p_forward_to_person_id => ln_last_def_approver
3934: ,p_person_id => l_creator_person_id );
3935:
3936: IF lv_response <>'N' THEN

Line 3938: hr_approval_custom.Check_Final_approver

3934: ,p_person_id => l_creator_person_id );
3935:
3936: IF lv_response <>'N' THEN
3937: result := 'COMPLETE:'||
3938: hr_approval_custom.Check_Final_approver
3939: (p_forward_to_person_id => ln_last_def_approver
3940: ,p_person_id => l_creator_person_id );
3941: hr_utility.set_location('Leaving: '|| l_proc,25);
3942: return;

Line 4002: hr_approval_custom.Check_Final_approver

3998: END IF;
3999: ELSE
4000: hr_utility.trace('In Eelse of ( IF ln_approval_level > 0 THEN):'|| l_proc);
4001: result := 'COMPLETE:'||
4002: hr_approval_custom.Check_Final_approver
4003: (p_forward_to_person_id => ln_last_def_approver
4004: ,p_person_id => l_creator_person_id );
4005: END IF;
4006: