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_RLTNSHPS_PVT dependencies on CSI_T_II_RELATIONSHIPS

Line 357: p_pkg_name => 'csi_t_ii_relationships_pkg');

353: begin
354:
355: csi_t_gen_utility_pvt.dump_api_info(
356: p_api_name => 'insert_row',
357: p_pkg_name => 'csi_t_ii_relationships_pkg');
358:
359: csi_t_ii_relationships_pkg.insert_row(
360: px_txn_relationship_id => l_txn_relationship_id,
361: p_transaction_line_id => p_txn_ii_rltns_rec.transaction_line_id,

Line 359: csi_t_ii_relationships_pkg.insert_row(

355: csi_t_gen_utility_pvt.dump_api_info(
356: p_api_name => 'insert_row',
357: p_pkg_name => 'csi_t_ii_relationships_pkg');
358:
359: csi_t_ii_relationships_pkg.insert_row(
360: px_txn_relationship_id => l_txn_relationship_id,
361: p_transaction_line_id => p_txn_ii_rltns_rec.transaction_line_id,
362: p_object_type => p_txn_ii_rltns_rec.object_type,
363: p_object_id => p_txn_ii_rltns_rec.object_id,

Line 411: 'csi_t_ii_relationships_pkg.insert_row Failed. '||substr(sqlerrm,1,200));

407: exception
408: when others then
409: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
410: fnd_message.set_token('MESSAGE',
411: 'csi_t_ii_relationships_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;
414: end;
415:

Line 488: --l_iir_rec csi_t_ii_relationships%ROWTYPE; M-M change . referencing datastructure record instead

484: l_debug_level NUMBER;
485:
486: l_return_status VARCHAR2(1);
487: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
488: --l_iir_rec csi_t_ii_relationships%ROWTYPE; M-M change . referencing datastructure record instead
489: l_iir_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
490: l_txn_line_dtl_rec1 csi_t_datastructures_grp.txn_line_detail_rec;
491: l_txn_line_dtl_rec2 csi_t_datastructures_grp.txn_line_detail_rec;
492: l_txn_line_dtl_g_miss csi_t_datastructures_grp.txn_line_detail_rec;

Line 500: FROM csi_t_ii_relationships

496: l_obj_tld_id NUMBER ;
497:
498: CURSOR iir_cur(p_rltns_id IN NUMBER) IS
499: SELECT *
500: FROM csi_t_ii_relationships
501: WHERE txn_relationship_id = p_rltns_id;
502:
503: BEGIN
504:

Line 909: p_pkg_name => 'csi_t_ii_relationships_pkg');

905: begin
906:
907: csi_t_gen_utility_pvt.dump_api_info(
908: p_api_name => 'update_row',
909: p_pkg_name => 'csi_t_ii_relationships_pkg');
910:
911: csi_t_ii_relationships_pkg.update_row(
912: p_txn_relationship_id => l_iir_rec.txn_relationship_id,
913: p_transaction_line_id => l_iir_rec.transaction_line_id,

Line 911: csi_t_ii_relationships_pkg.update_row(

907: csi_t_gen_utility_pvt.dump_api_info(
908: p_api_name => 'update_row',
909: p_pkg_name => 'csi_t_ii_relationships_pkg');
910:
911: csi_t_ii_relationships_pkg.update_row(
912: p_txn_relationship_id => l_iir_rec.txn_relationship_id,
913: p_transaction_line_id => l_iir_rec.transaction_line_id,
914: p_object_type => l_iir_rec.object_type,
915: p_object_id => l_iir_rec.object_id,

Line 962: 'csi_t_ii_relationships_pkg.update_row Failed. '||substr(sqlerrm,1,200));

958: exception
959: when others then
960: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
961: fnd_message.set_token('MESSAGE',
962: 'csi_t_ii_relationships_pkg.update_row Failed. '||substr(sqlerrm,1,200));
963: fnd_msg_pub.add;
964: raise fnd_api.g_exc_error;
965: end;
966:

Line 1042: FROM csi_t_ii_relationships

1038: l_txn_line_id NUMBER;
1039:
1040: CURSOR ii_cur (p_txn_line_id IN NUMBER) IS
1041: SELECT txn_relationship_id
1042: FROM csi_t_ii_relationships
1043: WHERE transaction_line_id = p_txn_line_id;
1044:
1045: BEGIN
1046: -- Standard Start of API savepoint

Line 1109: p_pkg_name => 'csi_t_ii_relationships_pkg');

1105: END IF;
1106:
1107: csi_t_gen_utility_pvt.dump_api_info(
1108: p_api_name => 'delete_row',
1109: p_pkg_name => 'csi_t_ii_relationships_pkg');
1110:
1111: csi_t_ii_relationships_pkg.delete_row(
1112: p_txn_relationship_id => l_rltns_id);
1113:

Line 1111: csi_t_ii_relationships_pkg.delete_row(

1107: csi_t_gen_utility_pvt.dump_api_info(
1108: p_api_name => 'delete_row',
1109: p_pkg_name => 'csi_t_ii_relationships_pkg');
1110:
1111: csi_t_ii_relationships_pkg.delete_row(
1112: p_txn_relationship_id => l_rltns_id);
1113:
1114: ELSE
1115:

Line 1136: csi_t_ii_relationships_pkg.delete_row(

1132:
1133: FOR ii_rec in ii_cur (l_txn_line_id)
1134: LOOP
1135:
1136: csi_t_ii_relationships_pkg.delete_row(
1137: p_txn_relationship_id => ii_rec.txn_relationship_id);
1138:
1139: END LOOP;
1140:

Line 1215: 'from csi_t_ii_relationships '||

1211: ' position_reference, mandatory_flag, active_start_date, active_end_date, '||
1212: ' context, attribute1, attribute2, attribute3, attribute4, attribute5, '||
1213: ' attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, '||
1214: ' attribute12, attribute13, attribute14, attribute15, object_version_number,transfer_components_flag '||
1215: 'from csi_t_ii_relationships '||
1216: 'where transaction_line_id in '||p_txn_line_id_list;
1217:
1218: l_iir_cur_id := dbms_sql.open_cursor;
1219: