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_TAT_SHD dependencies on PQH_TEMPLATE_ATTRIBUTES

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

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PQH_TEMPLATE_ATTRIBUTES_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_TEMPLATE_ATTRIBUTES_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_TEMPLATE_ATTRIBUTES_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 32: ElsIf (p_constraint_name = 'PQH_TEMPLATE_ATTRIBUTES_PK') 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;
32: ElsIf (p_constraint_name = 'PQH_TEMPLATE_ATTRIBUTES_PK') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;

Line 37: ElsIf (p_constraint_name = 'PQH_TEMPLATE_ATTRIBUTES_UK') Then

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

Line 77: from pqh_template_attributes

73: template_attribute_id,
74: attribute_id,
75: template_id,
76: object_version_number
77: from pqh_template_attributes
78: where template_attribute_id = p_template_attribute_id;
79: --
80: l_proc varchar2(72) := g_package||'api_updating';
81: l_fct_ret boolean;

Line 153: from pqh_template_attributes

149: template_attribute_id,
150: attribute_id,
151: template_id,
152: object_version_number
153: from pqh_template_attributes
154: where template_attribute_id = p_template_attribute_id
155: for update nowait;
156: --
157: l_proc varchar2(72) := g_package||'lck';

Line 196: hr_utility.set_message_token('TABLE_NAME', 'pqh_template_attributes');

192: -- The object is locked therefore we need to supply a meaningful
193: -- error message.
194: --
195: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
196: hr_utility.set_message_token('TABLE_NAME', 'pqh_template_attributes');
197: hr_utility.raise_error;
198: End lck;
199: --
200: -- ----------------------------------------------------------------------------

Line 252: l_template_id pqh_template_attributes.template_id%type;

248: ,p_owner in varchar2
249: ,p_last_update_date in varchar2
250: ) is
251: l_object_version_number number(15);
252: l_template_id pqh_template_attributes.template_id%type;
253: l_tem_txn_category_id pqh_templates.transaction_category_id%type;
254: l_att_txn_category_id pqh_transaction_categories.transaction_category_id%type;
255: l_attribute_id pqh_template_attributes.attribute_id%type;
256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;

Line 255: l_attribute_id pqh_template_attributes.attribute_id%type;

251: l_object_version_number number(15);
252: l_template_id pqh_template_attributes.template_id%type;
253: l_tem_txn_category_id pqh_templates.transaction_category_id%type;
254: l_att_txn_category_id pqh_transaction_categories.transaction_category_id%type;
255: l_attribute_id pqh_template_attributes.attribute_id%type;
256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
257: --
258: l_created_by pqh_templates.created_by%TYPE;
259: l_last_updated_by pqh_templates.last_updated_by%TYPE;

Line 256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;

252: l_template_id pqh_template_attributes.template_id%type;
253: l_tem_txn_category_id pqh_templates.transaction_category_id%type;
254: l_att_txn_category_id pqh_transaction_categories.transaction_category_id%type;
255: l_attribute_id pqh_template_attributes.attribute_id%type;
256: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
257: --
258: l_created_by pqh_templates.created_by%TYPE;
259: l_last_updated_by pqh_templates.last_updated_by%TYPE;
260: l_creation_date pqh_templates.creation_date%TYPE;

Line 285: from pqh_template_attributes

281: and transaction_category_id = p_tem_txn_category_id;
282:
283: cursor c_template_attributes (p_template_id number, p_attribute_id number) is
284: select template_attribute_id
285: from pqh_template_attributes
286: where template_id = p_template_id
287: and attribute_id = p_attribute_id;
288: --
289: l_data_migrator_mode varchar2(1);

Line 338: update PQH_TEMPLATE_ATTRIBUTES

334: fetch c_template_attributes into l_att_txn_category_id;
335:
336: if c_template_attributes%found then
337: close c_template_attributes;
338: update PQH_TEMPLATE_ATTRIBUTES
339: set required_flag = p_required_flag,
340: view_flag = p_view_flag,
341: edit_flag = p_edit_flag,
342: last_update_date = l_last_update_date,

Line 351: insert into pqh_template_attributes

347: --AND NVL(last_updated_by,-1) in (1,-1);
348: else
349: close c_template_attributes;
350: --
351: insert into pqh_template_attributes
352: (required_flag, view_flag, edit_flag, template_attribute_id, attribute_id,
353: template_id, object_version_number, last_update_date, last_updated_by, last_update_login,
354: created_by, creation_date)
355: values

Line 356: (p_required_flag, p_view_flag, p_edit_flag, pqh_template_attributes_s.nextval, l_attribute_id,

352: (required_flag, view_flag, edit_flag, template_attribute_id, attribute_id,
353: template_id, object_version_number, last_update_date, last_updated_by, last_update_login,
354: created_by, creation_date)
355: values
356: (p_required_flag, p_view_flag, p_edit_flag, pqh_template_attributes_s.nextval, l_attribute_id,
357: l_template_id, 1, l_last_update_date, l_last_updated_by, l_last_update_login,
358: l_created_by, l_creation_date);
359: --
360: end if;