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_UTL_PKG dependencies on CSI_ORDER_SHIP_PUB

Line 25: csi_order_ship_pub.g_api_name := 'csi_utl_pkg.'||p_api_name;

21: p_api_name IN VARCHAR2)
22: IS
23: BEGIN
24:
25: csi_order_ship_pub.g_api_name := 'csi_utl_pkg.'||p_api_name;
26:
27: csi_t_gen_utility_pvt.dump_api_info(
28: p_pkg_name => 'csi_utl_pkg',
29: p_api_name => p_api_name);

Line 779: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,

775: PROCEDURE split_ship_rec(
776: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
777: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
778: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
779: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
780: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
781: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
782: p_proc_qty IN NUMBER,
783: x_return_status OUT NOCOPY VARCHAR2)

Line 780: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,

776: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
777: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
778: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
779: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
780: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
781: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
782: p_proc_qty IN NUMBER,
783: x_return_status OUT NOCOPY VARCHAR2)
784: IS

Line 781: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

777: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
778: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
779: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
780: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
781: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
782: p_proc_qty IN NUMBER,
783: x_return_status OUT NOCOPY VARCHAR2)
784: IS
785:

Line 1011: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,

1007: END split_ship_rec;
1008:
1009: PROCEDURE create_txn_details(
1010: x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1011: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
1012: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
1013: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
1014: x_return_status OUT NOCOPY VARCHAR2)
1015: IS

Line 1012: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,

1008:
1009: PROCEDURE create_txn_details(
1010: x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1011: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
1012: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
1013: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
1014: x_return_status OUT NOCOPY VARCHAR2)
1015: IS
1016: l_index NUMBER := 0;

Line 1013: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

1009: PROCEDURE create_txn_details(
1010: x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1011: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
1012: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
1013: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
1014: x_return_status OUT NOCOPY VARCHAR2)
1015: IS
1016: l_index NUMBER := 0;
1017: l_ip_account_id NUMBER;

Line 1555: x_order_line_rec OUT NOCOPY csi_order_ship_pub.order_line_rec,

1551: END get_serial_contl_code;
1552:
1553: PROCEDURE get_order_line_dtls(
1554: p_mtl_transaction_id IN NUMBER,
1555: x_order_line_rec OUT NOCOPY csi_order_ship_pub.order_line_rec,
1556: x_return_status OUT NOCOPY VARCHAR2)
1557: IS
1558:
1559: -- Partner Ordering

Line 1563: l_order_line_rec csi_order_ship_pub.order_line_rec;

1559: -- Partner Ordering
1560: l_partner_rec oe_install_base_util.partner_order_rec;
1561: l_partner_owner_id NUMBER;
1562: l_partner_owner_acct_id NUMBER;
1563: l_order_line_rec csi_order_ship_pub.order_line_rec;
1564:
1565: -- sumathur Added for TSO With Equipment bug 5459427
1566: l_om_session_key csi_utility_grp.config_session_key;
1567: l_macd_processing BOOLEAN := FALSE;

Line 1906: x_trx_sub_type_rec OUT NOCOPY csi_order_ship_pub.txn_sub_type_rec,

1902:
1903: PROCEDURE get_sub_type_rec(
1904: p_sub_type_id IN NUMBER,
1905: p_trx_type_id IN NUMBER,
1906: x_trx_sub_type_rec OUT NOCOPY csi_order_ship_pub.txn_sub_type_rec,
1907: x_return_status OUT NOCOPY VARCHAR2)
1908: IS
1909: BEGIN
1910: api_log('get_sub_type_rec');

Line 1982: x_model_inst_tbl OUT NOCOPY csi_order_ship_pub.model_inst_tbl,

1978: END get_inst_relation;
1979:
1980: PROCEDURE get_model_inst_lst(
1981: p_parent_line_id IN number,
1982: x_model_inst_tbl OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
1983: x_return_status OUT NOCOPY varchar2)
1984: IS
1985:
1986: l_ind binary_integer := 0;

Line 2295: p_order_line_rec IN csi_order_ship_pub.order_line_rec)

2291:
2292: END wip_config_exists;
2293:
2294: FUNCTION check_standard_bom(
2295: p_order_line_rec IN csi_order_ship_pub.order_line_rec)
2296: RETURN BOOLEAN
2297: IS
2298:
2299: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

Line 2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

2403: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2404: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2408: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
2409: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
2410: x_return_status OUT nocopy varchar2)
2411: IS

Line 2501: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

2497:
2498: PROCEDURE convert_tpa_to_ipa(
2499: p_instance_party_id IN number,
2500: p_parent_tbl_index IN number,
2501: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2502: p_t_pa_rec IN csi_t_datastructures_grp.txn_pty_acct_detail_rec,
2503: x_i_pa_rec OUT nocopy csi_datastructures_pub.party_account_rec)
2504: IS
2505: BEGIN

Line 3152: l_n_line_dtl_rec.sub_type_id := csi_order_ship_pub.g_dflt_sub_type_id;

3148: END IF;
3149:
3150: l_n_line_dtl_rec.txn_line_detail_id := fnd_api.g_miss_num;
3151: l_n_line_dtl_rec.transaction_line_id := p_transaction_line_id;
3152: l_n_line_dtl_rec.sub_type_id := csi_order_ship_pub.g_dflt_sub_type_id;
3153: l_n_line_dtl_rec.processing_status := 'IN_PROCESS';
3154: l_n_line_dtl_rec.source_transaction_flag := 'N';
3155: l_n_line_dtl_rec.inventory_item_id := l_g_instance_rec.inventory_item_id;
3156: l_n_line_dtl_rec.inventory_revision := l_g_instance_rec.inventory_revision;

Line 3203: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

3199: x_return_status := fnd_api.g_ret_sts_error;
3200: END build_non_source_rec;
3201:
3202: PROCEDURE build_parent_relation(
3203: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
3204: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
3205: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3206: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
3207: x_return_status OUT NOCOPY VARCHAR2)

Line 3204: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,

3200: END build_non_source_rec;
3201:
3202: PROCEDURE build_parent_relation(
3203: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
3204: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
3205: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3206: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
3207: x_return_status OUT NOCOPY VARCHAR2)
3208: IS

Line 3217: px_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl)

3213: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3214:
3215: PROCEDURE filter_model_instances( --modified for bug5096435
3216: p_child_item_id IN number,
3217: px_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl)
3218: IS
3219: CURSOR iir_cur(p_object_id in number, p_item_id in number) IS
3220: SELECT cii.quantity alloc_quantity
3221: FROM csi_ii_relationships ciir,

Line 3519: x_mtl_txn_rec OUT NOCOPY csi_order_ship_pub.MTL_TXN_REC,

3515:
3516:
3517: PROCEDURE get_source_trx_dtls(
3518: p_mtl_transaction_id IN NUMBER,
3519: x_mtl_txn_rec OUT NOCOPY csi_order_ship_pub.MTL_TXN_REC,
3520: x_error_message OUT NOCOPY VARCHAR2,
3521: x_return_status OUT NOCOPY VARCHAR2)
3522: IS
3523: BEGIN

Line 4267: WHERE transaction_type_id = csi_order_ship_pub.g_txn_type_id

4263: non_src_change_owner_to_code
4264: INTO l_non_source_change_owner,
4265: l_non_src_change_owner_code
4266: FROM csi_txn_sub_types
4267: WHERE transaction_type_id = csi_order_ship_pub.g_txn_type_id
4268: AND sub_type_id = p_trx_rec.txn_sub_type_id;
4269:
4270: EXCEPTION
4271: WHEN no_data_found THEN

Line 4381: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

4377: PROCEDURE get_ii_relation_tbl(
4378: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4379: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4380: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4381: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4382: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4383: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4384: x_return_status OUT NOCOPY VARCHAR2)
4385: IS

Line 5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,

5625: PROCEDURE get_party_owner(
5626: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5627: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5628: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5633: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

Line 5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

5626: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5627: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5628: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5633: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5634: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

Line 5960: p_item_control_rec IN csi_order_ship_pub.item_control_rec)

5956:
5957:
5958: /* local debug dump routines */
5959: PROCEDURE dump_item_control_rec(
5960: p_item_control_rec IN csi_order_ship_pub.item_control_rec)
5961: IS
5962: l_rec csi_order_ship_pub.item_control_rec;
5963: BEGIN
5964:

Line 5962: l_rec csi_order_ship_pub.item_control_rec;

5958: /* local debug dump routines */
5959: PROCEDURE dump_item_control_rec(
5960: p_item_control_rec IN csi_order_ship_pub.item_control_rec)
5961: IS
5962: l_rec csi_order_ship_pub.item_control_rec;
5963: BEGIN
5964:
5965: l_rec := p_item_control_rec;
5966:

Line 5983: x_item_control_rec OUT NOCOPY csi_order_ship_pub.item_control_rec,

5979: END dump_item_control_rec;
5980:
5981: PROCEDURE get_item_control_rec(
5982: p_mtl_txn_id IN number,
5983: x_item_control_rec OUT NOCOPY csi_order_ship_pub.item_control_rec,
5984: x_return_status OUT NOCOPY varchar2)
5985: IS
5986:
5987: l_item_control_rec csi_order_ship_pub.item_control_rec;

Line 5987: l_item_control_rec csi_order_ship_pub.item_control_rec;

5983: x_item_control_rec OUT NOCOPY csi_order_ship_pub.item_control_rec,
5984: x_return_status OUT NOCOPY varchar2)
5985: IS
5986:
5987: l_item_control_rec csi_order_ship_pub.item_control_rec;
5988:
5989: BEGIN
5990:
5991: api_log('get_item_control_rec');

Line 6607: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;

6603: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,
6604: x_return_status OUT NOCOPY varchar2)
6605: IS
6606:
6607: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;
6608:
6609: l_instance_tbl csi_datastructures_pub.instance_tbl;
6610:
6611: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

Line 6692: l_line_dtl_rec.sub_type_id := csi_order_ship_pub.g_dflt_sub_type_id;

6688: IF l_object_id is not null THEN
6689:
6690: l_line_dtl_rec.txn_line_detail_id := fnd_api.g_miss_num;
6691: l_line_dtl_rec.transaction_line_id := p_model_txn_line_rec.transaction_line_id;
6692: l_line_dtl_rec.sub_type_id := csi_order_ship_pub.g_dflt_sub_type_id;
6693: l_line_dtl_rec.processing_status := 'IN_PROCESS';
6694: l_line_dtl_rec.source_transaction_flag := 'N';
6695: l_line_dtl_rec.inventory_item_id := l_instance_tbl(l_ind).inventory_item_id;
6696: l_line_dtl_rec.inventory_revision := l_instance_tbl(l_ind).inventory_revision;

Line 6924: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

6920:
6921: END get_config_children;
6922:
6923: PROCEDURE get_ib_trackable_children(
6924: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
6925: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
6926: x_return_status OUT NOCOPY varchar2)
6927: IS
6928: l_line_tbl oe_order_pub.line_tbl_type;

Line 7027: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

7023:
7024: END filter_processed_instances;
7025:
7026: PROCEDURE build_child_relation(
7027: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
7028: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
7029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7030: x_return_status OUT NOCOPY varchar2)
7031: IS

Line 7354: px_item_control_rec IN OUT nocopy csi_order_ship_pub.item_control_rec,

7350:
7351: PROCEDURE get_unit_price_in_primary_uom(
7352: p_unit_price IN number,
7353: p_unit_price_uom IN varchar2,
7354: px_item_control_rec IN OUT nocopy csi_order_ship_pub.item_control_rec,
7355: x_unit_price_in_primary_uom OUT nocopy number,
7356: x_return_status OUT nocopy varchar2)
7357: IS
7358: l_uom_conv_rate number;