APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_II_FORWARD_SYNC_TEMP

Line 1002: FROM csi_ii_forward_sync_temp

998: serial_number,
999: lot_control_code,
1000: mtl_txn_id,
1001: mtl_txn_creation_date
1002: FROM csi_ii_forward_sync_temp
1003: WHERE process_flag <> 'P';
1004:
1005: l_txn_type_id number;
1006: l_error_exists varchar2(1) := 'N';

Line 1086: SELECT csi_ii_forward_sync_temp_s.nextval

1082: l_csi_txn_rec.transaction_date := sysdate;
1083: l_csi_txn_rec.source_transaction_date := sysdate;
1084: l_csi_txn_rec.source_header_ref := 'Forward Synch';
1085:
1086: SELECT csi_ii_forward_sync_temp_s.nextval
1087: INTO l_csi_txn_rec.source_line_ref_id
1088: FROM sys.dual;
1089:
1090: FOR fs_rec IN fs_cur

Line 1353: UPDATE csi_ii_forward_sync_temp

1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351: END IF;
1352:
1353: UPDATE csi_ii_forward_sync_temp
1354: SET process_flag = 'P'
1355: WHERE instance_id = fs_rec.instance_id;
1356:
1357: EXCEPTION

Line 5212: FROM csi_ii_forward_sync_temp

5208: SELECT process_flag,
5209: date_time_stamp
5210: INTO l_process_flag,
5211: l_current_date
5212: FROM csi_ii_forward_sync_temp
5213: WHERE instance_id = m_srl_rec.instance_id;
5214:
5215: IF l_process_flag = 'P' THEN
5216: Insert_Full_Dump(p_instance_id => m_srl_rec.instance_id);

Line 5222: UPDATE csi_ii_forward_sync_temp

5218: ELSE
5219: l_current_date := l_current_date;
5220: END IF;
5221:
5222: UPDATE csi_ii_forward_sync_temp
5223: SET date_time_stamp = l_current_date,
5224: mtl_txn_id = l_p_mtl_txn_id,
5225: mtl_txn_creation_date = l_p_mtl_creation_date,
5226: contracts_flag = l_contracts_flag,

Line 5234: INSERT INTO csi_ii_forward_sync_temp(

5230: EXCEPTION
5231: WHEN no_data_found THEN
5232: Insert_Full_Dump(p_instance_id => m_srl_rec.instance_id);
5233: --
5234: INSERT INTO csi_ii_forward_sync_temp(
5235: instance_id,
5236: serial_number,
5237: inventory_item_id,
5238: lot_control_code,

Line 5498: SELECT csi_ii_forward_sync_temp_s.nextval

5494: identify_progressed(
5495: x_progressed => l_progressed);
5496:
5497: IF l_progressed THEN
5498: SELECT csi_ii_forward_sync_temp_s.nextval
5499: INTO l_seq_value
5500: FROM sys.dual;
5501: END IF;
5502:

Line 8943: FROM csi_ii_forward_sync_temp

8939: BEGIN
8940:
8941: SELECT 'Y'
8942: INTO l_fs_found
8943: FROM csi_ii_forward_sync_temp
8944: WHERE inventory_item_id = srl_rec.inventory_item_id
8945: AND serial_number = srl_rec.serial_number
8946: AND process_flag <> 'P';
8947:

Line 16280: FROM csi_ii_forward_sync_temp

16276: instance_id,
16277: date_time_stamp,
16278: mtl_txn_id,
16279: error_message
16280: FROM csi_ii_forward_sync_temp
16281: WHERE process_flag <> 'P';
16282:
16283: CURSOR err_txn_cur (p_item_id IN number, p_serial_number IN varchar2) IS
16284: SELECT cdt.mtl_txn_name,

Line 16344: FROM csi_ii_forward_sync_temp

16340: l_creation_date date;
16341:
16342: CURSOR fs_cur IS
16343: SELECT mtl_txn_id
16344: FROM csi_ii_forward_sync_temp
16345: WHERE process_flag <> 'P'
16346: AND mtl_txn_creation_date is null
16347: FOR UPDATE OF mtl_txn_creation_date;
16348: BEGIN

Line 16356: UPDATE csi_ii_forward_sync_temp

16352: INTO l_creation_date
16353: FROM mtl_material_transactions
16354: WHERE transaction_id = fs_rec.mtl_txn_id;
16355:
16356: UPDATE csi_ii_forward_sync_temp
16357: SET mtl_txn_creation_date = l_creation_date
16358: WHERE current of fs_cur;
16359:
16360: END LOOP;

Line 16787: FROM csi_ii_forward_sync_temp

16783: -- Check whether all the instances are forward synched
16784: BEGIN
16785: SELECT count(*)
16786: INTO l_recount
16787: FROM csi_ii_forward_sync_temp
16788: WHERE process_flag <> 'P';
16789: END;
16790: --
16791: IF nvl(l_recount,0) > 0 THEN