eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_INTERFACE_PKG

Line 554: l_source_header_rec csi_interface_pkg.source_header_rec;

550: l_error_rec csi_datastructures_pub.transaction_error_rec;
551: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
552: l_literal1 VARCHAR2(30) ;
553: l_literal2 VARCHAR2(30) ;
554: l_source_header_rec csi_interface_pkg.source_header_rec;
555: l_source_line_rec csi_interface_pkg.source_line_rec;
556: l_conv_to_prim_uom_req VARCHAR2(1) := 'Y';
557: --Added for bug 5194812--
558: l_om_session_key csi_utility_grp.config_session_key;

Line 555: l_source_line_rec csi_interface_pkg.source_line_rec;

551: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
552: l_literal1 VARCHAR2(30) ;
553: l_literal2 VARCHAR2(30) ;
554: l_source_header_rec csi_interface_pkg.source_header_rec;
555: l_source_line_rec csi_interface_pkg.source_line_rec;
556: l_conv_to_prim_uom_req VARCHAR2(1) := 'Y';
557: --Added for bug 5194812--
558: l_om_session_key csi_utility_grp.config_session_key;
559: l_macd_processing BOOLEAN := FALSE;

Line 667: l_macd_processing := csi_interface_pkg.check_macd_processing

663: l_om_session_key.session_hdr_id := l_order_line_rec.config_header_id;
664: l_om_session_key.session_rev_num := l_order_line_rec.config_rev_nbr;
665: l_om_session_key.session_item_id := l_order_line_rec.configuration_id;
666: --
667: l_macd_processing := csi_interface_pkg.check_macd_processing
668: ( p_config_session_key => l_om_session_key,
669: x_return_status => l_return_status
670: );
671: --Code end for bug5194812--

Line 1314: -- For this, we call CSI_INTERFACE_PKG.Get_CZ_Relations.

1310:
1311: --
1312: -- srramakr TSO with Equipment.
1313: -- If this is a MACD order line then we need to merge the Transaction details written by CZ and WSH
1314: -- For this, we call CSI_INTERFACE_PKG.Get_CZ_Relations.
1315: -- macd_order_line flag is set by Build_Shtd_Table routine.
1316: --
1317: IF l_order_line_rec.macd_order_line = FND_API.G_TRUE THEN
1318: l_source_line_rec.source_line_id := l_order_line_rec.order_line_id;

Line 1320: Csi_Interface_Pkg.Get_CZ_Relations

1316: --
1317: IF l_order_line_rec.macd_order_line = FND_API.G_TRUE THEN
1318: l_source_line_rec.source_line_id := l_order_line_rec.order_line_id;
1319: --
1320: Csi_Interface_Pkg.Get_CZ_Relations
1321: ( p_source_header_rec => l_source_header_rec,
1322: p_source_line_rec => l_source_line_rec,
1323: px_txn_line_rec => l_transaction_line_rec,
1324: px_txn_line_dtl_tbl => l_txn_line_detail_tbl,

Line 2454: l_macd_processing := csi_interface_pkg.check_macd_processing

2450: l_om_session_key.session_hdr_id := p_order_line_rec.config_header_id;
2451: l_om_session_key.session_rev_num := p_order_line_rec.config_rev_nbr;
2452: l_om_session_key.session_item_id := p_order_line_rec.configuration_id;
2453: --
2454: l_macd_processing := csi_interface_pkg.check_macd_processing
2455: ( p_config_session_key => l_om_session_key,
2456: x_return_status => l_return_status
2457: );
2458: --

Line 7303: csi_interface_pkg.build_relationship_tbl(

7299: -- relationship records written by Configurator. p_txn_ii_rltns_tbl contains this info.
7300: -- We will fork the code based on MACD order line flag in l_order_line_rec
7301: --
7302: IF l_order_line_rec.macd_order_line = FND_API.G_TRUE THEN
7303: csi_interface_pkg.build_relationship_tbl(
7304: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
7305: p_txn_line_dtl_tbl => p_txn_line_detail_tbl,
7306: x_c_ii_rltns_tbl => l_cre_ii_rltns_tbl,
7307: x_u_ii_rltns_tbl => l_upd_ii_rltns_tbl,

Line 8733: l_oke_source_table varchar2(30) := csi_interface_pkg.g_oke_source_table;

8729: x_return_status OUT NOCOPY varchar2,
8730: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
8731: IS
8732:
8733: l_oke_source_table varchar2(30) := csi_interface_pkg.g_oke_source_table;
8734:
8735: l_inventory_item_id number;
8736: l_organization_id number;
8737: l_source_line_id number;

Line 8739: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;

8735: l_inventory_item_id number;
8736: l_organization_id number;
8737: l_source_line_id number;
8738: l_source_quantity number;
8739: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8740: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8741:
8742: l_source_header_rec csi_interface_pkg.source_header_rec;
8743: l_source_line_rec csi_interface_pkg.source_line_rec;

Line 8740: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;

8736: l_organization_id number;
8737: l_source_line_id number;
8738: l_source_quantity number;
8739: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8740: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8741:
8742: l_source_header_rec csi_interface_pkg.source_header_rec;
8743: l_source_line_rec csi_interface_pkg.source_line_rec;
8744:

Line 8742: l_source_header_rec csi_interface_pkg.source_header_rec;

8738: l_source_quantity number;
8739: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8740: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8741:
8742: l_source_header_rec csi_interface_pkg.source_header_rec;
8743: l_source_line_rec csi_interface_pkg.source_line_rec;
8744:
8745: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8746:

Line 8743: l_source_line_rec csi_interface_pkg.source_line_rec;

8739: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8740: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8741:
8742: l_source_header_rec csi_interface_pkg.source_header_rec;
8743: l_source_line_rec csi_interface_pkg.source_line_rec;
8744:
8745: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8746:
8747: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 8799: csi_interface_pkg.get_source_info(

8795: l_source_quantity
8796: FROM mtl_material_transactions
8797: WHERE transaction_id = p_mtl_txn_id;
8798:
8799: csi_interface_pkg.get_source_info(
8800: p_source_table => l_oke_source_table,
8801: p_source_id => l_source_line_id,
8802: x_source_header_rec => l_source_header_rec,
8803: x_source_line_rec => l_source_line_rec,

Line 8818: csi_interface_pkg.get_item_attributes(

8814:
8815: l_source_line_rec.source_quantity := l_source_quantity;
8816: l_source_line_rec.shipped_quantity := l_source_quantity;
8817:
8818: csi_interface_pkg.get_item_attributes(
8819: p_transaction_id => p_mtl_txn_id, --Added for bug# 14835893
8820: p_inventory_item_id => l_inventory_item_id,
8821: p_organization_id => l_organization_id,
8822: x_item_attrib_rec => l_item_attrib_rec,

Line 8838: csi_interface_pkg.get_mtl_txn_tbl(

8834: l_error_rec.comms_nl_trackable_flag := l_item_attrib_rec.ib_trackable_flag;
8835:
8836: l_source_line_rec.uom_code := l_item_attrib_rec.primary_uom_code;
8837:
8838: csi_interface_pkg.get_mtl_txn_tbl(
8839: p_mtl_txn_id => p_mtl_txn_id,
8840: x_mtl_txn_tbl => l_mtl_txn_tbl,
8841: x_return_status => l_return_status);
8842:

Line 8874: csi_interface_pkg.pre_process_mtl_txn_tbl(

8870: x_return_status => l_return_status,
8871: x_msg_count => l_msg_count,
8872: x_msg_data => l_msg_data);
8873:
8874: csi_interface_pkg.pre_process_mtl_txn_tbl(
8875: p_item_attrib_rec => l_item_attrib_rec,
8876: px_mtl_txn_tbl => l_mtl_txn_tbl,
8877: x_return_status => l_return_status);
8878:

Line 8883: csi_interface_pkg.get_inventory_instances(

8879: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8880: RAISE fnd_api.g_exc_error;
8881: END IF;
8882:
8883: csi_interface_pkg.get_inventory_instances(
8884: p_item_attrib_rec => l_item_attrib_rec,
8885: px_mtl_txn_tbl => l_mtl_txn_tbl,
8886: x_return_status => l_return_status);
8887:

Line 8893: csi_interface_pkg.decrement_inventory_instances(

8889: RAISE fnd_api.g_exc_error;
8890: END IF;
8891:
8892: -- decrement source instances
8893: csi_interface_pkg.decrement_inventory_instances(
8894: p_item_attrib_rec => l_item_attrib_rec,
8895: p_mtl_txn_tbl => l_mtl_txn_tbl,
8896: px_txn_rec => l_csi_txn_rec,
8897: x_return_status => l_return_status);

Line 8922: csi_interface_pkg.build_default_txn_detail(

8918: END LOOP;
8919: END IF;
8920: END IF;
8921:
8922: csi_interface_pkg.build_default_txn_detail(
8923: p_source_table => l_oke_source_table,
8924: p_source_id => l_source_line_id,
8925: p_source_header_rec => l_source_header_rec,
8926: p_source_line_rec => l_source_line_rec,

Line 8941: csi_interface_pkg.sync_txn_dtl_and_mtl_txn(

8937: RAISE fnd_api.g_exc_error;
8938: END IF;
8939:
8940: -- match transaction detail with material transaction
8941: csi_interface_pkg.sync_txn_dtl_and_mtl_txn(
8942: p_mtl_txn_tbl => l_mtl_txn_tbl,
8943: p_item_attrib_rec => l_item_attrib_rec,
8944: px_txn_line_dtl_tbl => l_txn_line_detail_tbl,
8945: px_txn_party_dtl_tbl => l_txn_party_tbl,

Line 8959: csi_interface_pkg.interface_ib(

8955:
8956: -- ##**##-- comment this line later.
8957: l_source_line_rec.fulfilled_date := sysdate;
8958:
8959: csi_interface_pkg.interface_ib(
8960: p_source_header_rec => l_source_header_rec,
8961: p_source_line_rec => l_source_line_rec,
8962: px_csi_txn_rec => l_csi_txn_rec,
8963: px_txn_line_rec => l_txn_line_rec,