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_T_TXN_OUS_PVT dependencies on CSI_T_ORG_ASSIGNMENTS

Line 135: p_pkg_name => 'csi_t_org_assignments_pkg');

131: begin
132:
133: csi_t_gen_utility_pvt.dump_api_info(
134: p_api_name => 'insert_row',
135: p_pkg_name => 'csi_t_org_assignments_pkg');
136:
137: csi_t_org_assignments_pkg.insert_row(
138: px_txn_operating_unit_id => l_txn_operating_unit_id,
139: p_txn_line_detail_id => p_txn_org_assgn_rec.txn_line_detail_id,

Line 137: csi_t_org_assignments_pkg.insert_row(

133: csi_t_gen_utility_pvt.dump_api_info(
134: p_api_name => 'insert_row',
135: p_pkg_name => 'csi_t_org_assignments_pkg');
136:
137: csi_t_org_assignments_pkg.insert_row(
138: px_txn_operating_unit_id => l_txn_operating_unit_id,
139: p_txn_line_detail_id => p_txn_org_assgn_rec.txn_line_detail_id,
140: p_operating_unit_id => p_txn_org_assgn_rec.operating_unit_id,
141: p_relationship_type_code => p_txn_org_assgn_rec.relationship_type_code,

Line 173: 'csi_t_org_assignments_pkg.insert_row Failed. '||substr(sqlerrm,1,200));

169: exception
170: when others then
171: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
172: fnd_message.set_token('MESSAGE',
173: 'csi_t_org_assignments_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
174: fnd_msg_pub.add;
175: raise fnd_api.g_exc_error;
176: end;
177:

Line 248: l_ou_rec csi_t_org_assignments%rowtype;

244: l_api_version CONSTANT NUMBER := 1.0;
245: l_debug_level NUMBER;
246:
247: l_return_status VARCHAR2(1);
248: l_ou_rec csi_t_org_assignments%rowtype;
249: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
250: l_valid BOOLEAN := TRUE;
251:
252: CURSOR ou_cur (l_txn_ou_id in number) IS

Line 254: FROM csi_t_org_assignments

250: l_valid BOOLEAN := TRUE;
251:
252: CURSOR ou_cur (l_txn_ou_id in number) IS
253: SELECT *
254: FROM csi_t_org_assignments
255: WHERE txn_operating_unit_id = l_txn_ou_id;
256:
257: BEGIN
258:

Line 431: p_pkg_name => 'csi_t_org_assignments_pkg',

427: --debug info
428: begin
429:
430: csi_t_gen_utility_pvt.dump_api_info(
431: p_pkg_name => 'csi_t_org_assignments_pkg',
432: p_api_name => 'update_row');
433:
434: csi_t_org_assignments_pkg.update_row(
435: p_txn_operating_unit_id => l_ou_rec.txn_operating_unit_id,

Line 434: csi_t_org_assignments_pkg.update_row(

430: csi_t_gen_utility_pvt.dump_api_info(
431: p_pkg_name => 'csi_t_org_assignments_pkg',
432: p_api_name => 'update_row');
433:
434: csi_t_org_assignments_pkg.update_row(
435: p_txn_operating_unit_id => l_ou_rec.txn_operating_unit_id,
436: p_txn_line_detail_id => l_ou_rec.txn_line_detail_id,
437: p_operating_unit_id => l_ou_rec.operating_unit_id,
438: p_relationship_type_code=> l_ou_rec.relationship_type_code,

Line 470: 'csi_t_org_assignments_pkg.update_row failed. '||substr(sqlerrm,1,200));

466: exception
467: when others then
468: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
469: fnd_message.set_token('MESSAGE',
470: 'csi_t_org_assignments_pkg.update_row failed. '||substr(sqlerrm,1,200));
471: fnd_msg_pub.add;
472: raise fnd_api.g_exc_error;
473: end;
474:

Line 549: FROM csi_t_org_assignments

545: l_line_dtl_id NUMBER;
546:
547: CURSOR ou_cur (p_line_dtl_id IN NUMBER) IS
548: SELECT txn_operating_unit_id
549: FROM csi_t_org_assignments
550: WHERE txn_line_detail_id = p_line_dtl_id;
551:
552: BEGIN
553:

Line 618: p_pkg_name => 'csi_t_org_assignments_pkg');

614:
615: --debug info
616: csi_t_gen_utility_pvt.dump_api_info(
617: p_api_name => 'delete_row',
618: p_pkg_name => 'csi_t_org_assignments_pkg');
619:
620: csi_t_org_assignments_pkg.delete_row(
621: p_txn_operating_unit_id => l_txn_ou_id);
622:

Line 620: csi_t_org_assignments_pkg.delete_row(

616: csi_t_gen_utility_pvt.dump_api_info(
617: p_api_name => 'delete_row',
618: p_pkg_name => 'csi_t_org_assignments_pkg');
619:
620: csi_t_org_assignments_pkg.delete_row(
621: p_txn_operating_unit_id => l_txn_ou_id);
622:
623: ELSE
624:

Line 651: p_pkg_name => 'csi_t_org_assignments_pkg');

647: LOOP
648:
649: csi_t_gen_utility_pvt.dump_api_info(
650: p_api_name => 'delete_row',
651: p_pkg_name => 'csi_t_org_assignments_pkg');
652:
653: csi_t_org_assignments_pkg.delete_row(
654: p_txn_operating_unit_id => ou_rec.txn_operating_unit_id);
655:

Line 653: csi_t_org_assignments_pkg.delete_row(

649: csi_t_gen_utility_pvt.dump_api_info(
650: p_api_name => 'delete_row',
651: p_pkg_name => 'csi_t_org_assignments_pkg');
652:
653: csi_t_org_assignments_pkg.delete_row(
654: p_txn_operating_unit_id => ou_rec.txn_operating_unit_id);
655:
656: END LOOP;
657:

Line 732: 'from csi_t_org_assignments '||

728: ' operating_unit_id, relationship_type_code, active_start_date, active_end_date, '||
729: ' preserve_detail_flag, context, attribute1, attribute2, attribute3, attribute4, '||
730: ' attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, '||
731: ' attribute11, attribute12, attribute13, attribute14, attribute15, object_version_number '||
732: 'from csi_t_org_assignments '||
733: 'where txn_line_detail_id = :line_dtl_id';
734:
735: l_oa_cur_id := dbms_sql.open_cursor;
736: