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_PERSON_DEPLOYMENT_SWI

Line 1: Package Body hr_person_deployment_swi As

1: Package Body hr_person_deployment_swi As
2: /* $Header: hrpdtswi.pkb 120.13.12020000.7 2012/10/09 15:22:20 pathota ship $ */
3: --
4: -- Package variables
5: --

Line 6: g_package varchar2(33) := 'hr_person_deployment_swi.';

2: /* $Header: hrpdtswi.pkb 120.13.12020000.7 2012/10/09 15:22:20 pathota ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'hr_person_deployment_swi.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-----------------------< create_person_deployment >-----------------------|

Line 2440: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

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)
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

Line 2448: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

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)
2448: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')
2449: and t.status not in ('D','E','AC'));
2450:
2451: if lv_transaction_count = 0
2452: then

Line 2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

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') )
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

Line 2472: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

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') )
2473: );
2474:
2475: exception
2476: when others then lv_action := null;

Line 2502: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

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)
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

Line 2510: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

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)
2510: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')
2511: and t.status not in ('D','E','AC'));
2512:
2513:
2514: if lv_transaction_count = 0

Line 2529: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

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')
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

Line 2538: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

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')
2538: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2539: );
2540:
2541: exception
2542: when others then lv_action := null;

Line 2570: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

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)
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

Line 2578: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

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)
2578: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')
2579: and t.status not in ('D','E','AC'));
2580:
2581:
2582: if lv_transaction_count = 0

Line 2597: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

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'
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

Line 2606: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

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'
2606: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2607: );
2608:
2609: exception
2610: when others then lv_action := null;

Line 2940: end hr_person_deployment_swi;

2936: hr_utility.set_location(l_proc||sqlerrm,50);
2937: null;
2938: end;
2939:
2940: end hr_person_deployment_swi;