APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_TRANSACTIONS

Line 57: p_pkg_name => 'csi_transactions_pvt');

53: x_return_status := fnd_api.g_ret_sts_success;
54:
55: csi_t_gen_utility_pvt.dump_api_info(
56: p_api_name => 'create_transaction',
57: p_pkg_name => 'csi_transactions_pvt');
58:
59: csi_transactions_pvt.create_transaction(
60: p_api_version => 1.0,
61: p_commit => fnd_api.g_false,

Line 59: csi_transactions_pvt.create_transaction(

55: csi_t_gen_utility_pvt.dump_api_info(
56: p_api_name => 'create_transaction',
57: p_pkg_name => 'csi_transactions_pvt');
58:
59: csi_transactions_pvt.create_transaction(
60: p_api_version => 1.0,
61: p_commit => fnd_api.g_false,
62: p_init_msg_list => fnd_api.g_true,
63: p_validation_level => fnd_api.g_valid_level_full,

Line 4319: csi_transactions ct

4315:
4316: CURSOR txn_cur(p_instance_id in number) IS
4317: SELECT ct.transaction_type_id
4318: FROM csi_item_instances_h cih,
4319: csi_transactions ct
4320: WHERE cih.instance_id = p_instance_id
4321: AND ct.transaction_id = cih.transaction_id
4322: AND NOT (ct.transaction_type_id = 51 AND ct.source_header_ref_id = p_header_id)
4323: ORDER BY ct.transaction_date desc;

Line 9006: FROM CSI_TRANSACTIONS

9002:
9003: FOR shippable_order_rec IN shippable_order_cur LOOP
9004:
9005: SELECT 'Y' INTO l_dummy
9006: FROM CSI_TRANSACTIONS
9007: WHERE SOURCE_LINE_REF_ID = shippable_order_rec.line_id
9008: AND TRANSACTION_TYPE_ID = 51;
9009: END LOOP; -- shippable_order_rec IN shippable_order_cur
9010:

Line 9011: -- Found all shipment line in CSI_TRANSACTIONS

9007: WHERE SOURCE_LINE_REF_ID = shippable_order_rec.line_id
9008: AND TRANSACTION_TYPE_ID = 51;
9009: END LOOP; -- shippable_order_rec IN shippable_order_cur
9010:
9011: -- Found all shipment line in CSI_TRANSACTIONS
9012: RETURN 'Y';
9013:
9014: EXCEPTION
9015: WHEN NO_DATA_FOUND THEN

Line 9016: -- Some of the shipment line missing from CSI_TRANSACTIONS

9012: RETURN 'Y';
9013:
9014: EXCEPTION
9015: WHEN NO_DATA_FOUND THEN
9016: -- Some of the shipment line missing from CSI_TRANSACTIONS
9017: RETURN 'N';
9018:
9019: WHEN OTHERS THEN
9020: RETURN 'Y';