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

Line 546: rec_tab dbms_sql.desc_tab;

542: var_ps_node_key NUMBER;
543: var_parent_key NUMBER;
544: col_cnt INTEGER;
545: var_counter INTEGER;
546: rec_tab dbms_sql.desc_tab;
547: var_rec dbms_sql.desc_rec;
548: var_col_name VARCHAR2(255);
549: var_col_num NUMBER;
550: var_col_length NUMBER;

Line 547: var_rec dbms_sql.desc_rec;

543: var_parent_key NUMBER;
544: col_cnt INTEGER;
545: var_counter INTEGER;
546: rec_tab dbms_sql.desc_tab;
547: var_rec dbms_sql.desc_rec;
548: var_col_name VARCHAR2(255);
549: var_col_num NUMBER;
550: var_col_length NUMBER;
551: var_rule_id NUMBER;

Line 683: var_cursor := DBMS_SQL.OPEN_CURSOR;

679: var_sql:=var_view_name;
680: END IF;
681:
682: BEGIN
683: var_cursor := DBMS_SQL.OPEN_CURSOR;
684: DBMS_SQL.PARSE(var_cursor, 'SELECT * FROM '||var_sql||' ORDER BY name', dbms_sql.native);
685: var_exec := DBMS_SQL.EXECUTE(var_cursor);
686: DBMS_SQL.DESCRIBE_COLUMNS(var_cursor, col_cnt, rec_tab);
687: EXCEPTION

Line 684: DBMS_SQL.PARSE(var_cursor, 'SELECT * FROM '||var_sql||' ORDER BY name', dbms_sql.native);

680: END IF;
681:
682: BEGIN
683: var_cursor := DBMS_SQL.OPEN_CURSOR;
684: DBMS_SQL.PARSE(var_cursor, 'SELECT * FROM '||var_sql||' ORDER BY name', dbms_sql.native);
685: var_exec := DBMS_SQL.EXECUTE(var_cursor);
686: DBMS_SQL.DESCRIBE_COLUMNS(var_cursor, col_cnt, rec_tab);
687: EXCEPTION
688: WHEN OTHERS THEN

Line 685: var_exec := DBMS_SQL.EXECUTE(var_cursor);

681:
682: BEGIN
683: var_cursor := DBMS_SQL.OPEN_CURSOR;
684: DBMS_SQL.PARSE(var_cursor, 'SELECT * FROM '||var_sql||' ORDER BY name', dbms_sql.native);
685: var_exec := DBMS_SQL.EXECUTE(var_cursor);
686: DBMS_SQL.DESCRIBE_COLUMNS(var_cursor, col_cnt, rec_tab);
687: EXCEPTION
688: WHEN OTHERS THEN
689: rcode:=SQLERRM;

Line 686: DBMS_SQL.DESCRIBE_COLUMNS(var_cursor, col_cnt, rec_tab);

682: BEGIN
683: var_cursor := DBMS_SQL.OPEN_CURSOR;
684: DBMS_SQL.PARSE(var_cursor, 'SELECT * FROM '||var_sql||' ORDER BY name', dbms_sql.native);
685: var_exec := DBMS_SQL.EXECUTE(var_cursor);
686: DBMS_SQL.DESCRIBE_COLUMNS(var_cursor, col_cnt, rec_tab);
687: EXCEPTION
688: WHEN OTHERS THEN
689: rcode:=SQLERRM;
690: RAISE WRONG_SQL;

Line 702: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_property_ptr);

698: t_col(var_col_num).col_name:=var_col_name;
699: t_col(var_col_num).col_num:=var_col_num;
700:
701: IF var_col_name='property_id' THEN
702: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_property_ptr);
703: END IF;
704: IF var_col_name='name' THEN
705: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_name,var_col_length);
706: END IF;

Line 705: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_name,var_col_length);

701: IF var_col_name='property_id' THEN
702: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_property_ptr);
703: END IF;
704: IF var_col_name='name' THEN
705: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_name,var_col_length);
706: END IF;
707: IF var_col_name='item_type_id' THEN
708: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_type_ptr);
709: END IF;

Line 708: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_type_ptr);

704: IF var_col_name='name' THEN
705: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_name,var_col_length);
706: END IF;
707: IF var_col_name='item_type_id' THEN
708: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_type_ptr);
709: END IF;
710: IF var_col_name='item_id' THEN
711: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_id);
712: END IF;

Line 711: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_id);

707: IF var_col_name='item_type_id' THEN
708: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_type_ptr);
709: END IF;
710: IF var_col_name='item_id' THEN
711: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_id);
712: END IF;
713: IF var_col_name='desc_text' THEN
714: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_desc_text,var_col_length);
715: END IF;

Line 714: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_desc_text,var_col_length);

710: IF var_col_name='item_id' THEN
711: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_item_id);
712: END IF;
713: IF var_col_name='desc_text' THEN
714: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_desc_text,var_col_length);
715: END IF;
716: IF var_col_name='primary_uom_code' THEN
717: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_primary_uom_code,var_col_length);
718: END IF;

Line 717: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_primary_uom_code,var_col_length);

713: IF var_col_name='desc_text' THEN
714: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_desc_text,var_col_length);
715: END IF;
716: IF var_col_name='primary_uom_code' THEN
717: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_primary_uom_code,var_col_length);
718: END IF;
719: IF var_col_name='quoteable_flag' THEN
720: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_quoteable_flag,var_col_length);
721: END IF;

Line 720: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_quoteable_flag,var_col_length);

716: IF var_col_name='primary_uom_code' THEN
717: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_primary_uom_code,var_col_length);
718: END IF;
719: IF var_col_name='quoteable_flag' THEN
720: DBMS_SQL.DEFINE_COLUMN(var_cursor,var_col_num,var_quoteable_flag,var_col_length);
721: END IF;
722: var_col_num := rec_tab.next(var_col_num);
723: EXIT WHEN (var_col_num is null);
724: END LOOP;

Line 731: IF DBMS_SQL.FETCH_ROWS(var_cursor)=0 THEN

727: var_tree_seq := 0;
728:
729: LOOP
730: BEGIN
731: IF DBMS_SQL.FETCH_ROWS(var_cursor)=0 THEN
732: EXIT;
733: ELSE
734: IF t_col.Count>0 THEN
735: FOR i IN t_col.First..t_col.Last

Line 742: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_property_ptr);

738: var_col_name:=t_col(i).col_name;
739: var_col_num:=t_col(i).col_num;
740: rcode:=var_col_name;
741: IF var_col_name='property_id' THEN
742: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_property_ptr);
743: END IF;
744: IF var_col_name='name' THEN
745: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_name);
746: END IF;

Line 745: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_name);

741: IF var_col_name='property_id' THEN
742: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_property_ptr);
743: END IF;
744: IF var_col_name='name' THEN
745: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_name);
746: END IF;
747: IF var_col_name='item_type_id' THEN
748: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_type_ptr);
749: END IF;

Line 748: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_type_ptr);

744: IF var_col_name='name' THEN
745: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_name);
746: END IF;
747: IF var_col_name='item_type_id' THEN
748: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_type_ptr);
749: END IF;
750: IF var_col_name='item_id' THEN
751: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_id);
752: END IF;

Line 751: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_id);

747: IF var_col_name='item_type_id' THEN
748: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_type_ptr);
749: END IF;
750: IF var_col_name='item_id' THEN
751: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_id);
752: END IF;
753: IF var_col_name='desc_text' THEN
754: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_desc_text);
755: END IF;

Line 754: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_desc_text);

750: IF var_col_name='item_id' THEN
751: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_item_id);
752: END IF;
753: IF var_col_name='desc_text' THEN
754: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_desc_text);
755: END IF;
756: IF var_col_name='primary_uom_code' THEN
757: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_primary_uom_code);
758: END IF;

Line 757: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_primary_uom_code);

753: IF var_col_name='desc_text' THEN
754: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_desc_text);
755: END IF;
756: IF var_col_name='primary_uom_code' THEN
757: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_primary_uom_code);
758: END IF;
759: IF var_col_name='quoteable_flag' THEN
760: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_quoteable_flag);
761: END IF;

Line 760: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_quoteable_flag);

756: IF var_col_name='primary_uom_code' THEN
757: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_primary_uom_code);
758: END IF;
759: IF var_col_name='quoteable_flag' THEN
760: DBMS_SQL.COLUMN_VALUE(var_cursor,var_col_num,var_quoteable_flag);
761: END IF;
762: EXCEPTION
763: WHEN OTHERS THEN
764: RAISE WRONG_COLUMN_TYPE;

Line 967: DBMS_SQL.CLOSE_CURSOR(var_cursor);

963: WHEN SKIP_IT THEN
964: NULL;
965: END;
966: END LOOP;
967: DBMS_SQL.CLOSE_CURSOR(var_cursor);
968:
969: --
970: -- set descriptive fields --
971: --

Line 979: IF DBMS_SQL.IS_OPEN(var_cursor) THEN

975: --WHERE populator_id=p_populator_id;
976:
977: EXCEPTION
978: WHEN WRONG_COLUMN_TYPE THEN
979: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
980: DBMS_SQL.CLOSE_CURSOR(var_cursor);
981: END IF;
982: p_err:=mRUN_ID;
983: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);

Line 980: DBMS_SQL.CLOSE_CURSOR(var_cursor);

976:
977: EXCEPTION
978: WHEN WRONG_COLUMN_TYPE THEN
979: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
980: DBMS_SQL.CLOSE_CURSOR(var_cursor);
981: END IF;
982: p_err:=mRUN_ID;
983: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);
984: WHEN WRONG_SQL THEN

Line 985: IF DBMS_SQL.IS_OPEN(var_cursor) THEN

981: END IF;
982: p_err:=mRUN_ID;
983: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);
984: WHEN WRONG_SQL THEN
985: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
986: DBMS_SQL.CLOSE_CURSOR(var_cursor);
987: END IF;
988: p_err:=mRUN_ID;
989: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);

Line 986: DBMS_SQL.CLOSE_CURSOR(var_cursor);

982: p_err:=mRUN_ID;
983: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong type of column '||rcode);
984: WHEN WRONG_SQL THEN
985: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
986: DBMS_SQL.CLOSE_CURSOR(var_cursor);
987: END IF;
988: p_err:=mRUN_ID;
989: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);
990: WHEN OTHERS THEN

Line 991: IF DBMS_SQL.IS_OPEN(var_cursor) THEN

987: END IF;
988: p_err:=mRUN_ID;
989: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);
990: WHEN OTHERS THEN
991: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
992: DBMS_SQL.CLOSE_CURSOR(var_cursor);
993: END IF;
994: p_err:=mRUN_ID;
995: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);

Line 992: DBMS_SQL.CLOSE_CURSOR(var_cursor);

988: p_err:=mRUN_ID;
989: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" - wrong SQL query is used : '||rcode);
990: WHEN OTHERS THEN
991: IF DBMS_SQL.IS_OPEN(var_cursor) THEN
992: DBMS_SQL.CLOSE_CURSOR(var_cursor);
993: END IF;
994: p_err:=mRUN_ID;
995: LOG_REPORT('CZ_POPULATORS_PKG.Preview','Preview populator "'||var_pop_name||'" failed :'||SQLERRM);
996: END Preview_unsec;