DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on WF_USERS

Line 925: x_requester_username WF_USERS.NAME%TYPE;

921:
922: l_ItemType VARCHAR2(100) := 'PORCPT';
923: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;
924:
925: x_requester_username WF_USERS.NAME%TYPE;
926: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
927: x_buyer_username WF_USERS.NAME%TYPE;
928: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_id NUMBER := 0;

Line 926: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;

922: l_ItemType VARCHAR2(100) := 'PORCPT';
923: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;
924:
925: x_requester_username WF_USERS.NAME%TYPE;
926: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
927: x_buyer_username WF_USERS.NAME%TYPE;
928: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_id NUMBER := 0;
930: x_org_id NUMBER;

Line 927: x_buyer_username WF_USERS.NAME%TYPE;

923: l_ItemKey VARCHAR2(100) := x_WF_ItemKey;
924:
925: x_requester_username WF_USERS.NAME%TYPE;
926: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
927: x_buyer_username WF_USERS.NAME%TYPE;
928: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_id NUMBER := 0;
930: x_org_id NUMBER;
931:

Line 928: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;

924:
925: x_requester_username WF_USERS.NAME%TYPE;
926: x_requester_disp_name WF_USERS.DISPLAY_NAME%TYPE;
927: x_buyer_username WF_USERS.NAME%TYPE;
928: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
929: x_buyer_id NUMBER := 0;
930: x_org_id NUMBER;
931:
932: x_requester_current BOOLEAN ;

Line 1121: x_buyer_username WF_USERS.NAME%TYPE;

1117: funmode in varchar2,
1118: result out NOCOPY varchar2 ) IS
1119:
1120:
1121: x_buyer_username WF_USERS.NAME%TYPE;
1122: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
1123: x_po_header_id NUMBER;
1124: x_requester_id NUMBER;
1125:

Line 1122: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;

1118: result out NOCOPY varchar2 ) IS
1119:
1120:
1121: x_buyer_username WF_USERS.NAME%TYPE;
1122: x_buyer_disp_name WF_USERS.DISPLAY_NAME%TYPE;
1123: x_po_header_id NUMBER;
1124: x_requester_id NUMBER;
1125:
1126: -- Header info

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

1742: x_po_header_id NUMBER;
1743: x_requester_id NUMBER;
1744:
1745: x_org_id NUMBER;
1746: x_requester_username WF_USERS.NAME%TYPE; --Using the username in the initialize api
1747: x_rcv_trans_status VARCHAR2(500) := NULL;
1748: X_tmp_count NUMBER;
1749: X_tmp_count1 NUMBER;
1750: X_tmp_approve VARCHAR2(20);

Line 2670: x_manager_username WF_USERS.NAME%TYPE;

2666:
2667: x_org_id NUMBER;
2668: x_requester_id NUMBER;
2669: x_manager_id NUMBER;
2670: x_manager_username WF_USERS.NAME%TYPE;
2671: x_manager_disp_name WF_USERS.DISPLAY_NAME%TYPE;
2672:
2673: x_requester_current BOOLEAN ;
2674: dummy VARCHAR2(1);

Line 2671: x_manager_disp_name WF_USERS.DISPLAY_NAME%TYPE;

2667: x_org_id NUMBER;
2668: x_requester_id NUMBER;
2669: x_manager_id NUMBER;
2670: x_manager_username WF_USERS.NAME%TYPE;
2671: x_manager_disp_name WF_USERS.DISPLAY_NAME%TYPE;
2672:
2673: x_requester_current BOOLEAN ;
2674: dummy VARCHAR2(1);
2675:

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

2773:
2774: x_exp_receipt_date DATE;
2775: x_header_id NUMBER;
2776: x_requester_id NUMBER;
2777: x_requester_username WF_USERS.NAME%TYPE; --Use the requester username to be passed to initialize
2778: x_rcv_trans_status VARCHAR2(500) := NULL;
2779: X_tmp_count NUMBER;
2780: X_tmp_count1 NUMBER;
2781: X_tmp_approve VARCHAR2(20);

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

3053: l_document VARCHAR2(32000) := '';
3054: x_number VARCHAR2(20):= NULL;
3055: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := NULL;
3056: x_due_date DATE;
3057: x_buyer_name WF_USERS.DISPLAY_NAME%TYPE := NULL;
3058: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
3059: x_disp_count NUMBER := 0;
3060: x_confirm_rcpt_inst VARCHAR2(2000);
3061: x_is_int_req VARCHAR2(1);

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

3734: x_po_header_id NUMBER;
3735: x_requester_id NUMBER;
3736:
3737: x_org_id NUMBER;
3738: x_requester_username WF_USERS.NAME%TYPE; -- Use the requester username to be passed to initialize
3739: x_rcv_trans_status VARCHAR2(500) := NULL;
3740: x_insert_txns_status NUMBER;
3741:
3742: t_po_header_id rcvNumberArray;