APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on CSI_ITEM_INSTANCES

Line 2098: l_instance_id csi_item_instances.instance_id%type;

2094: l_commit_size NUMBER := 500;
2095: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
2096: l_lot_ctl_code mtl_system_items.lot_control_code%type;
2097: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
2098: l_instance_id csi_item_instances.instance_id%type;
2099: l_prod_txn_status csd_product_transactions.prod_txn_status%type;
2100:
2101: -- activity record
2102: l_activity_rec activity_rec_type;

Line 2655: from csi_item_instances

2651: IF NVL(l_ib_flag,'N') = 'Y' THEN
2652: BEGIN
2653: Select instance_id
2654: into l_instance_id
2655: from csi_item_instances
2656: where inventory_item_id = I.inventory_item_id
2657: and serial_number = l_st_serial_num;
2658: --and instance_usage_code = 'IN_INVENTORY';
2659: EXCEPTION

Line 3549: from csi_item_instances

3545: IF NVL(RCV.ib_flag,'N') = 'Y' THEN
3546: BEGIN
3547: Select instance_id
3548: into l_instance_id
3549: from csi_item_instances
3550: where inventory_item_id = RCV.item_id
3551: and serial_number = l_serial_num;
3552: Exception
3553: When NO_DATA_FOUND THEN

Line 3917: from csi_item_instances

3913: IF NVL(RCV.ib_flag,'N') = 'Y' THEN
3914: BEGIN
3915: Select instance_id
3916: into l_instance_id
3917: from csi_item_instances
3918: where inventory_item_id = RCV.item_id
3919: and serial_number = l_serial_num;
3920: Exception
3921: When NO_DATA_FOUND THEN

Line 4194: from csi_item_instances

4190: IF NVL(RCV.ib_flag,'N') = 'Y' THEN
4191: BEGIN
4192: Select instance_id
4193: into l_instance_id
4194: from csi_item_instances
4195: where inventory_item_id = RCV.item_id
4196: and serial_number = l_serial_num;
4197: Exception
4198: When NO_DATA_FOUND THEN

Line 4965: from csi_item_instances

4961: IF NVL(RCV.ib_flag,'N') = 'Y' THEN
4962: BEGIN
4963: Select instance_id
4964: into l_instance_id
4965: from csi_item_instances
4966: where inventory_item_id = RCV.item_id
4967: and serial_number = l_serial_num;
4968: Exception
4969: When NO_DATA_FOUND THEN

Line 5338: from csi_item_instances

5334: IF NVL(RCV.ib_flag,'N') = 'Y' THEN
5335: BEGIN
5336: Select instance_id
5337: into l_instance_id
5338: from csi_item_instances
5339: where inventory_item_id = RCV.item_id
5340: and serial_number = l_serial_num;
5341: Exception
5342: When NO_DATA_FOUND THEN

Line 5628: from csi_item_instances

5624: IF NVL(RCV.ib_flag,'N') = 'Y' THEN
5625: BEGIN
5626: Select instance_id
5627: into l_instance_id
5628: from csi_item_instances
5629: where inventory_item_id = RCV.item_id
5630: and serial_number = l_serial_num;
5631: Exception
5632: When NO_DATA_FOUND THEN

Line 6398: FROM csi_item_instances

6394: --Bug#6779806
6395: CURSOR cur_get_instance_id(p_order_line_id number, p_inventory_item_id number)
6396: IS
6397: SELECT instance_id
6398: FROM csi_item_instances
6399: WHERE last_oe_order_line_id = p_order_line_id
6400: AND inventory_item_id = p_inventory_item_id;
6401:
6402: --Bug#6779806

Line 6417: l_instance_id csi_item_instances.instance_id%type;

6413: l_result_ship_qty NUMBER;
6414: l_total_records NUMBER;
6415: l_dummy varchar2(30);
6416: l_commit_size NUMBER := 500;
6417: l_instance_id csi_item_instances.instance_id%type;
6418: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
6419: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
6420:
6421: -- activity record

Line 6705: from csi_item_instances

6701: nvl(l_ib_flag,'N') = 'Y' THEN
6702: Begin
6703: Select instance_id
6704: into l_instance_id
6705: from csi_item_instances
6706: where inventory_item_id = I.inventory_item_id
6707: and serial_number = I.shipped_serial_num;
6708: Exception
6709: When No_Data_Found then

Line 6805: --due to csi_item_instances has not update the instance id yet

6801: IF (NOT(l_serialized) and (nvl(l_ib_flag,'N') = 'Y')
6802: and (l_instance_id is null)
6803: and (l_enable_update_instance ='Y')) then
6804: --do nothing
6805: --due to csi_item_instances has not update the instance id yet
6806: --It is update by the concurent program.
6807: --if there is not instance id yet, we don't want to
6808: --update the history table
6809: null;