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_RFT_SHD dependencies on PQH_REF_TEMPLATES

Line 21: If (p_constraint_name = 'PQH_REF_TEMPLATES_FK1') Then

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

Line 26: ElsIf (p_constraint_name = 'PQH_REF_TEMPLATES_PK') Then

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

Line 31: ElsIf (p_constraint_name = 'PQH_REF_TEMPLATES_FK2') Then

27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_REF_TEMPLATES_FK2') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;

Line 36: ElsIf (p_constraint_name = 'PQH_REF_TEMPLATES_UK') Then

32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_REF_TEMPLATES_UK') Then
37: hr_utility.set_message(8302, 'PQH_DUPLICATE_REF_TEMPLATE');
38: hr_utility.raise_error;
39: /**
40: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 74: from pqh_ref_templates

70: base_template_id,
71: parent_template_id,
72: reference_type_cd,
73: object_version_number
74: from pqh_ref_templates
75: where ref_template_id = p_ref_template_id;
76: --
77: l_proc varchar2(72) := g_package||'api_updating';
78: l_fct_ret boolean;

Line 148: from pqh_ref_templates

144: base_template_id,
145: parent_template_id,
146: reference_type_cd,
147: object_version_number
148: from pqh_ref_templates
149: where ref_template_id = p_ref_template_id
150: for update nowait;
151: --
152: l_proc varchar2(72) := g_package||'lck';

Line 191: hr_utility.set_message_token('TABLE_NAME', 'pqh_ref_templates');

187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
191: hr_utility.set_message_token('TABLE_NAME', 'pqh_ref_templates');
192: hr_utility.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------

Line 422: l_parent_template_id pqh_ref_templates.parent_template_id%type;

418: ,p_last_update_date in varchar2
419: ) is
420: l_dummy varchar2(10);
421: l_object_version_number number(15) := 1;
422: l_parent_template_id pqh_ref_templates.parent_template_id%type;
423: l_base_template_id pqh_ref_templates.base_template_id%type;
424: --
425: l_created_by pqh_templates.created_by%TYPE;
426: l_last_updated_by pqh_templates.last_updated_by%TYPE;

Line 423: l_base_template_id pqh_ref_templates.base_template_id%type;

419: ) is
420: l_dummy varchar2(10);
421: l_object_version_number number(15) := 1;
422: l_parent_template_id pqh_ref_templates.parent_template_id%type;
423: l_base_template_id pqh_ref_templates.base_template_id%type;
424: --
425: l_created_by pqh_templates.created_by%TYPE;
426: l_last_updated_by pqh_templates.last_updated_by%TYPE;
427: l_creation_date pqh_templates.creation_date%TYPE;

Line 439: from pqh_ref_templates

435: --
436: cursor c_ref_templates(p_parent_template_id varchar2,
437: p_base_template_id varchar2) is
438: select 'x'
439: from pqh_ref_templates
440: where parent_template_id = p_parent_template_id
441: and base_template_id = p_base_template_id;
442: --
443: --

Line 486: update PQH_REF_TEMPLATES

482: open c_ref_templates(l_parent_template_id, l_base_template_id);
483: fetch c_ref_templates into l_dummy;
484: if c_ref_templates%found then
485: close c_ref_templates;
486: update PQH_REF_TEMPLATES
487: set reference_type_cd = p_reference_type_cd,
488: last_update_date = l_last_update_date,
489: last_updated_by = l_last_updated_by,
490: last_update_login = l_last_update_login

Line 497: p_entity_name=>'PQH_REF_TEMPLATES',

493: else
494: close c_ref_templates;
495: --
496: PER_RIC_PKG.chk_integrity(
497: p_entity_name=>'PQH_REF_TEMPLATES',
498: p_ref_entity_info=>
499: PER_RIC_PKG.ref_entity_tbl(
500: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
501: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_PARENT_TEMPLATE_ID, NULL))),

Line 506: insert into pqh_ref_templates

502: PER_RIC_PKG.ref_info_rec('PQH_TEMPLATES',PER_RIC_PKG.column_info_tbl(
503: PER_RIC_PKG.col_info_rec('TEMPLATE_ID',NULL,L_BASE_TEMPLATE_ID, NULL)))),
504: p_ref_type=>'INS');
505:
506: insert into pqh_ref_templates
507: (REF_TEMPLATE_ID, BASE_TEMPLATE_ID, PARENT_TEMPLATE_ID,
508: OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY,
509: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE,
510: REFERENCE_TYPE_CD )

Line 512: (PQH_REF_TEMPLATES_S.NEXTVAL, L_BASE_TEMPLATE_ID, L_PARENT_TEMPLATE_ID,

508: OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY,
509: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE,
510: REFERENCE_TYPE_CD )
511: values
512: (PQH_REF_TEMPLATES_S.NEXTVAL, L_BASE_TEMPLATE_ID, L_PARENT_TEMPLATE_ID,
513: L_OBJECT_VERSION_NUMBER, L_LAST_UPDATE_DATE, L_LAST_UPDATED_BY,
514: L_LAST_UPDATE_LOGIN, L_CREATED_BY, L_CREATION_DATE,
515: P_REFERENCE_TYPE_CD );
516: --