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 610: l_macd_processing := csi_interface_pkg.check_macd_processing

606: l_om_session_key.session_hdr_id := l_order_line_rec.config_header_id;
607: l_om_session_key.session_rev_num := l_order_line_rec.config_rev_nbr;
608: l_om_session_key.session_item_id := l_order_line_rec.configuration_id;
609: --
610: l_macd_processing := csi_interface_pkg.check_macd_processing
611: ( p_config_session_key => l_om_session_key,
612: x_return_status => l_return_status
613: );
614: --Code end for bug5194812--

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

1253:
1254: --
1255: -- srramakr TSO with Equipment.
1256: -- If this is a MACD order line then we need to merge the Transaction details written by CZ and WSH
1257: -- For this, we call CSI_INTERFACE_PKG.Get_CZ_Relations.
1258: -- macd_order_line flag is set by Build_Shtd_Table routine.
1259: --
1260: IF l_order_line_rec.macd_order_line = FND_API.G_TRUE THEN
1261: l_source_line_rec.source_line_id := l_order_line_rec.order_line_id;

Line 1263: Csi_Interface_Pkg.Get_CZ_Relations

1259: --
1260: IF l_order_line_rec.macd_order_line = FND_API.G_TRUE THEN
1261: l_source_line_rec.source_line_id := l_order_line_rec.order_line_id;
1262: --
1263: Csi_Interface_Pkg.Get_CZ_Relations
1264: ( p_source_header_rec => l_source_header_rec,
1265: p_source_line_rec => l_source_line_rec,
1266: px_txn_line_rec => l_transaction_line_rec,
1267: px_txn_line_dtl_tbl => l_txn_line_detail_tbl,

Line 2395: l_macd_processing := csi_interface_pkg.check_macd_processing

2391: l_om_session_key.session_hdr_id := p_order_line_rec.config_header_id;
2392: l_om_session_key.session_rev_num := p_order_line_rec.config_rev_nbr;
2393: l_om_session_key.session_item_id := p_order_line_rec.configuration_id;
2394: --
2395: l_macd_processing := csi_interface_pkg.check_macd_processing
2396: ( p_config_session_key => l_om_session_key,
2397: x_return_status => l_return_status
2398: );
2399: --

Line 7002: csi_interface_pkg.build_relationship_tbl(

6998: -- relationship records written by Configurator. p_txn_ii_rltns_tbl contains this info.
6999: -- We will fork the code based on MACD order line flag in l_order_line_rec
7000: --
7001: IF l_order_line_rec.macd_order_line = FND_API.G_TRUE THEN
7002: csi_interface_pkg.build_relationship_tbl(
7003: p_txn_ii_rltns_tbl => p_txn_ii_rltns_tbl,
7004: p_txn_line_dtl_tbl => p_txn_line_detail_tbl,
7005: x_c_ii_rltns_tbl => l_cre_ii_rltns_tbl,
7006: x_u_ii_rltns_tbl => l_upd_ii_rltns_tbl,

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

8410: x_return_status OUT NOCOPY varchar2,
8411: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
8412: IS
8413:
8414: l_oke_source_table varchar2(30) := csi_interface_pkg.g_oke_source_table;
8415:
8416: l_inventory_item_id number;
8417: l_organization_id number;
8418: l_source_line_id number;

Line 8420: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;

8416: l_inventory_item_id number;
8417: l_organization_id number;
8418: l_source_line_id number;
8419: l_source_quantity number;
8420: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8421: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8422:
8423: l_source_header_rec csi_interface_pkg.source_header_rec;
8424: l_source_line_rec csi_interface_pkg.source_line_rec;

Line 8421: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;

8417: l_organization_id number;
8418: l_source_line_id number;
8419: l_source_quantity number;
8420: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8421: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8422:
8423: l_source_header_rec csi_interface_pkg.source_header_rec;
8424: l_source_line_rec csi_interface_pkg.source_line_rec;
8425:

Line 8423: l_source_header_rec csi_interface_pkg.source_header_rec;

8419: l_source_quantity number;
8420: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8421: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8422:
8423: l_source_header_rec csi_interface_pkg.source_header_rec;
8424: l_source_line_rec csi_interface_pkg.source_line_rec;
8425:
8426: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8427:

Line 8424: l_source_line_rec csi_interface_pkg.source_line_rec;

8420: l_mtl_txn_tbl csi_interface_pkg.mtl_txn_tbl;
8421: l_item_attrib_rec csi_interface_pkg.item_attributes_rec;
8422:
8423: l_source_header_rec csi_interface_pkg.source_header_rec;
8424: l_source_line_rec csi_interface_pkg.source_line_rec;
8425:
8426: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8427:
8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 8480: csi_interface_pkg.get_source_info(

8476: l_source_quantity
8477: FROM mtl_material_transactions
8478: WHERE transaction_id = p_mtl_txn_id;
8479:
8480: csi_interface_pkg.get_source_info(
8481: p_source_table => l_oke_source_table,
8482: p_source_id => l_source_line_id,
8483: x_source_header_rec => l_source_header_rec,
8484: x_source_line_rec => l_source_line_rec,

Line 8499: csi_interface_pkg.get_item_attributes(

8495:
8496: l_source_line_rec.source_quantity := l_source_quantity;
8497: l_source_line_rec.shipped_quantity := l_source_quantity;
8498:
8499: csi_interface_pkg.get_item_attributes(
8500: p_inventory_item_id => l_inventory_item_id,
8501: p_organization_id => l_organization_id,
8502: x_item_attrib_rec => l_item_attrib_rec,
8503: x_return_status => l_return_status);

Line 8518: csi_interface_pkg.get_mtl_txn_tbl(

8514: l_error_rec.comms_nl_trackable_flag := l_item_attrib_rec.ib_trackable_flag;
8515:
8516: l_source_line_rec.uom_code := l_item_attrib_rec.primary_uom_code;
8517:
8518: csi_interface_pkg.get_mtl_txn_tbl(
8519: p_mtl_txn_id => p_mtl_txn_id,
8520: x_mtl_txn_tbl => l_mtl_txn_tbl,
8521: x_return_status => l_return_status);
8522:

Line 8554: csi_interface_pkg.pre_process_mtl_txn_tbl(

8550: x_return_status => l_return_status,
8551: x_msg_count => l_msg_count,
8552: x_msg_data => l_msg_data);
8553:
8554: csi_interface_pkg.pre_process_mtl_txn_tbl(
8555: p_item_attrib_rec => l_item_attrib_rec,
8556: px_mtl_txn_tbl => l_mtl_txn_tbl,
8557: x_return_status => l_return_status);
8558:

Line 8563: csi_interface_pkg.get_inventory_instances(

8559: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8560: RAISE fnd_api.g_exc_error;
8561: END IF;
8562:
8563: csi_interface_pkg.get_inventory_instances(
8564: p_item_attrib_rec => l_item_attrib_rec,
8565: px_mtl_txn_tbl => l_mtl_txn_tbl,
8566: x_return_status => l_return_status);
8567:

Line 8573: csi_interface_pkg.decrement_inventory_instances(

8569: RAISE fnd_api.g_exc_error;
8570: END IF;
8571:
8572: -- decrement source instances
8573: csi_interface_pkg.decrement_inventory_instances(
8574: p_item_attrib_rec => l_item_attrib_rec,
8575: p_mtl_txn_tbl => l_mtl_txn_tbl,
8576: px_txn_rec => l_csi_txn_rec,
8577: x_return_status => l_return_status);

Line 8602: csi_interface_pkg.build_default_txn_detail(

8598: END LOOP;
8599: END IF;
8600: END IF;
8601:
8602: csi_interface_pkg.build_default_txn_detail(
8603: p_source_table => l_oke_source_table,
8604: p_source_id => l_source_line_id,
8605: p_source_header_rec => l_source_header_rec,
8606: p_source_line_rec => l_source_line_rec,

Line 8621: csi_interface_pkg.sync_txn_dtl_and_mtl_txn(

8617: RAISE fnd_api.g_exc_error;
8618: END IF;
8619:
8620: -- match transaction detail with material transaction
8621: csi_interface_pkg.sync_txn_dtl_and_mtl_txn(
8622: p_mtl_txn_tbl => l_mtl_txn_tbl,
8623: p_item_attrib_rec => l_item_attrib_rec,
8624: px_txn_line_dtl_tbl => l_txn_line_detail_tbl,
8625: px_txn_party_dtl_tbl => l_txn_party_tbl,

Line 8639: csi_interface_pkg.interface_ib(

8635:
8636: -- ##**##-- comment this line later.
8637: l_source_line_rec.fulfilled_date := sysdate;
8638:
8639: csi_interface_pkg.interface_ib(
8640: p_source_header_rec => l_source_header_rec,
8641: p_source_line_rec => l_source_line_rec,
8642: px_csi_txn_rec => l_csi_txn_rec,
8643: px_txn_line_rec => l_txn_line_rec,