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.PQH_TCT_WIZARD_PKG dependencies on PQH_WIZARD_CANVASES

Line 2654: l_created_by pqh_wizard_canvases.created_by%TYPE;

2650:
2651: --
2652: l_language varchar2(30) ;
2653: --
2654: l_created_by pqh_wizard_canvases.created_by%TYPE;
2655: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2656: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2657: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2658: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;

Line 2655: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;

2651: --
2652: l_language varchar2(30) ;
2653: --
2654: l_created_by pqh_wizard_canvases.created_by%TYPE;
2655: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2656: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2657: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2658: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2659: --

Line 2656: l_creation_date pqh_wizard_canvases.creation_date%TYPE;

2652: l_language varchar2(30) ;
2653: --
2654: l_created_by pqh_wizard_canvases.created_by%TYPE;
2655: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2656: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2657: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2658: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2659: --
2660: --

Line 2657: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;

2653: --
2654: l_created_by pqh_wizard_canvases.created_by%TYPE;
2655: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2656: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2657: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2658: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2659: --
2660: --
2661:

Line 2658: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;

2654: l_created_by pqh_wizard_canvases.created_by%TYPE;
2655: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2656: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2657: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2658: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2659: --
2660: --
2661:
2662: l_rowid ROWID;

Line 2669: from pqh_wizard_canvases

2665: cursor c1 is select userenv('LANG') from dual ;
2666:
2667: cursor csr_wiz_canvas is
2668: select rowid
2669: from pqh_wizard_canvases
2670: where canvas_name = p_canvas_name
2671: and form_name = p_form_name;
2672:
2673: --and current_item = p_current_item;

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 ,

Line 2717: insert into pqh_wizard_canvases (

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 ,
2720: CURRENT_ITEM ,
2721: PREVIOUS_ITEM ,

Line 2760: update pqh_wizard_canvases

2756: l_last_update_login,
2757: l_created_by,
2758: l_creation_date );
2759: else
2760: update pqh_wizard_canvases
2761: set
2762: CANVAS_NAME = P_CANVAS_NAME ,
2763: CURRENT_ITEM = P_CURRENT_ITEM ,
2764: PREVIOUS_ITEM = P_PREVIOUS_ITEM ,