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 1155: FROM ALL_TAB_COLUMNS

1151: -- Start Generated Code
1152: /* Generated using:
1153: SET LINESIZE 200
1154: 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; '
1155: FROM ALL_TAB_COLUMNS
1156: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1157: AND COLUMN_NAME NOT IN
1158: ( -- special cases (for merge)
1159: 'INVENTORY_ITEM_ID'

Line 1572: FROM ALL_TAB_COLUMNS

1568: -- Start Generated Code
1569: /* Generated using:
1570: SET LINESIZE 200
1571: 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; '
1572: FROM ALL_TAB_COLUMNS
1573: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1574: AND COLUMN_NAME NOT IN
1575: ( -- special cases (for merge)
1576: 'INVENTORY_ITEM_ID'

Line 1992: FROM ALL_TAB_COLUMNS

1988: -- Starting generated code
1989: /* generate using the following script:
1990: SET LINESIZE 200
1991: 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; '
1992: FROM ALL_TAB_COLUMNS
1993: WHERE TABLE_NAME = 'MTL_SYSTEM_ITEMS_INTERFACE'
1994: AND COLUMN_NAME NOT IN
1995: ( -- special cases (for merge)
1996: 'INVENTORY_ITEM_ID'

Line 2723: FROM ALL_TAB_COLUMNS

2719: -- Start Generated Code
2720: /* Generated using:
2721: SET LINESIZE 200
2722: 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; '
2723: FROM ALL_TAB_COLUMNS
2724: WHERE TABLE_NAME = 'MTL_ITEM_REVISIONS_INTERFACE'
2725: AND COLUMN_NAME NOT IN
2726: ( -- special cases (for merge)
2727: 'INVENTORY_ITEM_ID'