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_TCA_SHD dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

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

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

80: member_identifying_flag,
81: refresh_flag,
82: select_flag,
83: value_style_cd
84: from pqh_txn_category_attributes
85: where txn_category_attribute_id = p_txn_category_attribute_id;
86: --
87: l_proc varchar2(72) := g_package||'api_updating';
88: l_fct_ret boolean;

Line 166: from pqh_txn_category_attributes

162: member_identifying_flag,
163: refresh_flag,
164: select_flag,
165: value_style_cd
166: from pqh_txn_category_attributes
167: where txn_category_attribute_id = p_txn_category_attribute_id
168: for update nowait;
169: --
170: l_proc varchar2(72) := g_package||'lck';

Line 209: hr_utility.set_message_token('TABLE_NAME', 'pqh_txn_category_attributes');

205: -- The object is locked therefore we need to supply a meaningful
206: -- error message.
207: --
208: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
209: hr_utility.set_message_token('TABLE_NAME', 'pqh_txn_category_attributes');
210: hr_utility.raise_error;
211: End lck;
212: --
213: -- ----------------------------------------------------------------------------

Line 293: l_txn_category_attribute_id pqh_txn_category_attributes.txn_category_attribute_id%TYPE := 0 ;

289: l_object_version_number number := 1;
290: l_language varchar2(30) ;
291: l_delete_attr_ranges_flag varchar2(30) := 'N';
292: --
293: l_txn_category_attribute_id pqh_txn_category_attributes.txn_category_attribute_id%TYPE := 0 ;
294: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
295: l_transaction_category_id pqh_txn_category_attributes.transaction_category_id%TYPE := 0 ;
296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;

Line 295: l_transaction_category_id pqh_txn_category_attributes.transaction_category_id%TYPE := 0 ;

291: l_delete_attr_ranges_flag varchar2(30) := 'N';
292: --
293: l_txn_category_attribute_id pqh_txn_category_attributes.txn_category_attribute_id%TYPE := 0 ;
294: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
295: l_transaction_category_id pqh_txn_category_attributes.transaction_category_id%TYPE := 0 ;
296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
299: --

Line 296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;

292: --
293: l_txn_category_attribute_id pqh_txn_category_attributes.txn_category_attribute_id%TYPE := 0 ;
294: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
295: l_transaction_category_id pqh_txn_category_attributes.transaction_category_id%TYPE := 0 ;
296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
299: --
300: l_created_by pqh_attributes.created_by%TYPE;

Line 297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;

293: l_txn_category_attribute_id pqh_txn_category_attributes.txn_category_attribute_id%TYPE := 0 ;
294: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
295: l_transaction_category_id pqh_txn_category_attributes.transaction_category_id%TYPE := 0 ;
296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
299: --
300: l_created_by pqh_attributes.created_by%TYPE;
301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;

Line 333: from pqh_txn_category_attributes

329: and business_group_id is null;
330: --
331: cursor csr_txn_cat_att_id ( p_attribute_id IN NUMBER, p_txn_category_id IN NUMBER ) is
332: select txn_category_attribute_id
333: from pqh_txn_category_attributes
334: where attribute_id = p_attribute_id
335: and transaction_category_id = p_txn_category_id;
336: --
337: cursor csr_value_set_id (p_value_set_name IN VARCHAR2) is

Line 420: UPDATE pqh_txn_category_attributes

416: l_last_update_login := 0;
417: --
418: if l_txn_category_attribute_id <> 0 then
419: -- row exits so update
420: UPDATE pqh_txn_category_attributes
421: SET value_set_id = l_flex_value_set_id,
422: transaction_table_route_id = l_transaction_table_route_id,
423: form_column_name = p_form_column_name,
424: identifier_flag = p_identifier_flag,

Line 443: UPDATE pqh_txn_category_attributes

439: -- Check if the local txn categories have to be updated.
440: --
441: If p_copy_to_bg_attr = 'Y' then
442: --
443: UPDATE pqh_txn_category_attributes
444: SET value_set_id = l_flex_value_set_id,
445: transaction_table_route_id = l_transaction_table_route_id,
446: form_column_name = p_form_column_name,
447: identifier_flag = p_identifier_flag,

Line 465: -- insert into pqh_txn_category_attributes table

461: End if; -- Propogate changes to bg specific txn category attributes
462:
463: else
464:
465: -- insert into pqh_txn_category_attributes table
466:
467: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
468:
469: INSERT INTO pqh_txn_category_attributes

Line 467: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;

463: else
464:
465: -- insert into pqh_txn_category_attributes table
466:
467: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
468:
469: INSERT INTO pqh_txn_category_attributes
470: (txn_category_attribute_id,
471: attribute_id,

Line 469: INSERT INTO pqh_txn_category_attributes

465: -- insert into pqh_txn_category_attributes table
466:
467: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
468:
469: INSERT INTO pqh_txn_category_attributes
470: (txn_category_attribute_id,
471: attribute_id,
472: transaction_category_id,
473: value_set_id,

Line 515: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;

511: For lcl_tca_rec in csr_local_txn_cat_id loop
512: --
513: l_transaction_category_id := lcl_tca_rec.transaction_category_id;
514:
515: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
516:
517: INSERT INTO pqh_txn_category_attributes
518: (txn_category_attribute_id,
519: attribute_id,

Line 517: INSERT INTO pqh_txn_category_attributes

513: l_transaction_category_id := lcl_tca_rec.transaction_category_id;
514:
515: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
516:
517: INSERT INTO pqh_txn_category_attributes
518: (txn_category_attribute_id,
519: attribute_id,
520: transaction_category_id,
521: value_set_id,