APPS.PER_ASG_AGGR dependencies on HR_API

Line 673: If p_per_information10 = hr_api.g_varchar2 then

669: open cur_person_details(p_person_id, l_effective_date);
670: fetch cur_person_details into l_cur_paye_agg_flag, l_curr_ni_agg_flag, l_cur_effective_start_date,l_cur_effective_end_date;
671: close cur_person_details;
672: -- If API call doesn't have parameter for PAYE aggregation flag, we need assign defatult value.
673: If p_per_information10 = hr_api.g_varchar2 then
674: l_cur_paye_agg_flag := hr_api.g_varchar2;
675: end if;
676:
677: IF nvl(l_cur_paye_agg_flag,'N') <> nvl(p_per_information10,'N') THEN

Line 674: l_cur_paye_agg_flag := hr_api.g_varchar2;

670: fetch cur_person_details into l_cur_paye_agg_flag, l_curr_ni_agg_flag, l_cur_effective_start_date,l_cur_effective_end_date;
671: close cur_person_details;
672: -- If API call doesn't have parameter for PAYE aggregation flag, we need assign defatult value.
673: If p_per_information10 = hr_api.g_varchar2 then
674: l_cur_paye_agg_flag := hr_api.g_varchar2;
675: end if;
676:
677: IF nvl(l_cur_paye_agg_flag,'N') <> nvl(p_per_information10,'N') THEN
678: -- End of bug 9535747

Line 910: If p_per_information9 = hr_api.g_varchar2 then

906: --The call to NI validation will be performed only in case when there is no change in PAYE Validation
907: --Else all validation willl be done in PAYE Validation Logic
908:
909: -- If API call doesn't have parameter for PAYE aggregation flag, we need assign defatult value.
910: If p_per_information9 = hr_api.g_varchar2 then
911: l_curr_ni_agg_flag := hr_api.g_varchar2;
912: end if;
913:
914: IF p_datetrack_update_mode <>'NOVALIDATION' THEN

Line 911: l_curr_ni_agg_flag := hr_api.g_varchar2;

907: --Else all validation willl be done in PAYE Validation Logic
908:
909: -- If API call doesn't have parameter for PAYE aggregation flag, we need assign defatult value.
910: If p_per_information9 = hr_api.g_varchar2 then
911: l_curr_ni_agg_flag := hr_api.g_varchar2;
912: end if;
913:
914: IF p_datetrack_update_mode <>'NOVALIDATION' THEN
915: l_local_date_trace_mode:=p_datetrack_update_mode;

Line 1189: l_eot := hr_api.g_eot;

1185: l_soy := to_date('06-04-'||SUBSTR(TO_CHAR(p_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY');
1186: ELSE
1187: l_soy := to_date('06-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(p_effective_date,'YYYY/MON/DD'),1,4))-1 ),'DD-MM-YYYY') ;
1188: END IF;
1189: l_eot := hr_api.g_eot;
1190: OPEN csr_ni_agg_ass(l_soy, l_eot);
1191: FETCH csr_ni_agg_ass into l_ni_asg_count;
1192: CLOSE csr_ni_agg_ass;
1193:

Line 1200: if rec.effective_end_date = hr_api.g_eot then

1196: l_person_effective_date := p_effective_date;
1197: FOR rec IN people_dt_records_desc(p_person_id, p_effective_date)
1198: LOOP
1199: if rec.effective_start_date < p_effective_date then
1200: if rec.effective_end_date = hr_api.g_eot then
1201: l_pers_dt_mode := 'UPDATE';
1202: else
1203: l_pers_dt_mode := 'UPDATE_CHANGE_INSERT';
1204: end if;

Line 1366: if (rec.effective_end_date = hr_api.g_eot) then

1362: end if;
1363:
1364: /* Idenfity the date track mode to be used. */
1365: if (rec.effective_start_date <> l_person_effective_date) then
1366: if (rec.effective_end_date = hr_api.g_eot) then
1367: l_pers_dt_mode := 'UPDATE';
1368: else
1369: l_pers_dt_mode := 'UPDATE_CHANGE_INSERT';
1370: end if;