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 694: l_parent_item_type wf_items.parent_item_type%TYPE;

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

Line 695: l_parent_item_key wf_items.parent_item_key%TYPE;

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

Line 706: FROM wf_items

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

Line 753: l_parent_item_type wf_items.parent_item_type%TYPE;

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

Line 754: l_parent_item_key wf_items.parent_item_key%TYPE;

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

Line 767: FROM wf_items

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

Line 813: l_parent_item_type wf_items.parent_item_type%TYPE;

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

Line 814: l_parent_item_key wf_items.parent_item_key%TYPE;

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

Line 827: FROM wf_items

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