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.ENG_CHANGE_ATTR_UTIL dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 731: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

727: ,p_application_id IN NUMBER
728: ,p_attr_group_name IN VARCHAR2
729: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
730: ,p_extension_id IN NUMBER
731: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
732: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
733: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
734: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
735: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL

Line 732: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

728: ,p_attr_group_name IN VARCHAR2
729: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
730: ,p_extension_id IN NUMBER
731: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
732: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
733: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
734: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
735: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
736: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 733: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

729: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
730: ,p_extension_id IN NUMBER
731: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
732: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
733: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
734: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
735: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
736: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
737: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL

Line 734: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

730: ,p_extension_id IN NUMBER
731: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
732: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
733: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
734: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
735: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
736: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
737: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
738: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL

Line 751: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

747: ,x_msg_count OUT NOCOPY NUMBER
748: ,x_msg_data OUT NOCOPY VARCHAR2
749: ,p_key_attr_upd IN VARCHAR2
750: ,p_data_level_name IN VARCHAR2
751: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
752:
753: )
754: IS
755: l_failed_row_id_list VARCHAR2(3200);

Line 763: l_extra_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

759: l_curr_ag_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
760: l_attr_meta_data EGO_ATTR_METADATA_TABLE;
761: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;
762: l_mode VARCHAR2(10);
763: l_extra_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
764: l_delete_index NUMBER;
765: l_attr_db_col VARCHAR2(30);
766: l_retrieved_value_char VARCHAR2(4000);
767: l_retrieved_value_num NUMBER;

Line 1305: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1301: ,p_attr_group_id IN NUMBER
1302: ,p_application_id IN NUMBER
1303: ,p_attr_group_type IN VARCHAR2
1304: ,p_attr_group_name IN VARCHAR2
1305: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1306: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1307: ,P_DATA_LEVEL_NAME IN VARCHAR2
1308: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1309: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

Line 1306: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1302: ,p_application_id IN NUMBER
1303: ,p_attr_group_type IN VARCHAR2
1304: ,p_attr_group_name IN VARCHAR2
1305: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1306: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1307: ,P_DATA_LEVEL_NAME IN VARCHAR2
1308: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1309: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1310: ,p_mode IN VARCHAR2

Line 1308: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

1304: ,p_attr_group_name IN VARCHAR2
1305: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1306: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1307: ,P_DATA_LEVEL_NAME IN VARCHAR2
1308: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1309: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1310: ,p_mode IN VARCHAR2
1311: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1312: ,p_extension_id IN NUMBER

Line 1311: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1307: ,P_DATA_LEVEL_NAME IN VARCHAR2
1308: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1309: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1310: ,p_mode IN VARCHAR2
1311: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1312: ,p_extension_id IN NUMBER
1313: ,p_pending_b_table_name IN VARCHAR2
1314: ,p_pending_tl_table_name IN VARCHAR2
1315: ,p_pending_vl_name IN VARCHAR2

Line 1767: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1763: ,p_attr_group_id IN NUMBER
1764: ,p_application_id IN NUMBER
1765: ,p_attr_group_type IN VARCHAR2
1766: ,p_attr_group_name IN VARCHAR2
1767: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1768: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1769: ,P_DATA_LEVEL_NAME IN VARCHAR2
1770: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1771: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

Line 1768: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1764: ,p_application_id IN NUMBER
1765: ,p_attr_group_type IN VARCHAR2
1766: ,p_attr_group_name IN VARCHAR2
1767: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1768: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1769: ,P_DATA_LEVEL_NAME IN VARCHAR2
1770: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1771: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
1772: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 1770: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1766: ,p_attr_group_name IN VARCHAR2
1767: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1768: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1769: ,P_DATA_LEVEL_NAME IN VARCHAR2
1770: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1771: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
1772: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1773: ,x_return_status OUT NOCOPY VARCHAR2
1774: ,x_errorcode OUT NOCOPY NUMBER

Line 2130: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY

2126: );
2127: END VALIDATE_GDSN_RECORDS;
2128:
2129:
2130: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2131: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2132: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2133: ,P_OBJECT_NAME VARCHAR2
2134: ,P_APPLICATION_ID NUMBER)

Line 2131: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY

2127: END VALIDATE_GDSN_RECORDS;
2128:
2129:
2130: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2131: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2132: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2133: ,P_OBJECT_NAME VARCHAR2
2134: ,P_APPLICATION_ID NUMBER)
2135: IS

Line 2132: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY

2128:
2129:
2130: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2131: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2132: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2133: ,P_OBJECT_NAME VARCHAR2
2134: ,P_APPLICATION_ID NUMBER)
2135: IS
2136: CURSOR C_DATA_LEVELS (p_objet_name VARCHAR2)

Line 2170: L_PEND_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;

2166: L_B_WHERE_CLAUSE VARCHAR2(4000);
2167: l_TL_data_level_dml VARCHAR2(10000);
2168: L_DYN_ATTR_GRP_SQL VARCHAR2(10000);
2169: L_PEND_BIND_INDEX NUMBER :=0;
2170: L_PEND_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2171: L_BIND_INDEX NUMBER :=0;
2172: L_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2173: L_ATTR_CURSOR_ID NUMBER;
2174: L_PROD_CURSOR_ID NUMBER;

Line 2172: L_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;

2168: L_DYN_ATTR_GRP_SQL VARCHAR2(10000);
2169: L_PEND_BIND_INDEX NUMBER :=0;
2170: L_PEND_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2171: L_BIND_INDEX NUMBER :=0;
2172: L_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2173: L_ATTR_CURSOR_ID NUMBER;
2174: L_PROD_CURSOR_ID NUMBER;
2175: L_B_CURSOR_ID NUMBER;
2176: L_TL_CURSOR_ID NUMBER;

Line 2185: L_UPDATE_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;

2181: l_b_update_dml VARCHAR2(10000);
2182: l_tl_update_dml VARCHAR2(10000);
2183: L_UPDATE_WHERE_CLAUSE VARCHAR2(4000) := NULL;
2184: L_UPDATE_BIND_INDEX NUMBER :=0;
2185: L_UPDATE_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2186: L_ADDED_UPDATE_B_DML VARCHAR2(10000);
2187: L_ADDED_UPDATE_TL_DML VARCHAR2(10000);
2188: L_ADDED_WHERE_CLAUSE VARCHAR2(4000);
2189: L_B_TEMP_WHERE_CLAUSE VARCHAR2(4000);

Line 2220: L_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2216: ||' EGO_MTL_SY_ITEMS_EXT_VL B '
2217: ||' WHERE A.EXTENSION_ID <> B.EXTENSION_ID '
2218: ||' AND A.ATTR_GROUP_ID = B.ATTR_GROUP_ID ';
2219:
2220: L_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2221: L_PEND_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2222: IF P_PK_ATTR_NAME_VALUE_PAIRS IS NOT NULL
2223: THEN
2224: FOR i IN 1 .. P_PK_ATTR_NAME_VALUE_PAIRS.LAST

Line 2221: L_PEND_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2217: ||' WHERE A.EXTENSION_ID <> B.EXTENSION_ID '
2218: ||' AND A.ATTR_GROUP_ID = B.ATTR_GROUP_ID ';
2219:
2220: L_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2221: L_PEND_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2222: IF P_PK_ATTR_NAME_VALUE_PAIRS IS NOT NULL
2223: THEN
2224: FOR i IN 1 .. P_PK_ATTR_NAME_VALUE_PAIRS.LAST
2225: LOOP

Line 2717: ,P_DATA_LEVEL_NAME_VALUE_PAIRS IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

2713: ,P_CHANGE_ID IN NUMBER
2714: ,P_CHANGE_LINE_ID IN NUMBER
2715: ,P_ORG_ID IN NUMBER
2716: ,P_DATA_LEVEL_NAME IN VARCHAR2
2717: ,P_DATA_LEVEL_NAME_VALUE_PAIRS IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
2718: )
2719: IS
2720: l_dynamic_sql VARCHAR2(4000);
2721: l_data_level_id NUMBER;