[Home] [Help]
3099: --
3100: -- PAY_KR_YEA_DET_DON_REQ_ERR
3101: --
3102: if p_information2 is not null
3103: and to_char(fnd_date.canonical_to_date(p_information2),'YYYY') <> g_target_yyyy then
3104: --
3105: hr_utility.set_message(801,'PAY_KR_YEA_DET_DON_INV_DATE');
3106: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_information2)));
3107: hr_utility.raise_error;
3102: if p_information2 is not null
3103: and to_char(fnd_date.canonical_to_date(p_information2),'YYYY') <> g_target_yyyy then
3104: --
3105: hr_utility.set_message(801,'PAY_KR_YEA_DET_DON_INV_DATE');
3106: hr_utility.set_message_token('DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_information2)));
3107: hr_utility.raise_error;
3108: --
3109: end if;
3110: --
4558: if l_value_tbl.count > 0 then
4559: --
4560: if l_value_tbl.count = 1 then
4561: --
4562: l_ass_data_rec.housing_loan_date := fnd_date.date_to_canonical(to_date(l_value_tbl(l_value_tbl.first),c_xml_date_fmt));
4563: --
4564: else
4565: --
4566: -- warning
4753: --
4754: l_don_tbl(l_don_ind).ni_num := l_don_tbl_tmp(l01cnt).ni_num;
4755: l_don_tbl(l_don_ind).donator_name := l_don_tbl_tmp(l01cnt).donator_name;
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)
4771: --
4772: l_don_tbl(l_don_ind).ni_num := l_don_tbl_tmp(l01cnt).ni_num;
4773: l_don_tbl(l_don_ind).donator_name := l_don_tbl_tmp(l01cnt).donator_name;
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 */
4788: --
4789: l_don_tbl(l_don_ind).ni_num := l_don_tbl_tmp(l01cnt).ni_num;
4790: l_don_tbl(l_don_ind).donator_name := l_don_tbl_tmp(l01cnt).donator_name;
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 */
5607: insert_kr_ass_yea_info(
5608: p_assignment_id => p_assignment_id,
5609: p_target_year => g_target_yyyy,
5610: p_information_type => 'KR_YEA_DETAIL_MEDICAL_EXP_INFO',
5611: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
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,
5687: insert_kr_ass_yea_info(
5688: p_assignment_id => p_assignment_id,
5689: p_target_year => g_target_yyyy,
5690: p_information_type => 'KR_YEA_DETAIL_DONATION_INFO',
5691: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
5692: p_information2 => l_ass_don_tbl(i).donated_date,
5693: p_information3 => l_ass_don_tbl(i).donated_amount,
5694: p_information5 => l_ass_don_tbl(i).donation_code,
5695: p_information7 => cnv_reg(l_ass_don_tbl(i).recipient_registration_number),
5954: insert_kr_ass_yea_info(
5955: p_assignment_id => p_assignment_id,
5956: p_target_year => g_target_yyyy,
5957: p_information_type => 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO',
5958: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
5959: p_information2 => get_relship(p_assignment_id,'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO',l_ass_educ_tbl(i).ni_num),
5960: p_information3 => l_ass_educ_tbl(i).school_type,
5961: p_information4 => l_ass_educ_tbl(i).exp,
5962: p_information5 => cnv_reg(l_ass_educ_tbl(i).ni_num),
5984: insert_kr_ass_yea_info(
5985: p_assignment_id => p_assignment_id,
5986: p_target_year => g_target_yyyy,
5987: p_information_type => 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO',
5988: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
5989: p_information2 => get_relship(p_assignment_id,'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO',l_ass_uniform_tbl(i).key),
5990: p_information3 => 'H',
5991: p_information4 => l_ass_uniform_tbl(i).val,
5992: p_information5 => cnv_reg(l_ass_uniform_tbl(i).key),
6012: insert_kr_ass_yea_info(
6013: p_assignment_id => p_assignment_id,
6014: p_target_year => g_target_yyyy,
6015: p_information_type => 'KR_YEA_SEP_PEN_DETAILS',
6016: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6017: p_information2 => get_type('KR_YEA_SEP_PEN_DETAILS',l_ass_saving_tbl(i).type),
6018: p_information3 => '110', --get_fin(l_ass_saving_tbl(i).financial_inst),
6019: p_information4 => l_ass_saving_tbl(i).account_num,
6020: p_information5 => l_ass_saving_tbl(i).contributed_amt,
6040: insert_kr_ass_yea_info(
6041: p_assignment_id => p_assignment_id,
6042: p_target_year => g_target_yyyy,
6043: p_information_type => 'KR_YEA_PEN_SAVING_DETAILS',
6044: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6045: p_information2 => l_ass_saving_tbl(i).type,
6046: p_information3 => '110', --get_fin(l_ass_saving_tbl(i).financial_inst),
6047: p_information4 => l_ass_saving_tbl(i).account_num,
6048: p_information5 => l_ass_saving_tbl(i).contributed_amt,
6068: insert_kr_ass_yea_info(
6069: p_assignment_id => p_assignment_id,
6070: p_target_year => g_target_yyyy,
6071: p_information_type => 'KR_YEA_LT_STOCK_SAVING_DETAILS',
6072: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6073: p_information2 => l_ass_saving_tbl(i).type,
6074: p_information3 => '110', --get_fin(l_ass_saving_tbl(i).financial_inst),
6075: p_information4 => l_ass_saving_tbl(i).account_num,
6076: p_information5 => l_ass_saving_tbl(i).contributed_amt,
6096: validate_kr_ass_yea_info(
6097: p_assignment_id => p_assignment_id,
6098: p_target_year => g_target_yyyy,
6099: p_information_type => 'KR_YEA_HOU_SAVING_DETAILS',
6100: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6101: p_information2 => get_type('KR_YEA_HOU_SAVING_DETAILS',l_ass_saving_tbl(i).type),
6102: p_information5 => l_ass_saving_tbl(i).contributed_amt);
6103: --
6104: insert_kr_ass_yea_info(
6104: insert_kr_ass_yea_info(
6105: p_assignment_id => p_assignment_id,
6106: p_target_year => g_target_yyyy,
6107: p_information_type => 'KR_YEA_HOU_SAVING_DETAILS',
6108: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6109: p_information2 => get_type('KR_YEA_HOU_SAVING_DETAILS',l_ass_saving_tbl(i).type),
6110: p_information3 => '110', --get_fin(l_ass_saving_tbl(i).financial_inst),
6111: p_information4 => l_ass_saving_tbl(i).account_num,
6112: p_information5 => l_ass_saving_tbl(i).contributed_amt,
6132: load_kr_ass_yea_info(
6133: p_assignment_id => p_assignment_id,
6134: p_target_year => g_target_yyyy,
6135: p_information_type => 'KR_YEA_SP_TAX_EXEM_INFO',
6136: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6137: p_information5 => l_ass_data_rec.pers_ins_prem,
6138: p_information6 => l_ass_data_rec.disabled_ins_prem,
6139: p_information7 => l_ass_data_rec.med_exp + nvl(l_csr_med_total_o.dep,0),
6140: p_information9 => l_ass_data_rec.med_exp_aged + nvl(l_csr_med_total_o.aged,0),
6157: load_kr_ass_yea_info(
6158: p_assignment_id => p_assignment_id,
6159: p_target_year => g_target_yyyy,
6160: p_information_type => 'KR_YEA_SP_TAX_EXEM_INFO2',
6161: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6162: p_information2 => l_ass_data_rec.ee_occupation_educ_exp,
6163: p_information4 => l_csr_don_total.promotional,
6164: p_information5 => l_csr_don_total.religious,
6165: p_information6 => l_csr_don_total.other,
6172: load_kr_ass_yea_info(
6173: p_assignment_id => p_assignment_id,
6174: p_target_year => g_target_yyyy,
6175: p_information_type => 'KR_YEA_SP_TAX_EXEM_INFO3',
6176: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6177: p_information6 => l_ass_data_rec.lt_2012_fixed_intr_wo_grace,
6178: p_information7 => l_ass_data_rec.lt_2012_housing_other_intr,
6179: p_assignment_yea_info_id => l_assignment_yea_info_id);
6180:
6197: load_kr_ass_yea_info(
6198: p_assignment_id => p_assignment_id,
6199: p_target_year => g_target_yyyy,
6200: p_information_type => 'KR_YEA_TAX_EXEM_INFO',
6201: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6202: p_information3 => l_ass_data_rec.pers_pension_prem,
6203: p_information4 => l_csr_pen_total.pen_saving,
6204: p_information7 => l_ass_data_rec.credit_card_exp,
6205: p_information10 => l_ass_data_rec.direct_card_exp,
6216: load_kr_ass_yea_info(
6217: p_assignment_id => p_assignment_id,
6218: p_target_year => g_target_yyyy,
6219: p_information_type => 'KR_YEA_TAX_EXEM_INFO2',
6220: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6221: p_information3 => l_ass_data_rec.credit_tm_exp,
6222: p_information5 => l_ass_data_rec.cash_tm_exp,
6223: p_information7 => l_ass_data_rec.direct_tm_exp,
6224: p_assignment_yea_info_id => l_assignment_yea_info_id);
6227: load_kr_ass_yea_info(
6228: p_assignment_id => p_assignment_id,
6229: p_target_year => g_target_yyyy,
6230: p_information_type => 'KR_YEA_EMP_EXPENSE_DETAILS',
6231: p_information1 => fnd_date.date_to_canonical(g_target_eoy),
6232: p_information2 => l_ass_data_rec.med_exp_nts,
6233: p_information3 => l_ass_data_rec.educ_exp_nts,
6234: p_information4 => l_ass_data_rec.card_exp_nts,
6235: p_information5 => l_ass_data_rec.don_exp_nts,
6411: pay_kr_yea_sshr_utils_pkg.run_validation_formula(
6412: p_business_group_id => g_business_group_id,
6413: p_assignment_id => p_assignment_id,
6414: p_target_year => to_char(g_target_yyyy),
6415: p_effective_date => fnd_date.date_to_canonical(g_target_eoy),
6416: p_return_message => l_return_message,
6417: p_return_status => l_return_status,
6418: p_ff_message0 => l_ff_message0,
6419: p_ff_message1 => l_ff_message1,
6428: p_ff_return_status => l_ff_return_status,
6429: p_ee_educ_exp => cnv_m(l_ass_data_rec_n.ee_educ_exp),
6430: p_housing_saving_type => l_ass_data_rec_n.housing_saving_type,
6431: p_housing_saving => cnv_m(l_ass_data_rec_n.housing_saving),
6432: p_housing_purchase_date => l_ass_data_rec_n.housing_purchase_date, /* fnd_date ? */
6433: p_housing_loan_date => l_ass_data_rec_n.housing_loan_date,
6434: p_housing_loan_repay => cnv_m(l_ass_data_rec_n.housing_loan_repay),
6435: p_lt_housing_loan_date => l_ass_data_rec_n.lt_housing_loan_date,
6436: p_lt_housing_loan_interest_rep => cnv_m(l_ass_data_rec_n.lt_housing_loan_interest_rep),