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.PQP_GB_OSP_FUNCTIONS dependencies on HR_API

Line 16: g_balance_date DATE := hr_api.g_date;

12: pqp_schedule_calculation_pkg.g_default_start_day;
13:
14: g_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
15: g_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
16: g_balance_date DATE := hr_api.g_date;
17: g_absences_taken_to_date pqp_absval_pkg.t_entitlements;
18:
19: g_scheme_calendar_type pay_element_type_extra_info.eei_information1%TYPE;
20: g_scheme_calendar_duration pay_element_type_extra_info.eei_information1%TYPE;

Line 27: g_omp_balance_date DATE := hr_api.g_date;

23:
24: -- Cache for get_omp_band_ent_bal_pl_typ
25: g_omp_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
26: g_omp_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
27: g_omp_balance_date DATE := hr_api.g_date;
28: g_omp_absences_taken_to_date pqp_absval_pkg.t_entitlements;
29:
30: -- Cache for pqp_get_plan_extra_info
31: g_element_type_id pay_element_type_extra_info.element_type_id%TYPE;

Line 185: g_balance_date := NULL;--DATE := hr_api.g_date

181: BEGIN
182:
183: g_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
184: g_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
185: g_balance_date := NULL;--DATE := hr_api.g_date
186: g_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
187:
188: g_scheme_calendar_type := NULL ;
189: g_scheme_calendar_duration := NULL ;

Line 196: g_omp_balance_date := NULL;--DATE := hr_api.g_date

192:
193: -- Cache for get_omp_band_ent_bal_pl_typ
194: g_omp_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
195: g_omp_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
196: g_omp_balance_date := NULL;--DATE := hr_api.g_date
197: g_omp_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
198:
199: -- Cache for pqp_get_plan_extra_info
200: g_element_type_id := NULL;--pay_element_type_extra_info.element_type_id%TYPE

Line 3574: -- ,hr_api.g_eot, p_abs_start_date

3570: debug('p_value:'||p_value);
3571: END IF;
3572: --SELECT DECODE(
3573: -- p_abs_end_date
3574: -- ,hr_api.g_eot, p_abs_start_date
3575: -- ,p_abs_end_date
3576: -- )
3577: --INTO l_abs_end_date
3578: --FROM DUAL;

Line 3580: IF TRUNC(p_abs_end_date) = hr_api.g_eot THEN

3576: -- )
3577: --INTO l_abs_end_date
3578: --FROM DUAL;
3579:
3580: IF TRUNC(p_abs_end_date) = hr_api.g_eot THEN
3581: l_abs_end_date := p_abs_start_date;
3582: ELSE
3583: l_abs_end_date := p_abs_end_date;
3584: END IF;

Line 4692: r_def_wp_dets.effective_end_date := hr_api.g_eot; -- End of Time

4688: debug(l_proc_name, 60);
4689: debug('Asg WP NOT Found, default WP available');
4690: r_def_wp_dets := NULL;
4691: r_def_wp_dets.effective_start_date := l_curr_date;
4692: r_def_wp_dets.effective_end_date := hr_api.g_eot; -- End of Time
4693: r_def_wp_dets.business_group_id := p_business_group_id;
4694: r_def_wp_dets.work_pattern := p_default_wp;
4695: r_def_wp_dets.start_day :=
4696: 'Day '

Line 5047: NVL(p_search_end_date, hr_api.g_eot)

5043: debug('p_search_end_date:'||p_search_end_date);
5044:
5045: -- Check the Start Date is earlier than or equal to End Date.
5046: IF NVL(p_search_start_date, SYSDATE) >
5047: NVL(p_search_end_date, hr_api.g_eot)
5048: THEN
5049: p_error_code := -1;
5050: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5051: --fnd_message.set_token('START'

Line 5129: NVL(p_search_end_date, hr_api.g_eot)

5125: p_error_code := 0;
5126:
5127: -- Check the Start Date is earlier than or equal to End Date.
5128: IF NVL(p_search_start_date, SYSDATE) >
5129: NVL(p_search_end_date, hr_api.g_eot)
5130: THEN
5131: p_error_code := -1;
5132: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5133: --fnd_message.set_token('START'

Line 5206: NVL(p_search_end_date, hr_api.g_eot)

5202: p_error_code := 0;
5203:
5204: -- Check the Start Date is earlier than or equal to End Date.
5205: IF NVL(p_search_start_date, SYSDATE) >
5206: NVL(p_search_end_date, hr_api.g_eot)
5207: THEN
5208: p_error_code := -1;
5209: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5210: --fnd_message.set_token('START'

Line 6684: debug('Call hr_api.not_exists_in_hr_lookups');

6680: IF csr_exists_in_gap_lookup%NOTFOUND
6681: THEN
6682: -- Check whether the lookup code exists
6683: -- for global security group id
6684: debug('Call hr_api.not_exists_in_hr_lookups');
6685:
6686: IF hr_api.not_exists_in_hr_lookups(p_effective_date, p_lookup_type
6687: ,p_lookup_code)
6688: THEN

Line 6686: IF hr_api.not_exists_in_hr_lookups(p_effective_date, p_lookup_type

6682: -- Check whether the lookup code exists
6683: -- for global security group id
6684: debug('Call hr_api.not_exists_in_hr_lookups');
6685:
6686: IF hr_api.not_exists_in_hr_lookups(p_effective_date, p_lookup_type
6687: ,p_lookup_code)
6688: THEN
6689: l_return := FALSE;
6690: ELSE

Line 7046: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN

7042: debug('p_level_of_entitlement'||p_level_of_entitlement);
7043: END IF;
7044: p_error_code := 0 ;
7045: -- Check the Start Date is earlier than or equal to End Date.
7046: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7047: p_error_code := -1 ;
7048: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7049: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7050: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));

Line 7112: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN

7108: debug('p_level_of_pay'||p_level_of_pay);
7109: END IF;
7110: p_error_code := 0 ;
7111: -- Check the Start Date is earlier than or equal to End Date.
7112: IF NVL(p_search_start_date,SYSDATE) > NVL(p_search_end_date,hr_api.g_eot) THEN
7113: p_error_code := -1 ;
7114: fnd_message.set_name('PQP','PQP_230617_END_GE_START');
7115: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));
7116: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_end_date));

Line 7683: l_boundary_date := hr_api.g_eot;

7679: IF g_debug THEN
7680: debug(l_proc_name,l_proc_step);
7681: END IF;
7682:
7683: l_boundary_date := hr_api.g_eot;
7684:
7685: END IF;
7686:
7687: IF g_debug THEN

Line 8848: NVL(l_absence.sickness_end_date,hr_api.g_eot);

8844: -- there was a time when for SSP one could only enter the sickness
8845: -- start and end dates, with the date_start and end being optional
8846: -- in addition end dates can be open, default to EOT
8847: l_absence.date_end :=
8848: NVL(l_absence.sickness_end_date,hr_api.g_eot);
8849: END IF;
8850:
8851:
8852: IF l_absence.business_group_id <> g_ssp_business_group_id

Line 9023: -- l_absence.date_end := NVL(l_absence.sickness_end_date,hr_api.g_eot);

9019: --
9020: -- l_absence.date_end := l_absence.date_start+l_max_ssp_period;
9021: -- l_absence.sickness_end_date := l_absence.date_start+l_max_ssp_period;
9022:
9023: -- l_absence.date_end := NVL(l_absence.sickness_end_date,hr_api.g_eot);
9024: --
9025: -- END IF;
9026:
9027:

Line 9651: NVL(l_absence.date_projected_end,hr_api.g_eot);

9647:
9648: IF l_absence.date_end IS NULL
9649: THEN
9650: l_absence.date_end :=
9651: NVL(l_absence.date_projected_end,hr_api.g_eot);
9652: END IF;
9653:
9654:
9655: IF l_absence.business_group_id <> g_smp_business_group_id

Line 10279: -- ,hr_api.g_eot))

10275: -- ,p_range_start_date => NVL(l_absence.date_start
10276: -- ,l_absence.sickness_start_date)
10277: -- ,p_range_end_date => NVL(l_absence.date_end
10278: -- ,NVL(l_absence.sickness_end_date
10279: -- ,hr_api.g_eot))
10280: -- );
10281:
10282:
10283: END IF; -- IF csr_absence_details%FOUND

Line 10395: -- ,hr_api.g_eot))

10391: -- ,p_range_start_date => NVL(l_absence.date_start
10392: -- ,l_absence.date_projected_start)
10393: -- ,p_range_end_date => NVL(l_absence.date_end
10394: -- ,NVL(l_absence.date_projected_end
10395: -- ,hr_api.g_eot))
10396: -- );
10397:
10398:
10399: END IF; -- IF csr_absence_details%FOUND

Line 11954: IF (p_abs_information4 <> hr_api.g_varchar2)

11950: debug('l_date_end'||l_date_end);
11951: debug(l_proc_name,15);
11952: END IF;
11953:
11954: IF (p_abs_information4 <> hr_api.g_varchar2)
11955: THEN
11956: l_pension_st_dt := fnd_date.canonical_to_date(p_abs_information4);
11957: END IF;
11958:

Line 11964: IF (p_abs_information5 <> hr_api.g_varchar2)

11960: debug(l_proc_name,25);
11961: END IF;
11962:
11963:
11964: IF (p_abs_information5 <> hr_api.g_varchar2)
11965: THEN
11966: l_pension_end_dt := fnd_date.canonical_to_date(p_abs_information5);
11967: END IF;
11968:

Line 11974: IF (p_abs_information6 <> hr_api.g_varchar2)

11970: debug(l_proc_name,35);
11971: END IF;
11972:
11973:
11974: IF (p_abs_information6 <> hr_api.g_varchar2)
11975: THEN
11976: l_pension_rt := fnd_number.canonical_to_number(p_abs_information6);
11977: END IF;
11978: