[Home] [Help]
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);
78: l_return_status VARCHAR2(1);
79: l_errorcode NUMBER;
80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(1000);
82: l_dynamic_sql VARCHAR2(32767);
83: p_line_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
84: p_line_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
85:
86: -------------------------------------------------------------------------
87: -- For finding ChangeID using Organization ID and Change Number --
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:
671: ELSE
672:
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
974:
1286: , p_bo_identifier IN VARCHAR2 := 'ECO'
1287: , p_change_number IN VARCHAR2
1288: , p_change_mgmt_type_code IN VARCHAR2
1289: , p_Organization_Code IN VARCHAR2
1290: , p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
1291: , p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
1292: , p_debug IN VARCHAR2 := 'N'
1293: , p_output_dir IN VARCHAR2 := NULL
1294: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1308: l_msg_count NUMBER;
1309: l_msg_data VARCHAR2(1000);
1310: l_dynamic_sql VARCHAR2(32767);
1311: p_debug_level NUMBER := 3;
1312: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
1313:
1314: cursor chg_csr is
1315: select EEC.CHANGE_ID,EEC.CHANGE_ORDER_TYPE_ID
1316: from ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
1374: );
1375: -- customer needs to populate ROW_IDENTIFIER,ATTR_GROUP_NAME,TRANSACTION_TYPE
1376: -- attributes.
1377: IF (p_attributes_row_table IS NOT NULL) THEN
1378: l_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
1379: FOR i IN 1..p_attributes_row_table.COUNT LOOP
1380: l_attr_row_table.EXTEND();
1381: l_attr_row_table(i) := EGO_USER_ATTR_ROW_OBJ(
1382: p_attributes_row_table(i).ROW_IDENTIFIER
1431: ,p_change_number IN VARCHAR2
1432: ,p_change_mgmt_type_code IN VARCHAR2
1433: ,p_Organization_Code IN VARCHAR2
1434: ,p_change_line_sequence_number IN NUMBER
1435: ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
1436: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
1437: , p_debug IN VARCHAR2 := 'N'
1438: , p_output_dir IN VARCHAR2 := NULL
1439: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1453: l_msg_count NUMBER;
1454: l_msg_data VARCHAR2(1000);
1455: l_dynamic_sql VARCHAR2(32767);
1456: p_debug_level NUMBER := 3;
1457: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
1458:
1459: cursor chgline_csr is
1460: select EEV.CHANGE_LINE_ID,EEV.CHANGE_TYPE_ID
1461: from ENG_CHANGE_LINES EEV,ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
1521:
1522: -- customer needs to populate ROW_IDENTIFIER,ATTR_GROUP_NAME,TRANSACTION_TYPE
1523: -- attributes.
1524: IF (p_attributes_row_table IS NOT NULL) THEN
1525: l_attr_row_table := EGO_USER_ATTR_ROW_TABLE();
1526: FOR i IN 1..p_attributes_row_table.COUNT LOOP
1527: l_attr_row_table.EXTEND();
1528: l_attr_row_table(i) := EGO_USER_ATTR_ROW_OBJ(
1529: p_attributes_row_table(i).ROW_IDENTIFIER