APPS.CSI_ML_CREATE_PUB dependencies on CSI_INSTANCE_INTERFACE

Line 57: FROM csi_instance_interface a

53: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
54:
55: CURSOR c_id is
56: SELECT a.inst_interface_id
57: FROM csi_instance_interface a
58: WHERE a.process_status = 'X';
59:
60: r_id c_id%rowtype;
61: RESOLVE_ERROR EXCEPTION;

Line 78: FROM csi_instance_interface

74: l_txn_to_date := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
75: -- get the number of records and fiqure out how many loops to do
76: SELECT ceil(count(1)/l_commit_recs)
77: INTO x_count
78: FROM csi_instance_interface
79: WHERE trunc(source_transaction_date) BETWEEN
80: nvl(l_txn_from_date,trunc(source_transaction_date)) AND
81: nvl(l_txn_to_date,trunc(source_transaction_date))
82: AND process_status = 'R'

Line 101: UPDATE csi_instance_interface a

97: -- X = Intermediate Process Status
98: -- P = Processed No Error
99: -- E = Error
100:
101: UPDATE csi_instance_interface a
102: SET process_status = 'X'
103: WHERE trunc(source_transaction_date) BETWEEN
104: nvl(l_txn_from_date,trunc(source_transaction_date)) AND
105: nvl(l_txn_to_date,trunc(source_transaction_date))

Line 325: FROM csi_instance_interface

321: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CSI_DEBUG_LEVEL'), '0'));
322:
323: CURSOR c_id (pc_parallel_worker_id IN NUMBER) is
324: SELECT inst_interface_id,process_status
325: FROM csi_instance_interface
326: WHERE process_status = 'X'
327: AND nvl(transaction_identifier,'-1') = '-1'
328: AND parallel_worker_id = pc_parallel_worker_id;
329:

Line 359: FROM csi_instance_interface

355:
356: -- Get the number of records and fiqure out how many loops to do
357: SELECT ceil(count(1)/l_commit_recs)
358: INTO x_count
359: FROM csi_instance_interface
360: WHERE trunc(source_transaction_date) BETWEEN
361: nvl(l_txn_from_date,trunc(source_transaction_date)) AND
362: nvl(l_txn_to_date,trunc(source_transaction_date))
363: AND nvl(transaction_identifier,'-1') = '-1'

Line 384: UPDATE csi_instance_interface a

380: -- X = Intermediate Process Status
381: -- P = Processed No Error
382: -- E = Error
383:
384: UPDATE csi_instance_interface a
385: SET process_status = 'X'
386: WHERE trunc(source_transaction_date) BETWEEN
387: nvl(l_txn_from_date,trunc(source_transaction_date)) AND
388: nvl(l_txn_to_date,trunc(source_transaction_date))

Line 578: UPDATE csi_instance_interface

574: END IF;
575: j := 1;
576: FOR j in l_inst_id_tbl.FIRST .. l_inst_id_tbl.LAST LOOP
577:
578: UPDATE csi_instance_interface
579: SET parallel_worker_id = -1
580: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
581:
582: END LOOP;

Line 593: UPDATE csi_instance_interface

589: END IF;
590: j := 1;
591: FOR j in l_inst_id_tbl.FIRST .. l_inst_id_tbl.LAST LOOP
592:
593: UPDATE csi_instance_interface
594: SET parallel_worker_id = -1
595: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
596:
597: END LOOP;

Line 612: UPDATE csi_instance_interface

608:
609: j := 1;
610: FOR j in l_inst_id_tbl.FIRST .. l_inst_id_tbl.LAST LOOP
611:
612: UPDATE csi_instance_interface
613: SET parallel_worker_id = -1
614: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
615:
616: END LOOP;