66: l_can_edit_this_instance VARCHAR2(1);
67: l_token_table ERROR_HANDLER.Token_Tbl_Type;
68: l_could_edit_prev_instance VARCHAR2(1);
69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
67: l_token_table ERROR_HANDLER.Token_Tbl_Type;
68: l_could_edit_prev_instance VARCHAR2(1);
69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
75: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
68: l_could_edit_prev_instance VARCHAR2(1);
69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
75: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
76: l_failed_row_id_buffer VARCHAR2(32767);
69: l_at_start_of_row BOOLEAN;
70: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
71: p_line_pk_col_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
72: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
73: p_line_class_code_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
74: p_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
75: p_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
76: l_failed_row_id_buffer VARCHAR2(32767);
77: l_failed_row_id_list VARCHAR2(32767);
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: );
666: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
667: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', attr_rec.CHANGE_TYPE_ID));
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: );
666: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
667: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', attr_rec.CHANGE_TYPE_ID));
668: p_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
669: p_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
670:
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: );
964:
965: p_line_class_code_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
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: );
964:
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);
1298: l_change_id NUMBER;
1299: l_change_type_id NUMBER;
1300: l_can_edit_this_instance VARCHAR2(1);
1301: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1302: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1303: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1304: l_failed_row_id_buffer VARCHAR2(32767);
1305: l_failed_row_id_list VARCHAR2(32767);
1306: l_return_status VARCHAR2(1);
1299: l_change_type_id NUMBER;
1300: l_can_edit_this_instance VARCHAR2(1);
1301: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1302: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1303: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1304: l_failed_row_id_buffer VARCHAR2(32767);
1305: l_failed_row_id_list VARCHAR2(32767);
1306: l_return_status VARCHAR2(1);
1307: l_errorcode NUMBER;
1365: RAISE G_NO_CHANGE_TO_VALIDATE;
1366: else
1367: G_ITEM_NAME := 'ENG_CHANGE';
1368:
1369: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1370: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID', l_change_id));
1371:
1372: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1373: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', l_change_type_id)
1368:
1369: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1370: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID', l_change_id));
1371:
1372: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1373: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', l_change_type_id)
1374: );
1375: -- customer needs to populate ROW_IDENTIFIER,ATTR_GROUP_NAME,TRANSACTION_TYPE
1376: -- attributes.
1443: l_change_line_id NUMBER;
1444: l_change_type_id NUMBER;
1445: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1446: l_can_edit_this_instance VARCHAR2(1);
1447: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1448: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1449: l_failed_row_id_buffer VARCHAR2(32767);
1450: l_failed_row_id_list VARCHAR2(32767);
1451: l_return_status VARCHAR2(1);
1444: l_change_type_id NUMBER;
1445: l_token_table ERROR_HANDLER.Token_Tbl_Type;
1446: l_can_edit_this_instance VARCHAR2(1);
1447: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1448: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1449: l_failed_row_id_buffer VARCHAR2(32767);
1450: l_failed_row_id_list VARCHAR2(32767);
1451: l_return_status VARCHAR2(1);
1452: l_errorcode NUMBER;
1510: RAISE G_NO_CHANGE_TO_VALIDATE;
1511: else
1512: G_ITEM_NAME := 'ENG_CHANGE_LINE';
1513:
1514: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1515: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_LINE_ID', l_change_line_id)
1516: );
1517:
1518: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1514: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1515: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_LINE_ID', l_change_line_id)
1516: );
1517:
1518: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1519: EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_TYPE_ID', l_change_type_id)
1520: );
1521:
1522: -- customer needs to populate ROW_IDENTIFIER,ATTR_GROUP_NAME,TRANSACTION_TYPE