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 1317: debug('Caching check:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));

1313: debug_enter(l_proc_name);
1314: END IF;
1315:
1316: IF g_debug THEN
1317: debug('Caching check:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1318: debug('Caching check:p_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1319: END IF;
1320:
1321: IF g_pl_id IS NULL -- first time the function is called

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

1314: END IF;
1315:
1316: IF g_debug THEN
1317: debug('Caching check:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1318: debug('Caching check:p_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1319: END IF;
1320:
1321: IF g_pl_id IS NULL -- first time the function is called
1322: OR p_pl_id <> g_pl_id -- subsequent calls reload cache only if

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

1978:
1979: l_proc_step := 150;
1980: IF g_debug THEN
1981: debug(l_proc_name, 150);
1982: debug('Caching Id:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1983: debug('Caching Id:p_pl_id:'||fnd_number.number_to_canonical(p_pl_id));
1984: END IF;
1985:
1986: g_pl_id := p_pl_id; -- set at the end only after calls have passed successfully.

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

1979: l_proc_step := 150;
1980: IF g_debug THEN
1981: debug(l_proc_name, 150);
1982: debug('Caching Id:g_pl_id:'||fnd_number.number_to_canonical(g_pl_id));
1983: debug('Caching Id:p_pl_id:'||fnd_number.number_to_canonical(p_pl_id));
1984: END IF;
1985:
1986: g_pl_id := p_pl_id; -- set at the end only after calls have passed successfully.
1987: g_plan_information := p_plan_information;

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

2119: debug(l_absence_part_days.abs_information1);
2120: END IF;
2121:
2122: p_part_start_day :=
2123: fnd_number.canonical_to_number(l_absence_part_days.abs_information1);
2124:
2125: l_proc_step := 30;
2126: IF g_debug THEN
2127: debug(p_part_start_day);

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

2129: debug(l_absence_part_days.abs_information2);
2130: END IF;
2131:
2132: p_part_end_day :=
2133: fnd_number.canonical_to_number(l_absence_part_days.abs_information2);
2134:
2135: l_proc_step := 40;
2136: IF g_debug THEN
2137: debug(p_part_end_day);

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

3161: -- 3 BAND3 0
3162: -- 4 BAND4 0
3163: IF g_debug THEN
3164: debug('p_absences_taken_to_date.COUNT:'||
3165: fnd_number.number_to_canonical(p_absences_taken_to_date.COUNT));
3166: END IF ;
3167:
3168: i := p_entitlements.FIRST;
3169: WHILE i IS NOT NULL

Line 3215: fnd_number.number_to_canonical

3211: -- (i=1) = (i=1)BAND1
3212:
3213: IF g_debug THEN
3214: debug('ent(i):'||
3215: fnd_number.number_to_canonical
3216: (p_entitlements(i).entitlement));
3217:
3218: debug('abs(j).duration:'||
3219: fnd_number.number_to_canonical

Line 3219: fnd_number.number_to_canonical

3215: fnd_number.number_to_canonical
3216: (p_entitlements(i).entitlement));
3217:
3218: debug('abs(j).duration:'||
3219: fnd_number.number_to_canonical
3220: (l_absences_taken_to_date(j).duration));
3221:
3222: debug('abs(j).duration_in_hours:'||
3223: fnd_number.number_to_canonical

Line 3223: fnd_number.number_to_canonical

3219: fnd_number.number_to_canonical
3220: (l_absences_taken_to_date(j).duration));
3221:
3222: debug('abs(j).duration_in_hours:'||
3223: fnd_number.number_to_canonical
3224: (l_absences_taken_to_date(j).duration_in_hours));
3225: END IF ;
3226:
3227:

Line 3288: fnd_number.number_to_canonical

3284: -- were at the previous length of service band.
3285:
3286: IF g_debug THEN
3287: debug('rem(i):'||
3288: fnd_number.number_to_canonical
3289: (p_entitlements_remaining(i).entitlement));
3290: END IF ;
3291:
3292: IF p_entitlements_remaining(i).entitlement < 0

Line 3302: -- fnd_number.number_to_canonical

3298: -- so set (i=1 BAND1) = 0
3299: END IF;
3300:
3301: -- debug('rem(i):'||
3302: -- fnd_number.number_to_canonical
3303: -- (p_entitlements_remaining(i).entitlement));
3304:
3305:
3306: --p_entitlements_remaining(i).ent_bal := 0;

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

3614: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'
3615: );
3616:
3617: g_open_ended_no_pay_days :=
3618: FND_NUMBER.canonical_to_number(NVL(l_open_ended_no_pay_days,365));
3619:
3620: IF g_debug THEN
3621: debug('g_open_ended_no_pay_days', g_open_ended_no_pay_days);
3622: END IF;

Line 4538: fnd_number.number_to_canonical(l_duration_to_process)

4534:
4535: l_duration_to_process := l_duration_to_process - l_duration_processed;
4536:
4537: debug('l_duration_to_process remaining:'||
4538: fnd_number.number_to_canonical(l_duration_to_process)
4539: );
4540:
4541: -- write the day to the cache
4542: -- date => l_current_date

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

5022: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'
5023: );
5024:
5025: g_open_ended_no_pay_days :=
5026: FND_NUMBER.canonical_to_number(NVL(l_open_ended_no_pay_days,365));
5027:
5028: IF g_debug THEN
5029: debug('g_open_ended_no_pay_days', g_open_ended_no_pay_days);
5030: END IF;