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_TXNS

Line 26: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;

22: --
23: -- Declare cursors and local variables
24: --
25: l_proc varchar2(72) := 'delete_PLAN_DESIGN_TXN';
26: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
27: --
28: cursor c_copy_entity_txn is
29: select object_version_number
30: from pqh_copy_entity_txns

Line 30: from pqh_copy_entity_txns

26: l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
27: --
28: cursor c_copy_entity_txn is
29: select object_version_number
30: from pqh_copy_entity_txns
31: where copy_entity_txn_id = p_copy_entity_txn_id;
32: --
33: /* cursor c_copy_entity_attrib is
34: select copy_entity_attrib_id,cea_object_version_number

Line 88: DELETE FROM PQH_COPY_ENTITY_TXNS

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;
90: --
91: END IF;
92:

Line 111: PQH_COPY_ENTITY_TXNS_api.delete_COPY_ENTITY_TXN

107: delete from pqh_process_log
108: where txn_id = p_copy_entity_txn_id
109: and module_cd = 'PDC_CP';
110:
111: PQH_COPY_ENTITY_TXNS_api.delete_COPY_ENTITY_TXN
112: (p_validate => false
113: ,p_copy_entity_txn_id => p_copy_entity_txn_id
114: ,p_object_version_number => l_object_version_number
115: ,p_effective_date => p_effective_date

Line 184: from pqh_copy_entity_txns cet

180: -- Bug : 4354708
181:
182: cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
183: select copy_entity_txn_id ,object_version_number
184: from pqh_copy_entity_txns cet
185: where cet.display_name = p_display_name
186: and cet.context_business_group_id = v_context_business_group_id
187: and cet.transaction_category_id = v_transaction_category_id ;
188: -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date ;

Line 204: where table_name = 'PQH_COPY_ENTITY_TXNS'

200: -- Bug : 4354708
201: cursor c_trig_cet is
202: select null
203: from all_triggers
204: where table_name = 'PQH_COPY_ENTITY_TXNS'
205: and trigger_name = 'PQH_COPY_ENTITY_TXNS_WHO'
206: and table_owner = l_schema
207: and status = 'ENABLED';
208: --Bug : 4354708

Line 205: and trigger_name = 'PQH_COPY_ENTITY_TXNS_WHO'

201: cursor c_trig_cet is
202: select null
203: from all_triggers
204: where table_name = 'PQH_COPY_ENTITY_TXNS'
205: and trigger_name = 'PQH_COPY_ENTITY_TXNS_WHO'
206: and table_owner = l_schema
207: and status = 'ENABLED';
208: --Bug : 4354708
209:

Line 218: l_start_with pqh_copy_entity_txns.start_with%type := 'BEN_PDC_TRGT_DTL_PAGE';

214: l_transaction_category_id number(15);
215: l_table_route_id number(15);
216: l_business_group_id number(15);
217: --
218: l_start_with pqh_copy_entity_txns.start_with%type := 'BEN_PDC_TRGT_DTL_PAGE';
219: l_status pqh_copy_entity_txns.status%type := 'IMPORTED';
220: l_old_copy_entity_txn_id number ;
221: l_ovn number ;
222: l_datestamp varchar2(30) := to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;

Line 219: l_status pqh_copy_entity_txns.status%type := 'IMPORTED';

215: l_table_route_id number(15);
216: l_business_group_id number(15);
217: --
218: l_start_with pqh_copy_entity_txns.start_with%type := 'BEN_PDC_TRGT_DTL_PAGE';
219: l_status pqh_copy_entity_txns.status%type := 'IMPORTED';
220: l_old_copy_entity_txn_id number ;
221: l_ovn number ;
222: l_datestamp varchar2(30) := to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;
223: --

Line 259: update pqh_copy_entity_txns

255: if c1%found then
256: -- close c1 ;
257: -- Now Update the displayName of the old transaction with timestamp appended.
258: --
259: update pqh_copy_entity_txns
260: set display_name = display_name||l_datestamp
261: where copy_entity_txn_id = l_old_copy_entity_txn_id ;
262: --
263: -- Raise exception through error

Line 277: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_TXNS

273: open c_trig_cet;
274: fetch c_trig_cet into l_dummy;
275: if c_trig_cet%notfound then
276: --
277: -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_TXNS
278: -- Set WHO columns
279: l_last_update_date := sysdate;
280: l_last_updated_by := fnd_global.user_id;
281: l_last_update_login := fnd_global.login_id;

Line 322: select pqh_copy_entity_txns_s.nextval into l_copy_entity_txn_id

318: fetch c3 into l_business_group_id ;
319: close c3;
320: */
321: --
322: select pqh_copy_entity_txns_s.nextval into l_copy_entity_txn_id
323: from dual ;
324: hr_utility.set_location(' Step 50 ',50);
325: --
326: -- Insert the row into: pqh_copy_entity_txns

Line 326: -- Insert the row into: pqh_copy_entity_txns

322: select pqh_copy_entity_txns_s.nextval into l_copy_entity_txn_id
323: from dual ;
324: hr_utility.set_location(' Step 50 ',50);
325: --
326: -- Insert the row into: pqh_copy_entity_txns
327: --
328: insert into pqh_copy_entity_txns
329: ( copy_entity_txn_id,
330: transaction_category_id,

Line 328: insert into pqh_copy_entity_txns

324: hr_utility.set_location(' Step 50 ',50);
325: --
326: -- Insert the row into: pqh_copy_entity_txns
327: --
328: insert into pqh_copy_entity_txns
329: ( copy_entity_txn_id,
330: transaction_category_id,
331: txn_category_attribute_id,
332: context_business_group_id,

Line 462: from pqh_copy_entity_txns cet,

458: where tc.short_name = p_TRANS_CATEGORY_NAME ;
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

Line 472: from pqh_copy_entity_txns cet

468: and cet.copy_entity_txn_id = cea.copy_entity_txn_id ;
469: --
470: cursor c3(v_context_business_group_id number, v_transaction_category_id number) is
471: select copy_entity_txn_id
472: from pqh_copy_entity_txns cet
473: where cet.display_name = p_display_name
474: and cet.context_business_group_id = v_context_business_group_id
475: and cet.transaction_category_id = v_transaction_category_id ;
476: -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date ;

Line 905: from pqh_copy_entity_txns cet,

901: where tc.short_name = p_TRANS_CATEGORY_NAME ;
902: --
903: cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
904: select null
905: from pqh_copy_entity_txns cet,
906: pqh_copy_entity_results cer
907: where cet.display_name = p_display_name
908: and cet.context_business_group_id = v_context_business_group_id
909: and cet.transaction_category_id = v_transaction_category_id

Line 919: from pqh_copy_entity_txns cet

915: cer.mirror_src_entity_result_id = to_number(p_mirror_src_entity_result_id)) ;
916: --
917: cursor c3(v_context_business_group_id number, v_transaction_category_id number) is
918: select copy_entity_txn_id
919: from pqh_copy_entity_txns cet
920: where cet.display_name = p_display_name
921: and cet.context_business_group_id = v_context_business_group_id
922: and cet.transaction_category_id = v_transaction_category_id ;
923: -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date ;

Line 1868: from pqh_copy_entity_txns cet

1864: where tc.short_name = g_TRANS_CATEGORY_NAME ;
1865: --
1866: cursor c3(v_context_business_group_id number, v_transaction_category_id number) is
1867: select copy_entity_txn_id
1868: from pqh_copy_entity_txns cet
1869: where cet.display_name = p_display_name
1870: and cet.context_business_group_id = v_context_business_group_id
1871: and cet.transaction_category_id = v_transaction_category_id;
1872: --