eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_CHANGE_USER_ATTRS_PUB dependencies on EGO_USER_ATTRS_DATA_PVT

Line 219: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);

215: -- ERROR_HANDLER SET-UP --
216: --======================--
217:
218: ERROR_HANDLER.Initialize();
219: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
220:
221: -----------------------------------------------------------
222: -- If we're debugging, we have to set up a Debug session --
223: -----------------------------------------------------------

Line 226: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE,p_debug_level);

222: -- If we're debugging, we have to set up a Debug session --
223: -----------------------------------------------------------
224: IF (p_debug_level > 0) THEN
225:
226: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE,p_debug_level);
227:
228: END IF;
229:
230: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Concurrent Program', 1);

Line 230: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Concurrent Program', 1);

226: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE,p_debug_level);
227:
228: END IF;
229:
230: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Concurrent Program', 1);
231:
232:
233:
234: --===================================--

Line 265: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversions', 1);

261: --==================================--
262: -- THE THREE PRELIMINARY CONVERSIONS --
263: --==================================--
264:
265: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversions', 1);
266:
267: ------------------------------------------------------------------
268: -- 1). Convert Organization Code to Organization ID
269: ------------------------------------------------------------------

Line 270: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Org Code conversion', 2);

266:
267: ------------------------------------------------------------------
268: -- 1). Convert Organization Code to Organization ID
269: ------------------------------------------------------------------
270: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Org Code conversion', 2);
271:
272: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
273: SET UAI.ORGANIZATION_ID = (SELECT MP.ORGANIZATION_ID
274: FROM MTL_PARAMETERS MP

Line 312: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Number conversion', 2);

308: -- rows that are still valid, meaning we won't have any null Org IDs) --
309: -- and gets the Change ID for each combination also gets change Line Id
310: -- from change_line_sequence_number
311: -------------------------------------------------------------------------
312: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Number conversion', 2);
313:
314: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
315: SET UAI.CHANGE_ID =
316: (SELECT EEC.CHANGE_ID

Line 402: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Type Id conversion', 2);

398:
399: ------------------------------------------------------
400: -- 4). Find the Change Type Id for each Change and Change Line--
401: ------------------------------------------------------
402: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Type Id conversion', 2);
403:
404: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
405: SET UAI.CHANGE_TYPE_ID =
406: (SELECT EEC.CHANGE_ORDER_TYPE_ID

Line 456: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversion error-reporting', 1);

452:
453: --========================================--
454: -- ERROR REPORTING FOR FAILED CONVERSIONS --
455: --========================================--
456: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting conversion error-reporting', 1);
457:
458: --------------------------------------------------------------------------
459: -- We fetch representative rows marked as errors and add error messages --
460: -- explaining the point in our conversion process at which each failed; --

Line 530: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting loop processing of valid rows', 1);

526:
527: --=====================================--
528: -- LOOP PROCESSING OF STILL-VALID ROWS --
529: --=====================================--
530: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting loop processing of valid rows', 1);
531:
532: ------------------------------------------------------------------
533: -- The interface table stores the Attribute data in a redundant --
534: -- form; we loop through its rows flattening the data out and --

Line 542: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before calling Header loop', 1);

538: -- the accumulated objects we've built in previous loops. --
539: ------------------------------------------------------------------
540:
541:
542: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before calling Header loop', 1);
543:
544: FOR attr_rec IN data_set_cursor_header(p_data_set_id)
545: LOOP
546: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop', 1);

Line 546: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop', 1);

542: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before calling Header loop', 1);
543:
544: FOR attr_rec IN data_set_cursor_header(p_data_set_id)
545: LOOP
546: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop', 1);
547: l_header_row_exists := TRUE;
548:
549: ------------------------------------------------------
550: -- Figure out whether we're starting a new instance --

Line 557: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop start_of_instance', 1);

553: l_prev_loop_org_id <> attr_rec.ORGANIZATION_ID OR
554: l_prev_loop_change_id <> attr_rec.CHANGE_ID);
555:
556: IF (l_at_start_of_instance) THEN
557: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop start_of_instance', 1);
558:
559: l_entity_index_counter := l_entity_index_counter + 1;
560:
561: ------------------------------------------------------------------

Line 661: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop l_prev_loop_org_id IS NULL', 1);

657: -- at the start of all subsequent instances. --
658: ------------------------------------------------------------------
659: G_ITEM_NAME := 'ENG_CHANGE';
660: IF (l_prev_loop_org_id IS NULL) THEN
661: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop l_prev_loop_org_id IS NULL', 1);
662:
663: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
664: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID', attr_rec.CHANGE_ID)
665: );

Line 682: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop previous instance processing ', 1);

678: -- (note that since we're always calling for the previous instance, we --
679: -- will need one final call after we're done looping through all rows; --
680: -- note also that we make sure the user passed the security check) --
681: -------------------------------------------------------------------------
682: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop previous instance processing ', 1);
683: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
684: (
685: p_api_version => G_API_VERSION
686: ,p_object_name => G_ITEM_NAME

Line 742: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop starting a new row ', 1);

738: -------------------------------------------
739: -- Build an Attr Row Object for each row --
740: -------------------------------------------
741: IF (l_at_start_of_row) THEN
742: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Header loop starting a new row ', 1);
743: p_attributes_row_table.EXTEND();
744:
745: p_attributes_row_table(p_attributes_row_table.LAST) := EGO_USER_ATTR_ROW_OBJ(
746: attr_rec.ROW_IDENTIFIER

Line 821: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with processing of final Change instance', 1);

817: l_prev_loop_org_id := NULL;
818: l_prev_loop_change_id := NULL;
819: l_prev_loop_row_identifier := NULL;
820:
821: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with processing of final Change instance', 1);
822:
823: ------------------------------------------------------------------------
824: -- If any rows for this instance failed, we add their ROW_IDENTIFIERs --
825: -- to our master list, which we will then use to mark as errors all --

Line 834: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before calling Line loop', 1);

830: l_failed_row_id_list := l_failed_row_id_list || l_failed_row_id_buffer || ',';
831:
832: END IF;
833: END IF;
834: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before calling Line loop', 1);
835:
836: FOR attr_rec IN data_set_cursor_line(p_data_set_id)
837: LOOP
838: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Line loop', 1);

Line 838: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Line loop', 1);

834: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before calling Line loop', 1);
835:
836: FOR attr_rec IN data_set_cursor_line(p_data_set_id)
837: LOOP
838: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside Line loop', 1);
839: l_line_row_exists := TRUE;
840:
841: ------------------------------------------------------
842: -- Figure out whether we're starting a new instance --

Line 849: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside IF (l_at_start_of_instance) loop', 1);

845: l_prev_loop_org_id <> attr_rec.ORGANIZATION_ID OR
846: l_prev_loop_change_line_id <> attr_rec.CHANGE_LINE_ID);
847:
848: IF (l_at_start_of_instance) THEN
849: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside IF (l_at_start_of_instance) loop', 1);
850:
851: l_entity_index_counter := l_entity_index_counter + 1;
852:
853: ------------------------------------------------------------------

Line 959: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside setting p_line_pk_col_name_value_pairs', 1);

955: -----------------------------------------------------------------
956: G_ITEM_NAME := 'ENG_CHANGE_LINE';
957: IF (l_prev_loop_org_id IS NULL ) THEN
958:
959: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside setting p_line_pk_col_name_value_pairs', 1);
960:
961: p_line_pk_col_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
962: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_LINE_ID', attr_rec.CHANGE_LINE_ID)
963: );

Line 969: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside intilizing attribute and data table ', 1);

965: p_line_class_code_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
966: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', attr_rec.CHANGE_TYPE_ID)
967:
968: );
969: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside intilizing attribute and data table ', 1);
970: p_line_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
971: p_line_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
972:
973: ELSE

Line 984: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside process the data collected for the previous instance ', 1);

980: -- (note that since we're always calling for the previous instance, we --
981: -- will need one final call after we're done looping through all rows; --
982: -- note also that we make sure the user passed the security check) --
983: -------------------------------------------------------------------------
984: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside process the data collected for the previous instance ', 1);
985: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
986: (
987: p_api_version => G_API_VERSION
988: ,p_object_name => G_ITEM_NAME

Line 1021: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating Primary key and classification ', 1);

1017: ------------------------------------------------------------------
1018: -- Now we update the Primary Key and Classification Code column --
1019: -- values, and we clear out the Attr Row and Attr Data tables --
1020: ------------------------------------------------------------------
1021: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating Primary key and classification ', 1);
1022:
1023: p_line_pk_col_name_value_pairs(1).VALUE := attr_rec.CHANGE_LINE_ID;
1024:
1025: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(1)iCHANGE_LINE_ID ', 1);

Line 1025: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(1)iCHANGE_LINE_ID ', 1);

1021: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating Primary key and classification ', 1);
1022:
1023: p_line_pk_col_name_value_pairs(1).VALUE := attr_rec.CHANGE_LINE_ID;
1024:
1025: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(1)iCHANGE_LINE_ID ', 1);
1026: -- p_line_pk_col_name_value_pairs(2).VALUE := attr_rec.ORGANIZATION_ID;
1027:
1028: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(2) ORGANIZATION_ID ', 1);
1029: p_line_class_code_value_pairs(1).VALUE := attr_rec.CHANGE_TYPE_ID;

Line 1028: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(2) ORGANIZATION_ID ', 1);

1024:
1025: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(1)iCHANGE_LINE_ID ', 1);
1026: -- p_line_pk_col_name_value_pairs(2).VALUE := attr_rec.ORGANIZATION_ID;
1027:
1028: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(2) ORGANIZATION_ID ', 1);
1029: p_line_class_code_value_pairs(1).VALUE := attr_rec.CHANGE_TYPE_ID;
1030:
1031: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside deleting attribute and data tables ', 1);
1032:

Line 1031: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside deleting attribute and data tables ', 1);

1027:
1028: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside updating value_pairs(2) ORGANIZATION_ID ', 1);
1029: p_line_class_code_value_pairs(1).VALUE := attr_rec.CHANGE_TYPE_ID;
1030:
1031: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac inside deleting attribute and data tables ', 1);
1032:
1033: p_line_attributes_row_table.DELETE;
1034: p_line_attributes_data_table.DELETE;
1035: END IF;

Line 1050: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac Before extending the attributes_row_table :',3);

1046: -------------------------------------------
1047: -- Build an Attr Row Object for each row --
1048: -------------------------------------------
1049: IF (l_at_start_of_row) THEN
1050: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac Before extending the attributes_row_table :',3);
1051:
1052: p_line_attributes_row_table.EXTEND();
1053: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac after extending the attributes_row_table :',3);
1054:

Line 1053: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac after extending the attributes_row_table :',3);

1049: IF (l_at_start_of_row) THEN
1050: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac Before extending the attributes_row_table :',3);
1051:
1052: p_line_attributes_row_table.EXTEND();
1053: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac after extending the attributes_row_table :',3);
1054:
1055: p_line_attributes_row_table(p_line_attributes_row_table.LAST) := EGO_USER_ATTR_ROW_OBJ(
1056: attr_rec.ROW_IDENTIFIER
1057: ,attr_rec.ATTR_GROUP_ID

Line 1074: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before extending attribute tabl ', 1);

1070:
1071: ---------------------------------------------------------------
1072: -- Add an Attr Data object to the Attr Data table every time --
1073: ---------------------------------------------------------------
1074: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before extending attribute tabl ', 1);
1075:
1076: p_line_attributes_data_table.EXTEND();
1077: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before after attribute tabl ', 1);
1078: p_line_attributes_data_table(p_line_attributes_data_table.LAST) := EGO_USER_ATTR_DATA_OBJ(

Line 1077: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before after attribute tabl ', 1);

1073: ---------------------------------------------------------------
1074: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before extending attribute tabl ', 1);
1075:
1076: p_line_attributes_data_table.EXTEND();
1077: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before after attribute tabl ', 1);
1078: p_line_attributes_data_table(p_line_attributes_data_table.LAST) := EGO_USER_ATTR_DATA_OBJ(
1079: attr_rec.ROW_IDENTIFIER
1080: ,attr_rec.ATTR_INT_NAME
1081: ,attr_rec.ATTR_VALUE_STR

Line 1097: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before end of line loop', 1);

1093: l_prev_loop_org_id := attr_rec.ORGANIZATION_ID;
1094: l_prev_loop_change_line_id := attr_rec.CHANGE_LINE_ID;
1095: l_prev_loop_row_identifier := attr_rec.ROW_IDENTIFIER;
1096:
1097: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before end of line loop', 1);
1098: END LOOP;
1099:
1100:
1101: -----------------------------------------------------------

Line 1108: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before final calling :',3);

1104: -- this time we pass p_log_errors as TRUE so we can log --
1105: -- all errors accumulated through our previous loops --
1106: -----------------------------------------------------------
1107: IF (l_can_edit_this_instance = 'T'AND l_line_row_exists ) THEN
1108: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Sac before final calling :',3);
1109:
1110:
1111: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
1112: (

Line 1138: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with processing of final line instance', 1);

1134: l_prev_loop_row_identifier := NULL;
1135:
1136:
1137:
1138: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with processing of final line instance', 1);
1139:
1140: ------------------------------------------------------------------------
1141: -- If any rows for this instance failed, we add their ROW_IDENTIFIERs --
1142: -- to our master list, which we will then use to mark as errors all --

Line 1159: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('List of all ROW_IDENTIFIERs that failed: '||l_failed_row_id_list, 3);

1155: -- Strip off any trailing ',' from the failed ROW_IDENTIFIER list... --
1156: -----------------------------------------------------------------------
1157: l_failed_row_id_list := SUBSTR(l_failed_row_id_list, 1, LENGTH(l_failed_row_id_list) - LENGTH(','));
1158:
1159: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('List of all ROW_IDENTIFIERs that failed: '||l_failed_row_id_list, 3);
1160:
1161: ---------------------------------------------------------------
1162: -- ...and then use it to mark as errors all rows in the list --
1163: -- (note that we have to use dynamic SQL because 1). static --

Line 1200: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Change Concurrent Program', 1);

1196: WHERE DATA_SET_ID = p_data_set_id
1197: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1198: END IF;
1199:
1200: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Done with Change Concurrent Program', 1);
1201:
1202: -------------------------------------------------------------------
1203: -- Finally, we log any errors that we've accumulated throughout --
1204: -- our conversions and looping (including all errors encountered --

Line 1353: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE);

1349: -- If we're debugging, we have to set up a Debug session --
1350: -----------------------------------------------------------
1351: IF (p_debug_level > 0) THEN
1352:
1353: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE);
1354:
1355: END IF;
1356:
1357: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Instance Program', 1);

Line 1357: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Instance Program', 1);

1353: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE);
1354:
1355: END IF;
1356:
1357: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Instance Program', 1);
1358:
1359:
1360: OPEN chg_csr;
1361: FETCH chg_csr INTO l_change_id,l_change_type_id;

Line 1494: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE);

1490: -- If we're debugging, we have to set up a Debug session --
1491: -----------------------------------------------------------
1492: IF (p_debug_level > 0) THEN
1493:
1494: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE);
1495:
1496: END IF;
1497:
1498: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Line Instance Program', 1);

Line 1498: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Line Instance Program', 1);

1494: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE);
1495:
1496: END IF;
1497:
1498: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting Change Line Instance Program', 1);
1499:
1500:
1501: OPEN chgline_csr;
1502: FETCH chgline_csr INTO l_change_line_id,l_change_type_id;