DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on FND_NUMBER

Line 86: pqp_utilities.debug(fnd_number.number_to_canonical(p_trace_number));

82: PROCEDURE debug
83: (p_trace_number IN NUMBER )
84: IS
85: BEGIN
86: pqp_utilities.debug(fnd_number.number_to_canonical(p_trace_number));
87: END debug;
88: --
89: --
90: --

Line 146: fnd_number.number_to_canonical(p_last_step_number)||'}: '||

142: debug(p_proc_name,SQLCODE);
143: debug(SQLERRM);
144: END IF;
145: l_message := p_proc_name||'{'||
146: fnd_number.number_to_canonical(p_last_step_number)||'}: '||
147: SUBSTRB(SQLERRM,1,2000);
148: IF g_debug THEN
149: debug(l_message);
150: END IF;

Line 185: fnd_number.canonical_to_number(p_scheme_period_duration);

181: l_fixed_year_start_date DATE:=
182: fnd_date.canonical_to_date(p_fixed_year_start_date);
183:
184: l_scheme_period_duration NUMBER(10):=
185: fnd_number.canonical_to_number(p_scheme_period_duration);
186:
187: l_end_date DATE;
188: l_temp VARCHAR2(25);
189:

Line 209: -- fnd_number.canonical_to_number(p_scheme_period_duration);

205: -- debug(l_scheme_period_duration);
206: -- IF l_scheme_period_duration IS NULL THEN
207: -- debug('IS NULL');
208: -- l_scheme_period_duration :=
209: -- fnd_number.canonical_to_number(p_scheme_period_duration);
210: -- END IF;
211: -- debug('l_scheme_period_duration:');
212: -- debug(l_scheme_period_duration);
213:

Line 1338: debug('Caching check:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));

1334: debug_enter(l_proc_name);
1335: END IF;
1336:
1337: IF g_debug THEN
1338: debug('Caching check:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1339: debug('Caching check:p_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1340: END IF;
1341:
1342: IF g_pl_id IS NULL -- first time the function is called

Line 1339: debug('Caching check:p_pl_id:'||fnd_number.number_to_canonical(g_pl_id));

1335: END IF;
1336:
1337: IF g_debug THEN
1338: debug('Caching check:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1339: debug('Caching check:p_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1340: END IF;
1341:
1342: IF g_pl_id IS NULL -- first time the function is called
1343: OR p_pl_id <> g_pl_id -- subsequent calls reload cache only if

Line 2003: debug('Caching Id:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));

1999:
2000: l_proc_step := 150;
2001: IF g_debug THEN
2002: debug(l_proc_name, 150);
2003: debug('Caching Id:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
2004: debug('Caching Id:p_pl_id:'||fnd_number.number_to_canonical(p_pl_id));
2005: END IF;
2006:
2007: g_pl_id := p_pl_id; -- set at the end only after calls have passed successfully.

Line 2004: debug('Caching Id:p_pl_id:'||fnd_number.number_to_canonical(p_pl_id));

2000: l_proc_step := 150;
2001: IF g_debug THEN
2002: debug(l_proc_name, 150);
2003: debug('Caching Id:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
2004: debug('Caching Id:p_pl_id:'||fnd_number.number_to_canonical(p_pl_id));
2005: END IF;
2006:
2007: g_pl_id := p_pl_id; -- set at the end only after calls have passed successfully.
2008: g_plan_information := p_plan_information;

Line 2144: fnd_number.canonical_to_number(l_absence_part_days.abs_information1);

2140: debug(l_absence_part_days.abs_information1);
2141: END IF;
2142:
2143: p_part_start_day :=
2144: fnd_number.canonical_to_number(l_absence_part_days.abs_information1);
2145:
2146: l_proc_step := 30;
2147: IF g_debug THEN
2148: debug(p_part_start_day);

Line 2154: fnd_number.canonical_to_number(l_absence_part_days.abs_information2);

2150: debug(l_absence_part_days.abs_information2);
2151: END IF;
2152:
2153: p_part_end_day :=
2154: fnd_number.canonical_to_number(l_absence_part_days.abs_information2);
2155:
2156: l_proc_step := 40;
2157: IF g_debug THEN
2158: debug(p_part_end_day);

Line 3186: fnd_number.number_to_canonical(p_absences_taken_to_date.COUNT));

3182: -- 3 BAND3 0
3183: -- 4 BAND4 0
3184: IF g_debug THEN
3185: debug('p_absences_taken_to_date.COUNT:'||
3186: fnd_number.number_to_canonical(p_absences_taken_to_date.COUNT));
3187: END IF ;
3188:
3189: i := p_entitlements.FIRST;
3190: WHILE i IS NOT NULL

Line 3236: fnd_number.number_to_canonical

3232: -- (i=1) = (i=1)BAND1
3233:
3234: IF g_debug THEN
3235: debug('ent(i):'||
3236: fnd_number.number_to_canonical
3237: (p_entitlements(i).entitlement));
3238:
3239: debug('abs(j).duration:'||
3240: fnd_number.number_to_canonical

Line 3240: fnd_number.number_to_canonical

3236: fnd_number.number_to_canonical
3237: (p_entitlements(i).entitlement));
3238:
3239: debug('abs(j).duration:'||
3240: fnd_number.number_to_canonical
3241: (l_absences_taken_to_date(j).duration));
3242:
3243: debug('abs(j).duration_in_hours:'||
3244: fnd_number.number_to_canonical

Line 3244: fnd_number.number_to_canonical

3240: fnd_number.number_to_canonical
3241: (l_absences_taken_to_date(j).duration));
3242:
3243: debug('abs(j).duration_in_hours:'||
3244: fnd_number.number_to_canonical
3245: (l_absences_taken_to_date(j).duration_in_hours));
3246: END IF ;
3247:
3248:

Line 3309: fnd_number.number_to_canonical

3305: -- were at the previous length of service band.
3306:
3307: IF g_debug THEN
3308: debug('rem(i):'||
3309: fnd_number.number_to_canonical
3310: (p_entitlements_remaining(i).entitlement));
3311: END IF ;
3312:
3313: IF p_entitlements_remaining(i).entitlement < 0

Line 3323: -- fnd_number.number_to_canonical

3319: -- so set (i=1 BAND1) = 0
3320: END IF;
3321:
3322: -- debug('rem(i):'||
3323: -- fnd_number.number_to_canonical
3324: -- (p_entitlements_remaining(i).entitlement));
3325:
3326:
3327: --p_entitlements_remaining(i).ent_bal := 0;

Line 3640: FND_NUMBER.canonical_to_number(NVL(l_open_ended_no_pay_days,365));

3636: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'
3637: );
3638:
3639: g_open_ended_no_pay_days :=
3640: FND_NUMBER.canonical_to_number(NVL(l_open_ended_no_pay_days,365));
3641:
3642: IF g_debug THEN
3643: debug('g_open_ended_no_pay_days', g_open_ended_no_pay_days);
3644: END IF;

Line 4566: fnd_number.number_to_canonical(l_duration_to_process)

4562:
4563: l_duration_to_process := l_duration_to_process - l_duration_processed;
4564:
4565: debug('l_duration_to_process remaining:'||
4566: fnd_number.number_to_canonical(l_duration_to_process)
4567: );
4568:
4569: -- write the day to the cache
4570: -- date => l_current_date

Line 5054: FND_NUMBER.canonical_to_number(NVL(l_open_ended_no_pay_days,365));

5050: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'
5051: );
5052:
5053: g_open_ended_no_pay_days :=
5054: FND_NUMBER.canonical_to_number(NVL(l_open_ended_no_pay_days,365));
5055:
5056: IF g_debug THEN
5057: debug('g_open_ended_no_pay_days', g_open_ended_no_pay_days);
5058: END IF;