DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on FND_GLOBAL

Line 145: fnd_global.user_id,fnd_global.login_id,SYSDATE,

141: VALUES (rcv_headers_interface_s.NEXTVAL,
142: x_request_group_id,
143: l_to_org_id,
144: SYSDATE,SYSDATE,
145: fnd_global.user_id,fnd_global.login_id,SYSDATE,
146: fnd_global.user_id,l_validation_flag,l_process_sts_pending,
147: 'INTERNAL ORDER',l_txn_type_new,
148: l_shipped_date(k),
149: l_shipment_num(k))

Line 146: fnd_global.user_id,l_validation_flag,l_process_sts_pending,

142: x_request_group_id,
143: l_to_org_id,
144: SYSDATE,SYSDATE,
145: fnd_global.user_id,fnd_global.login_id,SYSDATE,
146: fnd_global.user_id,l_validation_flag,l_process_sts_pending,
147: 'INTERNAL ORDER',l_txn_type_new,
148: l_shipped_date(k),
149: l_shipment_num(k))
150: RETURNING header_interface_id

Line 159: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);

155: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Getting employee id and requisition information '||x_request_group_id);
156: END IF;
157:
158: -- 2. get the employee id
159: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
160:
161:
162: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
163: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_transactions_interface');

Line 234: fnd_global.user_id,

230: l_to_org_id,
231: null,
232: l_subinventory,
233: SYSDATE,
234: fnd_global.user_id,
235: SYSDATE,
236: fnd_global.user_id,
237: fnd_global.login_id,
238: 'Y'

Line 236: fnd_global.user_id,

232: l_subinventory,
233: SYSDATE,
234: fnd_global.user_id,
235: SYSDATE,
236: fnd_global.user_id,
237: fnd_global.login_id,
238: 'Y'
239: , 'REQ'
240: , 'RCV'

Line 237: fnd_global.login_id,

233: SYSDATE,
234: fnd_global.user_id,
235: SYSDATE,
236: fnd_global.user_id,
237: fnd_global.login_id,
238: 'Y'
239: , 'REQ'
240: , 'RCV'
241: , 'DELIVER'

Line 310: 1,SYSDATE,fnd_global.user_id,

306: product_transaction_id,
307: product_code
308: )
309: VALUES(l_intf_txn_id(i),'CSD',
310: 1,SYSDATE,fnd_global.user_id,
311: SYSDATE,fnd_global.user_id,fnd_global.login_id,
312: l_fm_serial_num_tbl(j),
313: l_to_serial_num_tbl(j),
314: 1,

Line 311: SYSDATE,fnd_global.user_id,fnd_global.login_id,

307: product_code
308: )
309: VALUES(l_intf_txn_id(i),'CSD',
310: 1,SYSDATE,fnd_global.user_id,
311: SYSDATE,fnd_global.user_id,fnd_global.login_id,
312: l_fm_serial_num_tbl(j),
313: l_to_serial_num_tbl(j),
314: 1,
315: l_intf_txn_id(i),

Line 373: fnd_global.login_id last_update_login,

369: rcv_into_ou,
370: rcv_into_org,
371: sysdate creation_date,
372: sysdate last_update_date,
373: fnd_global.login_id last_update_login,
374: fnd_global.user_id created_by,
375: fnd_global.user_id last_updated_by,
376: (NVL(quantity_available,exp_quantity) - quantity_picked) available_quantity,
377: p_delivery_detail_id,

Line 374: fnd_global.user_id created_by,

370: rcv_into_org,
371: sysdate creation_date,
372: sysdate last_update_date,
373: fnd_global.login_id last_update_login,
374: fnd_global.user_id created_by,
375: fnd_global.user_id last_updated_by,
376: (NVL(quantity_available,exp_quantity) - quantity_picked) available_quantity,
377: p_delivery_detail_id,
378: to_number('1'),

Line 375: fnd_global.user_id last_updated_by,

371: sysdate creation_date,
372: sysdate last_update_date,
373: fnd_global.login_id last_update_login,
374: fnd_global.user_id created_by,
375: fnd_global.user_id last_updated_by,
376: (NVL(quantity_available,exp_quantity) - quantity_picked) available_quantity,
377: p_delivery_detail_id,
378: to_number('1'),
379: req_line_id

Line 501: l_user_id NUMBER := fnd_global.user_id;

497: x_return_status OUT NOCOPY VARCHAR2)
498: IS
499: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_requisition';
500: lc_api_version CONSTANT NUMBER := 1.0;
501: l_user_id NUMBER := fnd_global.user_id;
502: l_person_id NUMBER;
503: l_currency_code VARCHAR2(15);
504: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
505: l_item_descriptions JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();

Line 865: l_current_ou NUMBER := fnd_global.org_id;

861: l_request_id NUMBER;
862: l_success BOOLEAN := TRUE;
863: l_iso_header_id NUMBER;
864: l_iso_line_id NUMBER;
865: l_current_ou NUMBER := fnd_global.org_id;
866:
867: BEGIN
868: -- create internal requisition.
869: -- update the csd_product_transactions.

Line 1015: l_user_id NUMBER := fnd_global.user_id;

1011: l_order_rec csd_process_pvt.om_interface_rec;
1012: l_prod_txn_rec csd_process_pvt.product_txn_rec;
1013: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.pick_release_internal_order';
1014: lc_api_version CONSTANT NUMBER := 1.0;
1015: l_user_id NUMBER := fnd_global.user_id;
1016: l_login_id NUMBER := fnd_global.conc_login_id;
1017: l_document_set_id NUMBER;
1018: l_order_type_id NUMBER;
1019: l_dummy VARCHAR2(1);

Line 1016: l_login_id NUMBER := fnd_global.conc_login_id;

1012: l_prod_txn_rec csd_process_pvt.product_txn_rec;
1013: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.pick_release_internal_order';
1014: lc_api_version CONSTANT NUMBER := 1.0;
1015: l_user_id NUMBER := fnd_global.user_id;
1016: l_login_id NUMBER := fnd_global.conc_login_id;
1017: l_document_set_id NUMBER;
1018: l_order_type_id NUMBER;
1019: l_dummy VARCHAR2(1);
1020: l_picked_quantity NUMBER;

Line 2420: fnd_global.user_id,

2416: serial_prefix
2417: )
2418: VALUES (l_mmtt_temp_id,
2419: sysdate,
2420: fnd_global.user_id,
2421: sysdate,
2422: fnd_global.user_id,
2423: fnd_global.login_id,
2424: p_fm_serial_num_tbl(j),

Line 2422: fnd_global.user_id,

2418: VALUES (l_mmtt_temp_id,
2419: sysdate,
2420: fnd_global.user_id,
2421: sysdate,
2422: fnd_global.user_id,
2423: fnd_global.login_id,
2424: p_fm_serial_num_tbl(j),
2425: p_to_serial_num_tbl(j),
2426: l_mmtt_temp_id,

Line 2423: fnd_global.login_id,

2419: sysdate,
2420: fnd_global.user_id,
2421: sysdate,
2422: fnd_global.user_id,
2423: fnd_global.login_id,
2424: p_fm_serial_num_tbl(j),
2425: p_to_serial_num_tbl(j),
2426: l_mmtt_temp_id,
2427: p_quantity_tbl(j)