APPS.POR_AME_RCO_WF_PVT dependencies on WF_ITEMS

Line 230: l_item_key wf_items.item_key%TYPE;

226: resultout out NOCOPY varchar2) IS
227:
228: l_progress VARCHAR2(500) := '000';
229: l_document_id number;
230: l_item_key wf_items.item_key%TYPE;
231: l_next_approver_id number;
232: l_next_approver_name per_employees_current_x.full_name%TYPE;
233: l_next_approver_user_name VARCHAR2(100);
234: l_next_approver_disp_name VARCHAR2(240);

Line 693: l_parent_item_type wf_items.parent_item_type%TYPE;

689: funcmode in varchar2,
690: resultout out NOCOPY varchar2) IS
691:
692: l_progress VARCHAR2(500) := '000';
693: l_parent_item_type wf_items.parent_item_type%TYPE;
694: l_parent_item_key wf_items.parent_item_key%TYPE;
695:
696: begin
697:

Line 694: l_parent_item_key wf_items.parent_item_key%TYPE;

690: resultout out NOCOPY varchar2) IS
691:
692: l_progress VARCHAR2(500) := '000';
693: l_parent_item_type wf_items.parent_item_type%TYPE;
694: l_parent_item_key wf_items.parent_item_key%TYPE;
695:
696: begin
697:
698: l_progress := 'Process_Response_Approve: 001';

Line 705: FROM wf_items

701: END IF;
702:
703: SELECT parent_item_type, parent_item_key
704: into l_parent_item_type, l_parent_item_key
705: FROM wf_items
706: WHERE item_type = itemtype and item_key = itemkey;
707:
708: Process_Response_Internal(itemtype, itemkey, 'APPROVE');
709:

Line 752: l_parent_item_type wf_items.parent_item_type%TYPE;

748: funcmode in varchar2,
749: resultout out NOCOPY varchar2) IS
750:
751: l_progress VARCHAR2(500) := '000';
752: l_parent_item_type wf_items.parent_item_type%TYPE;
753: l_parent_item_key wf_items.parent_item_key%TYPE;
754:
755: begin
756:

Line 753: l_parent_item_key wf_items.parent_item_key%TYPE;

749: resultout out NOCOPY varchar2) IS
750:
751: l_progress VARCHAR2(500) := '000';
752: l_parent_item_type wf_items.parent_item_type%TYPE;
753: l_parent_item_key wf_items.parent_item_key%TYPE;
754:
755: begin
756:
757: l_progress := 'Process_Response_Reject: 001';

Line 766: FROM wf_items

762: Process_Response_Internal(itemtype, itemkey, 'REJECT');
763:
764: SELECT parent_item_type, parent_item_key
765: into l_parent_item_type, l_parent_item_key
766: FROM wf_items
767: WHERE item_type = itemtype and item_key = itemkey;
768:
769: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
770: itemkey => l_parent_item_key,

Line 812: l_parent_item_type wf_items.parent_item_type%TYPE;

808: funcmode in varchar2,
809: resultout out NOCOPY varchar2) IS
810:
811: l_progress VARCHAR2(500) := '000';
812: l_parent_item_type wf_items.parent_item_type%TYPE;
813: l_parent_item_key wf_items.parent_item_key%TYPE;
814:
815: begin
816:

Line 813: l_parent_item_key wf_items.parent_item_key%TYPE;

809: resultout out NOCOPY varchar2) IS
810:
811: l_progress VARCHAR2(500) := '000';
812: l_parent_item_type wf_items.parent_item_type%TYPE;
813: l_parent_item_key wf_items.parent_item_key%TYPE;
814:
815: begin
816:
817: l_progress := 'Process_Response_Timeout: 001';

Line 826: FROM wf_items

822: Process_Response_Internal(itemtype, itemkey, 'TIMEOUT');
823:
824: SELECT parent_item_type, parent_item_key
825: into l_parent_item_type, l_parent_item_key
826: FROM wf_items
827: WHERE item_type = itemtype and item_key = itemkey;
828:
829: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
830: itemkey => l_parent_item_key,