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 736: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

732: ,p_application_id IN NUMBER
733: ,p_attr_group_name IN VARCHAR2
734: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
735: ,p_extension_id IN NUMBER
736: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
737: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
738: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
739: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
740: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL

Line 737: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

733: ,p_attr_group_name IN VARCHAR2
734: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
735: ,p_extension_id IN NUMBER
736: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
737: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
738: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
739: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
740: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
741: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL

Line 738: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

734: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
735: ,p_extension_id IN NUMBER
736: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
737: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
738: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
739: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
740: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
741: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
742: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL

Line 739: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

735: ,p_extension_id IN NUMBER
736: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
737: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
738: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
739: ,p_extra_attr_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
740: ,p_alternate_ext_b_table_name IN VARCHAR2 DEFAULT NULL
741: ,p_alternate_ext_tl_table_name IN VARCHAR2 DEFAULT NULL
742: ,p_alternate_ext_vl_name IN VARCHAR2 DEFAULT NULL
743: ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL

Line 756: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

752: ,x_msg_count OUT NOCOPY NUMBER
753: ,x_msg_data OUT NOCOPY VARCHAR2
754: ,p_key_attr_upd IN VARCHAR2
755: ,p_data_level_name IN VARCHAR2
756: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
757:
758: )
759: IS
760: l_failed_row_id_list VARCHAR2(3200);

Line 768: l_extra_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

764: l_curr_ag_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
765: l_attr_meta_data EGO_ATTR_METADATA_TABLE;
766: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;
767: l_mode VARCHAR2(10);
768: l_extra_pk_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
769: l_delete_index NUMBER;
770: l_attr_db_col VARCHAR2(30);
771: l_retrieved_value_char VARCHAR2(4000);
772: l_retrieved_value_num NUMBER;

Line 1335: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1331: ,p_attr_group_id IN NUMBER
1332: ,p_application_id IN NUMBER
1333: ,p_attr_group_type IN VARCHAR2
1334: ,p_attr_group_name IN VARCHAR2
1335: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1336: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1337: ,P_DATA_LEVEL_NAME IN VARCHAR2
1338: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1339: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

Line 1336: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1332: ,p_application_id IN NUMBER
1333: ,p_attr_group_type IN VARCHAR2
1334: ,p_attr_group_name IN VARCHAR2
1335: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1336: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1337: ,P_DATA_LEVEL_NAME IN VARCHAR2
1338: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1339: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1340: ,p_mode IN VARCHAR2

Line 1338: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

1334: ,p_attr_group_name IN VARCHAR2
1335: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1336: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1337: ,P_DATA_LEVEL_NAME IN VARCHAR2
1338: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1339: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1340: ,p_mode IN VARCHAR2
1341: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1342: ,p_extension_id IN NUMBER

Line 1341: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1337: ,P_DATA_LEVEL_NAME IN VARCHAR2
1338: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1339: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1340: ,p_mode IN VARCHAR2
1341: ,p_extra_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1342: ,p_extension_id IN NUMBER
1343: ,p_pending_b_table_name IN VARCHAR2
1344: ,p_pending_tl_table_name IN VARCHAR2
1345: ,p_pending_vl_name IN VARCHAR2

Line 1798: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1794: ,p_attr_group_id IN NUMBER
1795: ,p_application_id IN NUMBER
1796: ,p_attr_group_type IN VARCHAR2
1797: ,p_attr_group_name IN VARCHAR2
1798: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1799: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1800: ,P_DATA_LEVEL_NAME IN VARCHAR2
1801: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1802: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

Line 1799: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1795: ,p_application_id IN NUMBER
1796: ,p_attr_group_type IN VARCHAR2
1797: ,p_attr_group_name IN VARCHAR2
1798: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1799: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1800: ,P_DATA_LEVEL_NAME IN VARCHAR2
1801: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1802: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
1803: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 1801: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

1797: ,p_attr_group_name IN VARCHAR2
1798: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1799: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1800: ,P_DATA_LEVEL_NAME IN VARCHAR2
1801: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1802: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
1803: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
1804: ,x_return_status OUT NOCOPY VARCHAR2
1805: ,x_errorcode OUT NOCOPY NUMBER

Line 2161: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY

2157: );
2158: END VALIDATE_GDSN_RECORDS;
2159:
2160:
2161: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2162: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2163: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2164: ,P_OBJECT_NAME VARCHAR2
2165: ,P_APPLICATION_ID NUMBER)

Line 2162: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY

2158: END VALIDATE_GDSN_RECORDS;
2159:
2160:
2161: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2162: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2163: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2164: ,P_OBJECT_NAME VARCHAR2
2165: ,P_APPLICATION_ID NUMBER)
2166: IS

Line 2163: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY

2159:
2160:
2161: PROCEDURE UPDATE_DATA_LEVEL(P_PK_ATTR_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2162: ,P_NEW_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2163: ,P_OLD_DL_NAME_VALUE_PAIRS EGO_COL_NAME_VALUE_PAIR_ARRAY
2164: ,P_OBJECT_NAME VARCHAR2
2165: ,P_APPLICATION_ID NUMBER)
2166: IS
2167: CURSOR C_DATA_LEVELS (p_objet_name VARCHAR2)

Line 2201: L_PEND_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;

2197: L_B_WHERE_CLAUSE VARCHAR2(4000);
2198: l_TL_data_level_dml VARCHAR2(10000);
2199: L_DYN_ATTR_GRP_SQL VARCHAR2(10000);
2200: L_PEND_BIND_INDEX NUMBER :=0;
2201: L_PEND_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2202: L_BIND_INDEX NUMBER :=0;
2203: L_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2204: L_ATTR_CURSOR_ID NUMBER;
2205: L_PROD_CURSOR_ID NUMBER;

Line 2203: L_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;

2199: L_DYN_ATTR_GRP_SQL VARCHAR2(10000);
2200: L_PEND_BIND_INDEX NUMBER :=0;
2201: L_PEND_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2202: L_BIND_INDEX NUMBER :=0;
2203: L_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2204: L_ATTR_CURSOR_ID NUMBER;
2205: L_PROD_CURSOR_ID NUMBER;
2206: L_B_CURSOR_ID NUMBER;
2207: L_TL_CURSOR_ID NUMBER;

Line 2216: L_UPDATE_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;

2212: l_b_update_dml VARCHAR2(10000);
2213: l_tl_update_dml VARCHAR2(10000);
2214: L_UPDATE_WHERE_CLAUSE VARCHAR2(4000) := NULL;
2215: L_UPDATE_BIND_INDEX NUMBER :=0;
2216: L_UPDATE_BIND_VALUES EGO_COL_NAME_VALUE_PAIR_ARRAY;
2217: L_ADDED_UPDATE_B_DML VARCHAR2(10000);
2218: L_ADDED_UPDATE_TL_DML VARCHAR2(10000);
2219: L_ADDED_WHERE_CLAUSE VARCHAR2(4000);
2220: L_B_TEMP_WHERE_CLAUSE VARCHAR2(4000);

Line 2251: L_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2247: ||' EGO_MTL_SY_ITEMS_EXT_VL B '
2248: ||' WHERE A.EXTENSION_ID <> B.EXTENSION_ID '
2249: ||' AND A.ATTR_GROUP_ID = B.ATTR_GROUP_ID ';
2250:
2251: L_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2252: L_PEND_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2253: IF P_PK_ATTR_NAME_VALUE_PAIRS IS NOT NULL
2254: THEN
2255: FOR i IN 1 .. P_PK_ATTR_NAME_VALUE_PAIRS.LAST

Line 2252: L_PEND_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2248: ||' WHERE A.EXTENSION_ID <> B.EXTENSION_ID '
2249: ||' AND A.ATTR_GROUP_ID = B.ATTR_GROUP_ID ';
2250:
2251: L_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2252: L_PEND_BIND_VALUES := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2253: IF P_PK_ATTR_NAME_VALUE_PAIRS IS NOT NULL
2254: THEN
2255: FOR i IN 1 .. P_PK_ATTR_NAME_VALUE_PAIRS.LAST
2256: LOOP

Line 2748: ,P_DATA_LEVEL_NAME_VALUE_PAIRS IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

2744: ,P_CHANGE_ID IN NUMBER
2745: ,P_CHANGE_LINE_ID IN NUMBER
2746: ,P_ORG_ID IN NUMBER
2747: ,P_DATA_LEVEL_NAME IN VARCHAR2
2748: ,P_DATA_LEVEL_NAME_VALUE_PAIRS IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
2749: )
2750: IS
2751: l_dynamic_sql VARCHAR2(4000);
2752: l_data_level_id NUMBER;