APPS.HR_GBBAL dependencies on FND_NUMBER

Line 92: l_year := FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(p_input_date,'YYYY'));

88: l_start_dd_mm varchar2(6);
89: l_correct_format BOOLEAN;
90: --
91: BEGIN
92: l_year := FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(p_input_date,'YYYY'));
93: --
94: -- Check that the passed in start of year
95: -- is in the correct format. Add a hyphen if one is missing
96: -- from the end, and ensure DD-MM- only has 6 characters.

Line 146: l_year := FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(p_input_date,'YYYY'));

142: l_start_dd_mm varchar2(6);
143: l_correct_format BOOLEAN;
144: --
145: BEGIN
146: l_year := FND_NUMBER.CANONICAL_TO_NUMBER(TO_CHAR(p_input_date,'YYYY'));
147: --
148: -- Check that the passed in start of year
149: -- is in the correct format. Add a hyphen if one is missing
150: -- from the end, and ensure DD-MM- only has 6 characters.

Line 243: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

239: /* bug fix 4493616 start*/
240: cursor get_master_latest_id (c_assignment_id IN NUMBER,
241: c_effective_date IN DATE) is
242: SELECT /*+ USE_NL(paa, ppa) */
243: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
244: paa.assignment_action_id),16))
245: FROM pay_assignment_actions paa,
246: pay_payroll_actions ppa
247: WHERE

Line 260: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

256: cursor get_latest_id (c_assignment_id IN NUMBER,
257: c_effective_date IN DATE,
258: c_master_asg_action_id IN NUMBER) is
259: SELECT /*+ USE_NL(paa, ppa) */
260: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
261: paa.assignment_action_id),16))
262: FROM pay_assignment_actions paa,
263: pay_payroll_actions ppa
264: WHERE

Line 398: ( to_date('06-04-' || to_char( fnd_number.canonical_to_number(to_char(

394: --
395: -- Set expired date to the 6th of April next.
396: --
397: l_expired_date :=
398: ( to_date('06-04-' || to_char( fnd_number.canonical_to_number(to_char(
399: p_action_effective_date,'YYYY')) + l_year_add_no),'DD-MM-YYYY'));
400: --
401: end if;
402: --

Line 453: to_char( fnd_number.canonical_to_number(to_char(

449: --
450: -- Set expired date to the 6th of April of the expiring year.
451: --
452: l_expired_date := ( to_date('06-04-' ||
453: to_char( fnd_number.canonical_to_number(to_char(
454: p_action_effective_date,'YYYY')) + l_year_add_no),'DD-MM-YYYY'));
455: --
456: END IF;
457: --

Line 479: l_frequency := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR

475: BEGIN
476: IF SUBSTR(p_dimension_name,31,8) = 'USER-REG' THEN -- [
477: l_start_reset := INSTR(p_dimension_name,'RESET',30);
478: l_start_dd_mon := SUBSTR(p_dimension_name, l_start_reset - 6, 5);
479: l_frequency := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR
480: (p_dimension_name, l_start_reset + 6, 2));
481: l_period_from_date := span_start(p_user_date,
482: l_frequency, l_start_dd_mon);
483: END IF; -- ]

Line 3189: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

3185: FEED PAY_BALANCE_FEEDS_F_UK2,
3186: PPTP PER_TIME_PERIODS_PK,
3187: RR PAY_RUN_RESULTS_N50,
3188: TARGET PAY_RUN_RESULT_VALUES_PK) */
3189: NVL(SUM(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
3190: INTO
3191: l_balance
3192: FROM
3193: pay_assignment_actions ASSACT

Line 3588: and fnd_number.canonical_to_number(UROWS.ROW_LOW_RANGE_OR_NAME) = PEL.ELEMENT_TYPE_ID

3584: per_time_periods bptp,
3585: pay_assignment_actions bassact
3586: where bassact.assignment_action_id = p_assignment_action_id
3587: and UROWS.user_table_id = g_ni_cat_indicator_table_id
3588: and fnd_number.canonical_to_number(UROWS.ROW_LOW_RANGE_OR_NAME) = PEL.ELEMENT_TYPE_ID
3589: and g_start_of_year between
3590: UROWS.effective_start_date and UROWS.effective_end_date
3591: and bact.payroll_action_id = bassact.payroll_action_id
3592: and bptp.time_period_id = bact.time_period_id