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 2633: l_created_by pqh_wizard_canvases.created_by%TYPE;

2629:
2630: --
2631: l_language varchar2(30) ;
2632: --
2633: l_created_by pqh_wizard_canvases.created_by%TYPE;
2634: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2635: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2636: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2637: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;

Line 2634: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;

2630: --
2631: l_language varchar2(30) ;
2632: --
2633: l_created_by pqh_wizard_canvases.created_by%TYPE;
2634: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2635: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2636: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2637: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2638: --

Line 2635: l_creation_date pqh_wizard_canvases.creation_date%TYPE;

2631: l_language varchar2(30) ;
2632: --
2633: l_created_by pqh_wizard_canvases.created_by%TYPE;
2634: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2635: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2636: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2637: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2638: --
2639: --

Line 2636: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;

2632: --
2633: l_created_by pqh_wizard_canvases.created_by%TYPE;
2634: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2635: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2636: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2637: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2638: --
2639: --
2640:

Line 2637: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;

2633: l_created_by pqh_wizard_canvases.created_by%TYPE;
2634: l_last_updated_by pqh_wizard_canvases.last_updated_by%TYPE;
2635: l_creation_date pqh_wizard_canvases.creation_date%TYPE;
2636: l_last_update_date pqh_wizard_canvases.last_update_date%TYPE;
2637: l_last_update_login pqh_wizard_canvases.last_update_login%TYPE;
2638: --
2639: --
2640:
2641: l_rowid ROWID;

Line 2648: from pqh_wizard_canvases

2644: cursor c1 is select userenv('LANG') from dual ;
2645:
2646: cursor csr_wiz_canvas is
2647: select rowid
2648: from pqh_wizard_canvases
2649: where canvas_name = p_canvas_name
2650: and form_name = p_form_name;
2651:
2652: --and current_item = p_current_item;

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

2690: FETCH csr_wiz_canvas INTO l_rowid;
2691: CLOSE csr_wiz_canvas;
2692:
2693: if ( l_rowid is null ) THEN
2694: select pqh_wizard_canvases_s.NEXTVAL into l_wizard_canvas_id from dual;
2695:
2696: insert into pqh_wizard_canvases (
2697: WIZARD_CANVAS_ID ,
2698: CANVAS_NAME ,

Line 2696: insert into pqh_wizard_canvases (

2692:
2693: if ( l_rowid is null ) THEN
2694: select pqh_wizard_canvases_s.NEXTVAL into l_wizard_canvas_id from dual;
2695:
2696: insert into pqh_wizard_canvases (
2697: WIZARD_CANVAS_ID ,
2698: CANVAS_NAME ,
2699: CURRENT_ITEM ,
2700: PREVIOUS_ITEM ,

Line 2739: update pqh_wizard_canvases

2735: l_last_update_login,
2736: l_created_by,
2737: l_creation_date );
2738: else
2739: update pqh_wizard_canvases
2740: set
2741: CANVAS_NAME = P_CANVAS_NAME ,
2742: CURRENT_ITEM = P_CURRENT_ITEM ,
2743: PREVIOUS_ITEM = P_PREVIOUS_ITEM ,