APPS.PQH_GSP_POST_PROCESS dependencies on BEN_PTNL_LER_FOR_PER

Line 1013: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;

1009: l_sal_value2 number;
1010:
1011: L_person_Id Per_All_People_F.Person_Id%TYPE;
1012: l_Ler_id Ben_ler_F.Ler_Id%TYPE;
1013: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
1014: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
1015: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
1016: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
1017: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;

Line 1014: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;

1010:
1011: L_person_Id Per_All_People_F.Person_Id%TYPE;
1012: l_Ler_id Ben_ler_F.Ler_Id%TYPE;
1013: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
1014: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
1015: l_PER_IN_LER_ID Ben_Per_In_Ler.Per_In_Ler_Id%TYPE;
1016: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
1017: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
1018: l_prev_assgt_id Per_All_Assignments_F.assignment_id%TYPE;

Line 1313: Ben_Ptnl_Ler_For_per_Api.CREATE_PTNL_LER_FOR_PER_PERF

1309: fnd_message.raise_error;
1310: End If;
1311:
1312: /* Create Potential Life Events */
1313: Ben_Ptnl_Ler_For_per_Api.CREATE_PTNL_LER_FOR_PER_PERF
1314: (P_PTNL_LER_FOR_PER_ID => L_PTNL_LER_FOR_PER_ID
1315: ,P_LF_EVT_OCRD_DT => l_New_Enrlmt_Dt
1316: ,P_PTNL_LER_FOR_PER_STAT_CD => 'PROCD'
1317: ,P_LER_ID => l_Ler_Id

Line 2674: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

2670: l_Per_In_ler_Stat_Cd Ben_Per_In_Ler.Per_In_Ler_Stat_Cd%TYPE;
2671: l_Error_Exists Varchar2(1) := 'N';
2672: l_conc_status boolean;
2673:
2674: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
2675: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;
2676:
2677: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2678: is

Line 2675: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;

2671: l_Error_Exists Varchar2(1) := 'N';
2672: l_conc_status boolean;
2673:
2674: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
2675: l_ptnl_ler_for_per_ovn ben_ptnl_ler_for_per.object_version_number%type;
2676:
2677: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2678: is
2679: select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number

Line 2681: ,ben_ptnl_ler_for_per ptnl

2677: cursor csr_ptnl_ler_dtls(p_per_in_ler_id in number)
2678: is
2679: select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number
2680: from ben_per_in_ler per
2681: ,ben_ptnl_ler_for_per ptnl
2682: where per.per_in_ler_id = p_per_in_ler_id
2683: and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
2684:
2685: Cursor Elctbl is

Line 2793: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

2789: into l_ptnl_ler_for_per_id
2790: ,l_ptnl_ler_for_per_ovn ;
2791: close csr_ptnl_ler_dtls ;
2792:
2793: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
2794: (p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
2795: ,p_ptnl_ler_for_per_stat_cd => l_Per_In_Ler_Stat_Cd
2796: ,p_voidd_dt => l_effective_date
2797: ,p_object_version_number => l_PTNL_LER_FOR_PER_OVN

Line 3215: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;

3211: Between Effective_Start_Date
3212: and Effective_End_Date
3213: and Business_Group_id = Hr_general.get_business_group_id;
3214:
3215: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3216: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3217: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3218: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3219: l_Grade_Id Per_Grades.Grade_Id%TYPE;

Line 3216: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;

3212: and Effective_End_Date
3213: and Business_Group_id = Hr_general.get_business_group_id;
3214:
3215: L_PTNL_LER_FOR_PER_ID Ben_Ptnl_Ler_For_Per.PTNL_LER_FOR_PER_ID%TYPE;
3216: l_Ptnl_Ovn Ben_Ptnl_Ler_For_Per.Object_Version_Number%TYPE;
3217: L_Pil_Ovn Ben_Per_In_Ler.Object_version_Number%TYPE;
3218: L_BG_Id Per_All_Assignments_F.Business_Group_id%TYPE;
3219: l_Grade_Id Per_Grades.Grade_Id%TYPE;
3220: l_Pgm_Id Ben_Pgm_F.Pgm_Id%TYPE;

Line 3511: from ben_ptnl_ler_for_per

3507:
3508: Cursor csr_ptnl_ler_dtls(p_PTNL_LER_FOR_PER_ID in number)
3509: IS
3510: select object_version_number
3511: from ben_ptnl_ler_for_per
3512: where PTNL_LER_FOR_PER_ID = p_PTNL_LER_FOR_PER_ID;
3513:
3514:
3515:

Line 3519: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;

3515:
3516:
3517: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3518: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3519: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3520: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3521: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3522: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3523: L_INV_NEXT_SAL_DATE_WARNING Boolean;

Line 3520: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;

3516:
3517: l_Pay_Proposal_Id Per_Pay_Proposals.Pay_Proposal_Id%TYPE;
3518: L_Pay_Proposals_Ovn Per_Pay_Proposals.Object_version_Number%TYPE;
3519: l_PTNL_LER_FOR_PER_ID ben_ptnl_ler_for_per.PTNL_LER_FOR_PER_ID%TYPE;
3520: l_PTNL_LER_FOR_PER_OVN ben_ptnl_ler_for_per.object_version_number%TYPE;
3521: l_Rt_Ovn Ben_Prtt_Rt_Val.Object_Version_Number%TYPE;
3522: l_salary Ben_Prtt_Rt_Val.Rt_Val%TYPE;
3523: L_INV_NEXT_SAL_DATE_WARNING Boolean;
3524: L_PROPOSED_SALARY_WARNING Boolean;

Line 3745: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

3741: ,P_VOIDD_DT => l_voidd_date
3742: ,P_OBJECT_VERSION_NUMBER => l_per_in_ler_ovn
3743: ,P_EFFECTIVE_DATE => P_Effective_Date);
3744:
3745: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
3746: (p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
3747: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
3748: ,p_voidd_dt => p_effective_date
3749: ,p_object_version_number => l_PTNL_LER_FOR_PER_OVN