eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_SYSTEMS_PVT dependencies on CSI_SYSTEMS_H

Line 417: FROM csi_transactions a, csi_systems_b b,csi_systems_h c

413: l_t_date VARCHAR2(25) := fnd_api.g_miss_char;
414: BEGIN
415: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
416: INTO l_f_date
417: FROM csi_transactions a, csi_systems_b b,csi_systems_h c
418: WHERE b.system_id = c.system_id
419: AND c.transaction_id = a.transaction_id
420: AND c.full_dump_flag = 'Y'
421: AND a.transaction_date <=p_time_stamp

Line 432: FROM csi_transactions a, csi_systems_b b,csi_systems_h c

428: from_time_stamp:=l_f_date;
429: BEGIN
430: SELECT max(min(to_char(a.transaction_date,'dd-mon-rr hh24:mi:ss')))
431: INTO l_t_date
432: FROM csi_transactions a, csi_systems_b b,csi_systems_h c
433: WHERE b.system_id = c.system_id
434: AND c.transaction_id = a.transaction_id
435: AND a.transaction_date <=p_time_stamp
436: AND c.system_id = p_system_id

Line 527: FROM csi_transactions a,csi_systems_b b,csi_systems_h c

523: ,c.new_attribute15
524: ,c.full_dump_flag
525: ,c.old_operating_unit_id
526: ,c.new_operating_unit_id
527: FROM csi_transactions a,csi_systems_b b,csi_systems_h c
528: WHERE b.system_id = c.system_id
529: AND c.transaction_id = a.transaction_id
530: AND c.system_id = p_system_id
531: AND a.transaction_date BETWEEN to_date(p_f_time_stamp,'dd/mm/yyyy hh24:mi:ss')

Line 546: FROM csi_transactions a,csi_systems_h b

542: to_time_stamp => l_t_time_stamp);
543:
544: SELECT max(to_char(a.transaction_date,'dd/mm/yyyy hh24:mi:ss'))
545: INTO l_to_date
546: FROM csi_transactions a,csi_systems_h b
547: WHERE a.transaction_id=b.transaction_id
548: AND b.system_id=p_sys_rec.system_id;
549:
550: IF ( (l_f_time_stamp IS NOT NULL) AND (p_time_stamp>to_date(l_to_date,'dd/mm/yyyy hh24:mi:ss')) ) THEN

Line 1231: FROM csi_systems_h

1227: l_systems_hist_rec csi_datastructures_pub.system_history_rec;
1228:
1229: CURSOR sys_hist_csr (p_sys_hist_id NUMBER) IS
1230: SELECT *
1231: FROM csi_systems_h
1232: WHERE csi_systems_h.system_history_id = p_sys_hist_id
1233: FOR UPDATE OF object_version_number;
1234: l_sys_hist_csr sys_hist_csr%ROWTYPE;
1235: l_sys_hist_id NUMBER;

Line 1232: WHERE csi_systems_h.system_history_id = p_sys_hist_id

1228:
1229: CURSOR sys_hist_csr (p_sys_hist_id NUMBER) IS
1230: SELECT *
1231: FROM csi_systems_h
1232: WHERE csi_systems_h.system_history_id = p_sys_hist_id
1233: FOR UPDATE OF object_version_number;
1234: l_sys_hist_csr sys_hist_csr%ROWTYPE;
1235: l_sys_hist_id NUMBER;
1236:

Line 1260: FROM csi_systems_h h

1256:
1257: BEGIN
1258: SELECT system_history_id
1259: INTO l_sys_hist_id
1260: FROM csi_systems_h h
1261: WHERE h.transaction_id = p_transaction_id
1262: AND h.system_id = p_old_systems_rec.system_id;
1263:
1264: OPEN sys_hist_csr(l_sys_hist_id);

Line 1270: csi_systems_h_pkg.update_row(

1266: CLOSE sys_hist_csr;
1267:
1268: IF l_sys_hist_csr.full_dump_flag = 'Y'
1269: THEN
1270: csi_systems_h_pkg.update_row(
1271: p_system_history_id => l_sys_hist_id,
1272: p_system_id => fnd_api.g_miss_num,
1273: p_transaction_id => fnd_api.g_miss_num,
1274: p_old_customer_id => fnd_api.g_miss_num,

Line 1881: csi_systems_h_pkg.update_row(

1877: l_sys_hist_csr.new_operating_unit_id := l_new_systems_rec.operating_unit_id;
1878: END IF;
1879: --
1880:
1881: csi_systems_h_pkg.update_row(
1882: p_system_history_id => l_sys_hist_id,
1883: p_system_id => fnd_api.g_miss_num,
1884: p_transaction_id => fnd_api.g_miss_num,
1885: p_old_customer_id => l_sys_hist_csr.old_customer_id,

Line 1968: csi_systems_h_pkg.insert_row(

1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN
1966:
1967: IF mod(l_old_systems_rec.object_version_number+1,l_full_dump)=0 THEN
1968: csi_systems_h_pkg.insert_row(
1969: px_system_history_id => l_systems_hist_rec.system_history_id,
1970: p_system_id => l_old_systems_rec.system_id,
1971: p_transaction_id => l_transaction_id,
1972: p_old_customer_id => l_old_systems_rec.customer_id,

Line 2406: csi_systems_h_pkg.insert_row(

2402: IF p_flag = 'EXPIRE' THEN
2403: l_systems_hist_rec.new_end_date_active := p_sysdate;
2404: END IF;
2405:
2406: csi_systems_h_pkg.insert_row(
2407: px_system_history_id => l_systems_hist_rec.system_history_id,
2408: p_system_id => l_old_systems_rec.system_id,
2409: p_transaction_id => l_transaction_id,
2410: p_old_customer_id => l_systems_hist_rec.old_customer_id,

Line 2754: csi_systems_h_pkg.insert_row(

2750: RETURN;
2751: END IF;
2752:
2753:
2754: csi_systems_h_pkg.insert_row(
2755: px_system_history_id => l_system_history_id,
2756: p_system_id => l_system_id,
2757: p_transaction_id => p_txn_rec.transaction_id,
2758: p_old_customer_id => NULL,

Line 3289: FROM csi_systems_h s,

3285: THEN
3286: BEGIN
3287: SELECT MAX(t.transaction_date)
3288: INTO l_transaction_date
3289: FROM csi_systems_h s,
3290: csi_transactions t
3291: WHERE s.system_id=p_system_rec.system_id
3292: AND s.transaction_id=t.transaction_id;
3293: -- srramakar. Exception handled right after select rather than at the end.

Line 6109: FROM CSI_SYSTEMS_H

6105: --
6106: CURSOR txn_hist_csr(p_txn_id IN NUMBER
6107: ,p_sys_id IN NUMBER) IS
6108: SELECT *
6109: FROM CSI_SYSTEMS_H
6110: WHERE transaction_id = p_txn_id
6111: AND system_id = p_sys_id;
6112: --
6113: l_old_sys_header_rec csi_datastructures_pub.system_header_rec;