[Home] [Help]
72: DECODE(DATA_TYPE, 'VARCHAR2', 2, 'NUMBER', 1, 'DATE', 3) TYPE ,
73: (DECODE( NULLABLE, 'N', '* ')) || (SELECT Meaning FROM bsc_lookups WHERE lookup_type = 'BSC_PMA_WEBADI_HINTS' and lookup_code = DATA_TYPE) HINT,
74: DECODE( NULLABLE, 'N', 'Y', 'N') NOT_NULL_FLAG,
75: DATA_LENGTH
76: FROM ALL_TAB_COLUMNS
77: WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
78: order by COLUMN_ID;
79: val_type VARCHAR2(8);
80: val_obj_name VARCHAR2(100);
164: counter number;
165: CURSOR TAB_COL IS
166: SELECT COLUMN_NAME,
167: DECODE(DATA_TYPE, 'VARCHAR2', 2, 'NUMBER', 1, 'DATE', 3) TYPE
168: FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
169: order by COLUMN_ID;
170:
171: BEGIN
172: l_stmt:='INSERT INTO BNE_LAYOUTS_B ( APPLICATION_ID, LAYOUT_CODE, OBJECT_VERSION_NUMBER, STYLESHEET_APP_ID,
259: , x_retcode OUT NOCOPY VARCHAR2)
260: IS
261: CURSOR TAB_COL IS
262: SELECT COLUMN_NAME
263: FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
264: order by COLUMN_ID;
265: col_list VARCHAR2(5000);
266: query VARCHAR2(5000);
267: content_code VARCHAR2(100);
295: IS
296: l_stmt VARCHAR2(3000);
297: CURSOR TAB_COL IS
298: SELECT COLUMN_NAME
299: FROM ALL_TAB_COLUMNS WHERE OWNER=g_bsc_schema AND TABLE_NAME = TAB_NAME
300: order by COLUMN_ID;
301: seq NUMBER;
302: BEGIN
303: -- Creating Mapping to download data from the Interface Table to the Excel Sheet