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

Line 22: If (p_constraint_name = 'PQH_COPY_ENTITY_FUNCTIONS_FK1') Then

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PQH_COPY_ENTITY_FUNCTIONS_FK1') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;

Line 27: ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_FUNCTIONS_FK2') Then

23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_FUNCTIONS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;

Line 64: from pqh_copy_entity_functions

60: copy_function_name,
61: post_copy_function_name,
62: object_version_number,
63: context
64: from pqh_copy_entity_functions
65: where copy_entity_function_id = p_copy_entity_function_id;
66: --
67: l_proc varchar2(72) := g_package||'api_updating';
68: l_fct_ret boolean;

Line 141: from pqh_copy_entity_functions

137: copy_function_name,
138: post_copy_function_name,
139: object_version_number,
140: context
141: from pqh_copy_entity_functions
142: where copy_entity_function_id = p_copy_entity_function_id
143: for update nowait;
144: --
145: l_proc varchar2(72) := g_package||'lck';

Line 184: hr_utility.set_message_token('TABLE_NAME', 'pqh_copy_entity_functions');

180: -- The object is locked therefore we need to supply a meaningful
181: -- error message.
182: --
183: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
184: hr_utility.set_message_token('TABLE_NAME', 'pqh_copy_entity_functions');
185: hr_utility.raise_error;
186: End lck;
187: --
188: -- ----------------------------------------------------------------------------

Line 249: l_table_route_id pqh_copy_entity_functions.table_route_id%TYPE;

245: l_effective_date date := sysdate ;
246: l_object_version_number number := 1;
247: l_language varchar2(30) ;
248: --
249: l_table_route_id pqh_copy_entity_functions.table_route_id%TYPE;
250: l_copy_entity_function_id pqh_copy_entity_functions.copy_entity_function_id%TYPE := 0;
251: --
252: --
253: l_created_by pqh_copy_entity_functions.created_by%TYPE;

Line 250: l_copy_entity_function_id pqh_copy_entity_functions.copy_entity_function_id%TYPE := 0;

246: l_object_version_number number := 1;
247: l_language varchar2(30) ;
248: --
249: l_table_route_id pqh_copy_entity_functions.table_route_id%TYPE;
250: l_copy_entity_function_id pqh_copy_entity_functions.copy_entity_function_id%TYPE := 0;
251: --
252: --
253: l_created_by pqh_copy_entity_functions.created_by%TYPE;
254: l_last_updated_by pqh_copy_entity_functions.last_updated_by%TYPE;

Line 253: l_created_by pqh_copy_entity_functions.created_by%TYPE;

249: l_table_route_id pqh_copy_entity_functions.table_route_id%TYPE;
250: l_copy_entity_function_id pqh_copy_entity_functions.copy_entity_function_id%TYPE := 0;
251: --
252: --
253: l_created_by pqh_copy_entity_functions.created_by%TYPE;
254: l_last_updated_by pqh_copy_entity_functions.last_updated_by%TYPE;
255: l_creation_date pqh_copy_entity_functions.creation_date%TYPE;
256: l_last_update_date pqh_copy_entity_functions.last_update_date%TYPE;
257: l_last_update_login pqh_copy_entity_functions.last_update_login%TYPE;

Line 254: l_last_updated_by pqh_copy_entity_functions.last_updated_by%TYPE;

250: l_copy_entity_function_id pqh_copy_entity_functions.copy_entity_function_id%TYPE := 0;
251: --
252: --
253: l_created_by pqh_copy_entity_functions.created_by%TYPE;
254: l_last_updated_by pqh_copy_entity_functions.last_updated_by%TYPE;
255: l_creation_date pqh_copy_entity_functions.creation_date%TYPE;
256: l_last_update_date pqh_copy_entity_functions.last_update_date%TYPE;
257: l_last_update_login pqh_copy_entity_functions.last_update_login%TYPE;
258: --

Line 255: l_creation_date pqh_copy_entity_functions.creation_date%TYPE;

251: --
252: --
253: l_created_by pqh_copy_entity_functions.created_by%TYPE;
254: l_last_updated_by pqh_copy_entity_functions.last_updated_by%TYPE;
255: l_creation_date pqh_copy_entity_functions.creation_date%TYPE;
256: l_last_update_date pqh_copy_entity_functions.last_update_date%TYPE;
257: l_last_update_login pqh_copy_entity_functions.last_update_login%TYPE;
258: --
259: cursor c1 is select userenv('LANG') from dual ;

Line 256: l_last_update_date pqh_copy_entity_functions.last_update_date%TYPE;

252: --
253: l_created_by pqh_copy_entity_functions.created_by%TYPE;
254: l_last_updated_by pqh_copy_entity_functions.last_updated_by%TYPE;
255: l_creation_date pqh_copy_entity_functions.creation_date%TYPE;
256: l_last_update_date pqh_copy_entity_functions.last_update_date%TYPE;
257: l_last_update_login pqh_copy_entity_functions.last_update_login%TYPE;
258: --
259: cursor c1 is select userenv('LANG') from dual ;
260: --

Line 257: l_last_update_login pqh_copy_entity_functions.last_update_login%TYPE;

253: l_created_by pqh_copy_entity_functions.created_by%TYPE;
254: l_last_updated_by pqh_copy_entity_functions.last_updated_by%TYPE;
255: l_creation_date pqh_copy_entity_functions.creation_date%TYPE;
256: l_last_update_date pqh_copy_entity_functions.last_update_date%TYPE;
257: l_last_update_login pqh_copy_entity_functions.last_update_login%TYPE;
258: --
259: cursor c1 is select userenv('LANG') from dual ;
260: --
261: --

Line 273: from pqh_copy_entity_functions

269: cursor csr_cef_id (p_table_route_id in number,
270: p_function_type_cd in varchar2,
271: p_context in varchar2) is
272: select copy_entity_function_id
273: from pqh_copy_entity_functions
274: where table_route_id = p_table_route_id
275: and function_type_cd = p_function_type_cd
276: and context = p_context;
277:

Line 329: update pqh_copy_entity_functions

325: --
326: --
327: if l_copy_entity_function_id <> 0 then
328: -- row exits so update
329: update pqh_copy_entity_functions
330: set pre_copy_function_name = p_pre_copy_function_name,
331: copy_function_name = p_copy_function_name,
332: post_copy_function_name = p_post_copy_function_name,
333: last_updated_by = l_last_updated_by,

Line 341: select pqh_copy_entity_functions_s.nextval into l_copy_entity_function_id from dual;

337: and nvl(last_updated_by , -1) in (l_last_updated_by,-1,1);
338: else
339: -- insert row
340:
341: select pqh_copy_entity_functions_s.nextval into l_copy_entity_function_id from dual;
342:
343: insert into pqh_copy_entity_functions
344: ( copy_entity_function_id,
345: table_route_id,

Line 343: insert into pqh_copy_entity_functions

339: -- insert row
340:
341: select pqh_copy_entity_functions_s.nextval into l_copy_entity_function_id from dual;
342:
343: insert into pqh_copy_entity_functions
344: ( copy_entity_function_id,
345: table_route_id,
346: function_type_cd,
347: pre_copy_function_name,