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_DESIGN_TXNS_API dependencies on PQH_COPY_ENTITY_ATTRIBS

Line 105: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;

101: --
102: -- Declare cursors and local variables
103: --
104: l_copy_entity_txn_id pqh_copy_entity_txns.copy_entity_txn_id%TYPE;
105: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
106: l_proc varchar2(72) := g_package||'create_PLAN_DESIGN_TXN';
107: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
108: l_cetobject_version_number pqh_copy_entity_txns.object_version_number%TYPE;
109:

Line 201: pqh_copy_entity_attribs_api.create_copy_entity_attrib

197: --
198: p_copy_entity_txn_id := l_copy_entity_txn_id;
199: p_cet_object_version_number := l_cetobject_version_number;
200: --
201: pqh_copy_entity_attribs_api.create_copy_entity_attrib
202: (
203: p_validate => false
204: ,p_copy_entity_attrib_id => l_copy_entity_attrib_id
205: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 365: from pqh_copy_entity_attribs

361: cursor chk_trgt_bgid(p_copy_entity_txn_id number,
362: p_target_business_group_id varchar2,
363: p_copy_entity_attrib_id number) is
364: select information5
365: from pqh_copy_entity_attribs
366: where copy_entity_attrib_id = p_copy_entity_attrib_id
367: -- and information5 <> p_target_business_group_id
368: and copy_entity_txn_id = p_copy_entity_txn_id ;
369: --

Line 501: pqh_copy_entity_attribs_api.update_copy_entity_attrib

497: --
498: close chk_trgt_bgid;
499: --
500:
501: pqh_copy_entity_attribs_api.update_copy_entity_attrib
502: (p_copy_entity_attrib_id => p_copy_entity_attrib_id
503: ,p_copy_entity_txn_id => p_copy_entity_txn_id
504: ,p_row_type_cd => p_row_type_cd
505: ,p_information_category => p_information_category

Line 641: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;

637: select cer.*
638: from ben_copy_entity_results cer
639: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
640: --
641: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
642: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
643: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
644:
645: begin

Line 642: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;

638: from ben_copy_entity_results cer
639: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
640: --
641: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
642: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
643: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
644:
645: begin
646: --

Line 643: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;

639: where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
640: --
641: l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
642: l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
643: l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
644:
645: begin
646: --
647: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 676: PQH_COPY_ENTITY_ATTRIBS_api.delete_COPY_ENTITY_ATTRIB

672: fetch c_copy_entity_attrib
673: into l_copy_entity_attrib_id,l_cea_object_version_number;
674: close c_copy_entity_attrib;
675: --
676: PQH_COPY_ENTITY_ATTRIBS_api.delete_COPY_ENTITY_ATTRIB
677: (p_validate => false
678: ,p_copy_entity_attrib_id => l_copy_entity_attrib_id
679: ,p_object_version_number => l_cea_object_version_number
680: ,p_effective_date => p_effective_date

Line 4852: from pqh_copy_entity_attribs cea

4848:
4849: --
4850: cursor c_cea is
4851: select copy_entity_attrib_id, object_version_number
4852: from pqh_copy_entity_attribs cea
4853: where copy_entity_txn_id = p_copy_entity_txn_id;
4854: --
4855:
4856: l_copy_entity_txn c_copy_entity_txn%rowtype;

Line 5089: -- Update Request Set Id into Information14 column of PQH_COPY_ENTITY_ATTRIBS table.

5085: --
5086: hr_utility.set_location('l_cea.copy_entity_attrib_id ' || l_cea.copy_entity_attrib_id, 10);
5087: hr_utility.set_location('l_cea.ovn' || l_cea.object_version_number, 10);
5088: --
5089: -- Update Request Set Id into Information14 column of PQH_COPY_ENTITY_ATTRIBS table.
5090: pqh_copy_entity_attribs_api.update_copy_entity_attrib
5091: (p_copy_entity_attrib_id => l_cea.copy_entity_attrib_id
5092: ,p_object_version_number => l_cea.object_version_number
5093: ,p_effective_date => trunc(l_copy_entity_txn.effective_date)

Line 5090: pqh_copy_entity_attribs_api.update_copy_entity_attrib

5086: hr_utility.set_location('l_cea.copy_entity_attrib_id ' || l_cea.copy_entity_attrib_id, 10);
5087: hr_utility.set_location('l_cea.ovn' || l_cea.object_version_number, 10);
5088: --
5089: -- Update Request Set Id into Information14 column of PQH_COPY_ENTITY_ATTRIBS table.
5090: pqh_copy_entity_attribs_api.update_copy_entity_attrib
5091: (p_copy_entity_attrib_id => l_cea.copy_entity_attrib_id
5092: ,p_object_version_number => l_cea.object_version_number
5093: ,p_effective_date => trunc(l_copy_entity_txn.effective_date)
5094: ,p_information14 => TO_CHAR(l_request_id)