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: --

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: --
470: -- Added the following code as a part of Zero Downtime Patching Project.
471: -- Code Starts Here.

Line 475: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',

471: -- Code Starts Here.
472: --
473:
474: PER_RIC_PKG.chk_integrity (
475: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
476: p_ref_entity_info=>
477: PER_RIC_PKG.ref_entity_tbl(
478: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
479: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),

Line 490: INSERT INTO pqh_txn_category_attributes

486: --
487: -- Code Ends Here
488: --
489:
490: INSERT INTO pqh_txn_category_attributes
491: (txn_category_attribute_id,
492: attribute_id,
493: transaction_category_id,
494: value_set_id,

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

532: For lcl_tca_rec in csr_local_txn_cat_id loop
533: --
534: l_transaction_category_id := lcl_tca_rec.transaction_category_id;
535:
536: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
537:
538: --
539: -- Added the following code as a part of Zero Downtime Patching Project.
540: -- Code Starts Here.

Line 543: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',

539: -- Added the following code as a part of Zero Downtime Patching Project.
540: -- Code Starts Here.
541: --
542: PER_RIC_PKG.chk_integrity (
543: p_entity_name=>'PQH_TXN_CATEGORY_ATTRIBUTES',
544: p_ref_entity_info=>
545: PER_RIC_PKG.ref_entity_tbl(
546: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
547: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_transaction_table_route_id, NULL))),

Line 557: INSERT INTO pqh_txn_category_attributes

553: --
554: -- Code Ends Here
555: --
556:
557: INSERT INTO pqh_txn_category_attributes
558: (txn_category_attribute_id,
559: attribute_id,
560: transaction_category_id,
561: value_set_id,