DBA Data[Home] [Help]

APPS.CSD_RECEIVE_PVT dependencies on FND_GLOBAL

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

460: VALUES (rcv_headers_interface_s.NEXTVAL,
461: rcv_interface_groups_s.NEXTVAL,
462: p_receive_tbl (1).to_organization_id,
463: p_receive_tbl (1).expected_receipt_date, SYSDATE,
464: fnd_global.user_id, fnd_global.login_id, SYSDATE,
465: fnd_global.user_id, l_validation_flag, l_process_sts_pending,
466: l_receipt_source_code, l_txn_Type_new,
467: -- added for internal orders.
468: p_receive_tbl (1).shipped_date,

Line 465: fnd_global.user_id, l_validation_flag, l_process_sts_pending,

461: rcv_interface_groups_s.NEXTVAL,
462: p_receive_tbl (1).to_organization_id,
463: p_receive_tbl (1).expected_receipt_date, SYSDATE,
464: fnd_global.user_id, fnd_global.login_id, SYSDATE,
465: fnd_global.user_id, l_validation_flag, l_process_sts_pending,
466: l_receipt_source_code, l_txn_Type_new,
467: -- added for internal orders.
468: p_receive_tbl (1).shipped_date,
469: p_receive_tbl (1).shipment_number

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

528: 'Inserting transactions interface table data'
529: );
530: END IF;
531:
532: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
533:
534: --Insert data into the transactions interface table.
535: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
536: LOOP

Line 637: fnd_global.user_id, SYSDATE, fnd_global.user_id,

633: p_receive_rec.item_revision,
634: p_receive_rec.to_organization_id,
635: p_receive_rec.ship_to_location_id,
636: p_receive_rec.subinventory, SYSDATE,
637: fnd_global.user_id, SYSDATE, fnd_global.user_id,
638: fnd_global.login_id, 'Y',
639: l_source_document_code
640: , 'RCV' --Interface_source_Code
641: , 'DELIVER' -- auto _Transact_Code

Line 638: fnd_global.login_id, 'Y',

634: p_receive_rec.to_organization_id,
635: p_receive_rec.ship_to_location_id,
636: p_receive_rec.subinventory, SYSDATE,
637: fnd_global.user_id, SYSDATE, fnd_global.user_id,
638: fnd_global.login_id, 'Y',
639: l_source_document_code
640: , 'RCV' --Interface_source_Code
641: , 'DELIVER' -- auto _Transact_Code
642: , l_receipt_source_Code --receipt_source_code

Line 783: l_source_line_id, SYSDATE, fnd_global.user_id,

779: transaction_quantity, primary_quantity,
780: serial_transaction_temp_id
781: )
782: VALUES (l_intf_txn_id, l_source_code,
783: l_source_line_id, SYSDATE, fnd_global.user_id,
784: SYSDATE, fnd_global.user_id, fnd_global.login_id,
785: p_receive_rec.lot_number, l_lot_expiration_date,
786: p_receive_rec.quantity, p_receive_rec.quantity,
787: --l_txn_tmp_id

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

780: serial_transaction_temp_id
781: )
782: VALUES (l_intf_txn_id, l_source_code,
783: l_source_line_id, SYSDATE, fnd_global.user_id,
784: SYSDATE, fnd_global.user_id, fnd_global.login_id,
785: p_receive_rec.lot_number, l_lot_expiration_date,
786: p_receive_rec.quantity, p_receive_rec.quantity,
787: --l_txn_tmp_id
788: decode(p_receive_rec.serial_number,null, null,l_txn_tmp_id)

Line 851: l_source_line_id, SYSDATE, fnd_global.user_id,

847: to_serial_number,
848: process_flag
849: )
850: VALUES (l_txn_tmp_id, l_source_code,
851: l_source_line_id, SYSDATE, fnd_global.user_id,
852: SYSDATE, fnd_global.user_id, fnd_global.login_id,
853: p_receive_rec.serial_number,
854: p_receive_rec.serial_number,
855: l_process_flag

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

848: process_flag
849: )
850: VALUES (l_txn_tmp_id, l_source_code,
851: l_source_line_id, SYSDATE, fnd_global.user_id,
852: SYSDATE, fnd_global.user_id, fnd_global.login_id,
853: p_receive_rec.serial_number,
854: p_receive_rec.serial_number,
855: l_process_flag
856: );