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 16291: FROM csi_ii_forward_sync_temp

16287: instance_id,
16288: date_time_stamp,
16289: mtl_txn_id,
16290: error_message
16291: FROM csi_ii_forward_sync_temp
16292: WHERE process_flag <> 'P';
16293:
16294: CURSOR err_txn_cur (p_item_id IN number, p_serial_number IN varchar2) IS
16295: SELECT cdt.mtl_txn_name,

Line 16355: FROM csi_ii_forward_sync_temp

16351: l_creation_date date;
16352:
16353: CURSOR fs_cur IS
16354: SELECT mtl_txn_id
16355: FROM csi_ii_forward_sync_temp
16356: WHERE process_flag <> 'P'
16357: AND mtl_txn_creation_date is null
16358: FOR UPDATE OF mtl_txn_creation_date;
16359: BEGIN

Line 16367: UPDATE csi_ii_forward_sync_temp

16363: INTO l_creation_date
16364: FROM mtl_material_transactions
16365: WHERE transaction_id = fs_rec.mtl_txn_id;
16366:
16367: UPDATE csi_ii_forward_sync_temp
16368: SET mtl_txn_creation_date = l_creation_date
16369: WHERE current of fs_cur;
16370:
16371: END LOOP;

Line 16798: FROM csi_ii_forward_sync_temp

16794: -- Check whether all the instances are forward synched
16795: BEGIN
16796: SELECT count(*)
16797: INTO l_recount
16798: FROM csi_ii_forward_sync_temp
16799: WHERE process_flag <> 'P';
16800: END;
16801: --
16802: IF nvl(l_recount,0) > 0 THEN