APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PTNL_LER_FOR_PER

Line 912: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;

908: and Business_Group_id = Hr_general.get_business_group_id;
909:
910: L_person_Id Per_All_People_F.Person_Id%TYPE;
911: l_Ler_id Ben_ler_F.Ler_Id%TYPE;
912: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
913: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
914: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
915: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
916: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;

Line 913: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;

909:
910: L_person_Id Per_All_People_F.Person_Id%TYPE;
911: l_Ler_id Ben_ler_F.Ler_Id%TYPE;
912: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
913: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
914: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
915: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
916: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
917: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;

Line 1153: Ben_Ptnl_Ler_For_per_Api.CREATE_PTNL_LER_FOR_PER_PERF

1149: fnd_message.raise_error;
1150: End If;
1151:
1152: /* Create Potential Life Events */
1153: Ben_Ptnl_Ler_For_per_Api.CREATE_PTNL_LER_FOR_PER_PERF
1154: (P_PTNL_LER_FOR_PER_ID => L_PTNL_LER_FOR_PER_ID
1155: ,P_LF_EVT_OCRD_DT => l_New_Enrlmt_Dt
1156: ,P_PTNL_LER_FOR_PER_STAT_CD => 'PROCD'
1157: ,P_LER_ID => l_Ler_Id

Line 2514: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

2510: l_Per_In_ler_Stat_Cd Ben_Per_In_Ler.Per_In_Ler_Stat_Cd%TYPE;
2511: l_Error_Exists Varchar2(1) := 'N';
2512: l_conc_status boolean;
2513:
2514: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
2515: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;
2516:
2517: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2518: is

Line 2515: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;

2511: l_Error_Exists Varchar2(1) := 'N';
2512: l_conc_status boolean;
2513:
2514: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
2515: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;
2516:
2517: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2518: is
2519: select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number

Line 2521: ,ben_ptnl_ler_for_per ptnl

2517: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2518: is
2519: select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number
2520: from ben_per_in_ler per
2521: ,ben_ptnl_ler_for_per ptnl
2522: where per.per_in_ler_id = p_per_in_ler_id
2523: and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
2524:
2525: Cursor Elctbl is

Line 2633: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

2629: into l_ptnl_ler_for_per_id
2630: ,l_ptnl_ler_for_per_ovn ;
2631: close csr_ptnl_ler_dtls ;
2632:
2633: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
2634: (p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
2635: ,p_ptnl_ler_for_per_stat_cd => l_Per_In_Ler_Stat_Cd
2636: ,p_voidd_dt => l_effective_date
2637: ,p_object_version_number => l_PTNL_LER_FOR_PER_OVN

Line 3055: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;

3051: Between Effective_Start_Date
3052: and Effective_End_Date
3053: and Business_Group_id = Hr_general.get_business_group_id;
3054:
3055: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3056: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3057: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3058: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3059: l_Grade_Id Per_Grades.Grade_Id%TYPE;

Line 3056: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;

3052: and Effective_End_Date
3053: and Business_Group_id = Hr_general.get_business_group_id;
3054:
3055: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3056: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3057: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3058: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3059: l_Grade_Id Per_Grades.Grade_Id%TYPE;
3060: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

Line 3351: from ben_ptnl_ler_for_per

3347:
3348: Cursor csr_ptnl_ler_dtls(p_PTNL_LER_FOR_PER_ID in number)
3349: IS
3350: select object_version_number
3351: from ben_ptnl_ler_for_per
3352: where PTNL_LER_FOR_PER_ID = p_PTNL_LER_FOR_PER_ID;
3353:
3354:
3355:

Line 3359: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;

3355:
3356:
3357: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3358: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3359: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3360: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3361: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3362: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3363: L_INV_NEXT_SAL_DATE_WARNING Boolean;

Line 3360: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;

3356:
3357: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3358: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3359: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3360: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3361: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3362: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3363: L_INV_NEXT_SAL_DATE_WARNING Boolean;
3364: L_PROPOSED_SALARY_WARNING Boolean;

Line 3585: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

3581: ,P_VOIDD_DT => l_voidd_date
3582: ,P_OBJECT_VERSION_NUMBER => l_per_in_ler_ovn
3583: ,P_EFFECTIVE_DATE => P_Effective_Date);
3584:
3585: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
3586: (p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
3587: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
3588: ,p_voidd_dt => p_effective_date
3589: ,p_object_version_number => l_PTNL_LER_FOR_PER_OVN