DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on WF_USERS

Line 927: x_requester_username WF_USERS.NAME%TYPE;

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;

Line 928: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;

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;

Line 929: x_buyer_username WF_USERS.NAME%TYPE;

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:

Line 930: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;

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 ;

Line 1123: x_buyer_username WF_USERS.NAME%TYPE;

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:

Line 1124: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;

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

Line 1749: x_requester_username WF_USERS.NAME%TYPE; --Using the username in the initialize api

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);

Line 2715: x_manager_username WF_USERS.NAME%TYPE;

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);

Line 2716: x_manager_disp_name WF_USERS.DISPLAY_NAME%TYPE;

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:

Line 2822: x_requester_username WF_USERS.NAME%TYPE; --Use the requester username to be passed to initialize

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);

Line 3102: x_buyer_name WF_USERS.DISPLAY_NAME%TYPE := NULL;

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);

Line 3798: x_requester_username WF_USERS.NAME%TYPE; -- Use the requester username to be passed to initialize

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;