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 FND_DATE

Line 329: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

325:
326: IF g_debug THEN
327: debug_enter(l_proc_name);
328: debug('p_business_group_id:'||p_business_group_id);
329: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
330: debug('p_absence_attendance_id:'||p_absence_attendance_id);
331: debug('p_segment_name:'||p_segment_name);
332: END IF;
333:

Line 602: debug('p_effective_date'||fnd_date.date_to_canonical(p_effective_date));

598:
599: IF g_debug THEN
600: debug_enter(l_proc_name);
601: debug('p_business_group_id:'||p_business_group_id);
602: debug('p_effective_date'||fnd_date.date_to_canonical(p_effective_date));
603: debug('p_absence_attendance_id:'||p_absence_attendance_id);
604: debug('p_segment_name:'||p_segment_name);
605: END IF;
606: --

Line 1884: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

1880: BEGIN
1881: IF g_debug THEN
1882: debug_enter(l_proc_name);
1883: debug('p_assignment_id:'||p_assignment_id);
1884: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1885: debug('p_title:'||p_title);
1886: END IF;
1887: l_absence_id :=
1888: pqp_gb_osp_functions.ben_get_absence_id(

Line 2057: SELECT fnd_date.date_to_canonical(

2053:
2054: IF p_message IS NULL
2055: THEN
2056: BEGIN
2057: SELECT fnd_date.date_to_canonical(
2058: ssp_smp_pkg.qualifying_week(fnd_date.canonical_to_date(l_due_date))
2059: )
2060: INTO l_val
2061: FROM DUAL;

Line 2058: ssp_smp_pkg.qualifying_week(fnd_date.canonical_to_date(l_due_date))

2054: IF p_message IS NULL
2055: THEN
2056: BEGIN
2057: SELECT fnd_date.date_to_canonical(
2058: ssp_smp_pkg.qualifying_week(fnd_date.canonical_to_date(l_due_date))
2059: )
2060: INTO l_val
2061: FROM DUAL;
2062: EXCEPTION

Line 2088: SELECT fnd_date.date_to_canonical(

2084:
2085: IF p_message IS NULL
2086: THEN
2087: BEGIN
2088: SELECT fnd_date.date_to_canonical(
2089: ssp_smp_pkg.expected_week_of_confinement(fnd_date.canonical_to_date(l_due_date))
2090: )
2091: INTO l_val
2092: FROM DUAL;

Line 2089: ssp_smp_pkg.expected_week_of_confinement(fnd_date.canonical_to_date(l_due_date))

2085: IF p_message IS NULL
2086: THEN
2087: BEGIN
2088: SELECT fnd_date.date_to_canonical(
2089: ssp_smp_pkg.expected_week_of_confinement(fnd_date.canonical_to_date(l_due_date))
2090: )
2091: INTO l_val
2092: FROM DUAL;
2093: EXCEPTION

Line 2193: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

2189: debug_enter(l_proc_name);
2190: debug('p_assignment_id:'||p_assignment_id);
2191: debug('p_business_group_id:'||p_business_group_id);
2192: debug('p_pl_id:'||p_pl_id);
2193: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
2194: END IF;
2195:
2196: -- IF p_absence_pay_plan_class = 'OSP'
2197: -- THEN -- check for an override, OMP does not yet need to support overrides

Line 2211: -- the fnd_date conversion to fail.

2207: -- a) performance
2208: -- b) depending on the explain plan the SQL query maybe executed
2209: -- using a different route which might cause the query to pei for
2210: -- information_types other than the one desired which might cause
2211: -- the fnd_date conversion to fail.
2212: l_override_entitlement_found := FALSE;
2213:
2214: l_pl_id_txt := fnd_number.number_to_canonical(p_pl_id);
2215:

Line 2227: fnd_date.canonical_to_date

2223: l_proc_step := 20;
2224: debug(l_proc_name, l_proc_step);
2225:
2226: IF p_effective_date BETWEEN
2227: fnd_date.canonical_to_date
2228: (r_override_entitlement.override_start_date_txt)
2229: AND
2230: fnd_date.canonical_to_date
2231: (r_override_entitlement.override_end_date_txt)

Line 2230: fnd_date.canonical_to_date

2226: IF p_effective_date BETWEEN
2227: fnd_date.canonical_to_date
2228: (r_override_entitlement.override_start_date_txt)
2229: AND
2230: fnd_date.canonical_to_date
2231: (r_override_entitlement.override_end_date_txt)
2232: THEN
2233:
2234: l_proc_step := 25;

Line 2891: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

2887:
2888: IF g_debug THEN
2889: debug_enter(l_proc_name);
2890: debug('p_business_group_id:'||p_business_group_id);
2891: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
2892: debug('p_pl_id:'||p_pl_id);
2893: debug('p_absence_pay_plan_class:'|| p_absence_pay_plan_class);
2894: debug('p_entitlement_table_id:'||p_entitlement_table_id);
2895: debug('p_benefits_length_of_service:'||p_benefits_length_of_service);

Line 3088: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

3084: --
3085: IF g_debug THEN
3086: debug_enter(l_proc_name);
3087: debug('p_business_group_id:'||p_business_group_id);
3088: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
3089: debug('p_assignment_id:'||p_assignment_id);
3090: debug('p_element_type_id:'||p_element_type_id);
3091: debug('p_entitlement_tab_id:'||p_entitlement_tab_id);
3092: debug('p_benefits_length_of_service:'||p_benefits_length_of_service);

Line 3640: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));

3636: FROM DUAL;
3637: BEGIN
3638: IF g_debug THEN
3639: debug_enter(l_proc_name);
3640: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));
3641: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));
3642: END IF;
3643:
3644: OPEN c_no_of_days(c_start_date => p_start_date

Line 3641: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));

3637: BEGIN
3638: IF g_debug THEN
3639: debug_enter(l_proc_name);
3640: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));
3641: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));
3642: END IF;
3643:
3644: OPEN c_no_of_days(c_start_date => p_start_date
3645: ,c_end_date => p_end_date);

Line 3691: debug('p_abs_start_date:'||fnd_date.date_to_canonical(p_abs_start_date));

3687: BEGIN
3688: IF g_debug THEN
3689: debug_enter(l_proc_name);
3690: debug('p_business_group_id:'||p_business_group_id);
3691: debug('p_abs_start_date:'||fnd_date.date_to_canonical(p_abs_start_date));
3692: debug('p_abs_end_date:'||fnd_date.date_to_canonical(p_abs_end_date));
3693: debug('p_table_id:'||p_table_id);
3694: debug('p_column_name:'||p_column_name);
3695: debug('p_value:'||p_value);

Line 3692: debug('p_abs_end_date:'||fnd_date.date_to_canonical(p_abs_end_date));

3688: IF g_debug THEN
3689: debug_enter(l_proc_name);
3690: debug('p_business_group_id:'||p_business_group_id);
3691: debug('p_abs_start_date:'||fnd_date.date_to_canonical(p_abs_start_date));
3692: debug('p_abs_end_date:'||fnd_date.date_to_canonical(p_abs_end_date));
3693: debug('p_table_id:'||p_table_id);
3694: debug('p_column_name:'||p_column_name);
3695: debug('p_value:'||p_value);
3696: END IF;

Line 3759: debug('p_abs_start_date:'||fnd_date.date_to_canonical(p_abs_start_date));

3755: BEGIN
3756: IF g_debug THEN
3757: debug_enter(l_proc_name);
3758: debug('p_business_group_id:'||p_business_group_id);
3759: debug('p_abs_start_date:'||fnd_date.date_to_canonical(p_abs_start_date));
3760: debug('p_abs_end_date:'||fnd_date.date_to_canonical(p_abs_end_date));
3761: debug('p_table_id:'||p_table_id);
3762: debug('p_column_name:'||p_column_name);
3763: debug('p_value:'||p_value);

Line 3760: debug('p_abs_end_date:'||fnd_date.date_to_canonical(p_abs_end_date));

3756: IF g_debug THEN
3757: debug_enter(l_proc_name);
3758: debug('p_business_group_id:'||p_business_group_id);
3759: debug('p_abs_start_date:'||fnd_date.date_to_canonical(p_abs_start_date));
3760: debug('p_abs_end_date:'||fnd_date.date_to_canonical(p_abs_end_date));
3761: debug('p_table_id:'||p_table_id);
3762: debug('p_column_name:'||p_column_name);
3763: debug('p_value:'||p_value);
3764: END IF;

Line 3922: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));

3918: IF g_debug THEN
3919: debug_enter(l_proc_name);
3920: debug('p_assignment_id:'||p_assignment_id);
3921: debug('p_business_group_id:'||p_business_group_id);
3922: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));
3923: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));
3924: debug('p_default_wp:'||p_default_wp);
3925: debug('p_table_id:'||p_table_id);
3926: debug('p_column_name:'||p_column_name);

Line 3923: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));

3919: debug_enter(l_proc_name);
3920: debug('p_assignment_id:'||p_assignment_id);
3921: debug('p_business_group_id:'||p_business_group_id);
3922: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));
3923: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));
3924: debug('p_default_wp:'||p_default_wp);
3925: debug('p_table_id:'||p_table_id);
3926: debug('p_column_name:'||p_column_name);
3927: debug('p_value:'||p_value);

Line 4001: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));

3997: IF g_debug THEN
3998: debug_enter(l_proc_name);
3999: debug('p_assignment_id:'||p_assignment_id);
4000: debug('p_business_group_id:'||p_business_group_id);
4001: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));
4002: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));
4003: debug('p_default_wp:'||p_default_wp);
4004: debug('p_table_id:'||p_table_id);
4005: debug('p_column_name:'||p_column_name);

Line 4002: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));

3998: debug_enter(l_proc_name);
3999: debug('p_assignment_id:'||p_assignment_id);
4000: debug('p_business_group_id:'||p_business_group_id);
4001: debug('p_start_date:'||fnd_date.date_to_canonical(p_start_date));
4002: debug('p_end_date:'||fnd_date.date_to_canonical(p_end_date));
4003: debug('p_default_wp:'||p_default_wp);
4004: debug('p_table_id:'||p_table_id);
4005: debug('p_column_name:'||p_column_name);
4006: debug('p_value:'||p_value);

Line 4114: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

4110: --
4111: IF g_debug THEN
4112: debug_enter(l_proc_name);
4113: debug('p_business_group_id:'||p_business_group_id);
4114: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
4115: debug('p_assignment_id:'||p_assignment_id);
4116: debug('p_element_type_id:'||p_element_type_id);
4117: debug('p_entitlement_tab_id:'||p_entitlement_tab_id);
4118: debug('p_benefits_length_of_service:'||p_benefits_length_of_service);

Line 4391: debug('p_curr_date:'||fnd_date.date_to_canonical(p_curr_date));

4387: BEGIN -- get_next_working_date_wp
4388: IF g_debug THEN
4389: debug_enter(l_proc_name);
4390: debug('p_business_group_id:'||p_business_group_id);
4391: debug('p_curr_date:'||fnd_date.date_to_canonical(p_curr_date));
4392: debug('p_balance_days:'||p_balance_days);
4393: debug('p_table_id:'||p_table_id);
4394: debug('p_column_name:'||p_column_name);
4395: debug('p_value:'||p_value);

Line 4430: debug('p_curr_date:'||fnd_date.date_to_canonical(p_curr_date));

4426: -- PS : we don't know till when to loop, so p_balance_days
4427: -- will be used as a balance counter
4428: LOOP -- Through dates starting with p_curr_date
4429: l_day := 'Day ' || LPAD(l_curr_day_no, 2, 0);
4430: debug('p_curr_date:'||fnd_date.date_to_canonical(p_curr_date));
4431:
4432: BEGIN
4433: l_retval :=
4434: pqp_utilities.pqp_gb_get_table_value(

Line 4571: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));

4567: IF g_debug THEN
4568: debug_enter(l_proc_name);
4569: debug('p_assignment_id:'||p_assignment_id);
4570: debug('p_business_group_id:'||p_business_group_id);
4571: debug('p_date_start:'||fnd_date.date_to_canonical(p_date_start));
4572: debug('p_days:'||p_days);
4573: debug('p_default_wp:'||p_default_wp);
4574: debug('p_table_id:'||p_table_id);
4575: debug('p_column_name:'||p_column_name);

Line 4893: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

4889: BEGIN
4890: IF g_debug THEN
4891: debug_enter(l_proc_name);
4892: debug('p_assignment_id:'||p_assignment_id);
4893: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
4894: debug('p_title:'||p_title);
4895: END IF;
4896: l_absence_id :=
4897: pqp_gb_osp_functions.ben_get_absence_id(

Line 4963: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

4959: BEGIN
4960: IF g_debug THEN
4961: debug_enter(l_proc_name);
4962: debug('p_assignment_id:'||p_assignment_id);
4963: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
4964: debug('p_title:'||p_title);
4965:
4966: END IF;
4967: l_absence_id :=

Line 5036: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));

5032: IF g_debug THEN
5033: debug_enter(l_proc_name);
5034: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5035: debug('p_pl_id:'||p_pl_id);
5036: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5037: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5038: debug('p_level_of_entitlement' || p_level_of_entitlement);
5039: END IF;
5040: p_error_code := 0;

Line 5037: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));

5033: debug_enter(l_proc_name);
5034: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5035: debug('p_pl_id:'||p_pl_id);
5036: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5037: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5038: debug('p_level_of_entitlement' || p_level_of_entitlement);
5039: END IF;
5040: p_error_code := 0;
5041: debug('p_level_of_entitlement:'||p_level_of_entitlement);

Line 5052: -- ,fnd_date.date_to_canonical(p_search_start_date));

5048: THEN
5049: p_error_code := -1;
5050: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5051: --fnd_message.set_token('START'
5052: -- ,fnd_date.date_to_canonical(p_search_start_date));
5053: --fnd_message.set_token('END'
5054: -- ,fnd_date.date_to_canonical(p_search_end_date));
5055: p_error_message := fnd_message.get();
5056: RETURN NULL;

Line 5054: -- ,fnd_date.date_to_canonical(p_search_end_date));

5050: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5051: --fnd_message.set_token('START'
5052: -- ,fnd_date.date_to_canonical(p_search_start_date));
5053: --fnd_message.set_token('END'
5054: -- ,fnd_date.date_to_canonical(p_search_end_date));
5055: p_error_message := fnd_message.get();
5056: RETURN NULL;
5057: END IF;
5058:

Line 5121: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));

5117: IF g_debug THEN
5118: debug_enter(l_proc_name);
5119: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5120: debug('p_pl_id:'||p_pl_id);
5121: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5122: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5123: debug('p_level_of_pay'|| p_level_of_pay);
5124: END IF;
5125: p_error_code := 0;

Line 5122: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));

5118: debug_enter(l_proc_name);
5119: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5120: debug('p_pl_id:'||p_pl_id);
5121: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5122: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5123: debug('p_level_of_pay'|| p_level_of_pay);
5124: END IF;
5125: p_error_code := 0;
5126:

Line 5134: -- ,fnd_date.date_to_canonical(p_search_start_date));

5130: THEN
5131: p_error_code := -1;
5132: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5133: --fnd_message.set_token('START'
5134: -- ,fnd_date.date_to_canonical(p_search_start_date));
5135: --fnd_message.set_token('END'
5136: -- ,fnd_date.date_to_canonical(p_search_end_date));
5137: p_error_message := fnd_message.get();
5138: RETURN NULL;

Line 5136: -- ,fnd_date.date_to_canonical(p_search_end_date));

5132: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5133: --fnd_message.set_token('START'
5134: -- ,fnd_date.date_to_canonical(p_search_start_date));
5135: --fnd_message.set_token('END'
5136: -- ,fnd_date.date_to_canonical(p_search_end_date));
5137: p_error_message := fnd_message.get();
5138: RETURN NULL;
5139: END IF;
5140:

Line 5198: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));

5194: IF g_debug THEN
5195: debug_enter(l_proc_name);
5196: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5197: debug('p_pl_id:'||p_pl_id);
5198: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5199: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5200: debug('p_work_pattern_day_type'||p_work_pattern_day_type);
5201: END IF;
5202: p_error_code := 0;

Line 5199: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));

5195: debug_enter(l_proc_name);
5196: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5197: debug('p_pl_id:'||p_pl_id);
5198: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5199: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5200: debug('p_work_pattern_day_type'||p_work_pattern_day_type);
5201: END IF;
5202: p_error_code := 0;
5203:

Line 5211: -- ,fnd_date.date_to_canonical(p_search_start_date));

5207: THEN
5208: p_error_code := -1;
5209: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5210: --fnd_message.set_token('START'
5211: -- ,fnd_date.date_to_canonical(p_search_start_date));
5212: --fnd_message.set_token('END'
5213: -- ,fnd_date.date_to_canonical(p_search_end_date));
5214: p_error_message := fnd_message.get();
5215: RETURN NULL;

Line 5213: -- ,fnd_date.date_to_canonical(p_search_end_date));

5209: fnd_message.set_name('PQP', 'PQP_230617_END_GE_START');
5210: --fnd_message.set_token('START'
5211: -- ,fnd_date.date_to_canonical(p_search_start_date));
5212: --fnd_message.set_token('END'
5213: -- ,fnd_date.date_to_canonical(p_search_end_date));
5214: p_error_message := fnd_message.get();
5215: RETURN NULL;
5216: END IF;
5217:

Line 5281: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));

5277: IF g_debug THEN
5278: debug_enter(l_proc_name);
5279: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5280: debug('p_pl_id:'||p_pl_id);
5281: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5282: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5283: END IF;
5284: -- Do the Search Start Date <= Search End Date Validation Here.
5285:

Line 5282: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));

5278: debug_enter(l_proc_name);
5279: debug('p_absence_attendance_id:'||p_absence_attendance_id);
5280: debug('p_pl_id:'||p_pl_id);
5281: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
5282: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
5283: END IF;
5284: -- Do the Search Start Date <= Search End Date Validation Here.
5285:
5286: p_error_code := 0;

Line 5462: debug('p_date:' || fnd_date.date_to_canonical(p_date));

5458: l_retval NUMBER := 0;
5459: BEGIN
5460: debug_enter(l_proc_name);
5461: p_error_code := 0;
5462: debug('p_date:' || fnd_date.date_to_canonical(p_date));
5463: debug(
5464: 'p_calendar_table_id:'
5465: || fnd_number.number_to_canonical(p_calendar_table_id)
5466: );

Line 5584: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

5580: END IF;
5581: IF g_debug THEN
5582: debug_enter(l_proc_name);
5583: debug('p_business_group_id:'||p_business_group_id);
5584: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
5585: debug('p_absence_start_date:'||fnd_date.date_to_canonical(l_absence_start_date));
5586: debug('p_assignment_id:'||p_assignment_id);
5587: debug('p_pl_typ_id:'||p_pl_typ_id);
5588: debug('p_scheme_calendar_type'||p_scheme_calendar_type);

Line 5585: debug('p_absence_start_date:'||fnd_date.date_to_canonical(l_absence_start_date));

5581: IF g_debug THEN
5582: debug_enter(l_proc_name);
5583: debug('p_business_group_id:'||p_business_group_id);
5584: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
5585: debug('p_absence_start_date:'||fnd_date.date_to_canonical(l_absence_start_date));
5586: debug('p_assignment_id:'||p_assignment_id);
5587: debug('p_pl_typ_id:'||p_pl_typ_id);
5588: debug('p_scheme_calendar_type'||p_scheme_calendar_type);
5589: debug('p_scheme_calendar_duration'||p_scheme_calendar_duration);

Line 5990: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

5986: debug_enter(l_proc_name);
5987: debug('p_business_group_id:'||p_business_group_id);
5988: debug('p_assignment_id:'||p_assignment_id);
5989: debug('p_element_type_id:'||p_element_type_id);
5990: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
5991: debug('p_absence_start_date:'||fnd_date.date_to_canonical(l_absence_start_date));
5992: debug('p_level_of_entitlement'||p_level_of_entitlement);
5993: debug('p_days_hours'||p_days_hours);
5994:

Line 5991: debug('p_absence_start_date:'||fnd_date.date_to_canonical(l_absence_start_date));

5987: debug('p_business_group_id:'||p_business_group_id);
5988: debug('p_assignment_id:'||p_assignment_id);
5989: debug('p_element_type_id:'||p_element_type_id);
5990: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
5991: debug('p_absence_start_date:'||fnd_date.date_to_canonical(l_absence_start_date));
5992: debug('p_level_of_entitlement'||p_level_of_entitlement);
5993: debug('p_days_hours'||p_days_hours);
5994:
5995: END IF;

Line 6109: debug('p_effective_date'||fnd_date.date_to_canonical(p_effective_date));

6105: debug_enter(l_proc_name);
6106: debug('p_business_group_id:'||p_business_group_id);
6107: debug('p_assignment_id:'||p_assignment_id);
6108: debug('p_element_type_id:'||p_element_type_id);
6109: debug('p_effective_date'||fnd_date.date_to_canonical(p_effective_date));
6110: debug('p_absence_start_date'||fnd_date.date_to_canonical(l_absence_start_date));
6111: END IF;
6112: p_band1_ent_bal :=
6113: get_band_ent_bal_by_ele_typ_id(

Line 6110: debug('p_absence_start_date'||fnd_date.date_to_canonical(l_absence_start_date));

6106: debug('p_business_group_id:'||p_business_group_id);
6107: debug('p_assignment_id:'||p_assignment_id);
6108: debug('p_element_type_id:'||p_element_type_id);
6109: debug('p_effective_date'||fnd_date.date_to_canonical(p_effective_date));
6110: debug('p_absence_start_date'||fnd_date.date_to_canonical(l_absence_start_date));
6111: END IF;
6112: p_band1_ent_bal :=
6113: get_band_ent_bal_by_ele_typ_id(
6114: p_business_group_id => p_business_group_id

Line 6247: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

6243: debug_enter(l_proc_name);
6244: debug('p_business_group_id:'||p_business_group_id);
6245: debug('p_assignment_id:'||p_assignment_id);
6246: debug('p_pl_id:'||p_pl_id);
6247: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
6248: debug('p_level_of_entitlement'||p_level_of_entitlement);
6249:
6250: END IF;
6251: OPEN csr_get_element_type_id(p_pl_id => p_pl_id);

Line 6314: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));

6310: debug('p_business_group_id:'||p_business_group_id);
6311: debug('p_effective_date'||p_effective_date);
6312: debug('p_pl_id:'||p_pl_id);
6313: debug('p_level_of_pay'||p_level_of_pay);
6314: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
6315: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
6316: END IF;
6317: OPEN csr_get_level_pay(
6318: p_assignment_id

Line 6315: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));

6311: debug('p_effective_date'||p_effective_date);
6312: debug('p_pl_id:'||p_pl_id);
6313: debug('p_level_of_pay'||p_level_of_pay);
6314: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
6315: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
6316: END IF;
6317: OPEN csr_get_level_pay(
6318: p_assignment_id
6319: ,p_business_group_id

Line 6371: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));

6367: IF g_debug THEN
6368: debug_enter(l_proc_name);
6369: debug('p_assignment_id:'||p_assignment_id);
6370: debug('p_business_group_id:'||p_business_group_id);
6371: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
6372: debug('p_pl_id:'||p_pl_id);
6373: debug('p_level_of_entitlement'||p_level_of_entitlement);
6374: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
6375: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));

Line 6374: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));

6370: debug('p_business_group_id:'||p_business_group_id);
6371: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
6372: debug('p_pl_id:'||p_pl_id);
6373: debug('p_level_of_entitlement'||p_level_of_entitlement);
6374: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
6375: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
6376: END IF;
6377: OPEN csr_get_level_ent(
6378: p_assignment_id

Line 6375: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));

6371: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
6372: debug('p_pl_id:'||p_pl_id);
6373: debug('p_level_of_entitlement'||p_level_of_entitlement);
6374: debug('p_search_start_date:'||fnd_date.date_to_canonical(p_search_start_date));
6375: debug('p_search_end_date:'||fnd_date.date_to_canonical(p_search_end_date));
6376: END IF;
6377: OPEN csr_get_level_ent(
6378: p_assignment_id
6379: ,p_business_group_id

Line 6661: debug('p_effective_date'|| fnd_date.date_to_canonical(p_effective_date));

6657: debug_enter(l_proc_name);
6658: --
6659: debug('p_business_group_id:'||p_business_group_id);
6660: debug('p_lookup_code '||p_lookup_code);
6661: debug('p_effective_date'|| fnd_date.date_to_canonical(p_effective_date));
6662: debug('p_lookup_type '||p_lookup_type);
6663: -- Get Security Group Information
6664: OPEN csr_get_security_group;
6665: FETCH csr_get_security_group INTO l_security_group_id;

Line 7049: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));

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));
7051: p_error_message := fnd_message.get();
7052: RETURN NULL;
7053: END IF;

Line 7050: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_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));
7051: p_error_message := fnd_message.get();
7052: RETURN NULL;
7053: END IF;
7054:

Line 7115: --fnd_message.set_token('START',fnd_date.date_to_canonical(p_search_start_date));

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));
7117: p_error_message := fnd_message.get();
7118: RETURN NULL;
7119: END IF;

Line 7116: --fnd_message.set_token('END',fnd_date.date_to_canonical(p_search_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));
7117: p_error_message := fnd_message.get();
7118: RETURN NULL;
7119: END IF;
7120:

Line 8028: fnd_date.canonical_to_date(p_pei_information1);

8024: END IF;
8025: -- if there are format errors it will bomb out in the next
8026: -- two statements
8027: l_override_start_date :=
8028: fnd_date.canonical_to_date(p_pei_information1);
8029:
8030: l_override_end_date :=
8031: fnd_date.canonical_to_date(p_pei_information2);
8032:

Line 8031: fnd_date.canonical_to_date(p_pei_information2);

8027: l_override_start_date :=
8028: fnd_date.canonical_to_date(p_pei_information1);
8029:
8030: l_override_end_date :=
8031: fnd_date.canonical_to_date(p_pei_information2);
8032:
8033: --l_override_pl_id :=
8034: -- fnd_number.canonical_to_number(p_pei_information3);
8035:

Line 8075: fnd_date.canonical_to_date(r_other_override_row.override_start_date_txt);

8071: debug(l_proc_name, l_proc_step+(l_loop_counter/100000));
8072: END IF;
8073:
8074: l_other_override_start_date :=
8075: fnd_date.canonical_to_date(r_other_override_row.override_start_date_txt);
8076:
8077: l_other_override_end_date :=
8078: fnd_date.canonical_to_date(r_other_override_row.override_end_date_txt);
8079:

Line 8078: fnd_date.canonical_to_date(r_other_override_row.override_end_date_txt);

8074: l_other_override_start_date :=
8075: fnd_date.canonical_to_date(r_other_override_row.override_start_date_txt);
8076:
8077: l_other_override_end_date :=
8078: fnd_date.canonical_to_date(r_other_override_row.override_end_date_txt);
8079:
8080: --l_other_override_pl_id :=
8081: -- fnd_number.canonical_to_number(r_other_override_row.pl_id_txt);
8082:

Line 9100: fnd_date.canonical_to_date(l_screen_entry_value);

9096: fnd_number.canonical_to_number(l_screen_entry_value);
9097: END IF;
9098: IF j = 3 THEN -- its date_from
9099: r_ssp_entry.date_from:=
9100: fnd_date.canonical_to_date(l_screen_entry_value);
9101: END IF;
9102: IF j = 4 THEN -- its date_to
9103: r_ssp_entry.date_to:=
9104: fnd_date.canonical_to_date(l_screen_entry_value);

Line 9104: fnd_date.canonical_to_date(l_screen_entry_value);

9100: fnd_date.canonical_to_date(l_screen_entry_value);
9101: END IF;
9102: IF j = 4 THEN -- its date_to
9103: r_ssp_entry.date_to:=
9104: fnd_date.canonical_to_date(l_screen_entry_value);
9105: END IF;
9106: IF j = 5 THEN -- its rate
9107: r_ssp_entry.rate:=
9108: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9226: fnd_date.canonical_to_date(l_screen_entry_value);

9222: fnd_number.canonical_to_number(l_screen_entry_value);
9223: END IF;
9224: IF j = 3 THEN -- its date_from
9225: r_ssp_entry.date_from:=
9226: fnd_date.canonical_to_date(l_screen_entry_value);
9227: END IF;
9228: IF j = 4 THEN -- its date_to
9229: r_ssp_entry.date_to:=
9230: fnd_date.canonical_to_date(l_screen_entry_value);

Line 9230: fnd_date.canonical_to_date(l_screen_entry_value);

9226: fnd_date.canonical_to_date(l_screen_entry_value);
9227: END IF;
9228: IF j = 4 THEN -- its date_to
9229: r_ssp_entry.date_to:=
9230: fnd_date.canonical_to_date(l_screen_entry_value);
9231: END IF;
9232: IF j = 5 THEN -- its rate
9233: r_ssp_entry.rate:=
9234: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9949: fnd_date.canonical_to_date(l_screen_entry_value);

9945: fnd_number.canonical_to_number(l_screen_entry_value);
9946: END IF;
9947: IF j = 2 THEN -- its week_commencing
9948: r_smp_entry.week_commencing :=
9949: fnd_date.canonical_to_date(l_screen_entry_value);
9950: END IF;
9951: --IF j = 3 THEN -- its rate (text)
9952: -- r_smp_entry.rate :=
9953: -- l_screen_entry_value;

Line 10047: fnd_date.canonical_to_date(l_screen_entry_value);

10043: fnd_number.canonical_to_number(l_screen_entry_value);
10044: END IF;
10045: IF j = 2 THEN -- its week_commencing
10046: r_smp_entry.week_commencing :=
10047: fnd_date.canonical_to_date(l_screen_entry_value);
10048: END IF;
10049: --IF j = 3 THEN -- its rate (text)
10050: -- r_smp_entry.rate :=
10051: -- l_screen_entry_value;

Line 10969: fnd_date.canonical_to_date(l_minimum_pay_info.start_date_txt);

10965:
10966: IF csr_get_minpay_info%FOUND THEN
10967:
10968: p_minpay_start_date :=
10969: fnd_date.canonical_to_date(l_minimum_pay_info.start_date_txt);
10970: p_minpay_end_date :=
10971: fnd_date.canonical_to_date(l_minimum_pay_info.end_date_txt);
10972: l_minpay_rate := l_minimum_pay_info.min_pay ;
10973: END IF;

Line 10971: fnd_date.canonical_to_date(l_minimum_pay_info.end_date_txt);

10967:
10968: p_minpay_start_date :=
10969: fnd_date.canonical_to_date(l_minimum_pay_info.start_date_txt);
10970: p_minpay_end_date :=
10971: fnd_date.canonical_to_date(l_minimum_pay_info.end_date_txt);
10972: l_minpay_rate := l_minimum_pay_info.min_pay ;
10973: END IF;
10974: CLOSE csr_get_minpay_info;
10975:

Line 11956: l_pension_st_dt := fnd_date.canonical_to_date(p_abs_information4);

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:
11959: IF g_debug THEN
11960: debug(l_proc_name,25);

Line 11966: l_pension_end_dt := fnd_date.canonical_to_date(p_abs_information5);

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:
11969: IF g_debug THEN
11970: debug(l_proc_name,35);