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_GENERIC dependencies on PQH_COPY_ENTITY_FUNCTIONS

Line 49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;

45: l_master_table_route_id pqh_table_route.table_route_id%TYPE;
46: l_effective_date varchar2(30); -- would hold date in char format
47: l_function_context pqh_copy_entity_contexts.context%TYPE;
48: l_context pqh_copy_entity_txns.context%TYPE;
49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;
50: l_pre_copy_function_name pqh_copy_entity_functions.pre_copy_function_name%TYPE;
51: l_copy_function_name pqh_copy_entity_functions.copy_function_name%TYPE;
52: l_post_copy_function_name pqh_copy_entity_functions.post_copy_function_name%TYPE;
53: l_dt_mode varchar2(50):=null;

Line 50: l_pre_copy_function_name pqh_copy_entity_functions.pre_copy_function_name%TYPE;

46: l_effective_date varchar2(30); -- would hold date in char format
47: l_function_context pqh_copy_entity_contexts.context%TYPE;
48: l_context pqh_copy_entity_txns.context%TYPE;
49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;
50: l_pre_copy_function_name pqh_copy_entity_functions.pre_copy_function_name%TYPE;
51: l_copy_function_name pqh_copy_entity_functions.copy_function_name%TYPE;
52: l_post_copy_function_name pqh_copy_entity_functions.post_copy_function_name%TYPE;
53: l_dt_mode varchar2(50):=null;
54: --

Line 51: l_copy_function_name pqh_copy_entity_functions.copy_function_name%TYPE;

47: l_function_context pqh_copy_entity_contexts.context%TYPE;
48: l_context pqh_copy_entity_txns.context%TYPE;
49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;
50: l_pre_copy_function_name pqh_copy_entity_functions.pre_copy_function_name%TYPE;
51: l_copy_function_name pqh_copy_entity_functions.copy_function_name%TYPE;
52: l_post_copy_function_name pqh_copy_entity_functions.post_copy_function_name%TYPE;
53: l_dt_mode varchar2(50):=null;
54: --
55: -- cursor for master table id

Line 52: l_post_copy_function_name pqh_copy_entity_functions.post_copy_function_name%TYPE;

48: l_context pqh_copy_entity_txns.context%TYPE;
49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;
50: l_pre_copy_function_name pqh_copy_entity_functions.pre_copy_function_name%TYPE;
51: l_copy_function_name pqh_copy_entity_functions.copy_function_name%TYPE;
52: l_post_copy_function_name pqh_copy_entity_functions.post_copy_function_name%TYPE;
53: l_dt_mode varchar2(50):=null;
54: --
55: -- cursor for master table id
56: --

Line 215: from pqh_copy_entity_contexts cec, pqh_copy_entity_functions cef

211: --
212: cursor c_all is
213: select cec.context, cec.application_short_name, cec.legislation_code, cec.responsibility_key,
214: cef.function_type_cd, cef.pre_copy_function_name, cef.copy_function_name, cef.post_copy_function_name
215: from pqh_copy_entity_contexts cec, pqh_copy_entity_functions cef
216: where cec.context = cef.context
217: and cef.table_route_id = p_table_route_id
218: and cec.transaction_short_name = p_transaction_short_name;
219: begin