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

Line 5508: x_cursor_id := DBMS_SQL.OPEN_CURSOR;

5504:
5505: BEGIN
5506: proc_name := 'denormalize_item_dimension';
5507:
5508: x_cursor_id := DBMS_SQL.OPEN_CURSOR;
5509:
5510: x_sql_statement :=
5511: 'UPDATE ' || p_table_name || ' xtable ' ||
5512: ' SET ( ' ||

Line 5535: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );

5531: ' AND mckfv.category_id = mic.category_id ' ||
5532: ' ) ' ;
5533:
5534:
5535: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5536:
5537: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5538: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5539:

Line 5537: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );

5533:
5534:
5535: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5536:
5537: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5538: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5539:
5540: p_errnum := 0;
5541: p_errmesg := '';

Line 5538: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);

5534:
5535: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5536:
5537: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5538: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5539:
5540: p_errnum := 0;
5541: p_errmesg := '';
5542:

Line 5578: x_cursor_id := DBMS_SQL.OPEN_CURSOR;

5574: x_ignore INTEGER ;
5575: proc_name VARCHAR2 (40);
5576: BEGIN
5577: proc_name := 'denormalize_time_dimension';
5578: x_cursor_id := DBMS_SQL.OPEN_CURSOR;
5579:
5580: x_sql_statement :=
5581: 'UPDATE ' || p_table_name || ' xtable ' ||
5582: ' SET ( ' ||

Line 5616: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );

5612: ' AND mo.adjustment_period_flag = ''N'' ' ||
5613: ' ) ' ;
5614:
5615:
5616: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5617:
5618: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5619: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5620:

Line 5618: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );

5614:
5615:
5616: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5617:
5618: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5619: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5620:
5621: p_errnum := 0;
5622: p_errmesg := '';

Line 5619: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);

5615:
5616: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5617:
5618: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5619: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5620:
5621: p_errnum := 0;
5622: p_errmesg := '';
5623:

Line 5666: x_cursor_id := DBMS_SQL.OPEN_CURSOR;

5662: proc_name VARCHAR2 (40);
5663:
5664: BEGIN
5665: proc_name := 'denormalize_org_dimension';
5666: x_cursor_id := DBMS_SQL.OPEN_CURSOR;
5667:
5668:
5669:
5670: x_sql_statement :=

Line 5702: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );

5698: ' AND hou.default_legal_context_id = to_char(ood.legal_entity) ' ||
5699: ' ) ' ;
5700: -- hou.legal_entity_id changed to hou.default_legal_context_id as part of R12 uptake
5701:
5702: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5703:
5704: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5705: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5706:

Line 5704: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );

5700: -- hou.legal_entity_id changed to hou.default_legal_context_id as part of R12 uptake
5701:
5702: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5703:
5704: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5705: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5706:
5707: p_errnum := 0;
5708: p_errmesg := '';

Line 5705: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);

5701:
5702: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5703:
5704: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5705: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5706:
5707: p_errnum := 0;
5708: p_errmesg := '';
5709:

Line 5772: x_cursor_id := DBMS_SQL.OPEN_CURSOR;

5768: x_mapping := null ;
5769: end ;
5770:
5771:
5772: x_cursor_id := DBMS_SQL.OPEN_CURSOR;
5773:
5774: x_sql_statement :=
5775: 'UPDATE ' || p_table_name || ' xtable ' ||
5776: ' SET ( ' ||

Line 5813: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );

5809: ' AND bthv.child_territory_type = ''COUNTRY'' ' ||
5810: ' AND bthv.parent_territory_type = ''AREA'' ' ||
5811: ' ) ' ;
5812:
5813: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5814:
5815: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5816:
5817:

Line 5815: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );

5811: ' ) ' ;
5812:
5813: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement, DBMS_SQL.V7 );
5814:
5815: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5816:
5817:
5818: x_sql_statement1 :=
5819: 'UPDATE ' || p_table_name || ' xtable ' ||

Line 5833: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement1, DBMS_SQL.V7 );

5829: ' AND bthv.parent_territory_code = xtable.country_code ' ||
5830: ' ) ' ;
5831:
5832:
5833: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement1, DBMS_SQL.V7 );
5834:
5835: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5836: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5837:

Line 5835: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );

5831:
5832:
5833: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement1, DBMS_SQL.V7 );
5834:
5835: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5836: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5837:
5838: p_errnum := 0;
5839: p_errmesg := '';

Line 5836: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);

5832:
5833: DBMS_SQL.PARSE( x_cursor_id, x_sql_statement1, DBMS_SQL.V7 );
5834:
5835: x_ignore := DBMS_SQL.EXECUTE( x_cursor_id );
5836: DBMS_SQL.CLOSE_CURSOR (x_cursor_id);
5837:
5838: p_errnum := 0;
5839: p_errmesg := '';
5840: