DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on CSI_UTL_PKG

Line 199: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893--commented for bug#16046156

195:
196: SELECT primary_uom_code,
197: serial_number_control_code,
198: --lot_control_code,
199: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),lot_control_code) lot_control_code,-- Added for bug#14835893--commented for bug#16046156
200: revision_qty_control_code,
201: location_control_code,
202: comms_nl_trackable_flag,
203: bom_item_type,

Line 434: csi_utl_pkg.make_non_header_tbl(

430:
431:
432: l_instance_hdr_tbl(1) := p_instance_hdr_rec;
433:
434: csi_utl_pkg.make_non_header_tbl(
435: p_instance_header_tbl => l_instance_hdr_tbl,
436: x_instance_tbl => l_instance_tbl,
437: x_return_status => l_return_status);
438:

Line 1078: csi_utl_pkg.make_non_header_tbl(

1074: debug('Assembly instances count :'||l_instance_hdr_tbl.COUNT);
1075:
1076: IF l_instance_hdr_tbl.COUNT > 0 THEN
1077:
1078: csi_utl_pkg.make_non_header_tbl(
1079: p_instance_header_tbl => l_instance_hdr_tbl,
1080: x_instance_tbl => l_instance_tbl,
1081: x_return_status => l_return_status);
1082:

Line 1342: csi_utl_pkg.make_non_header_tbl(

1338: ELSE
1339: debug('Issued instances not found for inventory item id: '||p_inventory_item_id);
1340: END IF;
1341:
1342: csi_utl_pkg.make_non_header_tbl(
1343: p_instance_header_tbl => l_instance_hdr_tbl,
1344: x_instance_tbl => l_instance_tbl,
1345: x_return_status => l_return_status);
1346:

Line 1417: csi_utl_pkg.make_non_header_tbl(

1413: END IF;
1414:
1415: IF l_instance_hdr_tbl.COUNT > 0 THEN
1416: debug('instance tbl count :'||l_instance_hdr_tbl.COUNT);
1417: csi_utl_pkg.make_non_header_tbl(
1418: p_instance_header_tbl => l_instance_hdr_tbl,
1419: x_instance_tbl => l_instance_tbl,
1420: x_return_status => l_return_status);
1421:

Line 5044: csi_utl_pkg.make_non_header_tbl(

5040: RAISE fnd_api.g_exc_error;
5041: END IF;
5042:
5043: IF l_instance_hdr_tbl.COUNT > 0 THEN
5044: csi_utl_pkg.make_non_header_tbl(
5045: p_instance_header_tbl => l_instance_hdr_tbl,
5046: x_instance_tbl => l_instance_tbl,
5047: x_return_status => l_return_status);
5048: