DBA Data[Home] [Help]

APPS.CSI_RMA_FULFILL_PUB dependencies on CSI_TRANSACTIONS

Line 497: p_pkg_name => 'csi_transactions_pvt');

493:
494:
495: csi_t_gen_utility_pvt.dump_api_info(
496: p_api_name => 'create_transaction',
497: p_pkg_name => 'csi_transactions_pvt');
498:
499: csi_transactions_pvt.create_transaction(
500: p_api_version => 1.0,
501: p_commit => fnd_api.g_false,

Line 499: csi_transactions_pvt.create_transaction(

495: csi_t_gen_utility_pvt.dump_api_info(
496: p_api_name => 'create_transaction',
497: p_pkg_name => 'csi_transactions_pvt');
498:
499: csi_transactions_pvt.create_transaction(
500: p_api_version => 1.0,
501: p_commit => fnd_api.g_false,
502: p_init_msg_list => fnd_api.g_true,
503: p_validation_level => fnd_api.g_valid_level_full,

Line 959: FROM csi_transactions ct

955: l_has_rma_receipt := 'N';
956: BEGIN
957: SELECT ct.TRANSACTION_TYPE_ID
958: INTO l_last_txn_type_id
959: FROM csi_transactions ct
960: WHERE ct.TRANSACTION_ID = (SELECT Max(ct2.TRANSACTION_ID)
961: FROM csi_item_instances_h cih, csi_transactions ct2
962: WHERE cih.transaction_id = ct2.transaction_id
963: AND cih.instance_id = l_instance_rec.instance_id

Line 961: FROM csi_item_instances_h cih, csi_transactions ct2

957: SELECT ct.TRANSACTION_TYPE_ID
958: INTO l_last_txn_type_id
959: FROM csi_transactions ct
960: WHERE ct.TRANSACTION_ID = (SELECT Max(ct2.TRANSACTION_ID)
961: FROM csi_item_instances_h cih, csi_transactions ct2
962: WHERE cih.transaction_id = ct2.transaction_id
963: AND cih.instance_id = l_instance_rec.instance_id
964: AND ct2.transaction_type_id = 53
965: AND ct2.source_header_ref_id = p_rma_line_rec.header_id);