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_USER_ATTR_DATA_TABLE

Line 306: ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

302: ( p_api_version IN NUMBER
303: ,p_object_name IN VARCHAR2
304: ,p_application_id IN NUMBER
305: ,p_attr_group_type IN VARCHAR2
306: ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
307: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
308: ,x_return_status OUT NOCOPY VARCHAR2
309: ,x_errorcode OUT NOCOPY NUMBER
310: ,x_msg_count OUT NOCOPY NUMBER

Line 307: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

303: ,p_object_name IN VARCHAR2
304: ,p_application_id IN NUMBER
305: ,p_attr_group_type IN VARCHAR2
306: ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
307: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
308: ,x_return_status OUT NOCOPY VARCHAR2
309: ,x_errorcode OUT NOCOPY NUMBER
310: ,x_msg_count OUT NOCOPY NUMBER
311: ,x_msg_data OUT NOCOPY VARCHAR2

Line 519: ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

515: ( p_api_version IN NUMBER
516: ,p_object_name IN VARCHAR2
517: ,p_application_id IN NUMBER
518: ,p_attr_group_type IN VARCHAR2
519: ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
520: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
521: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
522: ,x_return_status OUT NOCOPY VARCHAR2
523: ,x_errorcode OUT NOCOPY NUMBER

Line 520: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

516: ,p_object_name IN VARCHAR2
517: ,p_application_id IN NUMBER
518: ,p_attr_group_type IN VARCHAR2
519: ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
520: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
521: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
522: ,x_return_status OUT NOCOPY VARCHAR2
523: ,x_errorcode OUT NOCOPY NUMBER
524: ,x_msg_count OUT NOCOPY NUMBER

Line 521: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

517: ,p_application_id IN NUMBER
518: ,p_attr_group_type IN VARCHAR2
519: ,p_base_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
520: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
521: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
522: ,x_return_status OUT NOCOPY VARCHAR2
523: ,x_errorcode OUT NOCOPY NUMBER
524: ,x_msg_count OUT NOCOPY NUMBER
525: ,x_msg_data OUT NOCOPY VARCHAR2

Line 734: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

730: ,p_attr_group_id IN NUMBER
731: ,p_attr_group_type IN VARCHAR2
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

Line 766: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;

762: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
763: l_row_identifier NUMBER ;
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);

Line 775: l_bind_values EGO_USER_ATTR_DATA_TABLE;

771: l_retrieved_value_char VARCHAR2(4000);
772: l_retrieved_value_num NUMBER;
773: l_retrieved_value_date DATE;
774: l_bind_index NUMBER;
775: l_bind_values EGO_USER_ATTR_DATA_TABLE;
776: l_dynamic_sql VARCHAR2(20000);
777: l_column_count NUMBER;
778: l_uk_where_clause VARCHAR2(4000):= null;
779: l_cursor_id NUMBER;

Line 893: l_bind_values := EGO_USER_ATTR_DATA_TABLE();

889: if i = l_attr_meta_data.last
890:
891: THEN
892: l_bind_index := 1;
893: l_bind_values := EGO_USER_ATTR_DATA_TABLE();
894: IF L_CACHED_SQL_FOUND <> 'Y' THEN
895: IF l_dynamic_sql = 'SELECT ' THEN
896: l_dynamic_sql := l_dynamic_sql || ' PEND.EXTENSION_ID ';
897: ELSE

Line 1339: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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
1343: ,p_pending_b_table_name IN VARCHAR2

Line 1347: ,p_dml_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1343: ,p_pending_b_table_name IN VARCHAR2
1344: ,p_pending_tl_table_name IN VARCHAR2
1345: ,p_pending_vl_name IN VARCHAR2
1346: ,p_acd_type IN VARCHAR2
1347: ,p_dml_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1348: ,p_api_caller IN VARCHAR2
1349: ,p_key_attr_upd IN VARCHAR2
1350: ,x_return_status OUT NOCOPY VARCHAR2
1351: ,x_errorcode OUT NOCOPY NUMBER

Line 1363: l_b_bind_attr_table EGO_USER_ATTR_DATA_TABLE;

1359: l_bind_index NUMBER;
1360: l_bind_value NUMBER;
1361: l_b_bind_count NUMBER;
1362: l_tl_bind_count NUMBER;
1363: l_b_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1364: l_tl_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1365:
1366: l_pending_base_tbl VARCHAR2(100);
1367: l_pending_tl_tbl VARCHAR2(100);

Line 1364: l_tl_bind_attr_table EGO_USER_ATTR_DATA_TABLE;

1360: l_bind_value NUMBER;
1361: l_b_bind_count NUMBER;
1362: l_tl_bind_count NUMBER;
1363: l_b_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1364: l_tl_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1365:
1366: l_pending_base_tbl VARCHAR2(100);
1367: l_pending_tl_tbl VARCHAR2(100);
1368: l_pending_vl VARCHAR2(100);

Line 1372: L_ATTRIBUTES_DATA_TABLE EGO_USER_ATTR_DATA_TABLE;

1368: l_pending_vl VARCHAR2(100);
1369: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;
1370: l_number_of_rows NUMBER :=0;
1371: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
1372: L_ATTRIBUTES_DATA_TABLE EGO_USER_ATTR_DATA_TABLE;
1373: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1374: l_extension_id NUMBER := NULL;
1375: l_temp_extension_id NUMBER := NULL;
1376: l_row_identifier NUMBER ;

Line 1779: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

1775: ( p_api_version IN NUMBER
1776: ,p_object_name IN VARCHAR2
1777: ,p_application_id IN NUMBER
1778: ,p_attr_group_type IN VARCHAR2
1779: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
1780: ,x_return_status OUT NOCOPY VARCHAR2
1781: ,x_errorcode OUT NOCOPY NUMBER
1782: ,x_msg_count OUT NOCOPY NUMBER
1783: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1802: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

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
1806: ,x_msg_count OUT NOCOPY NUMBER

Line 1803: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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
1806: ,x_msg_count OUT NOCOPY NUMBER
1807: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1812: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE ;

1808: )
1809: IS
1810:
1811: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE ;
1812: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE ;
1813: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1814: l_extension_id NUMBER := NULL;
1815: l_temp_extension_id NUMBER := NULL;
1816:

Line 1819: l_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();

1815: l_temp_extension_id NUMBER := NULL;
1816:
1817: BEGIN
1818:
1819: l_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
1820: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE() ;
1821:
1822: x_setup_attr_data := p_attr_name_value_pairs;
1823: /*if p_data_level_name_value_pairs is NOT NULL

Line 1966: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1962:
1963: PROCEDURE VALIDATE_GDSN_RECORDS(p_inventory_item_id IN NUMBER
1964: ,p_organization_id IN NUMBER
1965: ,p_attr_group_type IN VARCHAR2
1966: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1967: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
1968: ,x_return_status OUT NOCOPY VARCHAR2
1969: ,x_msg_count OUT NOCOPY NUMBER
1970: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1967: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

1963: PROCEDURE VALIDATE_GDSN_RECORDS(p_inventory_item_id IN NUMBER
1964: ,p_organization_id IN NUMBER
1965: ,p_attr_group_type IN VARCHAR2
1966: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1967: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
1968: ,x_return_status OUT NOCOPY VARCHAR2
1969: ,x_msg_count OUT NOCOPY NUMBER
1970: ,x_msg_data OUT NOCOPY VARCHAR2
1971:

Line 2504: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE

2500: EXECUTE IMMEDIATE L_ADDED_UPDATE_B_DML;
2501: EXECUTE IMMEDIATE L_ADDED_UPDATE_TL_DML;
2502: END UPDATE_DATA_LEVEL;
2503:
2504: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
2505: ,x_rec_column OUT NOCOPY VARCHAR2
2506: ,p_attr_name IN VARCHAR2)
2507: IS
2508: BEGIN

Line 2520: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE

2516:
2517:
2518: END getValue;
2519:
2520: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
2521: ,x_rec_column OUT NOCOPY NUMBER
2522: ,p_attr_name IN VARCHAR2)
2523: IS
2524: l_attr_name VARCHAR2(80);

Line 2547: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE

2543: END IF;
2544: END LOOP;
2545:
2546: END getValue;
2547: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
2548: ,x_rec_column OUT NOCOPY DATE
2549: ,p_attr_name IN VARCHAR2)
2550: IS
2551: BEGIN