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 389: UPDATE csi_instance_interface a

385: -- X = Intermediate Process Status
386: -- P = Processed No Error
387: -- E = Error
388:
389: UPDATE csi_instance_interface a
390: SET process_status = 'X'
391: WHERE trunc(source_transaction_date) BETWEEN
392: nvl(l_txn_from_date,trunc(source_transaction_date)) AND
393: nvl(l_txn_to_date,trunc(source_transaction_date))

Line 572: UPDATE csi_instance_interface

568: END IF;
569: j := 1;
570:
571: FOR j in l_inst_id_tbl.FIRST .. l_inst_id_tbl.LAST LOOP
572: UPDATE csi_instance_interface
573: SET parallel_worker_id = -1
574: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
575: END LOOP;
576: COMMIT;

Line 606: UPDATE csi_instance_interface

602: END IF;
603: j := 1;
604: FOR j in l_inst_id_tbl.FIRST .. l_inst_id_tbl.LAST LOOP
605:
606: UPDATE csi_instance_interface
607: SET parallel_worker_id = -1
608: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
609:
610: END LOOP;

Line 621: UPDATE csi_instance_interface

617: END IF;
618: j := 1;
619: FOR j in l_inst_id_tbl.FIRST .. l_inst_id_tbl.LAST LOOP
620:
621: UPDATE csi_instance_interface
622: SET parallel_worker_id = -1
623: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
624:
625: END LOOP;

Line 640: UPDATE csi_instance_interface

636:
637: j := 1;
638: FOR j in l_inst_id_tbl.FIRST .. l_inst_id_tbl.LAST LOOP
639:
640: UPDATE csi_instance_interface
641: SET parallel_worker_id = -1
642: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
643:
644: END LOOP;