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.GHR_SF52_DO_UPDATE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 4: g_old_user_status per_assignment_status_types.user_status%type;

1: PACKAGE BODY GHR_SF52_DO_UPDATE AS
2: /* $Header: gh52doup.pkb 120.83.12020000.13 2013/01/16 06:53:40 vmididho ship $ */
3: g_effective_date date;
4: g_old_user_status per_assignment_status_types.user_status%type;
5: --
6: -- Removed all cursors required to fetch noa_code, as it is already passed from ghr_pa_requests (FRONT END)
7: --
8: -- *******************************

Line 2502: p_status_type_id out nocopy per_assignment_status_types.assignment_status_type_id%type,

2498: (p_noa_code in ghr_nature_of_actions.code%type,
2499: p_business_group_id in per_people_f.business_group_id%type,
2500: p_assignment_id in number,
2501: p_pa_request_id in ghr_pa_requests.pa_request_id%type, --Bug# 8724192
2502: p_status_type_id out nocopy per_assignment_status_types.assignment_status_type_id%type,
2503: p_activate_flag out nocopy varchar2,
2504: p_suspend_flag out nocopy varchar2,
2505: p_terminate_flag out nocopy varchar2
2506: )

Line 2510: l_system_status per_assignment_status_types.per_system_status%type;

2506: )
2507: is
2508:
2509: l_proc varchar2(70) := 'get_asg_status_type';
2510: l_system_status per_assignment_status_types.per_system_status%type;
2511: l_user_status per_assignment_status_types.user_status%type;
2512: l_asg_status_type_id number;
2513: l_active_flag varchar2(1) := 'N';
2514:

Line 2511: l_user_status per_assignment_status_types.user_status%type;

2507: is
2508:
2509: l_proc varchar2(70) := 'get_asg_status_type';
2510: l_system_status per_assignment_status_types.per_system_status%type;
2511: l_user_status per_assignment_status_types.user_status%type;
2512: l_asg_status_type_id number;
2513: l_active_flag varchar2(1) := 'N';
2514:
2515:

Line 2519: from per_assignment_status_types ast

2515:
2516: cursor c_asg_status_type is
2517: select ast.assignment_status_type_id,
2518: ast.active_flag
2519: from per_assignment_status_types ast
2520: where ast.per_system_status = l_system_status
2521: and ast.user_status like '%' || l_user_status || '%'
2522: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number
2523: and ast.legislation_code = 'US';

Line 2528: from per_assignment_status_types ast

2524:
2525: cursor c_asg_status_type_471 is
2526: select ast.assignment_status_type_id,
2527: ast.active_flag
2528: from per_assignment_status_types ast
2529: where ast.per_system_status = l_system_status
2530: and ast.user_status like '%' || l_user_status || '%'
2531: and instr(ast.user_status,'NTE') = 0
2532: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number

Line 2535: l_user_apnt_status per_assignment_status_types.user_status%type;

2531: and instr(ast.user_status,'NTE') = 0
2532: and nvl(ast.business_group_id,hr_api.g_number) = hr_api.g_number
2533: and ast.legislation_code = 'US';
2534: -- Bug# 4672772 Begin
2535: l_user_apnt_status per_assignment_status_types.user_status%type;
2536: l_user_apnt_eff_date date;
2537: CURSOR c_user_apnt_status IS
2538: select ast.user_status,asg.effective_start_date
2539: from per_assignment_status_types ast,

Line 2539: from per_assignment_status_types ast,

2535: l_user_apnt_status per_assignment_status_types.user_status%type;
2536: l_user_apnt_eff_date date;
2537: CURSOR c_user_apnt_status IS
2538: select ast.user_status,asg.effective_start_date
2539: from per_assignment_status_types ast,
2540: per_all_assignments_f asg
2541: where ast.assignment_status_type_id = asg.assignment_status_type_id
2542: and asg.assignment_id = p_assignment_id
2543: and asg.primary_flag = 'Y'

Line 2548: l_user_actv_apnt_status per_assignment_status_types.user_status%type;

2544: order by asg.effective_start_date;
2545:
2546: -- Bug# 4672772 End
2547: --Begin Bug# 6083404
2548: l_user_actv_apnt_status per_assignment_status_types.user_status%type;
2549: CURSOR c_user_actv_appt IS
2550: select ast.user_status
2551: from per_assignment_status_types ast,
2552: per_all_assignments_f asg

Line 2551: from per_assignment_status_types ast,

2547: --Begin Bug# 6083404
2548: l_user_actv_apnt_status per_assignment_status_types.user_status%type;
2549: CURSOR c_user_actv_appt IS
2550: select ast.user_status
2551: from per_assignment_status_types ast,
2552: per_all_assignments_f asg
2553: where ast.assignment_status_type_id = asg.assignment_status_type_id
2554: and asg.assignment_id = p_assignment_id
2555: and asg.primary_flag = 'Y'

Line 2572: from per_assignment_status_types ast,

2568: old_status_start_date date;
2569:
2570: Cursor c_cur_detail_user_status is
2571: select asg.effective_start_date
2572: from per_assignment_status_types ast,
2573: per_all_assignments_f asg
2574: where asg.assignment_id = p_assignment_id
2575: and ast.assignment_status_type_id = asg.assignment_status_type_id
2576: and ast.user_status='Detail NTE'

Line 2586: from per_assignment_status_types ast,

2582: --user processes detail action on next day of detail termination.
2583: -- 13014948,13023669 modified the cursor to handle the same day Detail and other actions
2584: Cursor c_old_user_status is
2585: select ast.user_status,ast.per_system_status
2586: from per_assignment_status_types ast,
2587: ghr_pa_history gph
2588: where gph.assignment_id = p_assignment_id
2589: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id
2590: and ast.user_status <> 'Detail NTE'

Line 2595: from per_assignment_status_types ast,

2591: and ast.per_system_status <> 'SUSP_ASSIGN' --Bug# 13087709
2592: and gph.table_name = 'PER_ASSIGNMENTS_F'
2593: and gph.effective_date < =
2594: (select asg.effective_start_date
2595: from per_assignment_status_types ast,
2596: per_all_assignments_f asg
2597: where asg.assignment_id = p_assignment_id
2598: and ast.assignment_status_type_id = asg.assignment_status_type_id
2599: and ast.user_status='Detail NTE'

Line 2606: from per_assignment_status_types ast,

2602: and asg.effective_end_date)
2603: order by gph.pa_history_id desc;
2604:
2605: /* select ast.user_status,ast.per_system_status
2606: from per_assignment_status_types ast,
2607: per_all_assignments_f asg
2608: where asg.assignment_id = p_assignment_id
2609: and ast.assignment_status_type_id = asg.assignment_status_type_id
2610: and ast.user_status <> 'Detail NTE'

Line 2613: from per_assignment_status_types ast,

2609: and ast.assignment_status_type_id = asg.assignment_status_type_id
2610: and ast.user_status <> 'Detail NTE'
2611: and asg.effective_start_date <
2612: (select asg.effective_start_date
2613: from per_assignment_status_types ast,
2614: per_all_assignments_f asg
2615: where asg.assignment_id = p_assignment_id
2616: and ast.assignment_status_type_id = asg.assignment_status_type_id
2617: and ast.user_status='Detail NTE'

Line 3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;

3141: l_date1 ghr_pa_requests.effective_date%type;
3142: l_address_id per_addresses.address_id%type;
3143: l_person_type per_person_types.system_person_type%type;
3144: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
3146: --
3147: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
3148: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;
3149: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;

Line 3220: l_old_system_status per_assignment_status_types.per_system_status%type;

3216: l_result_code varchar2(100);
3217: l_address_data per_addresses%rowtype;
3218: l_hr_user_type varchar2(20);
3219:
3220: l_old_system_status per_assignment_status_types.per_system_status%type;
3221:
3222: l_remark_id ghr_remarks.remark_id%type;
3223: l_remark_description ghr_remarks.description%type;
3224: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

Line 3487: per_assignment_status_types ast,

3483: select ast.user_status,
3484: ast.per_system_status,
3485: asg.effective_start_date
3486: from
3487: per_assignment_status_types ast,
3488: per_all_assignments_f asg
3489: where asg.assignment_id = l_assignment_id
3490: and ast.assignment_status_type_id = asg.assignment_status_type_id
3491: and g_effective_date

Line 3510: from per_assignments_f asg,per_assignment_status_types past

3506: --- Bug 5923426 start
3507: /****** Bug 13057211 Commented the cursor and wrote a modified one.
3508: Cursor c_user_old_status is
3509: Select past.per_system_status ,asg.assignment_status_type_id
3510: from per_assignments_f asg,per_assignment_status_types past
3511: where asg.assignment_id = l_assignment_id
3512: and asg.assignment_status_type_id = past.assignment_status_type_id
3513: order by asg.effective_start_date desc;
3514: ********/

Line 3520: from per_assignment_status_types ast,

3516:
3517: --- Bug 13057211 start
3518: Cursor c_user_old_status is
3519: select ast.per_system_status ,ast.assignment_status_type_id
3520: from per_assignment_status_types ast,
3521: ghr_pa_history gph
3522: where gph.assignment_id = l_assignment_id
3523: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id
3524: and gph.table_name = 'PER_ASSIGNMENTS_F'