APPS.EGO_IMPORT_PVT dependencies on ALL_TAB_COLUMNS

Line 19: TYPE COLUMN_NAMES IS TABLE OF ALL_TAB_COLUMNS.COLUMN_NAME%TYPE;

15: G_NEEDS_REQUEST_ID_STAMP CONSTANT NUMBER := -1;
16: G_NEED_TO_LOG_ERROR CONSTANT NUMBER := -3;
17:
18: SUBTYPE MSII_ROW IS MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
19: TYPE COLUMN_NAMES IS TABLE OF ALL_TAB_COLUMNS.COLUMN_NAME%TYPE;
20: SUBTYPE EIUAI_ROW IS EGO_ITM_USR_ATTR_INTRFC%ROWTYPE;
21: TYPE EIUAI_ROWS IS TABLE OF EIUAI_ROW INDEX BY BINARY_INTEGER;
22: SUBTYPE IAssocs_Row IS EGO_ITEM_ASSOCIATIONS_INTF%ROWTYPE;
23: TYPE IAssocs_Rows IS TABLE OF IAssocs_Row INDEX BY BINARY_INTEGER;

Line 1140: FROM ALL_TAB_COLUMNS

1136: -- Start Generated Code
1137: /* Generated using:
1138: SET LINESIZE 200
1139: SELECT 'if l_merged_rows( l_mrow_ix ).' ||column_name || ' is null then l_merged_rows( l_mrow_ix ).' || column_name || ' := l_old_rows( orow_ix ).' || column_name || '; end if; '
1140: FROM ALL_TAB_COLUMNS
1141: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1142: AND COLUMN_NAME NOT IN
1143: ( -- special cases (for merge)
1144: 'INVENTORY_ITEM_ID'

Line 1551: FROM ALL_TAB_COLUMNS

1547: -- Start Generated Code
1548: /* Generated using:
1549: SET LINESIZE 200
1550: SELECT 'if l_merged_rows( l_mrow_ix ).' ||column_name || ' is null then l_merged_rows( l_mrow_ix ).' || column_name || ' := l_old_rows( orow_ix ).' || column_name || '; end if; '
1551: FROM ALL_TAB_COLUMNS
1552: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1553: AND COLUMN_NAME NOT IN
1554: ( -- special cases (for merge)
1555: 'INVENTORY_ITEM_ID'

Line 1955: FROM ALL_TAB_COLUMNS

1951: -- Starting generated code
1952: /* generate using the following script:
1953: SET LINESIZE 200
1954: SELECT 'if l_merged_rows( l_mrow_ix ).' ||column_name || ' is null then l_merged_rows( l_mrow_ix ).' || column_name || ' := old_row.' || column_name || '; end if; '
1955: FROM ALL_TAB_COLUMNS
1956: WHERE TABLE_NAME = 'MTL_SYSTEM_ITEMS_INTERFACE'
1957: AND COLUMN_NAME NOT IN
1958: ( -- special cases (for merge)
1959: 'INVENTORY_ITEM_ID'

Line 2663: FROM ALL_TAB_COLUMNS

2659: -- Start Generated Code
2660: /* Generated using:
2661: SET LINESIZE 200
2662: SELECT 'if l_merged_rows( l_mrow_ix ).' ||column_name || ' is null then l_merged_rows( l_mrow_ix ).' || column_name || ' := l_old_rows( orow_ix ).' || column_name || '; end if; '
2663: FROM ALL_TAB_COLUMNS
2664: WHERE TABLE_NAME = 'MTL_ITEM_REVISIONS_INTERFACE'
2665: AND COLUMN_NAME NOT IN
2666: ( -- special cases (for merge)
2667: 'INVENTORY_ITEM_ID'