923:
924: l_ItemType VARCHAR2(100) := 'PORCPT';
925: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;
926:
927: x_requester_username WF_USERS.NAME%TYPE;
928: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_username WF_USERS.NAME%TYPE;
930: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
931: x_buyer_id NUMBER := 0;
924: l_ItemType VARCHAR2(100) := 'PORCPT';
925: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;
926:
927: x_requester_username WF_USERS.NAME%TYPE;
928: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_username WF_USERS.NAME%TYPE;
930: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
931: x_buyer_id NUMBER := 0;
932: x_org_id NUMBER;
925: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;
926:
927: x_requester_username WF_USERS.NAME%TYPE;
928: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_username WF_USERS.NAME%TYPE;
930: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
931: x_buyer_id NUMBER := 0;
932: x_org_id NUMBER;
933:
926:
927: x_requester_username WF_USERS.NAME%TYPE;
928: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_username WF_USERS.NAME%TYPE;
930: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
931: x_buyer_id NUMBER := 0;
932: x_org_id NUMBER;
933:
934: x_requester_current BOOLEAN ;
1119: funmode in varchar2,
1120: result out NOCOPY varchar2 ) IS
1121:
1122:
1123: x_buyer_username WF_USERS.NAME%TYPE;
1124: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
1125: x_po_header_id NUMBER;
1126: x_requester_id NUMBER;
1127:
1120: result out NOCOPY varchar2 ) IS
1121:
1122:
1123: x_buyer_username WF_USERS.NAME%TYPE;
1124: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
1125: x_po_header_id NUMBER;
1126: x_requester_id NUMBER;
1127:
1128: -- Header info
1745: x_po_header_id NUMBER;
1746: x_requester_id NUMBER;
1747:
1748: x_org_id NUMBER;
1749: x_requester_username WF_USERS.NAME%TYPE; --Using the username in the initialize api
1750: x_rcv_trans_status VARCHAR2(500) := NULL;
1751: X_tmp_count NUMBER;
1752: X_tmp_count1 NUMBER;
1753: X_tmp_approve VARCHAR2(20);
2711:
2712: x_org_id NUMBER;
2713: x_requester_id NUMBER;
2714: x_manager_id NUMBER;
2715: x_manager_username WF_USERS.NAME%TYPE;
2716: x_manager_disp_name WF_USERS.DISPLAY_NAME%TYPE;
2717:
2718: x_requester_current BOOLEAN ;
2719: dummy VARCHAR2(1);
2712: x_org_id NUMBER;
2713: x_requester_id NUMBER;
2714: x_manager_id NUMBER;
2715: x_manager_username WF_USERS.NAME%TYPE;
2716: x_manager_disp_name WF_USERS.DISPLAY_NAME%TYPE;
2717:
2718: x_requester_current BOOLEAN ;
2719: dummy VARCHAR2(1);
2720:
2818:
2819: x_exp_receipt_date DATE;
2820: x_header_id NUMBER;
2821: x_requester_id NUMBER;
2822: x_requester_username WF_USERS.NAME%TYPE; --Use the requester username to be passed to initialize
2823: x_rcv_trans_status VARCHAR2(500) := NULL;
2824: X_tmp_count NUMBER;
2825: X_tmp_count1 NUMBER;
2826: X_tmp_approve VARCHAR2(20);
3098: l_document VARCHAR2(32000) := '';
3099: x_number VARCHAR2(20):= NULL;
3100: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := NULL;
3101: x_due_date DATE;
3102: x_buyer_name WF_USERS.DISPLAY_NAME%TYPE := NULL;
3103: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
3104: x_disp_count NUMBER := 0;
3105: x_confirm_rcpt_inst VARCHAR2(2000);
3106: x_is_int_req VARCHAR2(1);
3794: x_po_header_id NUMBER;
3795: x_requester_id NUMBER;
3796:
3797: x_org_id NUMBER;
3798: x_requester_username WF_USERS.NAME%TYPE; -- Use the requester username to be passed to initialize
3799: x_rcv_trans_status VARCHAR2(500) := NULL;
3800: x_insert_txns_status NUMBER;
3801:
3802: t_po_header_id rcvNumberArray;