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_SAT_SHD dependencies on PQH_SPECIAL_ATTRIBUTES

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

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PQH_SPECIAL_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_SPECIAL_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_SPECIAL_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 66: from pqh_special_attributes

62: object_version_number,
63: ddf_column_name,
64: ddf_value_column_name,
65: context
66: from pqh_special_attributes
67: where special_attribute_id = p_special_attribute_id;
68: --
69: l_proc varchar2(72) := g_package||'api_updating';
70: l_fct_ret boolean;

Line 145: from pqh_special_attributes

141: object_version_number,
142: ddf_column_name,
143: ddf_value_column_name,
144: context
145: from pqh_special_attributes
146: where special_attribute_id = p_special_attribute_id
147: for update nowait;
148: --
149: l_proc varchar2(72) := g_package||'lck';

Line 188: hr_utility.set_message_token('TABLE_NAME', 'pqh_special_attributes');

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

Line 263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;

259: --
260: l_attribute_id pqh_attributes.attribute_id%TYPE ;
261: l_table_route_id pqh_attributes.master_table_route_id%TYPE;
262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;

Line 264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;

260: l_attribute_id pqh_attributes.attribute_id%TYPE ;
261: l_table_route_id pqh_attributes.master_table_route_id%TYPE;
262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;
268: l_creation_date pqh_special_attributes.creation_date%TYPE;

Line 266: l_created_by pqh_special_attributes.created_by%TYPE;

262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;
268: l_creation_date pqh_special_attributes.creation_date%TYPE;
269: l_last_update_date pqh_special_attributes.last_update_date%TYPE;
270: l_last_update_login pqh_special_attributes.last_update_login%TYPE;

Line 267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;

263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;
268: l_creation_date pqh_special_attributes.creation_date%TYPE;
269: l_last_update_date pqh_special_attributes.last_update_date%TYPE;
270: l_last_update_login pqh_special_attributes.last_update_login%TYPE;
271: --

Line 268: l_creation_date pqh_special_attributes.creation_date%TYPE;

264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;
268: l_creation_date pqh_special_attributes.creation_date%TYPE;
269: l_last_update_date pqh_special_attributes.last_update_date%TYPE;
270: l_last_update_login pqh_special_attributes.last_update_login%TYPE;
271: --
272: cursor c1 is select userenv('LANG') from dual ;

Line 269: l_last_update_date pqh_special_attributes.last_update_date%TYPE;

265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;
268: l_creation_date pqh_special_attributes.creation_date%TYPE;
269: l_last_update_date pqh_special_attributes.last_update_date%TYPE;
270: l_last_update_login pqh_special_attributes.last_update_login%TYPE;
271: --
272: cursor c1 is select userenv('LANG') from dual ;
273: --

Line 270: l_last_update_login pqh_special_attributes.last_update_login%TYPE;

266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;
268: l_creation_date pqh_special_attributes.creation_date%TYPE;
269: l_last_update_date pqh_special_attributes.last_update_date%TYPE;
270: l_last_update_login pqh_special_attributes.last_update_login%TYPE;
271: --
272: cursor c1 is select userenv('LANG') from dual ;
273: --
274: --

Line 306: from pqh_special_attributes

302: cursor csr_special_att_id(p_txn_category_attribute_id in number,
303: p_key_attribute_type in varchar2,
304: p_context in varchar2) is
305: select special_attribute_id
306: from pqh_special_attributes
307: where txn_category_attribute_id = p_txn_category_attribute_id
308: and key_attribute_type = p_key_attribute_type
309: and context = p_context;
310: --

Line 380: update pqh_special_attributes

376: Begin
377: --
378: if l_special_attribute_id <> 0 then
379: -- row exits so update
380: update pqh_special_attributes
381: set flex_code = p_flex_code,
382: ddf_column_name = p_ddf_column_name,
383: ddf_value_column_name = p_ddf_value_column_name,
384: key_attribute_type = p_key_attribute_type,

Line 395: select pqh_special_attributes_s.nextval into l_special_attribute_id from dual;

391: and nvl(last_updated_by, -1) in (l_last_updated_by,-1,0,1,120,121,122);
392:
393: else
394: -- insert
395: select pqh_special_attributes_s.nextval into l_special_attribute_id from dual;
396:
397: --
398: -- Added the following code as a part of Zero Downtime Patching Project.
399: -- Code Starts Here.

Line 402: p_entity_name=>'PQH_SPECIAL_ATTRIBUTES',

398: -- Added the following code as a part of Zero Downtime Patching Project.
399: -- Code Starts Here.
400: --
401: PER_RIC_PKG.chk_integrity (
402: p_entity_name=>'PQH_SPECIAL_ATTRIBUTES',
403: p_ref_entity_info=>
404: PER_RIC_PKG.ref_entity_tbl(
405: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
406: PER_RIC_PKG.col_info_rec('TXN_CATEGORY_ATTRIBUTE_ID',NULL,l_txn_category_attribute_id, NULL))),

Line 414: insert into pqh_special_attributes

410: --
411: -- Code Ends Here
412: --
413:
414: insert into pqh_special_attributes
415: ( special_attribute_id,
416: txn_category_attribute_id,
417: key_attribute_type,
418: attribute_type_cd,