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.PAY_KR_YEA_PDF_PKG dependencies on FND_NUMBER

Line 320: and fl.file_id = fnd_number.canonical_to_number(pkayi.ayi_information15); /* ayi_information14 in ('I','U','E') */

316: and pp2.effective_end_date >= g_target_soy
317: and pp2.effective_start_date < pp.effective_start_date)
318: and nvl(ppos.final_process_date,g_target_eoy)
319: between g_target_soy and g_target_eoy
320: and fl.file_id = fnd_number.canonical_to_number(pkayi.ayi_information15); /* ayi_information14 in ('I','U','E') */
321: --
322: type t_pdf_tbl is table of csr_kr_ass_yea%rowtype index by binary_integer;
323: g_pdf_tbl t_pdf_tbl;
324: --

Line 720: fnd_number.canonical_to_number(pkayi.ayi_information15) file_id,

716: --
717: cursor csr_kr_ass_yea
718: is
719: select pkayi.assignment_yea_info_id,
720: fnd_number.canonical_to_number(pkayi.ayi_information15) file_id,
721: pkayi.object_version_number
722: from per_kr_assignment_yea_info pkayi
723: where pkayi.assignment_id = p_assignment_id
724: and pkayi.target_year = p_target_year

Line 762: ayi_information15 = fnd_number.number_to_canonical(p_file_id),

758: l_object_version_number := l_csr_kr_ass_yea.object_version_number + 1;
759: --
760: update per_kr_assignment_yea_info
761: set ayi_information14 = c_import_status,
762: ayi_information15 = fnd_number.number_to_canonical(p_file_id),
763: ayi_information16 = nvl(p_proc_status,ayi_information16),
764: object_version_number = l_object_version_number
765: where assignment_yea_info_id = l_csr_kr_ass_yea.assignment_yea_info_id;
766: --

Line 812: fnd_number.number_to_canonical(p_file_id),

808: p_target_year,
809: 'KR_YEA_ENTRY_STATUS',
810: c_entry_status,
811: c_import_status,
812: fnd_number.number_to_canonical(p_file_id),
813: p_proc_status,
814: l_object_version_number);
815: --
816: end if;

Line 3154: if fnd_number.canonical_to_number(p_information5) > to_number(l_limit) then

3150: p_glbvar => 'KR_YEA_HOUSINSAVINTYPE_HST1',
3151: p_process_date => p_information1,
3152: p_result => l_limit);
3153: --
3154: if fnd_number.canonical_to_number(p_information5) > to_number(l_limit) then
3155: --
3156: hr_utility.set_message(801,'PAY_KR_MAX_HOU_SUB_SAVING');
3157: hr_utility.set_message_token('LIMIT',l_limit);
3158: hr_utility.raise_error;

Line 4291: select max(fnd_number.canonical_to_number(nvl(ayi_information10,0)))

4287: l_csr_pkayi csr_pkayi%rowtype;
4288: --
4289: cursor csr_med_max_priority
4290: is
4291: select max(fnd_number.canonical_to_number(nvl(ayi_information10,0)))
4292: from per_kr_assignment_yea_info
4293: where assignment_id = p_assignment_id
4294: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
4295: and ayi_information_category = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'

Line 4301: '0',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) emp,

4297: --
4298: cursor csr_med_total_o
4299: is
4300: select sum(to_number(decode(ayi_information7,
4301: '0',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) emp,
4302: sum(to_number(decode(ayi_information7,
4303: '0',null,to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0))))) dep,
4304: sum(to_number(decode(ayi_information9,
4305: 'B',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) aged

Line 4303: '0',null,to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0))))) dep,

4299: is
4300: select sum(to_number(decode(ayi_information7,
4301: '0',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) emp,
4302: sum(to_number(decode(ayi_information7,
4303: '0',null,to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0))))) dep,
4304: sum(to_number(decode(ayi_information9,
4305: 'B',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) aged
4306: from per_kr_assignment_yea_info
4307: where assignment_id = p_assignment_id

Line 4305: 'B',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) aged

4301: '0',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) emp,
4302: sum(to_number(decode(ayi_information7,
4303: '0',null,to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0))))) dep,
4304: sum(to_number(decode(ayi_information9,
4305: 'B',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0) + nvl(fnd_number.canonical_to_number(ayi_information11),0)),null))) aged
4306: from per_kr_assignment_yea_info
4307: where assignment_id = p_assignment_id
4308: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
4309: and ayi_information_category = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'

Line 4318: '10',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) statutory,

4314: --
4315: cursor csr_don_total
4316: is
4317: select sum(to_number(decode(ayi_information5,
4318: '10',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) statutory,
4319: sum(to_number(decode(ayi_information5,
4320: '20',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) political,
4321: sum(to_number(decode(ayi_information5,
4322: '21',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) promotional,

Line 4320: '20',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) political,

4316: is
4317: select sum(to_number(decode(ayi_information5,
4318: '10',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) statutory,
4319: sum(to_number(decode(ayi_information5,
4320: '20',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) political,
4321: sum(to_number(decode(ayi_information5,
4322: '21',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) promotional,
4323: sum(to_number(decode(ayi_information5,
4324: '30',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) special,

Line 4322: '21',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) promotional,

4318: '10',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) statutory,
4319: sum(to_number(decode(ayi_information5,
4320: '20',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) political,
4321: sum(to_number(decode(ayi_information5,
4322: '21',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) promotional,
4323: sum(to_number(decode(ayi_information5,
4324: '30',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) special,
4325: sum(to_number(decode(ayi_information5,
4326: '31',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) publicLegal,

Line 4324: '30',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) special,

4320: '20',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) political,
4321: sum(to_number(decode(ayi_information5,
4322: '21',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) promotional,
4323: sum(to_number(decode(ayi_information5,
4324: '30',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) special,
4325: sum(to_number(decode(ayi_information5,
4326: '31',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) publicLegal,
4327: sum(to_number(decode(ayi_information5,
4328: '40',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) specified,

Line 4326: '31',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) publicLegal,

4322: '21',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) promotional,
4323: sum(to_number(decode(ayi_information5,
4324: '30',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) special,
4325: sum(to_number(decode(ayi_information5,
4326: '31',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) publicLegal,
4327: sum(to_number(decode(ayi_information5,
4328: '40',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) specified,
4329: sum(to_number(decode(ayi_information5,
4330: '41',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) religious,

Line 4328: '40',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) specified,

4324: '30',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) special,
4325: sum(to_number(decode(ayi_information5,
4326: '31',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) publicLegal,
4327: sum(to_number(decode(ayi_information5,
4328: '40',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) specified,
4329: sum(to_number(decode(ayi_information5,
4330: '41',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) religious,
4331: sum(to_number(decode(ayi_information5,
4332: '42',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) esoa,

Line 4330: '41',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) religious,

4326: '31',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) publicLegal,
4327: sum(to_number(decode(ayi_information5,
4328: '40',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) specified,
4329: sum(to_number(decode(ayi_information5,
4330: '41',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) religious,
4331: sum(to_number(decode(ayi_information5,
4332: '42',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) esoa,
4333: sum(to_number(decode(ayi_information5,
4334: '50',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) other

Line 4332: '42',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) esoa,

4328: '40',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) specified,
4329: sum(to_number(decode(ayi_information5,
4330: '41',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) religious,
4331: sum(to_number(decode(ayi_information5,
4332: '42',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) esoa,
4333: sum(to_number(decode(ayi_information5,
4334: '50',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) other
4335: from per_kr_assignment_yea_info
4336: where assignment_id = p_assignment_id

Line 4334: '50',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) other

4330: '41',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) religious,
4331: sum(to_number(decode(ayi_information5,
4332: '42',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) esoa,
4333: sum(to_number(decode(ayi_information5,
4334: '50',to_char(nvl(fnd_number.canonical_to_number(ayi_information3),0)),null))) other
4335: from per_kr_assignment_yea_info
4336: where assignment_id = p_assignment_id
4337: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
4338: and ayi_information_category = 'KR_YEA_DETAIL_DONATION_INFO'

Line 4346: '1',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) employment,

4342: --
4343: cursor csr_sep_pen_total
4344: is
4345: select sum(to_number(decode(ayi_information2,
4346: '1',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) employment,
4347: sum(to_number(decode(ayi_information2,
4348: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) scientific
4349: from per_kr_assignment_yea_info
4350: where assignment_id = p_assignment_id

Line 4348: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) scientific

4344: is
4345: select sum(to_number(decode(ayi_information2,
4346: '1',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) employment,
4347: sum(to_number(decode(ayi_information2,
4348: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) scientific
4349: from per_kr_assignment_yea_info
4350: where assignment_id = p_assignment_id
4351: and information_type = 'KR_YEA_SEP_PEN_DETAILS'
4352: and ayi_information_category = 'KR_YEA_SEP_PEN_DETAILS'

Line 4360: '1',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year1,

4356: --
4357: cursor csr_lts_total
4358: is
4359: select sum(to_number(decode(ayi_information2,
4360: '1',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year1,
4361: sum(to_number(decode(ayi_information2,
4362: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year2,
4363: sum(to_number(decode(ayi_information2,
4364: '3',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year3

Line 4362: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year2,

4358: is
4359: select sum(to_number(decode(ayi_information2,
4360: '1',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year1,
4361: sum(to_number(decode(ayi_information2,
4362: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year2,
4363: sum(to_number(decode(ayi_information2,
4364: '3',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year3
4365: from per_kr_assignment_yea_info
4366: where assignment_id = p_assignment_id

Line 4364: '3',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year3

4360: '1',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year1,
4361: sum(to_number(decode(ayi_information2,
4362: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year2,
4363: sum(to_number(decode(ayi_information2,
4364: '3',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) year3
4365: from per_kr_assignment_yea_info
4366: where assignment_id = p_assignment_id
4367: and information_type = 'KR_YEA_LT_STOCK_SAVING_DETAILS'
4368: and ayi_information_category = 'KR_YEA_LT_STOCK_SAVING_DETAILS'

Line 4376: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) pen_saving

4372: --
4373: cursor csr_pen_total
4374: is
4375: select sum(to_number(decode(ayi_information2,
4376: '2',to_char(nvl(fnd_number.canonical_to_number(ayi_information5),0)),null))) pen_saving
4377: from per_kr_assignment_yea_info
4378: where assignment_id = p_assignment_id
4379: and information_type = 'KR_YEA_PEN_SAVING_DETAILS'
4380: and ayi_information_category = 'KR_YEA_PEN_SAVING_DETAILS'

Line 4464: l_ass_data_rec.pers_ins_prem := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.pers_ins_prem),0)

4460: --
4461: -- accumulate for only person
4462: if l_values_tbl(a01cnt).key = l_ni_num then
4463: --
4464: l_ass_data_rec.pers_ins_prem := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.pers_ins_prem),0)
4465: + nvl(to_number(l_values_tbl(a01cnt).val),0));
4466: --
4467: else
4468: --

Line 4505: l_ass_data_rec.disabled_ins_prem := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.disabled_ins_prem),0)

4501: --
4502: -- accumulate for only person
4503: if l_values_tbl(a02cnt).key = l_ni_num then
4504: --
4505: l_ass_data_rec.disabled_ins_prem := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.disabled_ins_prem),0)
4506: + nvl(to_number(l_values_tbl(a02cnt).val),0));
4507: --
4508: else
4509: --

Line 4544: l_ass_data_rec.housing_loan_repay := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.housing_loan_repay),0)

4540: if l_value_tbl.count > 0 then
4541: --
4542: for j01cnt in l_value_tbl.first..l_value_tbl.last loop
4543: --
4544: l_ass_data_rec.housing_loan_repay := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.housing_loan_repay),0)
4545: + nvl(to_number(l_value_tbl(j01cnt)),0));
4546: --
4547: end loop;
4548: --

Line 4606: l_ass_data_rec.lt_housing_loan_interest_rep := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_housing_loan_interest_rep),0)

4602: if l_lthouse_tbl(j02cnt).key is not null then
4603: --
4604: if to_number(l_lthouse_tbl(j02cnt).key) < c_int_type1_year_min then
4605: --
4606: l_ass_data_rec.lt_housing_loan_interest_rep := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_housing_loan_interest_rep),0)
4607: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));
4608: --
4609: elsif to_number(l_lthouse_tbl(j02cnt).key) >= c_int_type1_year_min
4610: and to_number(l_lthouse_tbl(j02cnt).key) < c_int_type2_year_min then

Line 4612: l_ass_data_rec.lt_housing_loan_int_repay_1 := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_housing_loan_int_repay_1),0)

4608: --
4609: elsif to_number(l_lthouse_tbl(j02cnt).key) >= c_int_type1_year_min
4610: and to_number(l_lthouse_tbl(j02cnt).key) < c_int_type2_year_min then
4611: --
4612: l_ass_data_rec.lt_housing_loan_int_repay_1 := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_housing_loan_int_repay_1),0)
4613: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));
4614: --
4615: elsif to_number(l_lthouse_tbl(j02cnt).key) >= c_int_type2_year_min then
4616: --

Line 4617: l_ass_data_rec.lt_housing_loan_int_repay_2 := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_housing_loan_int_repay_2),0)

4613: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));
4614: --
4615: elsif to_number(l_lthouse_tbl(j02cnt).key) >= c_int_type2_year_min then
4616: --
4617: l_ass_data_rec.lt_housing_loan_int_repay_2 := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_housing_loan_int_repay_2),0)
4618: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));
4619: --
4620: end if;
4621: --

Line 4629: l_ass_data_rec.lt_2012_housing_other_intr := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_2012_housing_other_intr),0)

4625: nvl(to_number(l_lthouse_tbl(j02cnt).fixed_rate),0) = 0 and
4626: nvl(to_number(l_lthouse_tbl(j02cnt).defer_debt),0) = 0 and
4627: nvl(to_number(l_lthouse_tbl(j02cnt).year_amt),0) = 0 and
4628: to_number(l_lthouse_tbl(j02cnt).val) is not null) then
4629: l_ass_data_rec.lt_2012_housing_other_intr := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_2012_housing_other_intr),0)
4630: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));
4631: else
4632: l_ass_data_rec.lt_2012_fixed_intr_wo_grace := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_2012_fixed_intr_wo_grace),0)
4633: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));

Line 4632: l_ass_data_rec.lt_2012_fixed_intr_wo_grace := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_2012_fixed_intr_wo_grace),0)

4628: to_number(l_lthouse_tbl(j02cnt).val) is not null) then
4629: l_ass_data_rec.lt_2012_housing_other_intr := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_2012_housing_other_intr),0)
4630: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));
4631: else
4632: l_ass_data_rec.lt_2012_fixed_intr_wo_grace := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.lt_2012_fixed_intr_wo_grace),0)
4633: + nvl(to_number(l_lthouse_tbl(j02cnt).val),0));
4634: end if;
4635:
4636: END IF;

Line 4661: l_ass_data_rec.med_exp_aged := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp_aged),0)

4657: if l_values_tbl(b01cnt).key = l_ni_num then
4658: --
4659: if pay_kr_ff_functions_pkg.aged_flag(l_values_tbl(b01cnt).key,g_target_eoy) = 'Y' then
4660: --
4661: l_ass_data_rec.med_exp_aged := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp_aged),0)
4662: + nvl(to_number(l_values_tbl(b01cnt).val),0));
4663: --
4664: l_med_tbl(l_med_ind).paid_amount := to_number(l_values_tbl(b01cnt).val);
4665: l_med_tbl(l_med_ind).source_code := '1'; /* KR_YEA_SOURCE_CODE */

Line 4671: l_ass_data_rec.med_exp_emp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp_emp),0)

4667: l_med_tbl(l_med_ind).disabled_or_aged := 'B'; /* KR_DISABLED_OR_AGED */
4668: --
4669: else
4670: --
4671: l_ass_data_rec.med_exp_emp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp_emp),0)
4672: + nvl(to_number(l_values_tbl(b01cnt).val),0));
4673: --
4674: l_med_tbl(l_med_ind).paid_amount := to_number(l_values_tbl(b01cnt).val);
4675: l_med_tbl(l_med_ind).source_code := '1'; /* KR_YEA_SOURCE_CODE */

Line 4687: l_ass_data_rec.med_exp_aged := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp_aged),0)

4683: else
4684: --
4685: if pay_kr_ff_functions_pkg.aged_flag(l_values_tbl(b01cnt).key,g_target_eoy) = 'Y' then
4686: --
4687: l_ass_data_rec.med_exp_aged := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp_aged),0)
4688: + nvl(to_number(l_values_tbl(b01cnt).val),0));
4689: --
4690: l_med_tbl(l_med_ind).paid_amount := to_number(l_values_tbl(b01cnt).val);
4691: l_med_tbl(l_med_ind).source_code := '1'; /* KR_YEA_SOURCE_CODE */

Line 4697: l_ass_data_rec.med_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp),0)

4693: l_med_tbl(l_med_ind).disabled_or_aged := 'B'; /* KR_DISABLED_OR_AGED */
4694: --
4695: else
4696: --
4697: l_ass_data_rec.med_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.med_exp),0)
4698: + nvl(to_number(l_values_tbl(b01cnt).val),0));
4699: --
4700: l_med_tbl(l_med_ind).paid_amount := to_number(l_values_tbl(b01cnt).val);
4701: l_med_tbl(l_med_ind).source_code := '1'; /* KR_YEA_SOURCE_CODE */

Line 4760: l_don_tbl(l_don_ind).donated_amount := fnd_number.number_to_canonical(l_don_poli

4756: l_don_tbl(l_don_ind).donation_code := l_don_tbl_tmp(l01cnt).donation_code;
4757: l_don_tbl(l_don_ind).donated_date := fnd_date.date_to_canonical(to_date(l_don_tbl_tmp(l01cnt).donated_date,c_xml_date_fmt)); /* covert to canonical from xml fmt */
4758: l_don_tbl(l_don_ind).recipient_name := l_don_tbl_tmp(l01cnt).recipient_name;
4759: l_don_tbl(l_don_ind).recipient_registration_number := l_don_tbl_tmp(l01cnt).recipient_registration_number;
4760: l_don_tbl(l_don_ind).donated_amount := fnd_number.number_to_canonical(l_don_poli
4761: + nvl(to_number(nvl(l_don_tbl_tmp(l01cnt).donated_amount,l_don_tbl_tmp(l01cnt).sum)),0)
4762: /*- c_don_poli_max*/);
4763: l_don_tbl(l_don_ind).donation_detail_type := '1'; /* KR_YEA_DONATION_DETAIL_TYPE */
4764: l_don_ind := l_don_ind + 1;

Line 4778: l_don_tbl(l_don_ind).donated_amount := fnd_number.number_to_canonical(to_number(nvl(l_don_tbl_tmp(l01cnt).donated_amount,l_don_tbl_tmp(l01cnt).sum)));

4774: l_don_tbl(l_don_ind).donation_code := l_don_tbl_tmp(l01cnt).donation_code;
4775: l_don_tbl(l_don_ind).donated_date := fnd_date.date_to_canonical(to_date(l_don_tbl_tmp(l01cnt).donated_date,c_xml_date_fmt));
4776: l_don_tbl(l_don_ind).recipient_name := l_don_tbl_tmp(l01cnt).recipient_name;
4777: l_don_tbl(l_don_ind).recipient_registration_number := l_don_tbl_tmp(l01cnt).recipient_registration_number;
4778: l_don_tbl(l_don_ind).donated_amount := fnd_number.number_to_canonical(to_number(nvl(l_don_tbl_tmp(l01cnt).donated_amount,l_don_tbl_tmp(l01cnt).sum)));
4779: l_don_tbl(l_don_ind).donation_detail_type := '1'; /* KR_YEA_DONATION_DETAIL_TYPE */
4780: l_don_ind := l_don_ind + 1;
4781: --
4782: end if;

Line 4795: l_don_tbl(l_don_ind).donated_amount := fnd_number.number_to_canonical(to_number(nvl(l_don_tbl_tmp(l01cnt).donated_amount,l_don_tbl_tmp(l01cnt).sum)));

4791: l_don_tbl(l_don_ind).donation_code := l_don_tbl_tmp(l01cnt).donation_code;
4792: l_don_tbl(l_don_ind).donated_date := fnd_date.date_to_canonical(to_date(l_don_tbl_tmp(l01cnt).donated_date,c_xml_date_fmt));
4793: l_don_tbl(l_don_ind).recipient_name := l_don_tbl_tmp(l01cnt).recipient_name;
4794: l_don_tbl(l_don_ind).recipient_registration_number := l_don_tbl_tmp(l01cnt).recipient_registration_number;
4795: l_don_tbl(l_don_ind).donated_amount := fnd_number.number_to_canonical(to_number(nvl(l_don_tbl_tmp(l01cnt).donated_amount,l_don_tbl_tmp(l01cnt).sum)));
4796: l_don_tbl(l_don_ind).donation_detail_type := '1'; /* KR_YEA_DONATION_DETAIL_TYPE */
4797: l_don_ind := l_don_ind + 1;
4798: --
4799: begin

Line 4846: l_ass_data_rec.ee_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)

4842: --
4843: -- accumulate for only person
4844: if l_values_tbl(c01cnt).key = l_ni_num then
4845: --
4846: l_ass_data_rec.ee_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)
4847: + nvl(to_number(l_values_tbl(c01cnt).val),0));
4848: --
4849: else
4850: --

Line 4886: l_ass_data_rec.ee_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)

4882: --
4883: -- accumulate for only person
4884: if l_values_tbl(c03cnt).key = l_ni_num then
4885: --
4886: l_ass_data_rec.ee_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)
4887: + nvl(to_number(l_values_tbl(c03cnt).val),0));
4888: --
4889: else
4890: --

Line 4926: l_ass_data_rec.ee_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)

4922: --
4923: -- accumulate for only person
4924: if l_values_tbl(c04cnt).key = l_ni_num then
4925: --
4926: l_ass_data_rec.ee_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)
4927: + nvl(to_number(l_values_tbl(c04cnt).val),0));
4928: --
4929: else
4930: --

Line 4967: l_ass_data_rec.ee_occupation_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_occupation_educ_exp),0)

4963: --
4964: -- accumulate for only person
4965: if l_values_tbl(c02cnt).key = l_ni_num then
4966: --
4967: l_ass_data_rec.ee_occupation_educ_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_occupation_educ_exp),0)
4968: + nvl(to_number(l_values_tbl(c02cnt).val),0));
4969: --
4970: end if;
4971: --

Line 5002: l_ass_data_rec.ee_uniform_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)

4998: --
4999: -- accumulate for only person
5000: if l_uniform_tbl(c06cnt).key = l_ni_num then
5001: --
5002: l_ass_data_rec.ee_uniform_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)
5003: + nvl(to_number(l_uniform_tbl(c06cnt).val),0));
5004: --
5005: else
5006: --

Line 5045: l_ass_data_rec.pers_pension_prem := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.pers_pension_prem),0)

5041: if l_value_tbl.count > 0 then
5042: --
5043: for d01cnt in l_value_tbl.first..l_value_tbl.last loop
5044: --
5045: l_ass_data_rec.pers_pension_prem := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.pers_pension_prem),0)
5046: + nvl(to_number(l_value_tbl(d01cnt)),0));
5047: --
5048: end loop;
5049: --

Line 5065: l_ass_data_rec.small_bus_install := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.small_bus_install),0)

5061: if l_value_tbl.count > 0 then
5062: --
5063: for k01cnt in l_value_tbl.first..l_value_tbl.last loop
5064: --
5065: l_ass_data_rec.small_bus_install := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.small_bus_install),0)
5066: + nvl(to_number(l_value_tbl(k01cnt)),0));
5067: --
5068: end loop;
5069: --

Line 5090: l_ass_data_rec.credit_card_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.credit_card_exp),0)

5086: -- accumulate for only person
5087: if l_cards_tbl(g01cnt).key = l_ni_num then
5088: --
5089: if l_cards_tbl(g01cnt).use_place_cd = 1 then
5090: l_ass_data_rec.credit_card_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.credit_card_exp),0)
5091: + nvl(to_number(l_cards_tbl(g01cnt).val),0));
5092: else
5093: l_ass_data_rec.credit_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.credit_tm_exp),0)
5094: + nvl(to_number(l_cards_tbl(g01cnt).val),0));

Line 5093: l_ass_data_rec.credit_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.credit_tm_exp),0)

5089: if l_cards_tbl(g01cnt).use_place_cd = 1 then
5090: l_ass_data_rec.credit_card_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.credit_card_exp),0)
5091: + nvl(to_number(l_cards_tbl(g01cnt).val),0));
5092: else
5093: l_ass_data_rec.credit_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.credit_tm_exp),0)
5094: + nvl(to_number(l_cards_tbl(g01cnt).val),0));
5095: end if;
5096: else
5097: --

Line 5144: l_ass_data_rec.cash_receipt_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.cash_receipt_exp),0)

5140: -- accumulate for only person
5141: if l_cards_tbl(g02cnt).key = l_ni_num then
5142: --
5143: if l_cards_tbl(g02cnt).use_place_cd = 1 then
5144: l_ass_data_rec.cash_receipt_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.cash_receipt_exp),0)
5145: + nvl(to_number(l_cards_tbl(g02cnt).val),0));
5146: else
5147: l_ass_data_rec.cash_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.cash_tm_exp),0)
5148: + nvl(to_number(l_cards_tbl(g02cnt).val),0));

Line 5147: l_ass_data_rec.cash_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.cash_tm_exp),0)

5143: if l_cards_tbl(g02cnt).use_place_cd = 1 then
5144: l_ass_data_rec.cash_receipt_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.cash_receipt_exp),0)
5145: + nvl(to_number(l_cards_tbl(g02cnt).val),0));
5146: else
5147: l_ass_data_rec.cash_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.cash_tm_exp),0)
5148: + nvl(to_number(l_cards_tbl(g02cnt).val),0));
5149: end if;
5150: --
5151: else

Line 5198: l_ass_data_rec.direct_card_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.direct_card_exp),0)

5194: -- accumulate for only person
5195: if l_cards_tbl(g03cnt).key = l_ni_num then
5196: --
5197: if l_cards_tbl(g03cnt).use_place_cd = 1 then
5198: l_ass_data_rec.direct_card_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.direct_card_exp),0)
5199: + nvl(to_number(l_cards_tbl(g03cnt).val),0));
5200: else
5201: l_ass_data_rec.direct_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.direct_tm_exp),0)
5202: + nvl(to_number(l_cards_tbl(g03cnt).val),0));

Line 5201: l_ass_data_rec.direct_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.direct_tm_exp),0)

5197: if l_cards_tbl(g03cnt).use_place_cd = 1 then
5198: l_ass_data_rec.direct_card_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.direct_card_exp),0)
5199: + nvl(to_number(l_cards_tbl(g03cnt).val),0));
5200: else
5201: l_ass_data_rec.direct_tm_exp := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.direct_tm_exp),0)
5202: + nvl(to_number(l_cards_tbl(g03cnt).val),0));
5203: end if;
5204: --
5205: else

Line 5253: l_sep_pen_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));

5249: if l_saving_tbl.count > 0 then
5250: --
5251: for f01cnt in l_saving_tbl.first..l_saving_tbl.last loop
5252: --
5253: l_sep_pen_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5254: l_sep_pen_saving_tbl(l_saving_ind).type := l_saving_tbl(f01cnt).type;
5255: l_sep_pen_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(f01cnt).financial_inst;
5256: l_sep_pen_saving_tbl(l_saving_ind).account_num := l_saving_tbl(f01cnt).account_num;
5257: l_sep_pen_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(f01cnt).contributed_amt));

Line 5257: l_sep_pen_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(f01cnt).contributed_amt));

5253: l_sep_pen_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5254: l_sep_pen_saving_tbl(l_saving_ind).type := l_saving_tbl(f01cnt).type;
5255: l_sep_pen_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(f01cnt).financial_inst;
5256: l_sep_pen_saving_tbl(l_saving_ind).account_num := l_saving_tbl(f01cnt).account_num;
5257: l_sep_pen_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(f01cnt).contributed_amt));
5258: l_saving_ind := l_saving_ind + 1;
5259: --
5260: end loop;
5261: --

Line 5283: l_pen_saving_tbl(l_pen_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_pen_saving_ind + 1));

5279: if l_saving_tbl.count > 0 then
5280: --
5281: for d01cnt in l_saving_tbl.first..l_saving_tbl.last loop
5282: --
5283: l_pen_saving_tbl(l_pen_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_pen_saving_ind + 1));
5284: l_pen_saving_tbl(l_pen_saving_ind).type := '1'; /* KR_YEA_PEN_SAVING_TYPES */
5285: l_pen_saving_tbl(l_pen_saving_ind).financial_inst := l_saving_tbl(d01cnt).financial_inst;
5286: l_pen_saving_tbl(l_pen_saving_ind).account_num := l_saving_tbl(d01cnt).account_num;
5287: l_pen_saving_tbl(l_pen_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(d01cnt).contributed_amt));

Line 5287: l_pen_saving_tbl(l_pen_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(d01cnt).contributed_amt));

5283: l_pen_saving_tbl(l_pen_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_pen_saving_ind + 1));
5284: l_pen_saving_tbl(l_pen_saving_ind).type := '1'; /* KR_YEA_PEN_SAVING_TYPES */
5285: l_pen_saving_tbl(l_pen_saving_ind).financial_inst := l_saving_tbl(d01cnt).financial_inst;
5286: l_pen_saving_tbl(l_pen_saving_ind).account_num := l_saving_tbl(d01cnt).account_num;
5287: l_pen_saving_tbl(l_pen_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(d01cnt).contributed_amt));
5288: l_pen_saving_ind := l_pen_saving_ind + 1;
5289: --
5290: end loop;
5291: --

Line 5303: l_pen_saving_tbl(l_pen_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_pen_saving_ind + 1));

5299: if l_saving_tbl.count > 0 then
5300: --
5301: for e01cnt in l_saving_tbl.first..l_saving_tbl.last loop
5302: --
5303: l_pen_saving_tbl(l_pen_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_pen_saving_ind + 1));
5304: l_pen_saving_tbl(l_pen_saving_ind).type := '2'; /* KR_YEA_PEN_SAVING_TYPES */
5305: l_pen_saving_tbl(l_pen_saving_ind).financial_inst := l_saving_tbl(e01cnt).financial_inst;
5306: l_pen_saving_tbl(l_pen_saving_ind).account_num := l_saving_tbl(e01cnt).account_num;
5307: l_pen_saving_tbl(l_pen_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(e01cnt).contributed_amt));

Line 5307: l_pen_saving_tbl(l_pen_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(e01cnt).contributed_amt));

5303: l_pen_saving_tbl(l_pen_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_pen_saving_ind + 1));
5304: l_pen_saving_tbl(l_pen_saving_ind).type := '2'; /* KR_YEA_PEN_SAVING_TYPES */
5305: l_pen_saving_tbl(l_pen_saving_ind).financial_inst := l_saving_tbl(e01cnt).financial_inst;
5306: l_pen_saving_tbl(l_pen_saving_ind).account_num := l_saving_tbl(e01cnt).account_num;
5307: l_pen_saving_tbl(l_pen_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(e01cnt).contributed_amt));
5308: l_pen_saving_ind := l_pen_saving_ind + 1;
5309: --
5310: end loop;
5311: --

Line 5336: l_hou_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));

5332: if l_saving_tbl.count > 0 then
5333: --
5334: for j03cnt in l_saving_tbl.first..l_saving_tbl.last loop
5335: --
5336: l_hou_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5337: l_hou_saving_tbl(l_saving_ind).type := l_saving_tbl(j03cnt).type;
5338: l_hou_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(j03cnt).financial_inst;
5339: l_hou_saving_tbl(l_saving_ind).account_num := l_saving_tbl(j03cnt).account_num;
5340: l_hou_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(j03cnt).contributed_amt));

Line 5340: l_hou_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(j03cnt).contributed_amt));

5336: l_hou_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5337: l_hou_saving_tbl(l_saving_ind).type := l_saving_tbl(j03cnt).type;
5338: l_hou_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(j03cnt).financial_inst;
5339: l_hou_saving_tbl(l_saving_ind).account_num := l_saving_tbl(j03cnt).account_num;
5340: l_hou_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(j03cnt).contributed_amt));
5341: l_saving_ind := l_saving_ind + 1;
5342: --
5343: end loop;
5344: --

Line 5371: l_lts_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));

5367: for m01cnt in l_saving_tbl.first..l_saving_tbl.last loop
5368: --
5369: if l_saving_tbl(m01cnt).cont_amt_y2 > 0 then
5370: --
5371: l_lts_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5372: l_lts_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(m01cnt).financial_inst;
5373: l_lts_saving_tbl(l_saving_ind).account_num := l_saving_tbl(m01cnt).account_num;
5374: l_lts_saving_tbl(l_saving_ind).type := '2'; /* KR_YEA_LT_STOCK_SAVING_YEAR */
5375: l_lts_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(m01cnt).cont_amt_y2));

Line 5375: l_lts_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(m01cnt).cont_amt_y2));

5371: l_lts_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5372: l_lts_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(m01cnt).financial_inst;
5373: l_lts_saving_tbl(l_saving_ind).account_num := l_saving_tbl(m01cnt).account_num;
5374: l_lts_saving_tbl(l_saving_ind).type := '2'; /* KR_YEA_LT_STOCK_SAVING_YEAR */
5375: l_lts_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(m01cnt).cont_amt_y2));
5376: l_saving_ind := l_saving_ind + 1;
5377: --
5378: end if;
5379: --

Line 5382: l_lts_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));

5378: end if;
5379: --
5380: if l_saving_tbl(m01cnt).cont_amt_y3 > 0 then
5381: --
5382: l_lts_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5383: l_lts_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(m01cnt).financial_inst;
5384: l_lts_saving_tbl(l_saving_ind).account_num := l_saving_tbl(m01cnt).account_num;
5385: l_lts_saving_tbl(l_saving_ind).type := '3'; /* KR_YEA_LT_STOCK_SAVING_YEAR */
5386: l_lts_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(m01cnt).cont_amt_y3));

Line 5386: l_lts_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(m01cnt).cont_amt_y3));

5382: l_lts_saving_tbl(l_saving_ind).priority := fnd_number.number_to_canonical(c_priority_inc * (l_saving_ind + 1));
5383: l_lts_saving_tbl(l_saving_ind).financial_inst := l_saving_tbl(m01cnt).financial_inst;
5384: l_lts_saving_tbl(l_saving_ind).account_num := l_saving_tbl(m01cnt).account_num;
5385: l_lts_saving_tbl(l_saving_ind).type := '3'; /* KR_YEA_LT_STOCK_SAVING_YEAR */
5386: l_lts_saving_tbl(l_saving_ind).contributed_amt := fnd_number.number_to_canonical(to_number(l_saving_tbl(m01cnt).cont_amt_y3));
5387: l_saving_ind := l_saving_ind + 1;
5388: --
5389: end if;
5390: --

Line 5408: l_ass_data_rec.ins_exp_nts := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.pers_ins_prem),0)

5404: --
5405: -- <>
5406: --
5407: -- NTS
5408: l_ass_data_rec.ins_exp_nts := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.pers_ins_prem),0)
5409: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.disabled_ins_prem),0));
5410: --
5411: if l_ass_data_rec.ins_exp_nts = 0 then
5412: --

Line 5409: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.disabled_ins_prem),0));

5405: -- <>
5406: --
5407: -- NTS
5408: l_ass_data_rec.ins_exp_nts := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.pers_ins_prem),0)
5409: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.disabled_ins_prem),0));
5410: --
5411: if l_ass_data_rec.ins_exp_nts = 0 then
5412: --
5413: l_ass_data_rec.ins_exp_nts := null;

Line 5422: l_ass_data_rec.med_exp_nts := fnd_number.number_to_canonical(l_med_exp_nts);

5418: --
5419: -- NTS
5420: if l_med_exp_nts <> 0 then
5421: --
5422: l_ass_data_rec.med_exp_nts := fnd_number.number_to_canonical(l_med_exp_nts);
5423: --
5424: end if;
5425: --
5426: -- <>

Line 5429: l_ass_data_rec.educ_exp_nts := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)

5425: --
5426: -- <>
5427: --
5428: -- NTS
5429: l_ass_data_rec.educ_exp_nts := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)
5430: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_uniform_exp),0)
5431: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_occupation_educ_exp),0));
5432: --
5433: if l_ass_data_rec.educ_exp_nts = 0 then

Line 5430: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_uniform_exp),0)

5426: -- <>
5427: --
5428: -- NTS
5429: l_ass_data_rec.educ_exp_nts := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)
5430: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_uniform_exp),0)
5431: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_occupation_educ_exp),0));
5432: --
5433: if l_ass_data_rec.educ_exp_nts = 0 then
5434: --

Line 5431: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_occupation_educ_exp),0));

5427: --
5428: -- NTS
5429: l_ass_data_rec.educ_exp_nts := fnd_number.number_to_canonical(nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_educ_exp),0)
5430: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_uniform_exp),0)
5431: + nvl(fnd_number.canonical_to_number(l_ass_data_rec.ee_occupation_educ_exp),0));
5432: --
5433: if l_ass_data_rec.educ_exp_nts = 0 then
5434: --
5435: l_ass_data_rec.educ_exp_nts := null;

Line 5456: l_ass_data_rec.don_exp_nts := fnd_number.number_to_canonical(l_don_exp_nts);

5452: --
5453: -- NTS
5454: if l_don_exp_nts <> 0 then
5455: --
5456: l_ass_data_rec.don_exp_nts := fnd_number.number_to_canonical(l_don_exp_nts);
5457: --
5458: end if;
5459: --
5460: -- --------------------------------------------------

Line 5616: p_information10 => fnd_number.number_to_canonical(l_max_priority + c_priority_inc * (i + 1)),

5612: p_information3 => l_ass_med_tbl(i).paid_amount,
5613: p_information7 => get_relship(p_assignment_id,'KR_YEA_DETAIL_MEDICAL_EXP_INFO',l_ass_med_tbl(i).resident_registration_no),
5614: p_information8 => cnv_reg(l_ass_med_tbl(i).resident_registration_no),
5615: p_information9 => l_ass_med_tbl(i).disabled_or_aged,
5616: p_information10 => fnd_number.number_to_canonical(l_max_priority + c_priority_inc * (i + 1)),
5617: p_information13 => l_ass_med_tbl(i).source_code,
5618: p_assignment_yea_info_id => l_assignment_yea_info_id);
5619: --
5620: end loop;

Line 6288: p_information1 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts),

6284: p_information_type => 'KR_DPNT_EXPENSE_INFO',
6285: p_emp_num => p_emp_num,
6286: p_emp_name => p_emp_name,
6287: p_con_ni => l_ass_dpnt_ind_tbl(i),
6288: p_information1 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts),
6289: p_information3 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts),
6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),
6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),

Line 6289: p_information3 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts),

6285: p_emp_num => p_emp_num,
6286: p_emp_name => p_emp_name,
6287: p_con_ni => l_ass_dpnt_ind_tbl(i),
6288: p_information1 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts),
6289: p_information3 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts),
6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),
6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),

Line 6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),

6286: p_emp_name => p_emp_name,
6287: p_con_ni => l_ass_dpnt_ind_tbl(i),
6288: p_information1 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts),
6289: p_information3 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts),
6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),
6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),

Line 6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),

6287: p_con_ni => l_ass_dpnt_ind_tbl(i),
6288: p_information1 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts),
6289: p_information3 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts),
6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),
6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),

Line 6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),

6288: p_information1 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts),
6289: p_information3 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts),
6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),
6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),
6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),

Line 6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),

6289: p_information3 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts),
6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),
6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),
6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),
6297: p_information20 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_tm_nts),

Line 6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),

6290: p_information5 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts),
6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),
6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),
6297: p_information20 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_tm_nts),
6298: p_information21 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_tm_nts),

Line 6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),

6291: p_information7 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts),
6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),
6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),
6297: p_information20 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_tm_nts),
6298: p_information21 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_tm_nts),
6299: p_contact_extra_info_id => l_contact_extra_info_id);

Line 6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),

6292: p_information9 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts),
6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),
6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),
6297: p_information20 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_tm_nts),
6298: p_information21 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_tm_nts),
6299: p_contact_extra_info_id => l_contact_extra_info_id);
6300: --

Line 6297: p_information20 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_tm_nts),

6293: p_information10 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts),
6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),
6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),
6297: p_information20 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_tm_nts),
6298: p_information21 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_tm_nts),
6299: p_contact_extra_info_id => l_contact_extra_info_id);
6300: --
6301: end if;

Line 6298: p_information21 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_tm_nts),

6294: p_information14 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts),
6295: p_information16 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts),
6296: p_information18 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_tm_nts),
6297: p_information20 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_tm_nts),
6298: p_information21 => fnd_number.number_to_canonical(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_tm_nts),
6299: p_contact_extra_info_id => l_contact_extra_info_id);
6300: --
6301: end if;
6302: --

Line 7180: and pkayi.ayi_information15 = fnd_number.number_to_canonical(fl.file_id));

7176: from per_kr_assignment_yea_info pkayi
7177: where pkayi.information_type = 'KR_YEA_ENTRY_STATUS'
7178: and pkayi.ayi_information_category = 'KR_YEA_ENTRY_STATUS'
7179: and pkayi.target_year = p_target_year
7180: and pkayi.ayi_information15 = fnd_number.number_to_canonical(fl.file_id));
7181: --
7182: l_csr_mass_new_file csr_mass_new_file%rowtype;
7183: --
7184: begin

Line 7273: and ayi_information15 = fnd_number.number_to_canonical(l_csr_file.file_id);

7269: object_version_number = object_version_number + 1
7270: where information_type = 'KR_YEA_ENTRY_STATUS'
7271: and ayi_information_category = 'KR_YEA_ENTRY_STATUS'
7272: and target_year = l_csr_file.target_year
7273: and ayi_information15 = fnd_number.number_to_canonical(l_csr_file.file_id);
7274: --
7275: end if;
7276: --
7277: if g_debug then