DBA Data[Home] [Help]

APPS.CSD_RECEIVE_PVT dependencies on FND_GLOBAL

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

437: VALUES (rcv_headers_interface_s.NEXTVAL,
438: rcv_interface_groups_s.NEXTVAL,
439: p_receive_tbl (1).to_organization_id,
440: p_receive_tbl (1).expected_receipt_date, SYSDATE,
441: fnd_global.user_id, fnd_global.login_id, SYSDATE,
442: fnd_global.user_id, l_validation_flag, l_process_sts_pending,
443: l_receipt_source_code, l_txn_Type_new,
444: -- added for internal orders.
445: p_receive_tbl (1).shipped_date,

Line 442: fnd_global.user_id, l_validation_flag, l_process_sts_pending,

438: rcv_interface_groups_s.NEXTVAL,
439: p_receive_tbl (1).to_organization_id,
440: p_receive_tbl (1).expected_receipt_date, SYSDATE,
441: fnd_global.user_id, fnd_global.login_id, SYSDATE,
442: fnd_global.user_id, l_validation_flag, l_process_sts_pending,
443: l_receipt_source_code, l_txn_Type_new,
444: -- added for internal orders.
445: p_receive_tbl (1).shipped_date,
446: p_receive_tbl (1).shipment_number

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

505: 'Inserting transactions interface table data'
506: );
507: END IF;
508:
509: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
510:
511: --Insert data into the transactions interface table.
512: FOR i IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
513: LOOP

Line 598: fnd_global.user_id, SYSDATE, fnd_global.user_id,

594: p_receive_rec.item_revision,
595: p_receive_rec.to_organization_id,
596: p_receive_rec.ship_to_location_id,
597: p_receive_rec.subinventory, SYSDATE,
598: fnd_global.user_id, SYSDATE, fnd_global.user_id,
599: fnd_global.login_id, 'Y',
600: l_source_document_code
601: , 'RCV' --Interface_source_Code
602: , 'DELIVER' -- auto _Transact_Code

Line 599: fnd_global.login_id, 'Y',

595: p_receive_rec.to_organization_id,
596: p_receive_rec.ship_to_location_id,
597: p_receive_rec.subinventory, SYSDATE,
598: fnd_global.user_id, SYSDATE, fnd_global.user_id,
599: fnd_global.login_id, 'Y',
600: l_source_document_code
601: , 'RCV' --Interface_source_Code
602: , 'DELIVER' -- auto _Transact_Code
603: , l_receipt_source_Code --receipt_source_code

Line 727: l_source_line_id, SYSDATE, fnd_global.user_id,

723: transaction_quantity, primary_quantity,
724: serial_transaction_temp_id
725: )
726: VALUES (l_intf_txn_id, l_source_code,
727: l_source_line_id, SYSDATE, fnd_global.user_id,
728: SYSDATE, fnd_global.user_id, fnd_global.login_id,
729: p_receive_rec.lot_number, l_lot_expiration_date,
730: p_receive_rec.quantity, p_receive_rec.quantity,
731: l_txn_tmp_id

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

724: serial_transaction_temp_id
725: )
726: VALUES (l_intf_txn_id, l_source_code,
727: l_source_line_id, SYSDATE, fnd_global.user_id,
728: SYSDATE, fnd_global.user_id, fnd_global.login_id,
729: p_receive_rec.lot_number, l_lot_expiration_date,
730: p_receive_rec.quantity, p_receive_rec.quantity,
731: l_txn_tmp_id
732: );

Line 794: l_source_line_id, SYSDATE, fnd_global.user_id,

790: to_serial_number,
791: process_flag
792: )
793: VALUES (l_txn_tmp_id, l_source_code,
794: l_source_line_id, SYSDATE, fnd_global.user_id,
795: SYSDATE, fnd_global.user_id, fnd_global.login_id,
796: p_receive_rec.serial_number,
797: p_receive_rec.serial_number,
798: l_process_flag

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

791: process_flag
792: )
793: VALUES (l_txn_tmp_id, l_source_code,
794: l_source_line_id, SYSDATE, fnd_global.user_id,
795: SYSDATE, fnd_global.user_id, fnd_global.login_id,
796: p_receive_rec.serial_number,
797: p_receive_rec.serial_number,
798: l_process_flag
799: );