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.BEN_PLAN_COPY_LOADER dependencies on PQH_COPY_ENTITY_ATTRIBS

Line 43: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;

39: select cer.*
40: from ben_copy_entity_results cer
41: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
42: --
43: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
44: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
45: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE; */
46:
47: begin

Line 44: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;

40: from ben_copy_entity_results cer
41: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
42: --
43: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
44: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
45: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE; */
46:
47: begin
48: --

Line 45: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE; */

41: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
42: --
43: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
44: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
45: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE; */
46:
47: begin
48: --
49: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 85: DELETE FROM PQH_COPY_ENTITY_ATTRIBS

81: --
82: DELETE FROM BEN_COPY_ENTITY_RESULTS
83: WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
84: --
85: DELETE FROM PQH_COPY_ENTITY_ATTRIBS
86: WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
87: --
88: DELETE FROM PQH_COPY_ENTITY_TXNS
89: WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;

Line 99: PQH_COPY_ENTITY_ATTRIBS_api.delete_COPY_ENTITY_ATTRIB

95: fetch c_copy_entity_attrib
96: into l_copy_entity_attrib_id,l_cea_object_version_number;
97: close c_copy_entity_attrib;
98: --
99: PQH_COPY_ENTITY_ATTRIBS_api.delete_COPY_ENTITY_ATTRIB
100: (p_validate => false
101: ,p_copy_entity_attrib_id => l_copy_entity_attrib_id
102: ,p_object_version_number => l_cea_object_version_number
103: ,p_effective_date => p_effective_date

Line 463: pqh_copy_entity_attribs cea

459: --
460: cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
461: select null
462: from pqh_copy_entity_txns cet,
463: pqh_copy_entity_attribs cea
464: where cet.display_name = p_display_name
465: and cet.context_business_group_id = v_context_business_group_id
466: and cet.transaction_category_id = v_transaction_category_id
467: -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date

Line 482: where table_name = 'PQH_COPY_ENTITY_ATTRIBS'

478: --Bug : 4354708
479: cursor c_trig_cea is
480: select null
481: from all_triggers
482: where table_name = 'PQH_COPY_ENTITY_ATTRIBS'
483: and trigger_name = 'PQH_COPY_ENTITY_ATTRIBS_WHO'
484: and table_owner = l_schema
485: and status = 'ENABLED';
486: --Bug : 4354708

Line 483: and trigger_name = 'PQH_COPY_ENTITY_ATTRIBS_WHO'

479: cursor c_trig_cea is
480: select null
481: from all_triggers
482: where table_name = 'PQH_COPY_ENTITY_ATTRIBS'
483: and trigger_name = 'PQH_COPY_ENTITY_ATTRIBS_WHO'
484: and table_owner = l_schema
485: and status = 'ENABLED';
486: --Bug : 4354708
487:

Line 496: l_target_typ_cd pqh_copy_entity_attribs.information3%type := 'BEN_PDIMPT';

492: l_copy_entity_attrib_id number(15);
493: l_business_group_id number ;
494: l_transaction_category_id number ;
495: --
496: l_target_typ_cd pqh_copy_entity_attribs.information3%type := 'BEN_PDIMPT';
497: begin
498: --
499: /* For seeded FHR copy process, set context_business_group_id to 0 */
500: if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN' then

Line 529: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_ATTRIBS

525: open c_trig_cea;
526: fetch c_trig_cea into l_dummy;
527: if c_trig_cea%notfound then
528: --
529: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_ATTRIBS
530: -- Set WHO columns
531: l_last_update_date := sysdate;
532: l_last_updated_by := fnd_global.user_id;
533: l_last_update_login := fnd_global.login_id;

Line 570: select pqh_copy_entity_attribs_s.nextval into l_copy_entity_attrib_id

566: close c3;
567: else
568: l_copy_entity_txn_id := g_perf_copy_entity_txn_id;
569: end if;
570: select pqh_copy_entity_attribs_s.nextval into l_copy_entity_attrib_id
571: from dual ;
572: --
573: -- Insert the row into: pqh_copy_entity_attribs
574: --

Line 573: -- Insert the row into: pqh_copy_entity_attribs

569: end if;
570: select pqh_copy_entity_attribs_s.nextval into l_copy_entity_attrib_id
571: from dual ;
572: --
573: -- Insert the row into: pqh_copy_entity_attribs
574: --
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: insert into pqh_copy_entity_attribs
577: ( copy_entity_attrib_id,

Line 576: insert into pqh_copy_entity_attribs

572: --
573: -- Insert the row into: pqh_copy_entity_attribs
574: --
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: insert into pqh_copy_entity_attribs
577: ( copy_entity_attrib_id,
578: copy_entity_txn_id,
579: row_type_cd,
580: information_category,