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 DBMS_SQL

Line 1218: l_iir_cur_id := dbms_sql.open_cursor;

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:
1220: dbms_sql.parse(l_iir_cur_id, l_select_stmt , dbms_sql.native);
1221:
1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);

Line 1220: dbms_sql.parse(l_iir_cur_id, l_select_stmt , dbms_sql.native);

1216: 'where transaction_line_id in '||p_txn_line_id_list;
1217:
1218: l_iir_cur_id := dbms_sql.open_cursor;
1219:
1220: dbms_sql.parse(l_iir_cur_id, l_select_stmt , dbms_sql.native);
1221:
1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);
1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);
1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);

Line 1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);

1218: l_iir_cur_id := dbms_sql.open_cursor;
1219:
1220: dbms_sql.parse(l_iir_cur_id, l_select_stmt , dbms_sql.native);
1221:
1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);
1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);
1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);
1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);

Line 1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);

1219:
1220: dbms_sql.parse(l_iir_cur_id, l_select_stmt , dbms_sql.native);
1221:
1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);
1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);
1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);
1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);

Line 1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);

1220: dbms_sql.parse(l_iir_cur_id, l_select_stmt , dbms_sql.native);
1221:
1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);
1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);
1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);
1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);

Line 1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);

1221:
1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);
1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);
1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);
1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);

Line 1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);

1222: dbms_sql.define_column(l_iir_cur_id,1,l_iir_rec.txn_relationship_id);
1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);
1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);
1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);

Line 1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);

1223: dbms_sql.define_column(l_iir_cur_id,2,l_iir_rec.transaction_line_id);
1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);
1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);

Line 1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);

1224: dbms_sql.define_column(l_iir_cur_id,3,l_iir_rec.csi_inst_relationship_id);
1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);

Line 1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);

1225: dbms_sql.define_column(l_iir_cur_id,4,l_iir_rec.subject_id);
1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);

Line 1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);

1226: dbms_sql.define_column(l_iir_cur_id,5,l_iir_rec.object_id);
1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);

Line 1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);

1227: dbms_sql.define_column(l_iir_cur_id,6,l_iir_rec.relationship_type_code,30);
1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);

Line 1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);

1228: dbms_sql.define_column(l_iir_cur_id,7,l_iir_rec.display_order);
1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);

Line 1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);

1229: dbms_sql.define_column(l_iir_cur_id,8,l_iir_rec.position_reference,30);
1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);

Line 1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);

1230: dbms_sql.define_column(l_iir_cur_id,9,l_iir_rec.mandatory_flag,1);
1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);

Line 1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);

1231: dbms_sql.define_column(l_iir_cur_id,10,l_iir_rec.active_start_date);
1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);

Line 1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);

1232: dbms_sql.define_column(l_iir_cur_id,11,l_iir_rec.active_end_date);
1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);

Line 1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);

1233: dbms_sql.define_column(l_iir_cur_id,12,l_iir_rec.context,30);
1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);

Line 1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);

1234: dbms_sql.define_column(l_iir_cur_id,13,l_iir_rec.attribute1,150);
1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);

Line 1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);

1235: dbms_sql.define_column(l_iir_cur_id,14,l_iir_rec.attribute2,150);
1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);

Line 1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);

1236: dbms_sql.define_column(l_iir_cur_id,15,l_iir_rec.attribute3,150);
1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);

Line 1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);

1237: dbms_sql.define_column(l_iir_cur_id,16,l_iir_rec.attribute4,150);
1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);

Line 1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);

1238: dbms_sql.define_column(l_iir_cur_id,17,l_iir_rec.attribute5,150);
1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);

Line 1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);

1239: dbms_sql.define_column(l_iir_cur_id,18,l_iir_rec.attribute6,150);
1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);

Line 1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);

1240: dbms_sql.define_column(l_iir_cur_id,19,l_iir_rec.attribute7,150);
1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);
1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);

Line 1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);

1241: dbms_sql.define_column(l_iir_cur_id,20,l_iir_rec.attribute8,150);
1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);
1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);
1249: dbms_sql.define_column(l_iir_cur_id,28,l_iir_rec.object_version_number);

Line 1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);

1242: dbms_sql.define_column(l_iir_cur_id,21,l_iir_rec.attribute9,150);
1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);
1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);
1249: dbms_sql.define_column(l_iir_cur_id,28,l_iir_rec.object_version_number);
1250: dbms_sql.define_column(l_iir_cur_id,29,l_iir_rec.transfer_components_flag,1);

Line 1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);

1243: dbms_sql.define_column(l_iir_cur_id,22,l_iir_rec.attribute10,150);
1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);
1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);
1249: dbms_sql.define_column(l_iir_cur_id,28,l_iir_rec.object_version_number);
1250: dbms_sql.define_column(l_iir_cur_id,29,l_iir_rec.transfer_components_flag,1);
1251:

Line 1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);

1244: dbms_sql.define_column(l_iir_cur_id,23,l_iir_rec.attribute11,150);
1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);
1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);
1249: dbms_sql.define_column(l_iir_cur_id,28,l_iir_rec.object_version_number);
1250: dbms_sql.define_column(l_iir_cur_id,29,l_iir_rec.transfer_components_flag,1);
1251:
1252: l_ind := 0;

Line 1249: dbms_sql.define_column(l_iir_cur_id,28,l_iir_rec.object_version_number);

1245: dbms_sql.define_column(l_iir_cur_id,24,l_iir_rec.attribute12,150);
1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);
1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);
1249: dbms_sql.define_column(l_iir_cur_id,28,l_iir_rec.object_version_number);
1250: dbms_sql.define_column(l_iir_cur_id,29,l_iir_rec.transfer_components_flag,1);
1251:
1252: l_ind := 0;
1253:

Line 1250: dbms_sql.define_column(l_iir_cur_id,29,l_iir_rec.transfer_components_flag,1);

1246: dbms_sql.define_column(l_iir_cur_id,25,l_iir_rec.attribute13,150);
1247: dbms_sql.define_column(l_iir_cur_id,26,l_iir_rec.attribute14,150);
1248: dbms_sql.define_column(l_iir_cur_id,27,l_iir_rec.attribute15,150);
1249: dbms_sql.define_column(l_iir_cur_id,28,l_iir_rec.object_version_number);
1250: dbms_sql.define_column(l_iir_cur_id,29,l_iir_rec.transfer_components_flag,1);
1251:
1252: l_ind := 0;
1253:
1254: l_processed_rows := dbms_sql.execute(l_iir_cur_id);

Line 1254: l_processed_rows := dbms_sql.execute(l_iir_cur_id);

1250: dbms_sql.define_column(l_iir_cur_id,29,l_iir_rec.transfer_components_flag,1);
1251:
1252: l_ind := 0;
1253:
1254: l_processed_rows := dbms_sql.execute(l_iir_cur_id);
1255: LOOP
1256: exit when dbms_sql.fetch_rows(l_iir_cur_id) = 0;
1257:
1258: l_ind := l_ind + 1;

Line 1256: exit when dbms_sql.fetch_rows(l_iir_cur_id) = 0;

1252: l_ind := 0;
1253:
1254: l_processed_rows := dbms_sql.execute(l_iir_cur_id);
1255: LOOP
1256: exit when dbms_sql.fetch_rows(l_iir_cur_id) = 0;
1257:
1258: l_ind := l_ind + 1;
1259:
1260:

Line 1261: dbms_sql.column_value(l_iir_cur_id,1,x_ii_rltns_tbl(l_ind).txn_relationship_id);

1257:
1258: l_ind := l_ind + 1;
1259:
1260:
1261: dbms_sql.column_value(l_iir_cur_id,1,x_ii_rltns_tbl(l_ind).txn_relationship_id);
1262: dbms_sql.column_value(l_iir_cur_id,2,x_ii_rltns_tbl(l_ind).transaction_line_id);
1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);
1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);

Line 1262: dbms_sql.column_value(l_iir_cur_id,2,x_ii_rltns_tbl(l_ind).transaction_line_id);

1258: l_ind := l_ind + 1;
1259:
1260:
1261: dbms_sql.column_value(l_iir_cur_id,1,x_ii_rltns_tbl(l_ind).txn_relationship_id);
1262: dbms_sql.column_value(l_iir_cur_id,2,x_ii_rltns_tbl(l_ind).transaction_line_id);
1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);
1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);

Line 1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);

1259:
1260:
1261: dbms_sql.column_value(l_iir_cur_id,1,x_ii_rltns_tbl(l_ind).txn_relationship_id);
1262: dbms_sql.column_value(l_iir_cur_id,2,x_ii_rltns_tbl(l_ind).transaction_line_id);
1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);
1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);

Line 1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);

1260:
1261: dbms_sql.column_value(l_iir_cur_id,1,x_ii_rltns_tbl(l_ind).txn_relationship_id);
1262: dbms_sql.column_value(l_iir_cur_id,2,x_ii_rltns_tbl(l_ind).transaction_line_id);
1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);
1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);

Line 1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);

1261: dbms_sql.column_value(l_iir_cur_id,1,x_ii_rltns_tbl(l_ind).txn_relationship_id);
1262: dbms_sql.column_value(l_iir_cur_id,2,x_ii_rltns_tbl(l_ind).transaction_line_id);
1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);
1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);

Line 1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);

1262: dbms_sql.column_value(l_iir_cur_id,2,x_ii_rltns_tbl(l_ind).transaction_line_id);
1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);
1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);

Line 1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);

1263: dbms_sql.column_value(l_iir_cur_id,3,x_ii_rltns_tbl(l_ind).csi_inst_relationship_id);
1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);

Line 1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);

1264: dbms_sql.column_value(l_iir_cur_id,4,x_ii_rltns_tbl(l_ind).subject_id);
1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);

Line 1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);

1265: dbms_sql.column_value(l_iir_cur_id,5,x_ii_rltns_tbl(l_ind).object_id);
1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);

Line 1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);

1266: dbms_sql.column_value(l_iir_cur_id,6,x_ii_rltns_tbl(l_ind).relationship_type_code);
1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);

Line 1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);

1267: dbms_sql.column_value(l_iir_cur_id,7,x_ii_rltns_tbl(l_ind).display_order);
1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);

Line 1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);

1268: dbms_sql.column_value(l_iir_cur_id,8,x_ii_rltns_tbl(l_ind).position_reference);
1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);

Line 1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);

1269: dbms_sql.column_value(l_iir_cur_id,9,x_ii_rltns_tbl(l_ind).mandatory_flag);
1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);

Line 1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);

1270: dbms_sql.column_value(l_iir_cur_id,10,x_ii_rltns_tbl(l_ind).active_start_date);
1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);

Line 1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);

1271: dbms_sql.column_value(l_iir_cur_id,11,x_ii_rltns_tbl(l_ind).active_end_date);
1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);

Line 1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);

1272: dbms_sql.column_value(l_iir_cur_id,12,x_ii_rltns_tbl(l_ind).context);
1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);

Line 1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);

1273: dbms_sql.column_value(l_iir_cur_id,13,x_ii_rltns_tbl(l_ind).attribute1);
1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);

Line 1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);

1274: dbms_sql.column_value(l_iir_cur_id,14,x_ii_rltns_tbl(l_ind).attribute2);
1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);

Line 1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);

1275: dbms_sql.column_value(l_iir_cur_id,15,x_ii_rltns_tbl(l_ind).attribute3);
1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);

Line 1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);

1276: dbms_sql.column_value(l_iir_cur_id,16,x_ii_rltns_tbl(l_ind).attribute4);
1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);

Line 1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);

1277: dbms_sql.column_value(l_iir_cur_id,17,x_ii_rltns_tbl(l_ind).attribute5);
1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);

Line 1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);

1278: dbms_sql.column_value(l_iir_cur_id,18,x_ii_rltns_tbl(l_ind).attribute6);
1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);

Line 1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);

1279: dbms_sql.column_value(l_iir_cur_id,19,x_ii_rltns_tbl(l_ind).attribute7);
1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);
1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);

Line 1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);

1280: dbms_sql.column_value(l_iir_cur_id,20,x_ii_rltns_tbl(l_ind).attribute8);
1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);
1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);
1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);

Line 1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);

1281: dbms_sql.column_value(l_iir_cur_id,21,x_ii_rltns_tbl(l_ind).attribute9);
1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);
1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);
1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);
1289: dbms_sql.column_value(l_iir_cur_id,29,x_ii_rltns_tbl(l_ind).transfer_components_flag);

Line 1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);

1282: dbms_sql.column_value(l_iir_cur_id,22,x_ii_rltns_tbl(l_ind).attribute10);
1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);
1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);
1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);
1289: dbms_sql.column_value(l_iir_cur_id,29,x_ii_rltns_tbl(l_ind).transfer_components_flag);
1290: END LOOP;

Line 1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);

1283: dbms_sql.column_value(l_iir_cur_id,23,x_ii_rltns_tbl(l_ind).attribute11);
1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);
1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);
1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);
1289: dbms_sql.column_value(l_iir_cur_id,29,x_ii_rltns_tbl(l_ind).transfer_components_flag);
1290: END LOOP;
1291:

Line 1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);

1284: dbms_sql.column_value(l_iir_cur_id,24,x_ii_rltns_tbl(l_ind).attribute12);
1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);
1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);
1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);
1289: dbms_sql.column_value(l_iir_cur_id,29,x_ii_rltns_tbl(l_ind).transfer_components_flag);
1290: END LOOP;
1291:
1292: dbms_sql.close_cursor(l_iir_cur_id);

Line 1289: dbms_sql.column_value(l_iir_cur_id,29,x_ii_rltns_tbl(l_ind).transfer_components_flag);

1285: dbms_sql.column_value(l_iir_cur_id,25,x_ii_rltns_tbl(l_ind).attribute13);
1286: dbms_sql.column_value(l_iir_cur_id,26,x_ii_rltns_tbl(l_ind).attribute14);
1287: dbms_sql.column_value(l_iir_cur_id,27,x_ii_rltns_tbl(l_ind).attribute15);
1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);
1289: dbms_sql.column_value(l_iir_cur_id,29,x_ii_rltns_tbl(l_ind).transfer_components_flag);
1290: END LOOP;
1291:
1292: dbms_sql.close_cursor(l_iir_cur_id);
1293:

Line 1292: dbms_sql.close_cursor(l_iir_cur_id);

1288: dbms_sql.column_value(l_iir_cur_id,28,x_ii_rltns_tbl(l_ind).object_version_number);
1289: dbms_sql.column_value(l_iir_cur_id,29,x_ii_rltns_tbl(l_ind).transfer_components_flag);
1290: END LOOP;
1291:
1292: dbms_sql.close_cursor(l_iir_cur_id);
1293:
1294: EXCEPTION
1295: WHEN others THEN
1296:

Line 1297: IF dbms_sql.is_open(l_iir_cur_id) THEN

1293:
1294: EXCEPTION
1295: WHEN others THEN
1296:
1297: IF dbms_sql.is_open(l_iir_cur_id) THEN
1298: dbms_sql.close_cursor(l_iir_cur_id);
1299: END IF;
1300: END get_ii_rltns_dtls;
1301:

Line 1298: dbms_sql.close_cursor(l_iir_cur_id);

1294: EXCEPTION
1295: WHEN others THEN
1296:
1297: IF dbms_sql.is_open(l_iir_cur_id) THEN
1298: dbms_sql.close_cursor(l_iir_cur_id);
1299: END IF;
1300: END get_ii_rltns_dtls;
1301:
1302: END csi_t_txn_rltnshps_pvt;