DBA Data[Home] [Help]

APPS.PQP_GB_PSI_STH_HISTORY dependencies on FND_NUMBER

Line 711: g_reported_pay_periods(fnd_number.canonical_to_number(TO_CHAR(l_start_date,'ddmmyyyy'))) := 'Y';

707: debug('g_end_date: '||g_end_date,10);
708: debug('g_adjusted_hours: '||g_adjusted_hours,10);
709:
710: debug('Marking that the current pay period is processed',10);
711: g_reported_pay_periods(fnd_number.canonical_to_number(TO_CHAR(l_start_date,'ddmmyyyy'))) := 'Y';
712:
713: debug_exit(l_proc);
714: EXCEPTION
715: WHEN others THEN

Line 1043: g_curr_element_entry_id := fnd_number.canonical_to_number(l_chg_surrogate_key);

1039: RETURN FALSE;
1040:
1041: END IF;
1042:
1043: g_curr_element_entry_id := fnd_number.canonical_to_number(l_chg_surrogate_key);
1044:
1045: IF l_chg_type = 'C' THEN
1046: -- for correction events on pay_element_entry_values_f
1047: -- the surrogate key is element_entry_value_id

Line 1132: l_claim_date_no := fnd_number.canonical_to_number(TO_CHAR(l_claim_date_dt,'ddmmyyyy'));

1128:
1129: IF l_claim_date IS NOT NULL THEN
1130: debug('Claim Date is not null',20);
1131: l_claim_date_dt := fnd_date.canonical_to_date(l_claim_date);
1132: l_claim_date_no := fnd_number.canonical_to_number(TO_CHAR(l_claim_date_dt,'ddmmyyyy'));
1133:
1134:
1135:
1136: IF pqp_gb_psi_functions.is_proper_claim_date(l_claim_date_dt

Line 1193: l_adj_hours_num := fnd_number.canonical_to_number(l_adj_hours);

1189: END IF; --IF l_claim_date IS NOT NULL
1190:
1191: debug('g_adjusted_hours: '||g_adjusted_hours,10);
1192:
1193: l_adj_hours_num := fnd_number.canonical_to_number(l_adj_hours);
1194:
1195: debug('l_adj_hours_num: '||l_adj_hours_num);
1196:
1197: IF l_adj_hours IS NOT NULL

Line 1353: AND g_reported_pay_periods.EXISTS(fnd_number.canonical_to_number

1349: END IF;
1350:
1351: -- bug fix 5365237
1352: IF nvl(g_adj_hrs_source,' ') = 'BALANCE'
1353: AND g_reported_pay_periods.EXISTS(fnd_number.canonical_to_number
1354: (
1355: TO_CHAR(ben_ext_person.g_chg_eff_dt,'ddmmyyyy')
1356: )
1357: )THEN