689: c_item_type := get_item_type(p_transaction_id);
690: c_item_key := get_item_key(p_transaction_id);
691:
692: -- bug 4333335 begins
693: hr_approval_custom.g_itemtype := c_item_type;
694: hr_approval_custom.g_itemkey := c_item_key;
695: -- bug 4333335 ends
696:
697: /*c_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,
690: c_item_key := get_item_key(p_transaction_id);
691:
692: -- bug 4333335 begins
693: hr_approval_custom.g_itemtype := c_item_type;
694: hr_approval_custom.g_itemkey := c_item_key;
695: -- bug 4333335 ends
696:
697: /*c_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,
698: itemkey => c_item_key,
700: */
701: c_creator_person_id := getApprStartingPointPersonId(p_transaction_id);
702: c_final_appprover_id := c_creator_person_id;
703:
704: lv_response := hr_approval_custom.Check_Final_approver(p_forward_to_person_id => c_creator_person_id,
705: p_person_id => c_creator_person_id );
706:
707:
708: while lv_response='N' loop
706:
707:
708: while lv_response='N' loop
709:
710: c_forward_to_person_id := hr_approval_custom.Get_Next_Approver(p_person_id =>c_final_appprover_id);
711:
712: c_final_appprover_id := c_forward_to_person_id;
713:
714: lv_response := hr_approval_custom.Check_Final_approver(p_forward_to_person_id => c_forward_to_person_id,
710: c_forward_to_person_id := hr_approval_custom.Get_Next_Approver(p_person_id =>c_final_appprover_id);
711:
712: c_final_appprover_id := c_forward_to_person_id;
713:
714: lv_response := hr_approval_custom.Check_Final_approver(p_forward_to_person_id => c_forward_to_person_id,
715: p_person_id => c_creator_person_id );
716:
717: end loop;
718:
2208: -- flow is using custom package for approvals
2209: -- -----------------------------------------------------------------------
2210: -- expose the wf control variables to the custom package
2211: -- -----------------------------------------------------------------------
2212: hr_approval_custom.g_itemtype := p_item_type;
2213: hr_approval_custom.g_itemkey := p_item_key;
2214:
2215: -- process the additional approvers and default approvers
2216: -- get the total number of additional approvers for this transaction
2209: -- -----------------------------------------------------------------------
2210: -- expose the wf control variables to the custom package
2211: -- -----------------------------------------------------------------------
2212: hr_approval_custom.g_itemtype := p_item_type;
2213: hr_approval_custom.g_itemkey := p_item_key;
2214:
2215: -- process the additional approvers and default approvers
2216: -- get the total number of additional approvers for this transaction
2217: ln_addntl_approvers := NVL(wf_engine.GetItemAttrNumber(itemtype => p_item_type
2290: -- get the next approver from the heirarchy tree.
2291: -- the l_current_forward_to_id resetting was removed for default approver.
2292: -- now the from column will show the last approver approved.
2293: ln_nextApprover_person_id :=
2294: hr_approval_custom.Get_Next_Approver(
2295: p_person_id =>NVL(ln_last_default_approver_id,
2296: wf_engine.GetItemAttrNumber
2297: (itemtype => p_item_type
2298: ,itemkey => p_item_key