APPS.PQH_TCT_WIZARD_PKG dependencies on DUAL

Line 67: from dual;

63: Return VARCHAR2 is
64: --
65: Cursor csr_next_rule is
66: Select pqh_system_rule_s.nextval
67: from dual;
68: --
69: l_range_name pqh_attribute_ranges.range_name%type;
70: l_next_sequence number;
71: --

Line 2465: Select pqh_routing_categories_s.nextval into rct_id from dual;

2461: fetch csr_routing_category into rct_rec;
2462:
2463: exit when csr_routing_category%notfound;
2464:
2465: Select pqh_routing_categories_s.nextval into rct_id from dual;
2466:
2467: insert into pqh_routing_categories (
2468: routing_category_id,
2469: transaction_category_id,

Line 2496: Select pqh_attribute_ranges_s.nextval into rng_id from dual;

2492: --
2493: for rng_rec in csr_default_approver(p_routing_category_id => rct_rec.routing_category_id)
2494: loop
2495:
2496: Select pqh_attribute_ranges_s.nextval into rng_id from dual;
2497:
2498: --
2499: -- Added the following code as a part of Zero Downtime Patching Project.
2500: -- Code Starts Here.

Line 2665: cursor c1 is select userenv('LANG') from dual ;

2661:
2662: l_rowid ROWID;
2663: l_wizard_canvas_id NUMBER;
2664:
2665: cursor c1 is select userenv('LANG') from dual ;
2666:
2667: cursor csr_wiz_canvas is
2668: select rowid
2669: from pqh_wizard_canvases

Line 2715: select pqh_wizard_canvases_s.NEXTVAL into l_wizard_canvas_id from dual;

2711: FETCH csr_wiz_canvas INTO l_rowid;
2712: CLOSE csr_wiz_canvas;
2713:
2714: if ( l_rowid is null ) THEN
2715: select pqh_wizard_canvases_s.NEXTVAL into l_wizard_canvas_id from dual;
2716:
2717: insert into pqh_wizard_canvases (
2718: WIZARD_CANVAS_ID ,
2719: CANVAS_NAME ,