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 2191: lv_result := hr_approval_custom.Check_Final_approver

2187: LOOP
2188: lv_job_title:=NULL;
2189: -- Check for final approver
2190: BEGIN
2191: lv_result := hr_approval_custom.Check_Final_approver
2192: (p_forward_to_person_id => lv_forward_to_id
2193: ,p_person_id => lv_creator_person_id );
2194: EXCEPTION WHEN OTHERS THEN
2195: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 2212: lv_forward_to_id := hr_approval_custom.Get_Next_Approver

2208: END IF;
2209:
2210: -- get the next approver from the custom package
2211:
2212: lv_forward_to_id := hr_approval_custom.Get_Next_Approver
2213: (p_person_id => lv_current_forward_to_id);
2214:
2215:
2216:

Line 3700: hr_approval_custom.Get_Next_Approver

3696: -- fix for bug #2087458
3697: -- the l_current_forward_to_id resetting was removed for default approver.
3698: -- now the from column will show the last approver approved.
3699: l_forward_to_person_id :=
3700: hr_approval_custom.Get_Next_Approver
3701: (p_person_id => NVL(ln_last_default_approver_id,
3702: wf_engine.GetItemAttrNumber
3703: (itemtype => itemtype
3704: ,itemkey => itemkey

Line 4048: lv_response := hr_approval_custom.Check_Final_approver

4044: ,p_itemkey => p_item_key);
4045:
4046:
4047: -- check if we have default approvers
4048: lv_response := hr_approval_custom.Check_Final_approver
4049: (p_forward_to_person_id => ln_last_def_approver
4050: ,p_person_id => l_creator_person_id );
4051:
4052: IF lv_response <>'N' THEN

Line 4054: hr_approval_custom.Check_Final_approver

4050: ,p_person_id => l_creator_person_id );
4051:
4052: IF lv_response <>'N' THEN
4053: result := 'COMPLETE:'||
4054: hr_approval_custom.Check_Final_approver
4055: (p_forward_to_person_id => ln_last_def_approver
4056: ,p_person_id => l_creator_person_id );
4057: hr_utility.set_location('Leaving: '|| l_proc,25);
4058: return;

Line 4118: hr_approval_custom.Check_Final_approver

4114: END IF;
4115: ELSE
4116: hr_utility.trace('In Eelse of ( IF ln_approval_level > 0 THEN):'|| l_proc);
4117: result := 'COMPLETE:'||
4118: hr_approval_custom.Check_Final_approver
4119: (p_forward_to_person_id => ln_last_def_approver
4120: ,p_person_id => l_creator_person_id );
4121: END IF;
4122: