APPS.CSI_T_TXN_ATTRIBS_PVT dependencies on DBMS_SQL

Line 981: l_iea_cur_id := dbms_sql.open_cursor;

977: ' attribute13, attribute14, attribute15, object_version_number '||
978: 'from csi_iea_values '||
979: 'where instance_id = :instance_id';
980:
981: l_iea_cur_id := dbms_sql.open_cursor;
982:
983: dbms_sql.parse(l_iea_cur_id, l_select_stmt , dbms_sql.native);
984:
985: dbms_sql.bind_variable(l_iea_cur_id, 'instance_id', p_instance_id);

Line 983: dbms_sql.parse(l_iea_cur_id, l_select_stmt , dbms_sql.native);

979: 'where instance_id = :instance_id';
980:
981: l_iea_cur_id := dbms_sql.open_cursor;
982:
983: dbms_sql.parse(l_iea_cur_id, l_select_stmt , dbms_sql.native);
984:
985: dbms_sql.bind_variable(l_iea_cur_id, 'instance_id', p_instance_id);
986:
987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);

Line 985: dbms_sql.bind_variable(l_iea_cur_id, 'instance_id', p_instance_id);

981: l_iea_cur_id := dbms_sql.open_cursor;
982:
983: dbms_sql.parse(l_iea_cur_id, l_select_stmt , dbms_sql.native);
984:
985: dbms_sql.bind_variable(l_iea_cur_id, 'instance_id', p_instance_id);
986:
987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);
988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);
989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);

Line 987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);

983: dbms_sql.parse(l_iea_cur_id, l_select_stmt , dbms_sql.native);
984:
985: dbms_sql.bind_variable(l_iea_cur_id, 'instance_id', p_instance_id);
986:
987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);
988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);
989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);
990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);

Line 988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);

984:
985: dbms_sql.bind_variable(l_iea_cur_id, 'instance_id', p_instance_id);
986:
987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);
988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);
989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);
990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);

Line 989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);

985: dbms_sql.bind_variable(l_iea_cur_id, 'instance_id', p_instance_id);
986:
987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);
988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);
989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);
990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);

Line 990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);

986:
987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);
988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);
989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);
990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);

Line 991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);

987: dbms_sql.define_column(l_iea_cur_id,1,l_iea_rec.attribute_value_id);
988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);
989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);
990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);

Line 992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);

988: dbms_sql.define_column(l_iea_cur_id,2,l_iea_rec.instance_id);
989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);
990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);

Line 993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);

989: dbms_sql.define_column(l_iea_cur_id,3,l_iea_rec.attribute_id);
990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);

Line 994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);

990: dbms_sql.define_column(l_iea_cur_id,4,l_iea_rec.attribute_value,240);
991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);

Line 995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);

991: dbms_sql.define_column(l_iea_cur_id,5,l_iea_rec.active_start_date);
992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);

Line 996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);

992: dbms_sql.define_column(l_iea_cur_id,6,l_iea_rec.active_end_date);
993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);

Line 997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);

993: dbms_sql.define_column(l_iea_cur_id,7,l_iea_rec.context,30);
994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);

Line 998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);

994: dbms_sql.define_column(l_iea_cur_id,8,l_iea_rec.attribute1,150);
995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);

Line 999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);

995: dbms_sql.define_column(l_iea_cur_id,9,l_iea_rec.attribute2,150);
996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);

Line 1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);

996: dbms_sql.define_column(l_iea_cur_id,10,l_iea_rec.attribute3,150);
997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);

Line 1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);

997: dbms_sql.define_column(l_iea_cur_id,11,l_iea_rec.attribute4,150);
998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);

Line 1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);

998: dbms_sql.define_column(l_iea_cur_id,12,l_iea_rec.attribute5,150);
999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);

Line 1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);

999: dbms_sql.define_column(l_iea_cur_id,13,l_iea_rec.attribute6,150);
1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);
1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);

Line 1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);

1000: dbms_sql.define_column(l_iea_cur_id,14,l_iea_rec.attribute7,150);
1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);
1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);
1008: dbms_sql.define_column(l_iea_cur_id,22,l_iea_rec.attribute15,150);

Line 1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);

1001: dbms_sql.define_column(l_iea_cur_id,15,l_iea_rec.attribute8,150);
1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);
1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);
1008: dbms_sql.define_column(l_iea_cur_id,22,l_iea_rec.attribute15,150);
1009: dbms_sql.define_column(l_iea_cur_id,23,l_iea_rec.object_version_number);

Line 1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);

1002: dbms_sql.define_column(l_iea_cur_id,16,l_iea_rec.attribute9,150);
1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);
1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);
1008: dbms_sql.define_column(l_iea_cur_id,22,l_iea_rec.attribute15,150);
1009: dbms_sql.define_column(l_iea_cur_id,23,l_iea_rec.object_version_number);
1010:

Line 1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);

1003: dbms_sql.define_column(l_iea_cur_id,17,l_iea_rec.attribute10,150);
1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);
1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);
1008: dbms_sql.define_column(l_iea_cur_id,22,l_iea_rec.attribute15,150);
1009: dbms_sql.define_column(l_iea_cur_id,23,l_iea_rec.object_version_number);
1010:
1011: l_ind := 0;

Line 1008: dbms_sql.define_column(l_iea_cur_id,22,l_iea_rec.attribute15,150);

1004: dbms_sql.define_column(l_iea_cur_id,18,l_iea_rec.attribute11,150);
1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);
1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);
1008: dbms_sql.define_column(l_iea_cur_id,22,l_iea_rec.attribute15,150);
1009: dbms_sql.define_column(l_iea_cur_id,23,l_iea_rec.object_version_number);
1010:
1011: l_ind := 0;
1012:

Line 1009: dbms_sql.define_column(l_iea_cur_id,23,l_iea_rec.object_version_number);

1005: dbms_sql.define_column(l_iea_cur_id,19,l_iea_rec.attribute12,150);
1006: dbms_sql.define_column(l_iea_cur_id,20,l_iea_rec.attribute13,150);
1007: dbms_sql.define_column(l_iea_cur_id,21,l_iea_rec.attribute14,150);
1008: dbms_sql.define_column(l_iea_cur_id,22,l_iea_rec.attribute15,150);
1009: dbms_sql.define_column(l_iea_cur_id,23,l_iea_rec.object_version_number);
1010:
1011: l_ind := 0;
1012:
1013: l_processed_rows := dbms_sql.execute(l_iea_cur_id);

Line 1013: l_processed_rows := dbms_sql.execute(l_iea_cur_id);

1009: dbms_sql.define_column(l_iea_cur_id,23,l_iea_rec.object_version_number);
1010:
1011: l_ind := 0;
1012:
1013: l_processed_rows := dbms_sql.execute(l_iea_cur_id);
1014: LOOP
1015:
1016: exit when dbms_sql.fetch_rows(l_iea_cur_id) = 0;
1017:

Line 1016: exit when dbms_sql.fetch_rows(l_iea_cur_id) = 0;

1012:
1013: l_processed_rows := dbms_sql.execute(l_iea_cur_id);
1014: LOOP
1015:
1016: exit when dbms_sql.fetch_rows(l_iea_cur_id) = 0;
1017:
1018: l_ind := l_ind + 1;
1019: dbms_sql.column_value(l_iea_cur_id,1,x_csi_ea_vals_tbl(l_ind).attribute_value_id);
1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);

Line 1019: dbms_sql.column_value(l_iea_cur_id,1,x_csi_ea_vals_tbl(l_ind).attribute_value_id);

1015:
1016: exit when dbms_sql.fetch_rows(l_iea_cur_id) = 0;
1017:
1018: l_ind := l_ind + 1;
1019: dbms_sql.column_value(l_iea_cur_id,1,x_csi_ea_vals_tbl(l_ind).attribute_value_id);
1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);
1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);
1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);

Line 1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);

1016: exit when dbms_sql.fetch_rows(l_iea_cur_id) = 0;
1017:
1018: l_ind := l_ind + 1;
1019: dbms_sql.column_value(l_iea_cur_id,1,x_csi_ea_vals_tbl(l_ind).attribute_value_id);
1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);
1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);
1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);

Line 1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);

1017:
1018: l_ind := l_ind + 1;
1019: dbms_sql.column_value(l_iea_cur_id,1,x_csi_ea_vals_tbl(l_ind).attribute_value_id);
1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);
1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);
1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);

Line 1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);

1018: l_ind := l_ind + 1;
1019: dbms_sql.column_value(l_iea_cur_id,1,x_csi_ea_vals_tbl(l_ind).attribute_value_id);
1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);
1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);
1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);

Line 1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);

1019: dbms_sql.column_value(l_iea_cur_id,1,x_csi_ea_vals_tbl(l_ind).attribute_value_id);
1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);
1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);
1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);

Line 1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);

1020: dbms_sql.column_value(l_iea_cur_id,2,x_csi_ea_vals_tbl(l_ind).instance_id);
1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);
1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);

Line 1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);

1021: dbms_sql.column_value(l_iea_cur_id,3,x_csi_ea_vals_tbl(l_ind).attribute_id);
1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);

Line 1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);

1022: dbms_sql.column_value(l_iea_cur_id,4,x_csi_ea_vals_tbl(l_ind).attribute_value);
1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);

Line 1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);

1023: dbms_sql.column_value(l_iea_cur_id,5,x_csi_ea_vals_tbl(l_ind).active_start_date);
1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);

Line 1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);

1024: dbms_sql.column_value(l_iea_cur_id,6,x_csi_ea_vals_tbl(l_ind).active_end_date);
1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);

Line 1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);

1025: dbms_sql.column_value(l_iea_cur_id,7,x_csi_ea_vals_tbl(l_ind).context);
1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);

Line 1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);

1026: dbms_sql.column_value(l_iea_cur_id,8,x_csi_ea_vals_tbl(l_ind).attribute1);
1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);

Line 1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);

1027: dbms_sql.column_value(l_iea_cur_id,9,x_csi_ea_vals_tbl(l_ind).attribute2);
1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);

Line 1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);

1028: dbms_sql.column_value(l_iea_cur_id,10,x_csi_ea_vals_tbl(l_ind).attribute3);
1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);

Line 1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);

1029: dbms_sql.column_value(l_iea_cur_id,11,x_csi_ea_vals_tbl(l_ind).attribute4);
1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);

Line 1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);

1030: dbms_sql.column_value(l_iea_cur_id,12,x_csi_ea_vals_tbl(l_ind).attribute5);
1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);

Line 1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);

1031: dbms_sql.column_value(l_iea_cur_id,13,x_csi_ea_vals_tbl(l_ind).attribute6);
1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);
1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);

Line 1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);

1032: dbms_sql.column_value(l_iea_cur_id,14,x_csi_ea_vals_tbl(l_ind).attribute7);
1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);
1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);
1040: dbms_sql.column_value(l_iea_cur_id,22,x_csi_ea_vals_tbl(l_ind).attribute15);

Line 1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);

1033: dbms_sql.column_value(l_iea_cur_id,15,x_csi_ea_vals_tbl(l_ind).attribute8);
1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);
1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);
1040: dbms_sql.column_value(l_iea_cur_id,22,x_csi_ea_vals_tbl(l_ind).attribute15);
1041: dbms_sql.column_value(l_iea_cur_id,23,x_csi_ea_vals_tbl(l_ind).object_version_number);

Line 1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);

1034: dbms_sql.column_value(l_iea_cur_id,16,x_csi_ea_vals_tbl(l_ind).attribute9);
1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);
1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);
1040: dbms_sql.column_value(l_iea_cur_id,22,x_csi_ea_vals_tbl(l_ind).attribute15);
1041: dbms_sql.column_value(l_iea_cur_id,23,x_csi_ea_vals_tbl(l_ind).object_version_number);
1042:

Line 1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);

1035: dbms_sql.column_value(l_iea_cur_id,17,x_csi_ea_vals_tbl(l_ind).attribute10);
1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);
1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);
1040: dbms_sql.column_value(l_iea_cur_id,22,x_csi_ea_vals_tbl(l_ind).attribute15);
1041: dbms_sql.column_value(l_iea_cur_id,23,x_csi_ea_vals_tbl(l_ind).object_version_number);
1042:
1043: END LOOP;

Line 1040: dbms_sql.column_value(l_iea_cur_id,22,x_csi_ea_vals_tbl(l_ind).attribute15);

1036: dbms_sql.column_value(l_iea_cur_id,18,x_csi_ea_vals_tbl(l_ind).attribute11);
1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);
1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);
1040: dbms_sql.column_value(l_iea_cur_id,22,x_csi_ea_vals_tbl(l_ind).attribute15);
1041: dbms_sql.column_value(l_iea_cur_id,23,x_csi_ea_vals_tbl(l_ind).object_version_number);
1042:
1043: END LOOP;
1044:

Line 1041: dbms_sql.column_value(l_iea_cur_id,23,x_csi_ea_vals_tbl(l_ind).object_version_number);

1037: dbms_sql.column_value(l_iea_cur_id,19,x_csi_ea_vals_tbl(l_ind).attribute12);
1038: dbms_sql.column_value(l_iea_cur_id,20,x_csi_ea_vals_tbl(l_ind).attribute13);
1039: dbms_sql.column_value(l_iea_cur_id,21,x_csi_ea_vals_tbl(l_ind).attribute14);
1040: dbms_sql.column_value(l_iea_cur_id,22,x_csi_ea_vals_tbl(l_ind).attribute15);
1041: dbms_sql.column_value(l_iea_cur_id,23,x_csi_ea_vals_tbl(l_ind).object_version_number);
1042:
1043: END LOOP;
1044:
1045: dbms_sql.close_cursor(l_iea_cur_id);

Line 1045: dbms_sql.close_cursor(l_iea_cur_id);

1041: dbms_sql.column_value(l_iea_cur_id,23,x_csi_ea_vals_tbl(l_ind).object_version_number);
1042:
1043: END LOOP;
1044:
1045: dbms_sql.close_cursor(l_iea_cur_id);
1046:
1047: EXCEPTION
1048: WHEN others THEN
1049:

Line 1050: IF dbms_sql.is_open(l_iea_cur_id) THEN

1046:
1047: EXCEPTION
1048: WHEN others THEN
1049:
1050: IF dbms_sql.is_open(l_iea_cur_id) THEN
1051: dbms_sql.close_cursor(l_iea_cur_id);
1052: END IF;
1053: END get_csi_ext_attrib_vals;
1054:

Line 1051: dbms_sql.close_cursor(l_iea_cur_id);

1047: EXCEPTION
1048: WHEN others THEN
1049:
1050: IF dbms_sql.is_open(l_iea_cur_id) THEN
1051: dbms_sql.close_cursor(l_iea_cur_id);
1052: END IF;
1053: END get_csi_ext_attrib_vals;
1054:
1055: PROCEDURE get_csi_ext_attribs(

Line 1113: l_ea_cur_id := dbms_sql.open_cursor;

1109:
1110: IF p_instance_id is not null THEN
1111: l_select_stmt := l_select_stmt||l_inst_based_stmt;
1112: END IF;
1113: l_ea_cur_id := dbms_sql.open_cursor;
1114:
1115: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);
1116:
1117: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id',p_line_dtl_id);

Line 1115: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);

1111: l_select_stmt := l_select_stmt||l_inst_based_stmt;
1112: END IF;
1113: l_ea_cur_id := dbms_sql.open_cursor;
1114:
1115: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);
1116:
1117: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id',p_line_dtl_id);
1118:
1119: IF p_instance_id is not null THEN

Line 1117: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id',p_line_dtl_id);

1113: l_ea_cur_id := dbms_sql.open_cursor;
1114:
1115: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);
1116:
1117: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id',p_line_dtl_id);
1118:
1119: IF p_instance_id is not null THEN
1120: dbms_sql.bind_variable(l_ea_cur_id,'instance_id',p_instance_id);
1121: END IF;

Line 1120: dbms_sql.bind_variable(l_ea_cur_id,'instance_id',p_instance_id);

1116:
1117: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id',p_line_dtl_id);
1118:
1119: IF p_instance_id is not null THEN
1120: dbms_sql.bind_variable(l_ea_cur_id,'instance_id',p_instance_id);
1121: END IF;
1122:
1123:
1124: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.attribute_id);

Line 1124: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.attribute_id);

1120: dbms_sql.bind_variable(l_ea_cur_id,'instance_id',p_instance_id);
1121: END IF;
1122:
1123:
1124: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.attribute_id);
1125: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.attribute_level,15);
1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);
1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);

Line 1125: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.attribute_level,15);

1121: END IF;
1122:
1123:
1124: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.attribute_id);
1125: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.attribute_level,15);
1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);
1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);

Line 1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);

1122:
1123:
1124: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.attribute_id);
1125: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.attribute_level,15);
1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);
1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);

Line 1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);

1123:
1124: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.attribute_id);
1125: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.attribute_level,15);
1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);
1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);

Line 1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);

1124: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.attribute_id);
1125: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.attribute_level,15);
1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);
1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);

Line 1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);

1125: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.attribute_level,15);
1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);
1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);

Line 1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);

1126: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.master_organization_id);
1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);

Line 1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);

1127: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.inventory_item_id);
1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);

Line 1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);

1128: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.item_category_id);
1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);

Line 1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);

1129: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.instance_id);
1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);

Line 1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);

1130: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.attribute_code,30);
1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);

Line 1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);

1131: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.attribute_name,50);
1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);

Line 1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);

1132: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.attribute_category,30);
1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);

Line 1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);

1133: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.description,240);
1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);

Line 1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);

1134: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.active_start_date);
1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);

Line 1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);

1135: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.active_end_date);
1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);

Line 1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);

1136: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.context,30);
1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);

Line 1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);

1137: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute1,150);
1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);

Line 1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);

1138: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute2,150);
1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);

Line 1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);

1139: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute3,150);
1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);

Line 1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);

1140: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute4,150);
1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);

Line 1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);

1141: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute5,150);
1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);

Line 1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);

1142: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute6,150);
1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);
1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);

Line 1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);

1143: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute7,150);
1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);
1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);
1151: dbms_sql.define_column(l_ea_cur_id,28,l_ea_rec.attribute15,150);

Line 1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);

1144: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute8,150);
1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);
1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);
1151: dbms_sql.define_column(l_ea_cur_id,28,l_ea_rec.attribute15,150);
1152: dbms_sql.define_column(l_ea_cur_id,29,l_ea_rec.object_version_number);

Line 1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);

1145: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute9,150);
1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);
1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);
1151: dbms_sql.define_column(l_ea_cur_id,28,l_ea_rec.attribute15,150);
1152: dbms_sql.define_column(l_ea_cur_id,29,l_ea_rec.object_version_number);
1153:

Line 1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);

1146: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute10,150);
1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);
1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);
1151: dbms_sql.define_column(l_ea_cur_id,28,l_ea_rec.attribute15,150);
1152: dbms_sql.define_column(l_ea_cur_id,29,l_ea_rec.object_version_number);
1153:
1154: l_ind := 0;

Line 1151: dbms_sql.define_column(l_ea_cur_id,28,l_ea_rec.attribute15,150);

1147: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute11,150);
1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);
1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);
1151: dbms_sql.define_column(l_ea_cur_id,28,l_ea_rec.attribute15,150);
1152: dbms_sql.define_column(l_ea_cur_id,29,l_ea_rec.object_version_number);
1153:
1154: l_ind := 0;
1155:

Line 1152: dbms_sql.define_column(l_ea_cur_id,29,l_ea_rec.object_version_number);

1148: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute12,150);
1149: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.attribute13,150);
1150: dbms_sql.define_column(l_ea_cur_id,27,l_ea_rec.attribute14,150);
1151: dbms_sql.define_column(l_ea_cur_id,28,l_ea_rec.attribute15,150);
1152: dbms_sql.define_column(l_ea_cur_id,29,l_ea_rec.object_version_number);
1153:
1154: l_ind := 0;
1155:
1156: l_processed_rows := dbms_sql.execute(l_ea_cur_id);

Line 1156: l_processed_rows := dbms_sql.execute(l_ea_cur_id);

1152: dbms_sql.define_column(l_ea_cur_id,29,l_ea_rec.object_version_number);
1153:
1154: l_ind := 0;
1155:
1156: l_processed_rows := dbms_sql.execute(l_ea_cur_id);
1157: LOOP
1158:
1159: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;
1160:

Line 1159: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;

1155:
1156: l_processed_rows := dbms_sql.execute(l_ea_cur_id);
1157: LOOP
1158:
1159: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;
1160:
1161: l_ind := l_ind + 1;
1162:
1163: dbms_sql.column_value(l_ea_cur_id,1,x_csi_ext_attribs_tbl(l_ind).attribute_id);

Line 1163: dbms_sql.column_value(l_ea_cur_id,1,x_csi_ext_attribs_tbl(l_ind).attribute_id);

1159: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;
1160:
1161: l_ind := l_ind + 1;
1162:
1163: dbms_sql.column_value(l_ea_cur_id,1,x_csi_ext_attribs_tbl(l_ind).attribute_id);
1164: dbms_sql.column_value(l_ea_cur_id,2,x_csi_ext_attribs_tbl(l_ind).attribute_level);
1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);
1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);

Line 1164: dbms_sql.column_value(l_ea_cur_id,2,x_csi_ext_attribs_tbl(l_ind).attribute_level);

1160:
1161: l_ind := l_ind + 1;
1162:
1163: dbms_sql.column_value(l_ea_cur_id,1,x_csi_ext_attribs_tbl(l_ind).attribute_id);
1164: dbms_sql.column_value(l_ea_cur_id,2,x_csi_ext_attribs_tbl(l_ind).attribute_level);
1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);
1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);

Line 1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);

1161: l_ind := l_ind + 1;
1162:
1163: dbms_sql.column_value(l_ea_cur_id,1,x_csi_ext_attribs_tbl(l_ind).attribute_id);
1164: dbms_sql.column_value(l_ea_cur_id,2,x_csi_ext_attribs_tbl(l_ind).attribute_level);
1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);
1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);

Line 1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);

1162:
1163: dbms_sql.column_value(l_ea_cur_id,1,x_csi_ext_attribs_tbl(l_ind).attribute_id);
1164: dbms_sql.column_value(l_ea_cur_id,2,x_csi_ext_attribs_tbl(l_ind).attribute_level);
1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);
1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);

Line 1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);

1163: dbms_sql.column_value(l_ea_cur_id,1,x_csi_ext_attribs_tbl(l_ind).attribute_id);
1164: dbms_sql.column_value(l_ea_cur_id,2,x_csi_ext_attribs_tbl(l_ind).attribute_level);
1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);
1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);

Line 1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);

1164: dbms_sql.column_value(l_ea_cur_id,2,x_csi_ext_attribs_tbl(l_ind).attribute_level);
1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);
1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);

Line 1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);

1165: dbms_sql.column_value(l_ea_cur_id,3,x_csi_ext_attribs_tbl(l_ind).master_organization_id);
1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);

Line 1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);

1166: dbms_sql.column_value(l_ea_cur_id,4,x_csi_ext_attribs_tbl(l_ind).inventory_item_id);
1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);

Line 1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);

1167: dbms_sql.column_value(l_ea_cur_id,5,x_csi_ext_attribs_tbl(l_ind).item_category_id);
1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);

Line 1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);

1168: dbms_sql.column_value(l_ea_cur_id,6,x_csi_ext_attribs_tbl(l_ind).instance_id);
1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);

Line 1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);

1169: dbms_sql.column_value(l_ea_cur_id,7,x_csi_ext_attribs_tbl(l_ind).attribute_code);
1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);

Line 1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);

1170: dbms_sql.column_value(l_ea_cur_id,8,x_csi_ext_attribs_tbl(l_ind).attribute_name);
1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);

Line 1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);

1171: dbms_sql.column_value(l_ea_cur_id,9,x_csi_ext_attribs_tbl(l_ind).attribute_category);
1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);

Line 1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);

1172: dbms_sql.column_value(l_ea_cur_id,10,x_csi_ext_attribs_tbl(l_ind).description);
1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);

Line 1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);

1173: dbms_sql.column_value(l_ea_cur_id,11,x_csi_ext_attribs_tbl(l_ind).active_start_date);
1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);

Line 1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);

1174: dbms_sql.column_value(l_ea_cur_id,12,x_csi_ext_attribs_tbl(l_ind).active_end_date);
1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);

Line 1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);

1175: dbms_sql.column_value(l_ea_cur_id,13,x_csi_ext_attribs_tbl(l_ind).context);
1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);

Line 1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);

1176: dbms_sql.column_value(l_ea_cur_id,14,x_csi_ext_attribs_tbl(l_ind).attribute1);
1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);

Line 1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);

1177: dbms_sql.column_value(l_ea_cur_id,15,x_csi_ext_attribs_tbl(l_ind).attribute2);
1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);

Line 1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);

1178: dbms_sql.column_value(l_ea_cur_id,16,x_csi_ext_attribs_tbl(l_ind).attribute3);
1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);

Line 1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);

1179: dbms_sql.column_value(l_ea_cur_id,17,x_csi_ext_attribs_tbl(l_ind).attribute4);
1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);

Line 1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);

1180: dbms_sql.column_value(l_ea_cur_id,18,x_csi_ext_attribs_tbl(l_ind).attribute5);
1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);

Line 1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);

1181: dbms_sql.column_value(l_ea_cur_id,19,x_csi_ext_attribs_tbl(l_ind).attribute6);
1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);
1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);

Line 1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);

1182: dbms_sql.column_value(l_ea_cur_id,20,x_csi_ext_attribs_tbl(l_ind).attribute7);
1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);
1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);
1190: dbms_sql.column_value(l_ea_cur_id,28,x_csi_ext_attribs_tbl(l_ind).attribute15);

Line 1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);

1183: dbms_sql.column_value(l_ea_cur_id,21,x_csi_ext_attribs_tbl(l_ind).attribute8);
1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);
1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);
1190: dbms_sql.column_value(l_ea_cur_id,28,x_csi_ext_attribs_tbl(l_ind).attribute15);
1191: dbms_sql.column_value(l_ea_cur_id,29,x_csi_ext_attribs_tbl(l_ind).object_version_number);

Line 1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);

1184: dbms_sql.column_value(l_ea_cur_id,22,x_csi_ext_attribs_tbl(l_ind).attribute9);
1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);
1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);
1190: dbms_sql.column_value(l_ea_cur_id,28,x_csi_ext_attribs_tbl(l_ind).attribute15);
1191: dbms_sql.column_value(l_ea_cur_id,29,x_csi_ext_attribs_tbl(l_ind).object_version_number);
1192:

Line 1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);

1185: dbms_sql.column_value(l_ea_cur_id,23,x_csi_ext_attribs_tbl(l_ind).attribute10);
1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);
1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);
1190: dbms_sql.column_value(l_ea_cur_id,28,x_csi_ext_attribs_tbl(l_ind).attribute15);
1191: dbms_sql.column_value(l_ea_cur_id,29,x_csi_ext_attribs_tbl(l_ind).object_version_number);
1192:
1193: END LOOP;

Line 1190: dbms_sql.column_value(l_ea_cur_id,28,x_csi_ext_attribs_tbl(l_ind).attribute15);

1186: dbms_sql.column_value(l_ea_cur_id,24,x_csi_ext_attribs_tbl(l_ind).attribute11);
1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);
1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);
1190: dbms_sql.column_value(l_ea_cur_id,28,x_csi_ext_attribs_tbl(l_ind).attribute15);
1191: dbms_sql.column_value(l_ea_cur_id,29,x_csi_ext_attribs_tbl(l_ind).object_version_number);
1192:
1193: END LOOP;
1194:

Line 1191: dbms_sql.column_value(l_ea_cur_id,29,x_csi_ext_attribs_tbl(l_ind).object_version_number);

1187: dbms_sql.column_value(l_ea_cur_id,25,x_csi_ext_attribs_tbl(l_ind).attribute12);
1188: dbms_sql.column_value(l_ea_cur_id,26,x_csi_ext_attribs_tbl(l_ind).attribute13);
1189: dbms_sql.column_value(l_ea_cur_id,27,x_csi_ext_attribs_tbl(l_ind).attribute14);
1190: dbms_sql.column_value(l_ea_cur_id,28,x_csi_ext_attribs_tbl(l_ind).attribute15);
1191: dbms_sql.column_value(l_ea_cur_id,29,x_csi_ext_attribs_tbl(l_ind).object_version_number);
1192:
1193: END LOOP;
1194:
1195: dbms_sql.close_cursor(l_ea_cur_id);

Line 1195: dbms_sql.close_cursor(l_ea_cur_id);

1191: dbms_sql.column_value(l_ea_cur_id,29,x_csi_ext_attribs_tbl(l_ind).object_version_number);
1192:
1193: END LOOP;
1194:
1195: dbms_sql.close_cursor(l_ea_cur_id);
1196:
1197: EXCEPTION
1198: WHEN others THEN
1199:

Line 1200: IF dbms_sql.is_open(l_ea_cur_id) THEN

1196:
1197: EXCEPTION
1198: WHEN others THEN
1199:
1200: IF dbms_sql.is_open(l_ea_cur_id) THEN
1201: dbms_sql.close_cursor(l_ea_cur_id);
1202: END IF;
1203: END get_csi_ext_attribs;
1204:

Line 1201: dbms_sql.close_cursor(l_ea_cur_id);

1197: EXCEPTION
1198: WHEN others THEN
1199:
1200: IF dbms_sql.is_open(l_ea_cur_id) THEN
1201: dbms_sql.close_cursor(l_ea_cur_id);
1202: END IF;
1203: END get_csi_ext_attribs;
1204:
1205: PROCEDURE get_ext_attrib_dtls(

Line 1230: l_ea_cur_id := dbms_sql.open_cursor;

1226: attribute15, object_version_number
1227: from csi_t_extend_attribs
1228: where txn_line_detail_id = :line_dtl_id';
1229:
1230: l_ea_cur_id := dbms_sql.open_cursor;
1231:
1232: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);
1233:
1234: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id', p_line_dtl_id);

Line 1232: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);

1228: where txn_line_detail_id = :line_dtl_id';
1229:
1230: l_ea_cur_id := dbms_sql.open_cursor;
1231:
1232: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);
1233:
1234: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id', p_line_dtl_id);
1235:
1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);

Line 1234: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id', p_line_dtl_id);

1230: l_ea_cur_id := dbms_sql.open_cursor;
1231:
1232: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);
1233:
1234: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id', p_line_dtl_id);
1235:
1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);
1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);
1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);

Line 1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);

1232: dbms_sql.parse(l_ea_cur_id, l_select_stmt , dbms_sql.native);
1233:
1234: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id', p_line_dtl_id);
1235:
1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);
1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);
1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);
1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);

Line 1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);

1233:
1234: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id', p_line_dtl_id);
1235:
1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);
1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);
1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);
1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);

Line 1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);

1234: dbms_sql.bind_variable(l_ea_cur_id,'line_dtl_id', p_line_dtl_id);
1235:
1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);
1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);
1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);
1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);

Line 1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);

1235:
1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);
1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);
1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);
1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);

Line 1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);

1236: dbms_sql.define_column(l_ea_cur_id,1,l_ea_rec.txn_attrib_detail_id);
1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);
1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);
1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);

Line 1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);

1237: dbms_sql.define_column(l_ea_cur_id,2,l_ea_rec.txn_line_detail_id);
1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);
1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);

Line 1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);

1238: dbms_sql.define_column(l_ea_cur_id,3,l_ea_rec.attrib_source_table,30);
1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);

Line 1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);

1239: dbms_sql.define_column(l_ea_cur_id,4,l_ea_rec.attribute_source_id);
1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);

Line 1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);

1240: dbms_sql.define_column(l_ea_cur_id,5,l_ea_rec.attribute_value,240);
1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);

Line 1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);

1241: dbms_sql.define_column(l_ea_cur_id,6,l_ea_rec.process_flag,1);
1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);

Line 1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);

1242: dbms_sql.define_column(l_ea_cur_id,7,l_ea_rec.active_start_date);
1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);

Line 1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);

1243: dbms_sql.define_column(l_ea_cur_id,8,l_ea_rec.active_end_date);
1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);

Line 1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);

1244: dbms_sql.define_column(l_ea_cur_id,9,l_ea_rec.preserve_detail_flag,1);
1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);

Line 1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);

1245: dbms_sql.define_column(l_ea_cur_id,10,l_ea_rec.context,30);
1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);

Line 1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);

1246: dbms_sql.define_column(l_ea_cur_id,11,l_ea_rec.attribute1,150);
1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);

Line 1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);

1247: dbms_sql.define_column(l_ea_cur_id,12,l_ea_rec.attribute2,150);
1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);

Line 1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);

1248: dbms_sql.define_column(l_ea_cur_id,13,l_ea_rec.attribute3,150);
1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);

Line 1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);

1249: dbms_sql.define_column(l_ea_cur_id,14,l_ea_rec.attribute4,150);
1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);

Line 1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);

1250: dbms_sql.define_column(l_ea_cur_id,15,l_ea_rec.attribute5,150);
1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);

Line 1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);

1251: dbms_sql.define_column(l_ea_cur_id,16,l_ea_rec.attribute6,150);
1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);
1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);

Line 1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);

1252: dbms_sql.define_column(l_ea_cur_id,17,l_ea_rec.attribute7,150);
1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);
1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);
1260: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute15,150);

Line 1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);

1253: dbms_sql.define_column(l_ea_cur_id,18,l_ea_rec.attribute8,150);
1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);
1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);
1260: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute15,150);
1261: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.object_version_number);

Line 1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);

1254: dbms_sql.define_column(l_ea_cur_id,19,l_ea_rec.attribute9,150);
1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);
1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);
1260: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute15,150);
1261: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.object_version_number);
1262:

Line 1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);

1255: dbms_sql.define_column(l_ea_cur_id,20,l_ea_rec.attribute10,150);
1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);
1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);
1260: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute15,150);
1261: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.object_version_number);
1262:
1263: l_ind := 0;

Line 1260: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute15,150);

1256: dbms_sql.define_column(l_ea_cur_id,21,l_ea_rec.attribute11,150);
1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);
1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);
1260: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute15,150);
1261: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.object_version_number);
1262:
1263: l_ind := 0;
1264:

Line 1261: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.object_version_number);

1257: dbms_sql.define_column(l_ea_cur_id,22,l_ea_rec.attribute12,150);
1258: dbms_sql.define_column(l_ea_cur_id,23,l_ea_rec.attribute13,150);
1259: dbms_sql.define_column(l_ea_cur_id,24,l_ea_rec.attribute14,150);
1260: dbms_sql.define_column(l_ea_cur_id,25,l_ea_rec.attribute15,150);
1261: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.object_version_number);
1262:
1263: l_ind := 0;
1264:
1265: l_processed_rows := dbms_sql.execute(l_ea_cur_id);

Line 1265: l_processed_rows := dbms_sql.execute(l_ea_cur_id);

1261: dbms_sql.define_column(l_ea_cur_id,26,l_ea_rec.object_version_number);
1262:
1263: l_ind := 0;
1264:
1265: l_processed_rows := dbms_sql.execute(l_ea_cur_id);
1266: LOOP
1267:
1268: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;
1269:

Line 1268: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;

1264:
1265: l_processed_rows := dbms_sql.execute(l_ea_cur_id);
1266: LOOP
1267:
1268: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;
1269:
1270: l_ind := l_ind + 1;
1271:
1272: dbms_sql.column_value(l_ea_cur_id,1,x_ext_attrib_tbl(l_ind).txn_attrib_detail_id);

Line 1272: dbms_sql.column_value(l_ea_cur_id,1,x_ext_attrib_tbl(l_ind).txn_attrib_detail_id);

1268: exit when dbms_sql.fetch_rows(l_ea_cur_id) = 0;
1269:
1270: l_ind := l_ind + 1;
1271:
1272: dbms_sql.column_value(l_ea_cur_id,1,x_ext_attrib_tbl(l_ind).txn_attrib_detail_id);
1273: dbms_sql.column_value(l_ea_cur_id,2,x_ext_attrib_tbl(l_ind).txn_line_detail_id);
1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);
1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);

Line 1273: dbms_sql.column_value(l_ea_cur_id,2,x_ext_attrib_tbl(l_ind).txn_line_detail_id);

1269:
1270: l_ind := l_ind + 1;
1271:
1272: dbms_sql.column_value(l_ea_cur_id,1,x_ext_attrib_tbl(l_ind).txn_attrib_detail_id);
1273: dbms_sql.column_value(l_ea_cur_id,2,x_ext_attrib_tbl(l_ind).txn_line_detail_id);
1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);
1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);

Line 1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);

1270: l_ind := l_ind + 1;
1271:
1272: dbms_sql.column_value(l_ea_cur_id,1,x_ext_attrib_tbl(l_ind).txn_attrib_detail_id);
1273: dbms_sql.column_value(l_ea_cur_id,2,x_ext_attrib_tbl(l_ind).txn_line_detail_id);
1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);
1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);

Line 1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);

1271:
1272: dbms_sql.column_value(l_ea_cur_id,1,x_ext_attrib_tbl(l_ind).txn_attrib_detail_id);
1273: dbms_sql.column_value(l_ea_cur_id,2,x_ext_attrib_tbl(l_ind).txn_line_detail_id);
1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);
1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);

Line 1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);

1272: dbms_sql.column_value(l_ea_cur_id,1,x_ext_attrib_tbl(l_ind).txn_attrib_detail_id);
1273: dbms_sql.column_value(l_ea_cur_id,2,x_ext_attrib_tbl(l_ind).txn_line_detail_id);
1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);
1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);

Line 1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);

1273: dbms_sql.column_value(l_ea_cur_id,2,x_ext_attrib_tbl(l_ind).txn_line_detail_id);
1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);
1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);

Line 1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);

1274: dbms_sql.column_value(l_ea_cur_id,3,x_ext_attrib_tbl(l_ind).attrib_source_table);
1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);

Line 1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);

1275: dbms_sql.column_value(l_ea_cur_id,4,x_ext_attrib_tbl(l_ind).attribute_source_id);
1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);

Line 1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);

1276: dbms_sql.column_value(l_ea_cur_id,5,x_ext_attrib_tbl(l_ind).attribute_value);
1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);

Line 1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);

1277: dbms_sql.column_value(l_ea_cur_id,6,x_ext_attrib_tbl(l_ind).process_flag);
1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);

Line 1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);

1278: dbms_sql.column_value(l_ea_cur_id,7,x_ext_attrib_tbl(l_ind).active_start_date);
1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);

Line 1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);

1279: dbms_sql.column_value(l_ea_cur_id,8,x_ext_attrib_tbl(l_ind).active_end_date);
1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);

Line 1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);

1280: dbms_sql.column_value(l_ea_cur_id,9,x_ext_attrib_tbl(l_ind).preserve_detail_flag);
1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);

Line 1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);

1281: dbms_sql.column_value(l_ea_cur_id,10,x_ext_attrib_tbl(l_ind).context);
1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);

Line 1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);

1282: dbms_sql.column_value(l_ea_cur_id,11,x_ext_attrib_tbl(l_ind).attribute1);
1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);

Line 1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);

1283: dbms_sql.column_value(l_ea_cur_id,12,x_ext_attrib_tbl(l_ind).attribute2);
1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);

Line 1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);

1284: dbms_sql.column_value(l_ea_cur_id,13,x_ext_attrib_tbl(l_ind).attribute3);
1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);

Line 1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);

1285: dbms_sql.column_value(l_ea_cur_id,14,x_ext_attrib_tbl(l_ind).attribute4);
1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);

Line 1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);

1286: dbms_sql.column_value(l_ea_cur_id,15,x_ext_attrib_tbl(l_ind).attribute5);
1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);

Line 1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);

1287: dbms_sql.column_value(l_ea_cur_id,16,x_ext_attrib_tbl(l_ind).attribute6);
1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);
1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);

Line 1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);

1288: dbms_sql.column_value(l_ea_cur_id,17,x_ext_attrib_tbl(l_ind).attribute7);
1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);
1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);
1296: dbms_sql.column_value(l_ea_cur_id,25,x_ext_attrib_tbl(l_ind).attribute15);

Line 1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);

1289: dbms_sql.column_value(l_ea_cur_id,18,x_ext_attrib_tbl(l_ind).attribute8);
1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);
1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);
1296: dbms_sql.column_value(l_ea_cur_id,25,x_ext_attrib_tbl(l_ind).attribute15);
1297: dbms_sql.column_value(l_ea_cur_id,26,x_ext_attrib_tbl(l_ind).object_version_number);

Line 1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);

1290: dbms_sql.column_value(l_ea_cur_id,19,x_ext_attrib_tbl(l_ind).attribute9);
1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);
1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);
1296: dbms_sql.column_value(l_ea_cur_id,25,x_ext_attrib_tbl(l_ind).attribute15);
1297: dbms_sql.column_value(l_ea_cur_id,26,x_ext_attrib_tbl(l_ind).object_version_number);
1298:

Line 1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);

1291: dbms_sql.column_value(l_ea_cur_id,20,x_ext_attrib_tbl(l_ind).attribute10);
1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);
1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);
1296: dbms_sql.column_value(l_ea_cur_id,25,x_ext_attrib_tbl(l_ind).attribute15);
1297: dbms_sql.column_value(l_ea_cur_id,26,x_ext_attrib_tbl(l_ind).object_version_number);
1298:
1299: END LOOP;

Line 1296: dbms_sql.column_value(l_ea_cur_id,25,x_ext_attrib_tbl(l_ind).attribute15);

1292: dbms_sql.column_value(l_ea_cur_id,21,x_ext_attrib_tbl(l_ind).attribute11);
1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);
1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);
1296: dbms_sql.column_value(l_ea_cur_id,25,x_ext_attrib_tbl(l_ind).attribute15);
1297: dbms_sql.column_value(l_ea_cur_id,26,x_ext_attrib_tbl(l_ind).object_version_number);
1298:
1299: END LOOP;
1300:

Line 1297: dbms_sql.column_value(l_ea_cur_id,26,x_ext_attrib_tbl(l_ind).object_version_number);

1293: dbms_sql.column_value(l_ea_cur_id,22,x_ext_attrib_tbl(l_ind).attribute12);
1294: dbms_sql.column_value(l_ea_cur_id,23,x_ext_attrib_tbl(l_ind).attribute13);
1295: dbms_sql.column_value(l_ea_cur_id,24,x_ext_attrib_tbl(l_ind).attribute14);
1296: dbms_sql.column_value(l_ea_cur_id,25,x_ext_attrib_tbl(l_ind).attribute15);
1297: dbms_sql.column_value(l_ea_cur_id,26,x_ext_attrib_tbl(l_ind).object_version_number);
1298:
1299: END LOOP;
1300:
1301: dbms_sql.close_cursor(l_ea_cur_id);

Line 1301: dbms_sql.close_cursor(l_ea_cur_id);

1297: dbms_sql.column_value(l_ea_cur_id,26,x_ext_attrib_tbl(l_ind).object_version_number);
1298:
1299: END LOOP;
1300:
1301: dbms_sql.close_cursor(l_ea_cur_id);
1302:
1303: EXCEPTION
1304: WHEN others THEN
1305:

Line 1306: IF dbms_sql.is_open(l_ea_cur_id) THEN

1302:
1303: EXCEPTION
1304: WHEN others THEN
1305:
1306: IF dbms_sql.is_open(l_ea_cur_id) THEN
1307: dbms_sql.close_cursor(l_ea_cur_id);
1308: END IF;
1309: END get_ext_attrib_dtls;
1310:

Line 1307: dbms_sql.close_cursor(l_ea_cur_id);

1303: EXCEPTION
1304: WHEN others THEN
1305:
1306: IF dbms_sql.is_open(l_ea_cur_id) THEN
1307: dbms_sql.close_cursor(l_ea_cur_id);
1308: END IF;
1309: END get_ext_attrib_dtls;
1310:
1311: PROCEDURE get_all_csi_ext_attrib_vals(