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.EDW_ITEMS_M_C dependencies on DBMS_SQL

Line 1701: l_cursor:=dbms_sql.open_cursor;

1697: l_row_cnt NUMBER; /* Bug# 2504279 */
1698: BEGIN
1699: /* Bug# 2504279, tempoary workaround begin*/
1700:
1701: l_cursor:=dbms_sql.open_cursor;
1702:
1703: -- Bug# 3296641
1704: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then
1705: l_where_clause := ' WHERE category_set_name = :l_category_set_name';

Line 1713: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

1709: END IF;
1710:
1711: l_stmt := 'SELECT count(*) row_cnt FROM '||p_view_name||l_where_clause;
1712:
1713: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
1714: dbms_sql.bind_variable(l_cursor, ':l_category_set_name', p_category_set_name);
1715:
1716: -- Bug# 3296641
1717: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then

Line 1714: dbms_sql.bind_variable(l_cursor, ':l_category_set_name', p_category_set_name);

1710:
1711: l_stmt := 'SELECT count(*) row_cnt FROM '||p_view_name||l_where_clause;
1712:
1713: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
1714: dbms_sql.bind_variable(l_cursor, ':l_category_set_name', p_category_set_name);
1715:
1716: -- Bug# 3296641
1717: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then
1718: null;

Line 1720: dbms_sql.bind_variable(l_cursor, ':l_push_date_range1', p_from_date);

1716: -- Bug# 3296641
1717: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then
1718: null;
1719: ELSE
1720: dbms_sql.bind_variable(l_cursor, ':l_push_date_range1', p_from_date);
1721: dbms_sql.bind_variable(l_cursor, ':l_push_date_range2', p_to_date);
1722: END IF;
1723:
1724: dbms_sql.define_column(l_cursor, 1, l_row_cnt);

Line 1721: dbms_sql.bind_variable(l_cursor, ':l_push_date_range2', p_to_date);

1717: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then
1718: null;
1719: ELSE
1720: dbms_sql.bind_variable(l_cursor, ':l_push_date_range1', p_from_date);
1721: dbms_sql.bind_variable(l_cursor, ':l_push_date_range2', p_to_date);
1722: END IF;
1723:
1724: dbms_sql.define_column(l_cursor, 1, l_row_cnt);
1725:

Line 1724: dbms_sql.define_column(l_cursor, 1, l_row_cnt);

1720: dbms_sql.bind_variable(l_cursor, ':l_push_date_range1', p_from_date);
1721: dbms_sql.bind_variable(l_cursor, ':l_push_date_range2', p_to_date);
1722: END IF;
1723:
1724: dbms_sql.define_column(l_cursor, 1, l_row_cnt);
1725:
1726: l_rows_inserted:=dbms_sql.execute_and_fetch(l_cursor, true);
1727:
1728: dbms_sql.column_value(l_cursor, 1, l_row_cnt);

Line 1726: l_rows_inserted:=dbms_sql.execute_and_fetch(l_cursor, true);

1722: END IF;
1723:
1724: dbms_sql.define_column(l_cursor, 1, l_row_cnt);
1725:
1726: l_rows_inserted:=dbms_sql.execute_and_fetch(l_cursor, true);
1727:
1728: dbms_sql.column_value(l_cursor, 1, l_row_cnt);
1729:
1730: dbms_sql.close_cursor(l_cursor);

Line 1728: dbms_sql.column_value(l_cursor, 1, l_row_cnt);

1724: dbms_sql.define_column(l_cursor, 1, l_row_cnt);
1725:
1726: l_rows_inserted:=dbms_sql.execute_and_fetch(l_cursor, true);
1727:
1728: dbms_sql.column_value(l_cursor, 1, l_row_cnt);
1729:
1730: dbms_sql.close_cursor(l_cursor);
1731:
1732: IF l_row_cnt = 0 THEN

Line 1730: dbms_sql.close_cursor(l_cursor);

1726: l_rows_inserted:=dbms_sql.execute_and_fetch(l_cursor, true);
1727:
1728: dbms_sql.column_value(l_cursor, 1, l_row_cnt);
1729:
1730: dbms_sql.close_cursor(l_cursor);
1731:
1732: IF l_row_cnt = 0 THEN
1733: edw_log.put_line(' ');
1734: edw_log.put_line('No rows fetched for insert into '||p_staging_table_name);

Line 1746: l_cursor:=dbms_sql.OPEN_CURSOR;

1742:
1743: edw_log.debug_line(' ');
1744: edw_log.debug_line('Constructing the sql statement for ' || p_staging_table_name || ' and pushing category set ' || p_category_set_name);
1745:
1746: l_cursor:=dbms_sql.OPEN_CURSOR;
1747:
1748: edw_log.debug_line('Constructing PKs and FKs');
1749:
1750: IF (p_staging_table_name IN ( 'EDW_ITEM_CATSET1_C6_LSTG',

Line 1859: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

1855: edw_log.put_line(l_stmt);
1856:
1857: l_rows_inserted := SQL%ROWCOUNT ;
1858: edw_log.debug_line('Parse the cursor');
1859: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
1860:
1861: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
1862: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
1863:

Line 1862: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);

1858: edw_log.debug_line('Parse the cursor');
1859: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
1860:
1861: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
1862: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
1863:
1864: -- Bug# 3296641
1865: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then
1866: null;

Line 1868: dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);

1864: -- Bug# 3296641
1865: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then
1866: null;
1867: ELSE
1868: dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);
1869: dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
1870: END IF;
1871:
1872: edw_log.debug_line('Pushing data, Executing the cursor');

Line 1869: dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);

1865: IF SUBSTRB(p_view_name,1,15) = 'EDW_ITEM_CATSET' then
1866: null;
1867: ELSE
1868: dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);
1869: dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
1870: END IF;
1871:
1872: edw_log.debug_line('Pushing data, Executing the cursor');
1873: l_rows_inserted:=dbms_sql.execute(l_cursor);

Line 1873: l_rows_inserted:=dbms_sql.execute(l_cursor);

1869: dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
1870: END IF;
1871:
1872: edw_log.debug_line('Pushing data, Executing the cursor');
1873: l_rows_inserted:=dbms_sql.execute(l_cursor);
1874:
1875: edw_log.debug_line('Close the cursor');
1876: dbms_sql.close_cursor(l_cursor);
1877: edw_log.debug_line(' ');

Line 1876: dbms_sql.close_cursor(l_cursor);

1872: edw_log.debug_line('Pushing data, Executing the cursor');
1873: l_rows_inserted:=dbms_sql.execute(l_cursor);
1874:
1875: edw_log.debug_line('Close the cursor');
1876: dbms_sql.close_cursor(l_cursor);
1877: edw_log.debug_line(' ');
1878:
1879: edw_log.put_line('Inserted '||TO_CHAR(l_rows_inserted)||
1880: ' rows into the staging table');

Line 2058: l_cursor:=dbms_sql.OPEN_CURSOR;

2054:
2055: -- Loop until there are no lower levels in the VBH hierarchy
2056: WHILE l_lower_lvl_exists LOOP
2057:
2058: l_cursor:=dbms_sql.OPEN_CURSOR;
2059:
2060: --
2061: -- Build staging table name
2062: --

Line 2256: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

2252: -- edw_log.put_line(l_from_clause);
2253: -- edw_log.put_line(l_where_clause);
2254: l_rows_inserted := SQL%ROWCOUNT ;
2255: edw_log.debug_line('Parse the cursor');
2256: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
2257:
2258: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2259: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2260: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);

Line 2259: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);

2255: edw_log.debug_line('Parse the cursor');
2256: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
2257:
2258: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2259: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2260: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);
2261: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
2262: dbms_sql.bind_variable(l_cursor,':l_value_set_id',l_vbh_value_set_id);
2263:

Line 2260: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);

2256: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
2257:
2258: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2259: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2260: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);
2261: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
2262: dbms_sql.bind_variable(l_cursor,':l_value_set_id',l_vbh_value_set_id);
2263:
2264: IF l_catset_lvl = p_no_of_catset_lvls THEN

Line 2261: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);

2257:
2258: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2259: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2260: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);
2261: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
2262: dbms_sql.bind_variable(l_cursor,':l_value_set_id',l_vbh_value_set_id);
2263:
2264: IF l_catset_lvl = p_no_of_catset_lvls THEN
2265: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);

Line 2262: dbms_sql.bind_variable(l_cursor,':l_value_set_id',l_vbh_value_set_id);

2258: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2259: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2260: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range1',p_from_date);
2261: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
2262: dbms_sql.bind_variable(l_cursor,':l_value_set_id',l_vbh_value_set_id);
2263:
2264: IF l_catset_lvl = p_no_of_catset_lvls THEN
2265: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);
2266: END IF;

Line 2265: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);

2261: -- Bug# 3296641 dbms_sql.bind_variable(l_cursor,':l_push_date_range2',p_to_date);
2262: dbms_sql.bind_variable(l_cursor,':l_value_set_id',l_vbh_value_set_id);
2263:
2264: IF l_catset_lvl = p_no_of_catset_lvls THEN
2265: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);
2266: END IF;
2267:
2268: edw_log.debug_line('Pushing data, Executing the cursor');
2269: l_rows_inserted:=dbms_sql.execute(l_cursor);

Line 2269: l_rows_inserted:=dbms_sql.execute(l_cursor);

2265: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);
2266: END IF;
2267:
2268: edw_log.debug_line('Pushing data, Executing the cursor');
2269: l_rows_inserted:=dbms_sql.execute(l_cursor);
2270:
2271: edw_log.debug_line('Close the cursor');
2272: dbms_sql.close_CURSOR(l_cursor);
2273: edw_log.debug_line(' ');

Line 2272: dbms_sql.close_CURSOR(l_cursor);

2268: edw_log.debug_line('Pushing data, Executing the cursor');
2269: l_rows_inserted:=dbms_sql.execute(l_cursor);
2270:
2271: edw_log.debug_line('Close the cursor');
2272: dbms_sql.close_CURSOR(l_cursor);
2273: edw_log.debug_line(' ');
2274:
2275: edw_log.put_line('Inserted '||TO_CHAR(l_rows_inserted)||
2276: ' rows into the staging table');

Line 2384: l_cursor:=dbms_sql.OPEN_CURSOR;

2380: l_catset_lvl := p_no_of_catset_lvls;
2381:
2382: -- Loop until there are no lower levels in the VBH hierarchy
2383: WHILE l_lower_lvl_exists LOOP
2384: l_cursor:=dbms_sql.OPEN_CURSOR;
2385: --
2386: -- Build staging table name
2387: --
2388: l_staging_table_name := 'EDW_ITEM_CATSETI3_C' || l_catset_lvl || '_LSTG';

Line 2519: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);

2515: -- edw_log.put_line(l_from_clause);
2516: -- edw_log.put_line(l_where_clause);
2517: l_rows_inserted := SQL%ROWCOUNT ;
2518: edw_log.debug_line('Parse the cursor');
2519: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
2520:
2521: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2522: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2523: dbms_sql.bind_variable(l_cursor,':l_cat_set_id',p_category_set_id);

Line 2522: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);

2518: edw_log.debug_line('Parse the cursor');
2519: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
2520:
2521: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2522: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2523: dbms_sql.bind_variable(l_cursor,':l_cat_set_id',p_category_set_id);
2524:
2525: /* IF l_catset_lvl = p_no_of_catset_lvls THEN
2526: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);

Line 2523: dbms_sql.bind_variable(l_cursor,':l_cat_set_id',p_category_set_id);

2519: dbms_sql.parse(l_cursor,l_stmt,dbms_sql.native);
2520:
2521: edw_log.debug_line('Bind l_category_set_name variable, and last_update dates');
2522: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2523: dbms_sql.bind_variable(l_cursor,':l_cat_set_id',p_category_set_id);
2524:
2525: /* IF l_catset_lvl = p_no_of_catset_lvls THEN
2526: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);
2527: END IF;

Line 2526: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);

2522: dbms_sql.bind_variable(l_cursor,':l_category_set_name',p_category_set_name);
2523: dbms_sql.bind_variable(l_cursor,':l_cat_set_id',p_category_set_id);
2524:
2525: /* IF l_catset_lvl = p_no_of_catset_lvls THEN
2526: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);
2527: END IF;
2528: */
2529: edw_log.debug_line('Pushing data, Executing the cursor');
2530: l_rows_inserted:=dbms_sql.execute(l_cursor);

Line 2530: l_rows_inserted:=dbms_sql.execute(l_cursor);

2526: dbms_sql.bind_variable(l_cursor,':l_hrchy_top_node',p_hrchy_top_node);
2527: END IF;
2528: */
2529: edw_log.debug_line('Pushing data, Executing the cursor');
2530: l_rows_inserted:=dbms_sql.execute(l_cursor);
2531:
2532: edw_log.debug_line('Close the cursor');
2533: dbms_sql.close_CURSOR(l_cursor);
2534: edw_log.debug_line(' ');

Line 2533: dbms_sql.close_CURSOR(l_cursor);

2529: edw_log.debug_line('Pushing data, Executing the cursor');
2530: l_rows_inserted:=dbms_sql.execute(l_cursor);
2531:
2532: edw_log.debug_line('Close the cursor');
2533: dbms_sql.close_CURSOR(l_cursor);
2534: edw_log.debug_line(' ');
2535:
2536: edw_log.put_line('Inserted '||TO_CHAR(l_rows_inserted)||
2537: ' rows into the staging table');

Line 2662: l_cursor:=dbms_sql.OPEN_CURSOR;

2658: ELSE
2659: l_control_level := 1;
2660: END IF;
2661:
2662: l_cursor:=dbms_sql.OPEN_CURSOR;
2663:
2664: edw_log.put_line('Pushing Categories');
2665:
2666: IF p_item_item_org=1 THEN

Line 2899: l_cursor := dbms_sql.open_cursor;

2895: -- Bug 3424451
2896: -- Changing the static sql to dynamic sql to make the package
2897: -- backward compatible.
2898: l_rows_inserted := 0;
2899: l_cursor := dbms_sql.open_cursor;
2900:
2901: l_hierarchy_stmt := 'SELECT HIERARCHY_ENABLED, CATEGORY_SET_ID'||
2902: ' FROM MTL_CATEGORY_SETS ' ||
2903: ' WHERE CATEGORY_SET_NAME = :l_catset3_name';

Line 2907: dbms_sql.parse(l_cursor,l_hierarchy_stmt,dbms_sql.native);

2903: ' WHERE CATEGORY_SET_NAME = :l_catset3_name';
2904:
2905: edw_log.put_line('Constructing the SQL statement: ' || l_hierarchy_stmt);
2906:
2907: dbms_sql.parse(l_cursor,l_hierarchy_stmt,dbms_sql.native);
2908: dbms_sql.bind_variable(l_cursor,':l_catset3_name', l_item_catset3_name);
2909: dbms_sql.define_column(l_cursor, 1, l_hrchy_enabled, 1);
2910: dbms_sql.define_column(l_cursor, 2, l_catset3_id);
2911:

Line 2908: dbms_sql.bind_variable(l_cursor,':l_catset3_name', l_item_catset3_name);

2904:
2905: edw_log.put_line('Constructing the SQL statement: ' || l_hierarchy_stmt);
2906:
2907: dbms_sql.parse(l_cursor,l_hierarchy_stmt,dbms_sql.native);
2908: dbms_sql.bind_variable(l_cursor,':l_catset3_name', l_item_catset3_name);
2909: dbms_sql.define_column(l_cursor, 1, l_hrchy_enabled, 1);
2910: dbms_sql.define_column(l_cursor, 2, l_catset3_id);
2911:
2912: l_rows_inserted := dbms_sql.execute_and_fetch(l_cursor, true);

Line 2909: dbms_sql.define_column(l_cursor, 1, l_hrchy_enabled, 1);

2905: edw_log.put_line('Constructing the SQL statement: ' || l_hierarchy_stmt);
2906:
2907: dbms_sql.parse(l_cursor,l_hierarchy_stmt,dbms_sql.native);
2908: dbms_sql.bind_variable(l_cursor,':l_catset3_name', l_item_catset3_name);
2909: dbms_sql.define_column(l_cursor, 1, l_hrchy_enabled, 1);
2910: dbms_sql.define_column(l_cursor, 2, l_catset3_id);
2911:
2912: l_rows_inserted := dbms_sql.execute_and_fetch(l_cursor, true);
2913:

Line 2910: dbms_sql.define_column(l_cursor, 2, l_catset3_id);

2906:
2907: dbms_sql.parse(l_cursor,l_hierarchy_stmt,dbms_sql.native);
2908: dbms_sql.bind_variable(l_cursor,':l_catset3_name', l_item_catset3_name);
2909: dbms_sql.define_column(l_cursor, 1, l_hrchy_enabled, 1);
2910: dbms_sql.define_column(l_cursor, 2, l_catset3_id);
2911:
2912: l_rows_inserted := dbms_sql.execute_and_fetch(l_cursor, true);
2913:
2914: edw_log.put_line('rows inserted ' || l_rows_inserted);

Line 2912: l_rows_inserted := dbms_sql.execute_and_fetch(l_cursor, true);

2908: dbms_sql.bind_variable(l_cursor,':l_catset3_name', l_item_catset3_name);
2909: dbms_sql.define_column(l_cursor, 1, l_hrchy_enabled, 1);
2910: dbms_sql.define_column(l_cursor, 2, l_catset3_id);
2911:
2912: l_rows_inserted := dbms_sql.execute_and_fetch(l_cursor, true);
2913:
2914: edw_log.put_line('rows inserted ' || l_rows_inserted);
2915:
2916: if l_rows_inserted > 0 then

Line 2917: dbms_sql.column_value(l_cursor, 1, l_hrchy_enabled);

2913:
2914: edw_log.put_line('rows inserted ' || l_rows_inserted);
2915:
2916: if l_rows_inserted > 0 then
2917: dbms_sql.column_value(l_cursor, 1, l_hrchy_enabled);
2918: dbms_sql.column_value(l_cursor, 2, l_catset3_id);
2919: -- edw_log.put_line('l_hrchy_enabled ' || l_hrchy_enabled);
2920: end if;
2921:

Line 2918: dbms_sql.column_value(l_cursor, 2, l_catset3_id);

2914: edw_log.put_line('rows inserted ' || l_rows_inserted);
2915:
2916: if l_rows_inserted > 0 then
2917: dbms_sql.column_value(l_cursor, 1, l_hrchy_enabled);
2918: dbms_sql.column_value(l_cursor, 2, l_catset3_id);
2919: -- edw_log.put_line('l_hrchy_enabled ' || l_hrchy_enabled);
2920: end if;
2921:
2922: dbms_sql.close_cursor(l_cursor);

Line 2922: dbms_sql.close_cursor(l_cursor);

2918: dbms_sql.column_value(l_cursor, 2, l_catset3_id);
2919: -- edw_log.put_line('l_hrchy_enabled ' || l_hrchy_enabled);
2920: end if;
2921:
2922: dbms_sql.close_cursor(l_cursor);
2923:
2924: EXCEPTION
2925: WHEN NO_DATA_FOUND THEN
2926: -- edw_log.put_line('in exception ');