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_B

Line 291: FROM csi_systems_b ';

287: start_date_active,end_date_active,context,attribute1,attribute2,attribute3,
288: attribute4,attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,
289: attribute11,attribute12,attribute13,attribute14,attribute15,object_version_number,
290: operating_unit_id
291: FROM csi_systems_b ';
292:
293:
294:
295: END gen_select;

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 1181: FROM csi_systems_b

1177: x_msg_data OUT NOCOPY VARCHAR2) IS
1178:
1179: CURSOR par_chld_csr IS
1180: SELECT 'x'
1181: FROM csi_systems_b
1182: WHERE system_id = x_parent_system_id
1183: START WITH parent_system_id = x_system_id
1184: CONNECT BY parent_system_id = prior system_id;
1185: l_dummy VARCHAR2(1);

Line 2675: -- invoke table handler(csi_systems_b_pkg.insert_row)

2671: END IF;
2672:
2673:
2674: IF x_return_status = fnd_api.g_ret_sts_success THEN
2675: -- invoke table handler(csi_systems_b_pkg.insert_row)
2676:
2677:
2678: csi_systems_b_pkg.insert_row(
2679: px_system_id => x_system_id,

Line 2678: csi_systems_b_pkg.insert_row(

2674: IF x_return_status = fnd_api.g_ret_sts_success THEN
2675: -- invoke table handler(csi_systems_b_pkg.insert_row)
2676:
2677:
2678: csi_systems_b_pkg.insert_row(
2679: px_system_id => x_system_id,
2680: p_customer_id => p_system_rec.customer_id,
2681: p_system_type_code => p_system_rec.system_type_code,
2682: p_system_number => p_system_rec.system_number,

Line 2945: FROM csi_systems_b

2941: attribute14,
2942: attribute15,
2943: object_version_number,
2944: operating_unit_id
2945: FROM csi_systems_b
2946: WHERE system_id=sys_id
2947: FOR UPDATE OF object_version_number ;
2948:
2949: CURSOR tl_csr (sys_id NUMBER) IS

Line 3334: -- invoke table handler(csi_systems_b_pkg.update_row)

3330: -- rather than going to the actual fnd_api.g_exc_error.
3331: ELSE
3332:
3333: IF x_return_status = fnd_api.g_ret_sts_success THEN
3334: -- invoke table handler(csi_systems_b_pkg.update_row)
3335: IF p_txn_rec.source_group_ref = 'XFER' THEN
3336:
3337: csi_systems_b_pkg.update_row_for_mu(
3338: p_system_id => p_system_rec.system_id,

Line 3337: csi_systems_b_pkg.update_row_for_mu(

3333: IF x_return_status = fnd_api.g_ret_sts_success THEN
3334: -- invoke table handler(csi_systems_b_pkg.update_row)
3335: IF p_txn_rec.source_group_ref = 'XFER' THEN
3336:
3337: csi_systems_b_pkg.update_row_for_mu(
3338: p_system_id => p_system_rec.system_id,
3339: p_customer_id => p_system_rec.customer_id,
3340: p_system_type_code => p_system_rec.system_type_code,
3341: p_system_number => p_system_rec.system_number,

Line 3385: csi_systems_b_pkg.update_row(

3381: p_program_id => p_system_rec.program_id,
3382: p_program_update_date => p_system_rec.program_update_date);
3383: ELSE
3384:
3385: csi_systems_b_pkg.update_row(
3386: p_system_id => p_system_rec.system_id,
3387: p_customer_id => p_system_rec.customer_id,
3388: p_system_type_code => p_system_rec.system_type_code,
3389: p_system_number => p_system_rec.system_number,

Line 4022: FROM csi_systems_b

4018: attribute14,
4019: attribute15,
4020: object_version_number,
4021: operating_unit_id
4022: FROM csi_systems_b
4023: WHERE system_id=p_system_id
4024: FOR UPDATE OF object_version_number ;
4025:
4026: CURSOR tl_csr (sys_id NUMBER) IS

Line 4245: csi_systems_b_pkg.update_row(

4241: END LOOP; -- Instance loop
4242: END IF; -- cascade profile check
4243: --
4244: -- Moved down for Bug # 3031086.
4245: csi_systems_b_pkg.update_row(
4246: p_system_id => p_system_rec.system_id,
4247: p_customer_id => p_system_rec.customer_id,
4248: p_system_type_code => p_system_rec.system_type_code,
4249: p_system_number => p_system_rec.system_number,

Line 4417: FROM csi_systems_b

4413: THEN
4414: BEGIN
4415: SELECT 'x'
4416: INTO l_dummy
4417: FROM csi_systems_b
4418: WHERE system_id=p_system_id;
4419: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');
4420: fnd_message.set_token('system_id',p_system_id);
4421: fnd_msg_pub.add;

Line 4435: FROM csi_systems_b

4431: THEN
4432: BEGIN
4433: SELECT 'x'
4434: INTO l_dummy
4435: FROM csi_systems_b
4436: WHERE system_id=p_system_id;
4437: EXCEPTION
4438: WHEN no_data_found THEN
4439: fnd_message.set_name('CSI', 'CSI_INVALID_SYSTEM_ID');

Line 4656: FROM csi_systems_b

4652: THEN
4653: BEGIN
4654: SELECT 'x'
4655: INTO l_dummy
4656: FROM csi_systems_b
4657: WHERE system_id=p_parent_system_id;
4658: EXCEPTION
4659: WHEN no_data_found THEN
4660: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');

Line 4674: FROM csi_systems_b

4670: THEN
4671: BEGIN
4672: SELECT 'x'
4673: INTO l_dummy
4674: FROM csi_systems_b
4675: WHERE system_id=p_parent_system_id;
4676: EXCEPTION
4677: WHEN no_data_found THEN
4678: fnd_message.set_name('CSI', 'CSI_INVALID_PARENT_SYS_ID');

Line 5179: FROM csi_systems_b

5175: THEN
5176: BEGIN
5177: SELECT 'x'
5178: INTO l_dummy
5179: FROM csi_systems_b
5180: WHERE system_id=p_auto_sys_id;
5181: EXCEPTION
5182: WHEN no_data_found THEN
5183: fnd_message.set_name('CSI', 'CSI_INVALID_AUTOSYS_ID');

Line 5260: FROM csi_systems_b

5256: THEN
5257: BEGIN
5258: SELECT start_date_active
5259: INTO l_start_date_active
5260: FROM csi_systems_b
5261: WHERE system_id = p_system_id;
5262: IF l_start_date_active > p_end_date
5263: THEN
5264: fnd_message.set_name('CSI', 'CSI_START_DATE_GREATER');