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.HR_PERSON_DEPLOYMENT_SWI dependencies on HR_API_TRANSACTIONS

Line 478: from hr_api_transactions hat,

474:
475: cursor c_del_trans is
476: select hat.transaction_id transaction_id,
477: hats.transaction_step_id transaction_step_id
478: from hr_api_transactions hat,
479: hr_api_transaction_steps hats
480: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
481: and hat.transaction_id = hats.transaction_id
482: and hats.information1 = to_char(p_person_deployment_id);

Line 1347: from hr_api_transactions hat,hr_api_transaction_steps hats

1343: l_person_deployment_id := hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null);
1344: begin
1345: select max(hat.transaction_id)
1346: into l_transaction_id
1347: from hr_api_transactions hat,hr_api_transaction_steps hats
1348: where hat.transaction_id = hats.transaction_id
1349: and hats.information1 = l_person_deployment_id
1350: and hats.information12 = 'CreateMode';
1351: exception

Line 2435: from hr_api_transactions hat,

2431: if upper(p_deployment_status) = 'DRAFT'
2432: then
2433: select count(hat.transaction_id)
2434: into lv_transaction_count
2435: from hr_api_transactions hat,
2436: hr_api_transaction_steps hats
2437: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2438: and hats.transaction_id = hat.transaction_id
2439: and hats.information1 = to_char(p_deployment_id)

Line 2443: from hr_api_transactions t,

2439: and hats.information1 = to_char(p_deployment_id)
2440: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2441: and hat.status in ('AC')
2442: and not exists ( select 'e'
2443: from hr_api_transactions t,
2444: hr_api_transaction_steps hat
2445: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2446: and hat.transaction_id = t.transaction_id
2447: and hat.information1 = to_char(p_deployment_id)

Line 2460: from hr_api_transactions hat, hr_api_transaction_steps hats

2456: select ACTION
2457: into lv_action
2458: from PQH_SS_APPROVAL_HISTORY
2459: where transaction_history_id in (select hat.transaction_id
2460: from hr_api_transactions hat, hr_api_transaction_steps hats
2461: where hat.transaction_id = hats.transaction_id
2462: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2463: and hats.information1 = to_char(p_deployment_id)
2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

Line 2468: from hr_api_transactions hat, hr_api_transaction_steps hats

2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2465: and creation_date = (select max(CREATION_DATE)
2466: from PQH_SS_APPROVAL_HISTORY
2467: where transaction_history_id in (select hat.transaction_id
2468: from hr_api_transactions hat, hr_api_transaction_steps hats
2469: where hat.transaction_id = hats.transaction_id
2470: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2471: and hats.information1 = to_char(p_deployment_id)
2472: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

Line 2497: from hr_api_transactions hat,

2493: then
2494:
2495: select count(hat.transaction_id)
2496: into lv_transaction_count
2497: from hr_api_transactions hat,
2498: hr_api_transaction_steps hats
2499: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2500: and hats.transaction_id = hat.transaction_id
2501: and hats.information1 = to_char(p_deployment_id)

Line 2505: from hr_api_transactions t,

2501: and hats.information1 = to_char(p_deployment_id)
2502: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2503: and hat.status in ('AC')
2504: and not exists ( select 'e'
2505: from hr_api_transactions t,
2506: hr_api_transaction_steps hat
2507: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2508: and hat.transaction_id = t.transaction_id
2509: and hat.information1 = to_char(p_deployment_id)

Line 2524: from hr_api_transactions hat, hr_api_transaction_steps hats

2520: select ACTION
2521: into lv_action
2522: from PQH_SS_APPROVAL_HISTORY
2523: where transaction_history_id in (select hat.transaction_id
2524: from hr_api_transactions hat, hr_api_transaction_steps hats
2525: where hat.transaction_id = hats.transaction_id
2526: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2527: and hats.information1 = to_char(p_deployment_id)
2528: and upper(hats.information12) in ('RETURNMODE','ACTUPDATEMODE')

Line 2533: from hr_api_transactions hat, hr_api_transaction_steps hats

2529: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2530: and creation_date = (select max(CREATION_DATE)
2531: from PQH_SS_APPROVAL_HISTORY
2532: where transaction_history_id in (select hat.transaction_id
2533: from hr_api_transactions hat, hr_api_transaction_steps hats
2534: where hat.transaction_id = hats.transaction_id
2535: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2536: and hats.information1 = to_char(p_deployment_id)
2537: and upper(hats.information12) in ('RETURNMODE','ACTUPDATEMODE')

Line 2565: from hr_api_transactions hat,

2561: then
2562:
2563: select count(hat.transaction_id)
2564: into lv_transaction_count
2565: from hr_api_transactions hat,
2566: hr_api_transaction_steps hats
2567: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2568: and hats.transaction_id = hat.transaction_id
2569: and hats.information1 = to_char(p_deployment_id)

Line 2573: from hr_api_transactions t,

2569: and hats.information1 = to_char(p_deployment_id)
2570: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2571: and hat.status in ('AC')
2572: and not exists ( select 'e'
2573: from hr_api_transactions t,
2574: hr_api_transaction_steps hat
2575: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2576: and hat.transaction_id = t.transaction_id
2577: and hat.information1 = to_char(p_deployment_id)

Line 2592: from hr_api_transactions hat, hr_api_transaction_steps hats

2588: select ACTION
2589: into lv_action
2590: from PQH_SS_APPROVAL_HISTORY
2591: where transaction_history_id in (select hat.transaction_id
2592: from hr_api_transactions hat, hr_api_transaction_steps hats
2593: where hat.transaction_id = hats.transaction_id
2594: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2595: and hats.information1 = to_char(p_deployment_id)
2596: and upper(hats.information12) = 'RETURNMODE'

Line 2601: from hr_api_transactions hat, hr_api_transaction_steps hats

2597: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2598: and creation_date = (select max(CREATION_DATE)
2599: from PQH_SS_APPROVAL_HISTORY
2600: where transaction_history_id in (select hat.transaction_id
2601: from hr_api_transactions hat, hr_api_transaction_steps hats
2602: where hat.transaction_id = hats.transaction_id
2603: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2604: and hats.information1 = to_char(p_deployment_id)
2605: and upper(hats.information12) = 'RETURNMODE'

Line 2916: from hr_api_transactions

2912:
2913: begin
2914: select item_type,item_key
2915: into l_item_type,l_item_key
2916: from hr_api_transactions
2917: where transaction_id = p_transaction_id;
2918:
2919: hr_utility.set_location(l_proc||'l_item_key='||l_item_key,41);
2920: Exception