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_TXNS

Line 104: l_copy_entity_txn_id pqh_copy_entity_txns.copy_entity_txn_id%TYPE;

100: ) is
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;

Line 107: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;

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:
110: --
111: cursor txn_cat_c is

Line 108: l_cetobject_version_number pqh_copy_entity_txns.object_version_number%TYPE;

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:
110: --
111: cursor txn_cat_c is
112: select transaction_category_id

Line 162: hr_utility.set_location('Before PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);

158: null ;
159: end ;
160: -- Need to create a row into pqh_transaction_category(tct) table
161: --
162: hr_utility.set_location('Before PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);
163:
164: --
165: open txn_cat_c;
166: fetch txn_cat_c into l_transaction_category_id;

Line 171: PQH_COPY_ENTITY_TXNS_API.create_COPY_ENTITY_TXN

167: close txn_cat_c;
168: --
169: hr_utility.set_location('l_transaction_category_id '||l_transaction_category_id, 60);
170: --
171: PQH_COPY_ENTITY_TXNS_API.create_COPY_ENTITY_TXN
172: (
173: p_validate => false
174: , p_copy_entity_txn_id => l_copy_entity_txn_id
175: ,p_transaction_category_id => l_transaction_category_id

Line 192: hr_utility.set_location('After PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);

188: ,p_object_version_number => l_cetobject_version_number
189: ,p_effective_date => trunc(p_effective_date)
190: );
191: --
192: hr_utility.set_location('After PQH_COPY_ENTITY_TXNS_APIS.create_COPY_ENTITY_TXN ', 60);
193:
194:
195: --
196: -- Set all output arguments

Line 357: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;

353: --
354: -- Declare cursors and local variables
355: --
356: l_proc varchar2(72) := g_package||'update_PLAN_DESIGN_TXN';
357: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
358: l_cet_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
359: l_cea_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
360: --
361: cursor chk_trgt_bgid(p_copy_entity_txn_id number,

Line 358: l_cet_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;

354: -- Declare cursors and local variables
355: --
356: l_proc varchar2(72) := g_package||'update_PLAN_DESIGN_TXN';
357: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
358: l_cet_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
359: l_cea_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
360: --
361: cursor chk_trgt_bgid(p_copy_entity_txn_id number,
362: p_target_business_group_id varchar2,

Line 359: l_cea_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;

355: --
356: l_proc varchar2(72) := g_package||'update_PLAN_DESIGN_TXN';
357: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
358: l_cet_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
359: l_cea_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
360: --
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

Line 436: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN

432: --
433: if p_upd_record_type in ('CET', 'CET_CEA')
434: then
435: --
436: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN
437: (
438: p_copy_entity_txn_id => p_copy_entity_txn_id
439: ,p_transaction_category_id => p_transaction_category_id
440: ,p_txn_category_attribute_id => p_txn_category_attribute_id

Line 629: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;

625: --
626: -- Declare cursors and local variables
627: --
628: l_proc varchar2(72) := g_package||'delete_PLAN_DESIGN_TXN';
629: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
630: --
631: cursor c_copy_entity_attrib is
632: select copy_entity_attrib_id,cea_object_version_number
633: from ben_copy_entity_txns_vw

Line 688: PQH_COPY_ENTITY_TXNS_api.delete_COPY_ENTITY_TXN

684: delete from pqh_process_log
685: where txn_id = p_copy_entity_txn_id
686: and module_cd = 'PDC_CP';
687:
688: PQH_COPY_ENTITY_TXNS_api.delete_COPY_ENTITY_TXN
689: (p_validate => false
690: ,p_copy_entity_txn_id => p_copy_entity_txn_id
691: ,p_object_version_number => l_object_version_number
692: ,p_effective_date => p_effective_date

Line 698: -- Update the records in PQH_COPY_ENTITY_TXNS table with status as 'Purged'

694: hr_utility.set_location(l_proc, 40);
695: --
696: else
697: --
698: -- Update the records in PQH_COPY_ENTITY_TXNS table with status as 'Purged'
699: --
700: PQH_COPY_ENTITY_TXNS_api.update_COPY_ENTITY_TXN
701: (p_validate => false
702: ,p_datetrack_mode => hr_api.g_correction

Line 700: PQH_COPY_ENTITY_TXNS_api.update_COPY_ENTITY_TXN

696: else
697: --
698: -- Update the records in PQH_COPY_ENTITY_TXNS table with status as 'Purged'
699: --
700: PQH_COPY_ENTITY_TXNS_api.update_COPY_ENTITY_TXN
701: (p_validate => false
702: ,p_datetrack_mode => hr_api.g_correction
703: ,p_copy_entity_txn_id => p_copy_entity_txn_id
704: ,p_start_with => null

Line 2236: pqh_copy_entity_txns cet

2232: --
2233: cursor is_maping_completed(p_entity_txn_id number,p_table_route_id number) is
2234: select cer.information175
2235: from ben_copy_entity_results cer,
2236: pqh_copy_entity_txns cet
2237: where cer.copy_entity_txn_id = p_entity_txn_id
2238: and cer.copy_entity_txn_id = cet.copy_entity_txn_id
2239: and cer.information176 is null
2240: and cer.information174 is not null

Line 4865: l_entity_param varchar2(50) := 'PQH_COPY_ENTITY_TXNS';

4861:
4862: l_request_id number := null;
4863: l_mode_param varchar2(50) := 'DOWNLOAD';
4864: l_loader_config_param varchar2(50) := '@ben:/patch/115/import/bencer.lct';
4865: l_entity_param varchar2(50) := 'PQH_COPY_ENTITY_TXNS';
4866: l_proc varchar2(72) := g_package||'submit_copy_request';
4867: l_display_name_param varchar2(50) := 'DISPLAY_NAME=';
4868: l_src_effective_date_param varchar2(50) := 'SRC_EFFECTIVE_DATE=';
4869: l_dummy varchar2(1);

Line 4878: l_start_with pqh_copy_entity_txns.start_with%type;

4874: -- REUSE
4875: l_reuse_object_flag varchar2(30) := null;
4876: l_second_request_id number ;
4877: --
4878: l_start_with pqh_copy_entity_txns.start_with%type;
4879: l_status varchar2(50) := null;
4880:
4881: --TCS PDW Integration ENH
4882: l_errbuff varchar2(2000);

Line 4986: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN

4982: l_compile_ff := true;
4983: end if;
4984: end if;
4985: --
4986: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN
4987: (p_copy_entity_txn_id => p_copy_entity_txn_id
4988: ,p_datetrack_mode => hr_api.g_correction
4989: ,p_status => l_status
4990: ,p_start_with => NULL /* To disable Continue Icon */

Line 5257: l_start_with pqh_copy_entity_txns.start_with%type;

5253: ,cet.sfl_step_name
5254: from ben_copy_entity_txns_vw cet
5255: where cet.copy_entity_txn_id = p_copy_entity_txn_id ;
5256: --
5257: l_start_with pqh_copy_entity_txns.start_with%type;
5258: begin
5259: --
5260: l_outcome :=
5261: fnd_concurrent.wait_for_request(

Line 5309: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN

5305: --
5306: --
5307: hr_utility.set_location('Before call to CET Update',100);
5308: --
5309: pqh_copy_entity_txns_api.update_COPY_ENTITY_TXN
5310: (
5311: p_copy_entity_txn_id => p_copy_entity_txn_id
5312: ,p_datetrack_mode => hr_api.g_correction
5313: ,p_status => l_txn_status

Line 5443: l_copy_entity_txn_id PQH_COPY_ENTITY_TXNS.copy_entity_txn_id%type;

5439: AND cet.src_effective_date <= p_effective_date
5440: AND cet.context_business_group_id = p_business_group_id;
5441:
5442: l_purge_processes get_purge_processes%rowtype;
5443: l_copy_entity_txn_id PQH_COPY_ENTITY_TXNS.copy_entity_txn_id%type;
5444: l_effective_date date;
5445: l_count number;
5446: l_retain_log varchar2(10);
5447: --