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_GEN_FORM dependencies on PQH_COPY_ENTITY_RESULTS

Line 248: l_ins := 'pqh_copy_entity_results_api.create_copy_entity_result '||

244: hr_utility.set_location(g_package||'create_source: inside c_txn',2);
245: --
246: -- l_ins would hold the string call to create source records on the results table
247: --
248: l_ins := 'pqh_copy_entity_results_api.create_copy_entity_result '||
249: '( '||
250: 'p_copy_entity_result_id => l_var '||
251: ',p_object_version_number => l_var '||
252: ',p_result_type_cd => ''SOURCE'' '||

Line 535: delete from pqh_copy_entity_results

531: l_count number;
532: l_row_count boolean := true;
533: begin
534: --
535: delete from pqh_copy_entity_results
536: where copy_entity_txn_id = p_copy_entity_txn_id;
537: --
538: create_source ( p_copy_entity_txn_id => p_copy_entity_txn_id
539: , p_delimiter => p_delimiter

Line 550: pqh_copy_entity_results_api.update_copy_entity_result

546: , p_count number
547: , p_object_version_number in out nocopy number ) is
548:
549: begin
550: pqh_copy_entity_results_api.update_copy_entity_result
551: ( p_validate => false
552: , p_copy_entity_result_id => p_copy_entity_result_id
553: , p_number_of_copies => p_count
554: , p_object_version_number => p_object_version_number

Line 852: from pqh_copy_entity_results

848: information178 ,
849: information179 ,
850: information180
851: , object_version_number
852: from pqh_copy_entity_results
853: where copy_entity_txn_id = p_copy_entity_txn_id
854: and number_of_copies <> 0
855: and result_type_cd = 'SOURCE'
856: for update of copy_entity_result_id;

Line 1318: delete from pqh_copy_entity_results

1314: begin
1315: --
1316: hr_utility.set_location(g_package||'create_target: Entering',1);
1317: --
1318: delete from pqh_copy_entity_results
1319: where result_type_cd = 'TARGET'
1320: and copy_entity_txn_id = p_copy_entity_txn_id;
1321: --
1322: for rec in c_txn loop

Line 1686: pqh_copy_entity_results_api.create_copy_entity_result

1682: -- , p_lf2 => p_lf2
1683: -- , p_ln1 => p_ln1
1684: -- , p_ln2 => p_ln2);
1685: --
1686: pqh_copy_entity_results_api.create_copy_entity_result
1687: (
1688: p_validate => FALSE
1689: ,p_copy_entity_result_id => l_copy_entity_result_id
1690: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1881: update pqh_copy_entity_results

1877: ,p_effective_date => trunc(sysdate)
1878: );
1879:
1880: end loop; -- 1..rec.number_of_copies
1881: update pqh_copy_entity_results
1882: set status = 'TGT_P'
1883: where copy_entity_result_id = rec.copy_entity_result_id;
1884: --
1885: if l_warn is not null and p_batch_status is null then

Line 2458: from pqh_copy_entity_results

2454: is
2455: l_ovn number := p_object_version_number;
2456: cursor c_tgt is
2457: select copy_entity_result_id, object_version_number
2458: from pqh_copy_entity_results
2459: where src_copy_entity_result_id = p_copy_entity_result_id ;
2460: begin
2461: for i in c_tgt loop
2462: pqh_copy_entity_results_api.delete_copy_entity_result

Line 2462: pqh_copy_entity_results_api.delete_copy_entity_result

2458: from pqh_copy_entity_results
2459: where src_copy_entity_result_id = p_copy_entity_result_id ;
2460: begin
2461: for i in c_tgt loop
2462: pqh_copy_entity_results_api.delete_copy_entity_result
2463: (p_validate => FALSE
2464: ,p_copy_entity_result_id => i.copy_entity_result_id
2465: ,p_object_version_number => i.object_version_number
2466: ,p_effective_date => p_effective_date );

Line 2469: pqh_copy_entity_results_api.delete_copy_entity_result

2465: ,p_object_version_number => i.object_version_number
2466: ,p_effective_date => p_effective_date );
2467: end loop;
2468: --
2469: pqh_copy_entity_results_api.delete_copy_entity_result
2470: (p_validate => p_validate
2471: ,p_copy_entity_result_id => p_copy_entity_result_id
2472: ,p_object_version_number => l_ovn
2473: ,p_effective_date => p_effective_date );

Line 2486: update pqh_copy_entity_results

2482: is
2483: begin
2484: --
2485: if p_mode = 'INVERT' then
2486: update pqh_copy_entity_results
2487: set number_of_copies = decode(number_of_copies,0, nvl(p_select_value,1), 0)
2488: where copy_entity_txn_id = p_copy_entity_txn_id
2489: --and src_copy_entity_result_id = nvl(p_copy_entity_result_id, -99)
2490: and nvl(src_copy_entity_result_id,-99) = nvl(p_copy_entity_result_id, nvl(src_copy_entity_result_id,-99))

Line 2494: update pqh_copy_entity_results

2490: and nvl(src_copy_entity_result_id,-99) = nvl(p_copy_entity_result_id, nvl(src_copy_entity_result_id,-99))
2491: and status not in ('COMPLETED', 'DPT_ERR')
2492: and result_type_cd = p_block ;
2493: elsif p_mode = 'NONE' then
2494: update pqh_copy_entity_results
2495: set number_of_copies = 0
2496: where copy_entity_txn_id = p_copy_entity_txn_id
2497: and nvl(src_copy_entity_result_id,-99) = nvl(p_copy_entity_result_id, nvl(src_copy_entity_result_id,-99))
2498: and status not in ('COMPLETED', 'DPT_ERR')

Line 2501: update pqh_copy_entity_results

2497: and nvl(src_copy_entity_result_id,-99) = nvl(p_copy_entity_result_id, nvl(src_copy_entity_result_id,-99))
2498: and status not in ('COMPLETED', 'DPT_ERR')
2499: and result_type_cd = p_block ;
2500: elsif p_mode = 'ALL' then
2501: update pqh_copy_entity_results
2502: set number_of_copies = nvl(p_select_value,1)
2503: where copy_entity_txn_id = p_copy_entity_txn_id
2504: and nvl(src_copy_entity_result_id,-99) = nvl(p_copy_entity_result_id, nvl(src_copy_entity_result_id,-99))
2505: and status not in ('COMPLETED', 'DPT_ERR')

Line 2602: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc

2598: --
2599: begin
2600: for i in c_dt('DISPLAY') loop
2601: if i.ddf_value_column_name is not null then
2602: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc
2603: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2604: ||' and result_type_cd = ''TARGET'''
2605: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2606: end if;

Line 2607: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode

2603: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2604: ||' and result_type_cd = ''TARGET'''
2605: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2606: end if;
2607: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode
2608: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2609: ||' and result_type_cd = ''TARGET'''
2610: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2611:

Line 2618: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc

2614: --
2615: if l_upd then
2616: for i in c_dt('SELECT') loop
2617: if i.ddf_value_column_name is not null then
2618: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc
2619: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2620: ||' and result_type_cd = ''TARGET'''
2621: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2622: end if;

Line 2623: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode

2619: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2620: ||' and result_type_cd = ''TARGET'''
2621: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2622: end if;
2623: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode
2624: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2625: ||' and result_type_cd = ''TARGET'''
2626: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2627:

Line 2635: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc

2631: --
2632: if l_upd then
2633: for i in c_dt('PARAMETER') loop
2634: if i.ddf_value_column_name is not null then
2635: execute immediate 'update pqh_copy_entity_results set '||i.ddf_value_column_name||' = '''||p_dt_desc
2636: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2637: ||' and result_type_cd = ''TARGET'''
2638: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2639: end if;

Line 2640: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode

2636: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2637: ||' and result_type_cd = ''TARGET'''
2638: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2639: end if;
2640: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||p_dt_mode
2641: ||''' where copy_entity_txn_id = '||to_char(pqh_gen_form.g_txn_id)
2642: ||' and result_type_cd = ''TARGET'''
2643: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
2644: