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 729: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE

725: ,p_attr_group_id IN NUMBER
726: ,p_attr_group_type IN VARCHAR2
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

Line 761: l_attr_data_table EGO_USER_ATTR_DATA_TABLE;

757: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
758: l_row_identifier NUMBER ;
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);

Line 770: l_bind_values EGO_USER_ATTR_DATA_TABLE;

766: l_retrieved_value_char VARCHAR2(4000);
767: l_retrieved_value_num NUMBER;
768: l_retrieved_value_date DATE;
769: l_bind_index NUMBER;
770: l_bind_values EGO_USER_ATTR_DATA_TABLE;
771: l_dynamic_sql VARCHAR2(20000);
772: l_column_count NUMBER;
773: l_uk_where_clause VARCHAR2(4000):= null;
774: l_cursor_id NUMBER;

Line 885: l_bind_values := EGO_USER_ATTR_DATA_TABLE();

881: if i = l_attr_meta_data.last
882:
883: THEN
884: l_bind_index := 1;
885: l_bind_values := EGO_USER_ATTR_DATA_TABLE();
886: IF L_CACHED_SQL_FOUND <> 'Y' THEN
887: IF l_dynamic_sql = 'SELECT ' THEN
888: l_dynamic_sql := l_dynamic_sql || ' PEND.EXTENSION_ID ';
889: ELSE

Line 1309: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

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

Line 1317: ,p_dml_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1313: ,p_pending_b_table_name IN VARCHAR2
1314: ,p_pending_tl_table_name IN VARCHAR2
1315: ,p_pending_vl_name IN VARCHAR2
1316: ,p_acd_type IN VARCHAR2
1317: ,p_dml_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1318: ,p_api_caller IN VARCHAR2
1319: ,p_key_attr_upd IN VARCHAR2
1320: ,x_return_status OUT NOCOPY VARCHAR2
1321: ,x_errorcode OUT NOCOPY NUMBER

Line 1333: l_b_bind_attr_table EGO_USER_ATTR_DATA_TABLE;

1329: l_bind_index NUMBER;
1330: l_bind_value NUMBER;
1331: l_b_bind_count NUMBER;
1332: l_tl_bind_count NUMBER;
1333: l_b_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1334: l_tl_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1335:
1336: l_pending_base_tbl VARCHAR2(100);
1337: l_pending_tl_tbl VARCHAR2(100);

Line 1334: l_tl_bind_attr_table EGO_USER_ATTR_DATA_TABLE;

1330: l_bind_value NUMBER;
1331: l_b_bind_count NUMBER;
1332: l_tl_bind_count NUMBER;
1333: l_b_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1334: l_tl_bind_attr_table EGO_USER_ATTR_DATA_TABLE;
1335:
1336: l_pending_base_tbl VARCHAR2(100);
1337: l_pending_tl_tbl VARCHAR2(100);
1338: l_pending_vl VARCHAR2(100);

Line 1342: L_ATTRIBUTES_DATA_TABLE EGO_USER_ATTR_DATA_TABLE;

1338: l_pending_vl VARCHAR2(100);
1339: l_cursor_id INTEGER := DBMS_SQL.OPEN_CURSOR;
1340: l_number_of_rows NUMBER :=0;
1341: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
1342: L_ATTRIBUTES_DATA_TABLE EGO_USER_ATTR_DATA_TABLE;
1343: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1344: l_extension_id NUMBER := NULL;
1345: l_temp_extension_id NUMBER := NULL;
1346: l_row_identifier NUMBER ;

Line 1748: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

1744: ( p_api_version IN NUMBER
1745: ,p_object_name IN VARCHAR2
1746: ,p_application_id IN NUMBER
1747: ,p_attr_group_type IN VARCHAR2
1748: ,p_pk_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
1749: ,x_return_status OUT NOCOPY VARCHAR2
1750: ,x_errorcode OUT NOCOPY NUMBER
1751: ,x_msg_count OUT NOCOPY NUMBER
1752: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1771: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL

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

Line 1772: ,x_setup_attr_data OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

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

Line 1781: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE ;

1777: )
1778: IS
1779:
1780: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE ;
1781: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE ;
1782: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1783: l_extension_id NUMBER := NULL;
1784: l_temp_extension_id NUMBER := NULL;
1785:

Line 1788: l_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();

1784: l_temp_extension_id NUMBER := NULL;
1785:
1786: BEGIN
1787:
1788: l_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
1789: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE() ;
1790:
1791: x_setup_attr_data := p_attr_name_value_pairs;
1792: /*if p_data_level_name_value_pairs is NOT NULL

Line 1935: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

1931:
1932: PROCEDURE VALIDATE_GDSN_RECORDS(p_inventory_item_id IN NUMBER
1933: ,p_organization_id IN NUMBER
1934: ,p_attr_group_type IN VARCHAR2
1935: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1936: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
1937: ,x_return_status OUT NOCOPY VARCHAR2
1938: ,x_msg_count OUT NOCOPY NUMBER
1939: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1936: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE

1932: PROCEDURE VALIDATE_GDSN_RECORDS(p_inventory_item_id IN NUMBER
1933: ,p_organization_id IN NUMBER
1934: ,p_attr_group_type IN VARCHAR2
1935: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
1936: ,p_tl_attr_names_values IN EGO_USER_ATTR_DATA_TABLE
1937: ,x_return_status OUT NOCOPY VARCHAR2
1938: ,x_msg_count OUT NOCOPY NUMBER
1939: ,x_msg_data OUT NOCOPY VARCHAR2
1940:

Line 2473: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE

2469: EXECUTE IMMEDIATE L_ADDED_UPDATE_B_DML;
2470: EXECUTE IMMEDIATE L_ADDED_UPDATE_TL_DML;
2471: END UPDATE_DATA_LEVEL;
2472:
2473: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
2474: ,x_rec_column OUT NOCOPY VARCHAR2
2475: ,p_attr_name IN VARCHAR2)
2476: IS
2477: BEGIN

Line 2489: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE

2485:
2486:
2487: END getValue;
2488:
2489: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
2490: ,x_rec_column OUT NOCOPY NUMBER
2491: ,p_attr_name IN VARCHAR2)
2492: IS
2493: l_attr_name VARCHAR2(80);

Line 2516: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE

2512: END IF;
2513: END LOOP;
2514:
2515: END getValue;
2516: PROCEDURE getValue(p_attrs_data_tbl IN EGO_USER_ATTR_DATA_TABLE
2517: ,x_rec_column OUT NOCOPY DATE
2518: ,p_attr_name IN VARCHAR2)
2519: IS
2520: BEGIN