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

Line 104: from pqh_copy_entity_results cer ,

100: -- Cursor for all selected target records
101: --
102: cursor c_target is
103: select cer.* , src.information1 src_information1
104: from pqh_copy_entity_results cer ,
105: pqh_copy_entity_results src
106: where cer.copy_entity_txn_id = p_copy_entity_txn_id
107: and cer.src_copy_entity_result_id = src.copy_entity_result_id
108: and src.number_of_copies <> 0

Line 105: pqh_copy_entity_results src

101: --
102: cursor c_target is
103: select cer.* , src.information1 src_information1
104: from pqh_copy_entity_results cer ,
105: pqh_copy_entity_results src
106: where cer.copy_entity_txn_id = p_copy_entity_txn_id
107: and cer.src_copy_entity_result_id = src.copy_entity_result_id
108: and src.number_of_copies <> 0
109: and cer.number_of_copies = 1

Line 169: from pqh_copy_entity_results

165: and sat1.ddf_column_name is not null ;
166: --
167: cursor c_status(v_status in varchar2) is
168: select status
169: from pqh_copy_entity_results
170: where result_type_cd = 'TARGET'
171: and copy_entity_txn_id = p_copy_entity_txn_id
172: and status = v_status
173: and number_of_copies <> 0

Line 342: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||rec1.dt_mode

338: pqh_generic.g_gbl_context := rec1.gbl_context ;
339: l_dt_mode := rec1.dt_mode;
340: --
341: for i in c_dt loop
342: execute immediate 'update pqh_copy_entity_results set '||i.ddf_column_name||' = '''||rec1.dt_mode
343: ||''' where copy_entity_txn_id = '||to_char(p_copy_entity_txn_id)
344: ||' and result_type_cd = ''TARGET'''
345: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
346: end loop; --c_dt

Line 348: update pqh_copy_entity_results

344: ||' and result_type_cd = ''TARGET'''
345: ||' and number_of_copies = 1 and status in (''TGT_P'',''TGT_ERR'')' ;
346: end loop; --c_dt
347: --
348: update pqh_copy_entity_results
349: set status = 'COMPLETED'
350: where copy_entity_txn_id = rec1.copy_entity_txn_id
351: and result_type_cd = 'SOURCE'
352: and number_of_copies <> 0

Line 353: and copy_entity_result_id not in (select src_copy_entity_result_id from pqh_copy_entity_results

349: set status = 'COMPLETED'
350: where copy_entity_txn_id = rec1.copy_entity_txn_id
351: and result_type_cd = 'SOURCE'
352: and number_of_copies <> 0
353: and copy_entity_result_id not in (select src_copy_entity_result_id from pqh_copy_entity_results
354: where copy_entity_txn_id = rec1.copy_entity_txn_id
355: and result_type_cd = 'TARGET'
356: and number_of_copies <> 1 ) ;
357: --

Line 358: update pqh_copy_entity_results

354: where copy_entity_txn_id = rec1.copy_entity_txn_id
355: and result_type_cd = 'TARGET'
356: and number_of_copies <> 1 ) ;
357: --
358: update pqh_copy_entity_results
359: set status = 'TGT_P'
360: where copy_entity_txn_id = rec1.copy_entity_txn_id
361: and result_type_cd = 'TARGET'
362: and number_of_copies = 0

Line 395: update pqh_copy_entity_results

391: hr_utility.set_location(' '||l_proc ||' rec2', 5);
392: --
393: for rec2 in c_target loop
394: --
395: update pqh_copy_entity_results
396: set status = 'COMPLETED'
397: where copy_entity_result_id = rec2.copy_entity_result_id ;
398: --
399: pqh_generic.g_result_id := rec2.copy_entity_result_id ;

Line 532: update pqh_copy_entity_results

528: , p_copy_proc => l_copy_function_name
529: , p_post_copy_proc => l_post_copy_function_name);
530: --
531: hr_utility.set_location('on master heading for upd', 499);
532: update pqh_copy_entity_results
533: set number_of_copies = '0'
534: where copy_entity_result_id = rec2.copy_entity_result_id
535: and status in ('COMPLETED','DPT_ERR') ;
536: exception

Line 1122: -- update pqh_copy_entity_results

1118: --
1119: rollback ;
1120: --
1121: hr_utility.set_location(pqh_generic.v_err,10);
1122: -- update pqh_copy_entity_results
1123: -- set status = substr(substr(p_msg_code,1,1)||replace(pqh_generic.v_err,'ORA'),1,30)
1124: -- ,number_of_copies = '0'
1125: -- where copy_entity_result_id = p_copy_entity_result_id;
1126: -- commit;

Line 1358: || 'from pqh_copy_entity_results cer '

1354: hr_utility.set_location(' : '||'column_name ='||p_column_name,15);
1355: execute immediate 'declare '
1356: || 'cursor c1 is '
1357: || 'select cer.'||p_ddf_column_name ||' value '
1358: || 'from pqh_copy_entity_results cer '
1359: || 'where cer.copy_entity_result_id = '||p_copy_entity_result_id ||' '
1360: || 'and cer.copy_entity_txn_id = '||p_copy_entity_txn_id ||'; '
1361: || 'begin '
1362: || 'for i in c1 loop '

Line 1454: from pqh_copy_entity_results

1450: --
1451: cursor c_tgt is
1452: select copy_entity_txn_id,
1453: src_copy_entity_result_id
1454: from pqh_copy_entity_results
1455: where copy_entity_result_id = l_copy_entity_result_id ;
1456: --
1457: cursor c_src (l_src_id in number, l_status in varchar2) is
1458: select copy_entity_txn_id,

Line 1460: from pqh_copy_entity_results

1456: --
1457: cursor c_src (l_src_id in number, l_status in varchar2) is
1458: select copy_entity_txn_id,
1459: copy_entity_result_id
1460: from pqh_copy_entity_results
1461: where copy_entity_result_id = l_src_id
1462: and status in ( 'COMPLETED', 'DPT_ERR')
1463: and status <> l_status ;
1464: --

Line 1489: update pqh_copy_entity_results

1485: pqh_process_batch_log.insert_log ( p_message_type_cd => 'ERROR',
1486: p_message_text => pqh_generic.v_err );
1487: --
1488: l_status := 'DPT_ERR' ;
1489: update pqh_copy_entity_results
1490: set status = 'DPT_ERR',
1491: number_of_copies = 0
1492: where copy_entity_result_id = l_copy_entity_result_id;
1493: else

Line 1505: update pqh_copy_entity_results

1501: pqh_process_batch_log.insert_log ( p_message_type_cd => 'ERROR',
1502: p_message_text => pqh_generic.v_err );
1503: --
1504: l_status := 'TGT_ERR' ;
1505: update pqh_copy_entity_results
1506: set status = 'TGT_ERR'
1507: where copy_entity_result_id = l_copy_entity_result_id;
1508: --
1509: end if;

Line 1517: update pqh_copy_entity_results

1513: l_src_copy_entity_result_id := i.src_copy_entity_result_id ;
1514: end loop;
1515: --
1516: for i in c_src (l_src_copy_entity_result_id, 'NONE' ) loop
1517: update pqh_copy_entity_results
1518: set status = l_status
1519: where copy_entity_result_id = i.copy_entity_result_id;
1520: --
1521: update pqh_copy_entity_txns