[Home] [Help]
1520: INTO l_ns_instance_rec.object_version_number,
1521: l_location_code,
1522: l_serial_number,
1523: l_active_end_date
1524: FROM csi_item_instances
1525: WHERE instance_id = p_txn_line_detail_rec.instance_id;
1526:
1527: debug(' TXN Line Dtl ID :'||p_txn_line_detail_rec.txn_line_detail_id);
1528: debug(' Instance ID :'||l_ns_instance_rec.instance_id );
1606: -- expiring the instance back. Added this IF for Bug 3039821
1607:
1608: SELECT object_version_number
1609: INTO l_exp_instance_rec.object_version_number
1610: FROM csi_item_instances
1611: WHERE instance_id = p_txn_line_detail_rec.instance_id;
1612:
1613: l_exp_instance_rec.instance_id := p_txn_line_detail_rec.instance_id;
1614:
2213:
2214: -- debug('After Create OBJECT_VERSION_NUMBER '||l_cre_instance_rec.object_version_number);
2215: Select object_version_number
2216: Into l_zero_instance_rec.object_version_number
2217: From csi_item_instances
2218: Where instance_id = l_cre_instance_rec.instance_id;
2219:
2220: -- debug('Before calling update OBJECT_VERSION_NUMBER '||l_zero_instance_rec.object_version_number);
2221:
2255: -- l_instance_header_tbl(1).object_version_number := l_cre_instance_rec.object_version_number;
2256:
2257: Select object_version_number
2258: Into l_instance_header_tbl(1).object_version_number
2259: From csi_item_instances
2260: Where instance_id = l_zero_instance_rec.instance_id;
2261:
2262: px_error_rec.instance_id := l_zero_instance_rec.instance_id;
2263:
2869:
2870: BEGIN
2871: SELECT instance_usage_code
2872: INTO l_instance_usage_code
2873: FROM csi_item_instances
2874: WHERE instance_id = px_txn_line_detail_tbl(l_ind).instance_id;
2875: EXCEPTION
2876: WHEN no_data_found THEN
2877: l_instance_usage_code := 'NULL';
3818: --START: Bug 12420630 ; FP for Bug 9396215
3819: BEGIN
3820: SELECT last_vld_organization_id
3821: INTO l_last_vld_organization_id
3822: FROM csi_item_instances
3823: WHERE instance_id = p_instance_id;
3824:
3825: l_neg_code := csi_inv_trxs_pkg.get_neg_inv_code(l_last_vld_organization_id);
3826: IF l_neg_code = 1 THEN
3836: SELECT object_version_number,
3837: quantity - p_quantity
3838: INTO l_instance_rec.object_version_number,
3839: l_instance_rec.quantity
3840: FROM csi_item_instances
3841: WHERE instance_id = l_instance_rec.instance_id;
3842:
3843: csi_t_gen_utility_pvt.dump_api_info(
3844: p_api_name => 'update_item_instance',
4154: l_u_instance_rec.vld_organization_id := p_organization_id;
4155:
4156: SELECT object_version_number
4157: INTO l_u_instance_rec.object_version_number
4158: FROM csi_item_instances
4159: WHERE instance_id = l_u_instance_rec.instance_id;
4160:
4161: csi_item_instance_pub.update_item_instance(
4162: p_api_version => 1.0,
4262: SELECT object_version_number,
4263: location_type_code
4264: INTO l_inst_object_ver_num,
4265: l_location_type_code
4266: FROM csi_item_instances
4267: WHERE instance_id = p_instance_id;
4268:
4269: SELECT * INTO l_order_line_rec
4270: FROM oe_order_lines_all
4450: CURSOR wip_nsrl_cur(p_item_id IN number) IS
4451: SELECT instance_id,
4452: quantity,
4453: serial_number
4454: FROM csi_item_instances
4455: WHERE inventory_item_id = p_item_id
4456: AND location_type_code = 'WIP'
4457: AND wip_job_id = p_wip_entity_id;
4458:
4459: CURSOR wip_inst_cur(p_item_id IN number, p_qty_per_assy IN number) IS
4460: SELECT instance_id,
4461: quantity,
4462: serial_number
4463: FROM csi_item_instances
4464: WHERE inventory_item_id = p_item_id
4465: AND location_type_code = 'WIP'
4466: AND wip_job_id = p_wip_entity_id
4467: AND quantity <= p_qty_per_assy;
4809:
4810: BEGIN
4811: SELECT sum(quantity)
4812: INTO l_total_qty
4813: FROM csi_item_instances
4814: WHERE last_oe_order_line_id = p_order_line_rec.order_line_id
4815: AND inventory_item_id = p_order_line_rec.inv_item_id;
4816: EXCEPTION
4817: WHEN others then
5697: object_version_number
5698: INTO l_so_instance_id,
5699: l_so_qty,
5700: l_so_obj_ver_num
5701: FROM csi_item_instances
5702: WHERE serial_number = l_tld_rec.serial_number
5703: AND inventory_item_id = l_tld_rec.inventory_item_id
5704: AND (instance_usage_code = 'RETURNED' --added the outer braces for bug6310708
5705: --Start of code for 6188180
5786: l_instance_id := l_tld_rec.changed_instance_id;
5787:
5788: SELECT object_version_number
5789: INTO l_inst_obj_ver_num
5790: FROM csi_item_instances
5791: WHERE instance_id = l_tld_rec.changed_instance_id;
5792:
5793: csi_utl_pkg.rebuild_tbls(
5794: p_new_instance_id => l_instance_id,
6156: SELECT owner_party_id,
6157: object_version_number
6158: INTO l_owner_party_id,
6159: l_chg_instance_rec.object_version_number
6160: FROM CSI_ITEM_INSTANCES
6161: WHERE instance_id = l_upd_party_tbl(1).instance_id;
6162:
6163: IF l_owner_party_id <> p_order_line_rec.internal_party_id
6164: AND
6221: /* Fixed for Bug 2728984 */
6222: BEGIN
6223: SELECT object_version_number
6224: INTO l_upd_instance_rec.object_version_number
6225: FROM CSI_ITEM_INSTANCES
6226: WHERE instance_id = l_upd_instance_rec.instance_id;
6227: END;
6228:
6229: BEGIN
8906: LOOP
8907: BEGIN
8908: SELECT instance_id
8909: INTO l_mtl_txn_tbl(ret_ind).instance_id
8910: FROM csi_item_instances
8911: WHERE inventory_item_id = l_mtl_txn_tbl(ret_ind).inventory_item_id
8912: AND serial_number = l_mtl_txn_tbl(ret_ind).serial_number
8913: AND instance_usage_code = 'RETURNED';
8914: EXCEPTION