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_NL_PGGM_PENSION_EXTRACTS dependencies on FND_NUMBER

Line 429: l_data_value := Fnd_Number.Canonical_To_Number(Nvl(p_data_value,'0'));

425: FUNCTION IsNumber (p_data_value IN Varchar2)
426: RETURN Boolean IS
427: l_data_value Number;
428: BEGIN
429: l_data_value := Fnd_Number.Canonical_To_Number(Nvl(p_data_value,'0'));
430: RETURN TRUE;
431: EXCEPTION
432: WHEN Value_Error THEN
433: RETURN FALSE;

Line 2015: SELECT fnd_number.canonical_to_number(NVL(scl.SEGMENT29,'0')) pt_perc,

2011:
2012: --Cursor to check the PTP in the Std Conditions tab
2013: --Pick ptp value from Std conditions at asg level
2014: CURSOR csr_get_ptp_std_cond(c_assignment_id NUMBER,bg_id NUMBER) IS
2015: SELECT fnd_number.canonical_to_number(NVL(scl.SEGMENT29,'0')) pt_perc,
2016: asg.effective_start_date, asg.effective_end_date
2017: FROM per_assignments_f asg
2018: ,hr_soft_coding_keyflex scl
2019: WHERE asg.assignment_id = c_assignment_id

Line 2026: SELECT fnd_number.canonical_to_number(NVL(scl.SEGMENT29,'0')) pt_perc

2022: AND g_extract_params(p_business_group_id).extract_end_date;
2023:
2024: --Cursor to check the previous PTP in the Std Conditions tab
2025: CURSOR csr_get_prev_ptp_std_cond(c_asg_id NUMBER,c_date DATE) IS
2026: SELECT fnd_number.canonical_to_number(NVL(scl.SEGMENT29,'0')) pt_perc
2027: FROM per_all_assignments_f asg
2028: ,hr_soft_coding_keyflex scl
2029: WHERE asg.assignment_id = c_asg_id
2030: AND (c_date - 1 BETWEEN asg.effective_start_date

Line 3389: SELECT fnd_number.canonical_to_number (ppf.prl_information1)

3385: )
3386: Return Number is
3387: -- Cursor to get Org id for the given asg id
3388: CURSOR csr_get_org_id IS
3389: SELECT fnd_number.canonical_to_number (ppf.prl_information1)
3390: FROM per_all_assignments_f paf,
3391: pay_all_payrolls_f ppf
3392: WHERE paf.assignment_id = p_assignment_id
3393: AND paf.business_group_id = p_business_group_id

Line 3468: SELECT fnd_number.canonical_to_number (ppf.prl_information1)

3464: Return Number is
3465:
3466: -- Cursor to get Org id for the given asg id
3467: CURSOR csr_get_org_id IS
3468: SELECT fnd_number.canonical_to_number (ppf.prl_information1)
3469: FROM per_all_assignments_f paf,
3470: pay_all_payrolls_f ppf
3471: WHERE paf.assignment_id = p_assignment_id
3472: AND paf.business_group_id = p_business_group_id

Line 3928: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc

3924: and peev.screen_entry_value is not null;
3925:
3926: --Pick ptp value from Std conditions at asg level
3927: CURSOR csr_get_ptp_asg_level(c_assignment_id NUMBER,c_effective_date IN DATE) IS
3928: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
3929: FROM per_assignments_f asg
3930: ,hr_soft_coding_keyflex target
3931: WHERE asg.assignment_id = c_assignment_id
3932: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3966: p_data_element_value := lpad(fnd_number.number_to_canonical(ceil(l_ptp)),3,'0')||'000';

3962: CLOSE csr_get_ptp_asg_level;
3963: END IF;
3964: CLOSE csr_get_overide_ptp_val;
3965:
3966: p_data_element_value := lpad(fnd_number.number_to_canonical(ceil(l_ptp)),3,'0')||'000';
3967:
3968: Hr_Utility.set_location(' Leaving: ' ||l_proc_name,20);
3969: RETURN l_ret_val;
3970: EXCEPTION

Line 4220: SELECT CEIL(fnd_number.canonical_to_number(peev.screen_entry_value))

4216: --
4217: -- Cursor to get the current year override for pension salary
4218: --
4219: CURSOR csr_curr_year_pen_sal_or(c_asg_id Number,c_start_date DATE) IS
4220: SELECT CEIL(fnd_number.canonical_to_number(peev.screen_entry_value))
4221: FROM pay_element_entries_f pee,
4222: pay_input_values_f piv,
4223: pay_element_types_f pet,
4224: pay_element_entry_values_f peev

Line 4925: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc

4921: and peev.screen_entry_value is not null;
4922:
4923: --Pick ptp value from Std conditions at asg level
4924: CURSOR c_get_ptp_std_asg(c_effective_date IN DATE) IS
4925: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
4926: FROM per_assignments_f asg
4927: ,hr_soft_coding_keyflex target
4928: WHERE asg.assignment_id = p_assignment_id
4929: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 5030: p_data_element_value := lpad(fnd_number.number_to_canonical(ceil(l_ptp_value)),3,'0')||'000';

5026: END IF;
5027: END IF;
5028: END IF;
5029:
5030: p_data_element_value := lpad(fnd_number.number_to_canonical(ceil(l_ptp_value)),3,'0')||'000';
5031:
5032: END IF;
5033: Hr_Utility.set_location(' Leaving: ' ||l_proc_name,50);
5034: l_ret_val:=0;

Line 5230: p_data_element_value:= lpad(fnd_number.number_to_canonical(CEIL(l_irr_pay_amt)),6,'0');

5226: ,'Assignment Period To Date'
5227: ,g_extract_params(p_business_group_id).extract_start_date
5228: ,g_extract_params(p_business_group_id).extract_end_date
5229: );
5230: p_data_element_value:= lpad(fnd_number.number_to_canonical(CEIL(l_irr_pay_amt)),6,'0');
5231: /*--For yearly report round the irregular payment amount
5232: IF g_extract_params(p_business_group_id).extract_type='Y' THEN
5233: p_data_element_value:= lpad(fnd_number.number_to_canonical(CEIL(l_irr_pay_amt)),6,'0');
5234: ELSE

Line 5233: p_data_element_value:= lpad(fnd_number.number_to_canonical(CEIL(l_irr_pay_amt)),6,'0');

5229: );
5230: p_data_element_value:= lpad(fnd_number.number_to_canonical(CEIL(l_irr_pay_amt)),6,'0');
5231: /*--For yearly report round the irregular payment amount
5232: IF g_extract_params(p_business_group_id).extract_type='Y' THEN
5233: p_data_element_value:= lpad(fnd_number.number_to_canonical(CEIL(l_irr_pay_amt)),6,'0');
5234: ELSE
5235: p_data_element_value:=l_irr_pay_amt;
5236: END IF; */
5237:

Line 6185: p_data_element_value := Trim(To_Char(Fnd_Number.Canonical_To_Number

6181: ,p_date_earned
6182: ,p_error_message
6183: ,p_data_element_value);
6184: IF ISNUMBER(p_data_element_value) THEN
6185: p_data_element_value := Trim(To_Char(Fnd_Number.Canonical_To_Number
6186: (Nvl(p_data_element_value,'0'))
6187: ,'099999'));
6188: END IF;
6189: ELSIF(p_data_element_cd = 'PGGM_EE_NUM') THEN

Line 6197: p_data_element_value := Trim(To_Char(Fnd_Number.Canonical_To_Number

6193: ,p_date_earned
6194: ,p_error_message
6195: ,p_data_element_value);
6196: IF ISNUMBER(p_data_element_value) THEN
6197: p_data_element_value := Trim(To_Char(Fnd_Number.Canonical_To_Number
6198: (Nvl(p_data_element_value,'0'))
6199: ,'099'));
6200: END IF;
6201: ELSIF(p_data_element_cd = 'EE_NUM') THEN

Line 8018: l_trailer_new_rec.val_04 := lpad(fnd_number.number_to_canonical(l_010_count),6,'0');

8014:
8015: --Get the record count for 010
8016: l_010_count:=Get_Trailer_Record_Count(g_rcd_dtls(010).ext_rcd_id
8017: ,g_extract_params(p_business_group_id).org_id );
8018: l_trailer_new_rec.val_04 := lpad(fnd_number.number_to_canonical(l_010_count),6,'0');
8019: l_total_data_rcd_count:=l_total_data_rcd_count+l_010_count;
8020:
8021: --Get the record count for 020
8022: l_020_count:=Get_Trailer_Record_Count(g_rcd_dtls(020).ext_rcd_id

Line 8024: l_trailer_new_rec.val_05 := lpad(fnd_number.number_to_canonical(l_020_count),6,'0');

8020:
8021: --Get the record count for 020
8022: l_020_count:=Get_Trailer_Record_Count(g_rcd_dtls(020).ext_rcd_id
8023: ,g_extract_params(p_business_group_id).org_id );
8024: l_trailer_new_rec.val_05 := lpad(fnd_number.number_to_canonical(l_020_count),6,'0');
8025: l_total_data_rcd_count:=l_total_data_rcd_count+l_020_count;
8026:
8027: --Get the record count for 030
8028: l_030_count:=Get_Trailer_Record_Count(g_rcd_dtls(030).ext_rcd_id

Line 8030: l_trailer_new_rec.val_06 := lpad(fnd_number.number_to_canonical(l_030_count),6,'0');

8026:
8027: --Get the record count for 030
8028: l_030_count:=Get_Trailer_Record_Count(g_rcd_dtls(030).ext_rcd_id
8029: ,g_extract_params(p_business_group_id).org_id );
8030: l_trailer_new_rec.val_06 := lpad(fnd_number.number_to_canonical(l_030_count),6,'0');
8031: l_total_data_rcd_count:=l_total_data_rcd_count+l_030_count;
8032:
8033: --Get the record count for 040
8034: l_040_count:=Get_Trailer_Record_Count(g_rcd_dtls(040).ext_rcd_id

Line 8036: l_trailer_new_rec.val_07 := lpad(fnd_number.number_to_canonical(l_040_count),6,'0');

8032:
8033: --Get the record count for 040
8034: l_040_count:=Get_Trailer_Record_Count(g_rcd_dtls(040).ext_rcd_id
8035: ,g_extract_params(p_business_group_id).org_id );
8036: l_trailer_new_rec.val_07 := lpad(fnd_number.number_to_canonical(l_040_count),6,'0');
8037: l_total_data_rcd_count:=l_total_data_rcd_count+l_040_count;
8038:
8039:
8040: --Get the record count for 060

Line 8043: l_trailer_new_rec.val_09 := lpad(fnd_number.number_to_canonical(l_060_count),6,'0');

8039:
8040: --Get the record count for 060
8041: l_060_count:=Get_Trailer_Record_Count(g_rcd_dtls(060).ext_rcd_id
8042: ,g_extract_params(p_business_group_id).org_id );
8043: l_trailer_new_rec.val_09 := lpad(fnd_number.number_to_canonical(l_060_count),6,'0');
8044: l_total_data_rcd_count:=l_total_data_rcd_count+l_060_count;
8045:
8046: --Get the record count for 070
8047: l_070_count:=Get_Trailer_Record_Count(g_rcd_dtls(070).ext_rcd_id

Line 8049: l_trailer_new_rec.val_10 := lpad(fnd_number.number_to_canonical(l_070_count),6,'0');

8045:
8046: --Get the record count for 070
8047: l_070_count:=Get_Trailer_Record_Count(g_rcd_dtls(070).ext_rcd_id
8048: ,g_extract_params(p_business_group_id).org_id );
8049: l_trailer_new_rec.val_10 := lpad(fnd_number.number_to_canonical(l_070_count),6,'0');
8050: l_total_data_rcd_count:=l_total_data_rcd_count+l_070_count;
8051:
8052: --Get the record count for 080
8053: l_080_count:=Get_Trailer_Record_Count(g_rcd_dtls(080).ext_rcd_id

Line 8055: l_trailer_new_rec.val_11 := lpad(fnd_number.number_to_canonical(l_080_count),6,'0');

8051:
8052: --Get the record count for 080
8053: l_080_count:=Get_Trailer_Record_Count(g_rcd_dtls(080).ext_rcd_id
8054: ,g_extract_params(p_business_group_id).org_id );
8055: l_trailer_new_rec.val_11 := lpad(fnd_number.number_to_canonical(l_080_count),6,'0');
8056: l_total_data_rcd_count:=l_total_data_rcd_count+l_080_count;
8057:
8058: --Get the record count for 081
8059: l_081_count:=Get_Trailer_Record_Count(g_rcd_dtls(081).ext_rcd_id

Line 8061: l_trailer_new_rec.val_15 := lpad(fnd_number.number_to_canonical(l_081_count),6,'0');

8057:
8058: --Get the record count for 081
8059: l_081_count:=Get_Trailer_Record_Count(g_rcd_dtls(081).ext_rcd_id
8060: ,g_extract_params(p_business_group_id).org_id );
8061: l_trailer_new_rec.val_15 := lpad(fnd_number.number_to_canonical(l_081_count),6,'0');
8062: l_total_data_rcd_count:=l_total_data_rcd_count+l_081_count;
8063:
8064: --Set Total Data Record Count
8065: l_trailer_new_rec.val_03 := lpad(fnd_number.number_to_canonical(l_total_data_rcd_count),6,'0');

Line 8065: l_trailer_new_rec.val_03 := lpad(fnd_number.number_to_canonical(l_total_data_rcd_count),6,'0');

8061: l_trailer_new_rec.val_15 := lpad(fnd_number.number_to_canonical(l_081_count),6,'0');
8062: l_total_data_rcd_count:=l_total_data_rcd_count+l_081_count;
8063:
8064: --Set Total Data Record Count
8065: l_trailer_new_rec.val_03 := lpad(fnd_number.number_to_canonical(l_total_data_rcd_count),6,'0');
8066:
8067: END IF;
8068: --Set the primary sort value
8069: l_sort_val := Lpad(sort_val,15,0);