[Home] [Help]
16: --
17: g_pdf_ind number := 0;
18: g_admin varchar2(1);
19: g_ss_call varchar2(1);
20: g_dpnt_ni_num per_kr_assignment_yea_info.ayi_information1%type;
21: g_dpnt_ind number;
22: --
23: type t_ass_yea_rec is record(
24: assignment_yea_info_id number,
33: g_ass_yea_tbl t_ass_yea_tbl;
34: g_ass_yea_ind number := 0;
35: --
36: type t_med_rec is record(
37: paid_amount per_kr_assignment_yea_info.ayi_information1%type,
38: source_code per_kr_assignment_yea_info.ayi_information1%type,
39: resident_registration_no per_kr_assignment_yea_info.ayi_information1%type,
40: disabled_or_aged per_kr_assignment_yea_info.ayi_information1%type);
41: type t_med_tbl is table of t_med_rec index by binary_integer;
34: g_ass_yea_ind number := 0;
35: --
36: type t_med_rec is record(
37: paid_amount per_kr_assignment_yea_info.ayi_information1%type,
38: source_code per_kr_assignment_yea_info.ayi_information1%type,
39: resident_registration_no per_kr_assignment_yea_info.ayi_information1%type,
40: disabled_or_aged per_kr_assignment_yea_info.ayi_information1%type);
41: type t_med_tbl is table of t_med_rec index by binary_integer;
42: --
35: --
36: type t_med_rec is record(
37: paid_amount per_kr_assignment_yea_info.ayi_information1%type,
38: source_code per_kr_assignment_yea_info.ayi_information1%type,
39: resident_registration_no per_kr_assignment_yea_info.ayi_information1%type,
40: disabled_or_aged per_kr_assignment_yea_info.ayi_information1%type);
41: type t_med_tbl is table of t_med_rec index by binary_integer;
42: --
43: type t_don_rec is record(
36: type t_med_rec is record(
37: paid_amount per_kr_assignment_yea_info.ayi_information1%type,
38: source_code per_kr_assignment_yea_info.ayi_information1%type,
39: resident_registration_no per_kr_assignment_yea_info.ayi_information1%type,
40: disabled_or_aged per_kr_assignment_yea_info.ayi_information1%type);
41: type t_med_tbl is table of t_med_rec index by binary_integer;
42: --
43: type t_don_rec is record(
44: ni_num per_kr_assignment_yea_info.ayi_information1%type,
40: disabled_or_aged per_kr_assignment_yea_info.ayi_information1%type);
41: type t_med_tbl is table of t_med_rec index by binary_integer;
42: --
43: type t_don_rec is record(
44: ni_num per_kr_assignment_yea_info.ayi_information1%type,
45: donation_code per_kr_assignment_yea_info.ayi_information1%type,
46: sum per_kr_assignment_yea_info.ayi_information1%type,
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
41: type t_med_tbl is table of t_med_rec index by binary_integer;
42: --
43: type t_don_rec is record(
44: ni_num per_kr_assignment_yea_info.ayi_information1%type,
45: donation_code per_kr_assignment_yea_info.ayi_information1%type,
46: sum per_kr_assignment_yea_info.ayi_information1%type,
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
42: --
43: type t_don_rec is record(
44: ni_num per_kr_assignment_yea_info.ayi_information1%type,
45: donation_code per_kr_assignment_yea_info.ayi_information1%type,
46: sum per_kr_assignment_yea_info.ayi_information1%type,
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
43: type t_don_rec is record(
44: ni_num per_kr_assignment_yea_info.ayi_information1%type,
45: donation_code per_kr_assignment_yea_info.ayi_information1%type,
46: sum per_kr_assignment_yea_info.ayi_information1%type,
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
51: donation_detail_type per_kr_assignment_yea_info.ayi_information1%type,
44: ni_num per_kr_assignment_yea_info.ayi_information1%type,
45: donation_code per_kr_assignment_yea_info.ayi_information1%type,
46: sum per_kr_assignment_yea_info.ayi_information1%type,
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
51: donation_detail_type per_kr_assignment_yea_info.ayi_information1%type,
52: donator_name per_kr_assignment_yea_info.ayi_information1%type,
45: donation_code per_kr_assignment_yea_info.ayi_information1%type,
46: sum per_kr_assignment_yea_info.ayi_information1%type,
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
51: donation_detail_type per_kr_assignment_yea_info.ayi_information1%type,
52: donator_name per_kr_assignment_yea_info.ayi_information1%type,
53: relationship per_kr_assignment_yea_info.ayi_information1%type);
46: sum per_kr_assignment_yea_info.ayi_information1%type,
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
51: donation_detail_type per_kr_assignment_yea_info.ayi_information1%type,
52: donator_name per_kr_assignment_yea_info.ayi_information1%type,
53: relationship per_kr_assignment_yea_info.ayi_information1%type);
54: type t_don_tbl is table of t_don_rec index by binary_integer;
47: donated_amount per_kr_assignment_yea_info.ayi_information1%type,
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
51: donation_detail_type per_kr_assignment_yea_info.ayi_information1%type,
52: donator_name per_kr_assignment_yea_info.ayi_information1%type,
53: relationship per_kr_assignment_yea_info.ayi_information1%type);
54: type t_don_tbl is table of t_don_rec index by binary_integer;
55: --
48: donated_date per_kr_assignment_yea_info.ayi_information1%type,
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
51: donation_detail_type per_kr_assignment_yea_info.ayi_information1%type,
52: donator_name per_kr_assignment_yea_info.ayi_information1%type,
53: relationship per_kr_assignment_yea_info.ayi_information1%type);
54: type t_don_tbl is table of t_don_rec index by binary_integer;
55: --
56: type t_educ_rec is record(
49: recipient_name per_kr_assignment_yea_info.ayi_information1%type,
50: recipient_registration_number per_kr_assignment_yea_info.ayi_information1%type,
51: donation_detail_type per_kr_assignment_yea_info.ayi_information1%type,
52: donator_name per_kr_assignment_yea_info.ayi_information1%type,
53: relationship per_kr_assignment_yea_info.ayi_information1%type);
54: type t_don_tbl is table of t_don_rec index by binary_integer;
55: --
56: type t_educ_rec is record(
57: ni_num per_kr_assignment_yea_info.ayi_information1%type,
53: relationship per_kr_assignment_yea_info.ayi_information1%type);
54: type t_don_tbl is table of t_don_rec index by binary_integer;
55: --
56: type t_educ_rec is record(
57: ni_num per_kr_assignment_yea_info.ayi_information1%type,
58: dpnt_name per_kr_assignment_yea_info.ayi_information1%type,
59: school_type per_kr_assignment_yea_info.ayi_information1%type,
60: nts_other per_kr_assignment_yea_info.ayi_information1%type,
61: exp per_kr_assignment_yea_info.ayi_information1%type);
54: type t_don_tbl is table of t_don_rec index by binary_integer;
55: --
56: type t_educ_rec is record(
57: ni_num per_kr_assignment_yea_info.ayi_information1%type,
58: dpnt_name per_kr_assignment_yea_info.ayi_information1%type,
59: school_type per_kr_assignment_yea_info.ayi_information1%type,
60: nts_other per_kr_assignment_yea_info.ayi_information1%type,
61: exp per_kr_assignment_yea_info.ayi_information1%type);
62: type t_educ_tbl is table of t_educ_rec index by binary_integer;
55: --
56: type t_educ_rec is record(
57: ni_num per_kr_assignment_yea_info.ayi_information1%type,
58: dpnt_name per_kr_assignment_yea_info.ayi_information1%type,
59: school_type per_kr_assignment_yea_info.ayi_information1%type,
60: nts_other per_kr_assignment_yea_info.ayi_information1%type,
61: exp per_kr_assignment_yea_info.ayi_information1%type);
62: type t_educ_tbl is table of t_educ_rec index by binary_integer;
63: --
56: type t_educ_rec is record(
57: ni_num per_kr_assignment_yea_info.ayi_information1%type,
58: dpnt_name per_kr_assignment_yea_info.ayi_information1%type,
59: school_type per_kr_assignment_yea_info.ayi_information1%type,
60: nts_other per_kr_assignment_yea_info.ayi_information1%type,
61: exp per_kr_assignment_yea_info.ayi_information1%type);
62: type t_educ_tbl is table of t_educ_rec index by binary_integer;
63: --
64: type t_saving_rec is record(
57: ni_num per_kr_assignment_yea_info.ayi_information1%type,
58: dpnt_name per_kr_assignment_yea_info.ayi_information1%type,
59: school_type per_kr_assignment_yea_info.ayi_information1%type,
60: nts_other per_kr_assignment_yea_info.ayi_information1%type,
61: exp per_kr_assignment_yea_info.ayi_information1%type);
62: type t_educ_tbl is table of t_educ_rec index by binary_integer;
63: --
64: type t_saving_rec is record(
65: priority per_kr_assignment_yea_info.ayi_information1%type,
61: exp per_kr_assignment_yea_info.ayi_information1%type);
62: type t_educ_tbl is table of t_educ_rec index by binary_integer;
63: --
64: type t_saving_rec is record(
65: priority per_kr_assignment_yea_info.ayi_information1%type,
66: type per_kr_assignment_yea_info.ayi_information1%type,
67: financial_inst per_kr_assignment_yea_info.ayi_information1%type,
68: account_num per_kr_assignment_yea_info.ayi_information1%type,
69: contributed_amt per_kr_assignment_yea_info.ayi_information1%type,
62: type t_educ_tbl is table of t_educ_rec index by binary_integer;
63: --
64: type t_saving_rec is record(
65: priority per_kr_assignment_yea_info.ayi_information1%type,
66: type per_kr_assignment_yea_info.ayi_information1%type,
67: financial_inst per_kr_assignment_yea_info.ayi_information1%type,
68: account_num per_kr_assignment_yea_info.ayi_information1%type,
69: contributed_amt per_kr_assignment_yea_info.ayi_information1%type,
70: cont_amt_y2 per_kr_assignment_yea_info.ayi_information1%type,
63: --
64: type t_saving_rec is record(
65: priority per_kr_assignment_yea_info.ayi_information1%type,
66: type per_kr_assignment_yea_info.ayi_information1%type,
67: financial_inst per_kr_assignment_yea_info.ayi_information1%type,
68: account_num per_kr_assignment_yea_info.ayi_information1%type,
69: contributed_amt per_kr_assignment_yea_info.ayi_information1%type,
70: cont_amt_y2 per_kr_assignment_yea_info.ayi_information1%type,
71: cont_amt_y3 per_kr_assignment_yea_info.ayi_information1%type);
64: type t_saving_rec is record(
65: priority per_kr_assignment_yea_info.ayi_information1%type,
66: type per_kr_assignment_yea_info.ayi_information1%type,
67: financial_inst per_kr_assignment_yea_info.ayi_information1%type,
68: account_num per_kr_assignment_yea_info.ayi_information1%type,
69: contributed_amt per_kr_assignment_yea_info.ayi_information1%type,
70: cont_amt_y2 per_kr_assignment_yea_info.ayi_information1%type,
71: cont_amt_y3 per_kr_assignment_yea_info.ayi_information1%type);
72: type t_saving_tbl is table of t_saving_rec index by binary_integer;
65: priority per_kr_assignment_yea_info.ayi_information1%type,
66: type per_kr_assignment_yea_info.ayi_information1%type,
67: financial_inst per_kr_assignment_yea_info.ayi_information1%type,
68: account_num per_kr_assignment_yea_info.ayi_information1%type,
69: contributed_amt per_kr_assignment_yea_info.ayi_information1%type,
70: cont_amt_y2 per_kr_assignment_yea_info.ayi_information1%type,
71: cont_amt_y3 per_kr_assignment_yea_info.ayi_information1%type);
72: type t_saving_tbl is table of t_saving_rec index by binary_integer;
73: -- Bug :16083942 2012 pdf layout changes
66: type per_kr_assignment_yea_info.ayi_information1%type,
67: financial_inst per_kr_assignment_yea_info.ayi_information1%type,
68: account_num per_kr_assignment_yea_info.ayi_information1%type,
69: contributed_amt per_kr_assignment_yea_info.ayi_information1%type,
70: cont_amt_y2 per_kr_assignment_yea_info.ayi_information1%type,
71: cont_amt_y3 per_kr_assignment_yea_info.ayi_information1%type);
72: type t_saving_tbl is table of t_saving_rec index by binary_integer;
73: -- Bug :16083942 2012 pdf layout changes
74: type t_cards_rec is record(
67: financial_inst per_kr_assignment_yea_info.ayi_information1%type,
68: account_num per_kr_assignment_yea_info.ayi_information1%type,
69: contributed_amt per_kr_assignment_yea_info.ayi_information1%type,
70: cont_amt_y2 per_kr_assignment_yea_info.ayi_information1%type,
71: cont_amt_y3 per_kr_assignment_yea_info.ayi_information1%type);
72: type t_saving_tbl is table of t_saving_rec index by binary_integer;
73: -- Bug :16083942 2012 pdf layout changes
74: type t_cards_rec is record(
75: key per_kr_assignment_yea_info.ayi_information1%type,
71: cont_amt_y3 per_kr_assignment_yea_info.ayi_information1%type);
72: type t_saving_tbl is table of t_saving_rec index by binary_integer;
73: -- Bug :16083942 2012 pdf layout changes
74: type t_cards_rec is record(
75: key per_kr_assignment_yea_info.ayi_information1%type,
76: val per_kr_assignment_yea_info.ayi_information1%type,
77: use_place_cd number
78: );
79: type t_cards_tbl is table of t_cards_rec index by binary_integer;
72: type t_saving_tbl is table of t_saving_rec index by binary_integer;
73: -- Bug :16083942 2012 pdf layout changes
74: type t_cards_rec is record(
75: key per_kr_assignment_yea_info.ayi_information1%type,
76: val per_kr_assignment_yea_info.ayi_information1%type,
77: use_place_cd number
78: );
79: type t_cards_tbl is table of t_cards_rec index by binary_integer;
80:
78: );
79: type t_cards_tbl is table of t_cards_rec index by binary_integer;
80:
81: type t_uniform_rec is record(
82: key per_kr_assignment_yea_info.ayi_information1%type,
83: val per_kr_assignment_yea_info.ayi_information1%type,
84: empname per_kr_assignment_yea_info.ayi_information1%type
85: );
86: type t_uniform_tbl is table of t_uniform_rec index by binary_integer;
79: type t_cards_tbl is table of t_cards_rec index by binary_integer;
80:
81: type t_uniform_rec is record(
82: key per_kr_assignment_yea_info.ayi_information1%type,
83: val per_kr_assignment_yea_info.ayi_information1%type,
84: empname per_kr_assignment_yea_info.ayi_information1%type
85: );
86: type t_uniform_tbl is table of t_uniform_rec index by binary_integer;
87:
80:
81: type t_uniform_rec is record(
82: key per_kr_assignment_yea_info.ayi_information1%type,
83: val per_kr_assignment_yea_info.ayi_information1%type,
84: empname per_kr_assignment_yea_info.ayi_information1%type
85: );
86: type t_uniform_tbl is table of t_uniform_rec index by binary_integer;
87:
88: type t_lthouse_rec is record(
85: );
86: type t_uniform_tbl is table of t_uniform_rec index by binary_integer;
87:
88: type t_lthouse_rec is record(
89: key per_kr_assignment_yea_info.ayi_information1%type,
90: val per_kr_assignment_yea_info.ayi_information1%type,
91: start_date per_kr_assignment_yea_info.ayi_information1%type,
92: debt number,
93: fixed_rate number,
86: type t_uniform_tbl is table of t_uniform_rec index by binary_integer;
87:
88: type t_lthouse_rec is record(
89: key per_kr_assignment_yea_info.ayi_information1%type,
90: val per_kr_assignment_yea_info.ayi_information1%type,
91: start_date per_kr_assignment_yea_info.ayi_information1%type,
92: debt number,
93: fixed_rate number,
94: defer_debt number,
87:
88: type t_lthouse_rec is record(
89: key per_kr_assignment_yea_info.ayi_information1%type,
90: val per_kr_assignment_yea_info.ayi_information1%type,
91: start_date per_kr_assignment_yea_info.ayi_information1%type,
92: debt number,
93: fixed_rate number,
94: defer_debt number,
95: year_amt number
109: cash_tm_nts number,
110: don_exp_nts number);
111: type t_dpnt_tbl is table of t_dpnt_rec index by binary_integer;
112: --
113: type t_char_tbl is table of per_kr_assignment_yea_info.ayi_information1%type index by binary_integer;
114: --
115: type t_ass_data_rec is record(
116: pers_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
117: disabled_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
112: --
113: type t_char_tbl is table of per_kr_assignment_yea_info.ayi_information1%type index by binary_integer;
114: --
115: type t_ass_data_rec is record(
116: pers_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
117: disabled_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
118: housing_loan_repay per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
113: type t_char_tbl is table of per_kr_assignment_yea_info.ayi_information1%type index by binary_integer;
114: --
115: type t_ass_data_rec is record(
116: pers_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
117: disabled_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
118: housing_loan_repay per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
114: --
115: type t_ass_data_rec is record(
116: pers_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
117: disabled_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
118: housing_loan_repay per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
115: type t_ass_data_rec is record(
116: pers_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
117: disabled_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
118: housing_loan_repay per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
116: pers_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
117: disabled_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
118: housing_loan_repay per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
117: disabled_ins_prem per_kr_assignment_yea_info.ayi_information1%type,
118: housing_loan_repay per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
118: housing_loan_repay per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
119: housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
120: lt_housing_loan_interest_rep per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
121: lt_housing_loan_int_repay_1 per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
122: lt_housing_loan_int_repay_2 per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
123: lt_2012_fixed_intr_wo_grace per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
124: lt_2012_housing_other_intr per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
125: med_exp_aged per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
126: med_exp_emp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
127: med_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
128: political_donation1 per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
129: ee_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
130: ee_uniform_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
131: ee_occupation_educ_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
132: pers_pension_prem per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
133: small_bus_install per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
134: credit_card_exp per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
135: credit_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
136: cash_receipt_exp per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
137: cash_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
138: direct_card_exp per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
146: direct_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
139: direct_tm_exp per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
146: direct_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
147: tm_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
140: ins_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
146: direct_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
147: tm_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
148: don_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
141: med_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
146: direct_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
147: tm_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
148: don_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
149: med_tbl t_med_tbl,
142: educ_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
146: direct_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
147: tm_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
148: don_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
149: med_tbl t_med_tbl,
150: don_tbl t_don_tbl,
143: card_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
146: direct_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
147: tm_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
148: don_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
149: med_tbl t_med_tbl,
150: don_tbl t_don_tbl,
151: educ_tbl t_educ_tbl,
144: card_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
145: direct_payment_nts per_kr_assignment_yea_info.ayi_information1%type,
146: direct_tm_nts per_kr_assignment_yea_info.ayi_information1%type,
147: tm_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
148: don_exp_nts per_kr_assignment_yea_info.ayi_information1%type,
149: med_tbl t_med_tbl,
150: don_tbl t_don_tbl,
151: educ_tbl t_educ_tbl,
152: uniform_tbl t_uniform_tbl,
156: lts_saving_tbl t_saving_tbl,
157: dpnt_ind_tbl t_char_tbl,
158: dpnt_tbl t_dpnt_tbl,
159: --
160: entry_status per_kr_assignment_yea_info.ayi_information1%type,
161: validation_status per_kr_assignment_yea_info.ayi_information1%type,
162: entry_error1 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
157: dpnt_ind_tbl t_char_tbl,
158: dpnt_tbl t_dpnt_tbl,
159: --
160: entry_status per_kr_assignment_yea_info.ayi_information1%type,
161: validation_status per_kr_assignment_yea_info.ayi_information1%type,
162: entry_error1 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
158: dpnt_tbl t_dpnt_tbl,
159: --
160: entry_status per_kr_assignment_yea_info.ayi_information1%type,
161: validation_status per_kr_assignment_yea_info.ayi_information1%type,
162: entry_error1 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
159: --
160: entry_status per_kr_assignment_yea_info.ayi_information1%type,
161: validation_status per_kr_assignment_yea_info.ayi_information1%type,
162: entry_error1 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
160: entry_status per_kr_assignment_yea_info.ayi_information1%type,
161: validation_status per_kr_assignment_yea_info.ayi_information1%type,
162: entry_error1 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
161: validation_status per_kr_assignment_yea_info.ayi_information1%type,
162: entry_error1 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
162: entry_error1 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
163: entry_error2 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
164: entry_error3 per_kr_assignment_yea_info.ayi_information1%type,
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
172: --
165: entry_error4 per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
172: --
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
166: entry_error5 per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
172: --
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
167: entry_error6 per_kr_assignment_yea_info.ayi_information1%type,
168: entry_error7 per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
172: --
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
169: entry_error8 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
172: --
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
170: entry_error9 per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
172: --
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
171: entry_error10 per_kr_assignment_yea_info.ayi_information1%type,
172: --
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
172: --
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
173: housing_saving_type per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
174: housing_saving per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
175: housing_purchase_date per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
176: lt_housing_loan_date per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
177: donation1 per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
178: hi_prem per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
179: political_donation2 per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
180: political_donation3 per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
181: donation2 per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
182: donation3 per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
183: lt_housing_loan_date_1 per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
184: mfr_marriage_occasions per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
185: mfr_funeral_occasions per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
186: mfr_relocation_occasions per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
187: ei_prem per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
188: esoa_donation per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
189: pers_ins_name per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
190: med_exp_disabled per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
191: immigration_purpose per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
192: contract_date per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
193: expiry_date per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
194: stax_applicable_flag per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
195: fw_application_date per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
196: fw_submission_date per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
197: tax_paid_date per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
198: ovs_submission_date per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
199: kr_ovs_location per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
200: kr_ovs_work_period per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
201: kr_ovs_responsibility per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
202: territory_code per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
203: currency_code per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
204: taxable per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
205: taxable_subj_tax_break per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
206: tax_break_rate per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
207: tax_foreign_currency per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
208: tax per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
209: ovs_application_date per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
210: housing_loan_interest_repay per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
211: stock_saving per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
212: lt_stock_saving1 per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
213: lt_stock_saving2 per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
221: credit_card_exp_dpnt per_kr_assignment_yea_info.ayi_information1%type,
214: dpnt_direct_exp per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
221: credit_card_exp_dpnt per_kr_assignment_yea_info.ayi_information1%type,
222: pen_prem per_kr_assignment_yea_info.ayi_information1%type,
215: giro_tuition_paid_exp per_kr_assignment_yea_info.ayi_information1%type,
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
221: credit_card_exp_dpnt per_kr_assignment_yea_info.ayi_information1%type,
222: pen_prem per_kr_assignment_yea_info.ayi_information1%type,
223: ltci_prem per_kr_assignment_yea_info.ayi_information1%type);
216: np_prem per_kr_assignment_yea_info.ayi_information1%type,
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
221: credit_card_exp_dpnt per_kr_assignment_yea_info.ayi_information1%type,
222: pen_prem per_kr_assignment_yea_info.ayi_information1%type,
223: ltci_prem per_kr_assignment_yea_info.ayi_information1%type);
224: --
217: pers_pension_saving per_kr_assignment_yea_info.ayi_information1%type,
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
221: credit_card_exp_dpnt per_kr_assignment_yea_info.ayi_information1%type,
222: pen_prem per_kr_assignment_yea_info.ayi_information1%type,
223: ltci_prem per_kr_assignment_yea_info.ayi_information1%type);
224: --
225: /* same condition with EmpSearchVO.xml */
218: invest_partnership_fin1 per_kr_assignment_yea_info.ayi_information1%type,
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
221: credit_card_exp_dpnt per_kr_assignment_yea_info.ayi_information1%type,
222: pen_prem per_kr_assignment_yea_info.ayi_information1%type,
223: ltci_prem per_kr_assignment_yea_info.ayi_information1%type);
224: --
225: /* same condition with EmpSearchVO.xml */
226: /* no need primary flag check for rehire */
219: invest_partnership_fin2 per_kr_assignment_yea_info.ayi_information1%type,
220: emp_stock_own_plan_contri per_kr_assignment_yea_info.ayi_information1%type,
221: credit_card_exp_dpnt per_kr_assignment_yea_info.ayi_information1%type,
222: pen_prem per_kr_assignment_yea_info.ayi_information1%type,
223: ltci_prem per_kr_assignment_yea_info.ayi_information1%type);
224: --
225: /* same condition with EmpSearchVO.xml */
226: /* no need primary flag check for rehire */
227: cursor csr_map_name(
231: pp.last_name||pp.first_name emp_name,
232: substrb(pp.national_identifier,1,6) res_reg_num,
233: pp.national_identifier ni_num,
234: pp.employee_number emp_num
235: from per_kr_assignment_yea_info pkayi,
236: per_people_f pp,
237: per_periods_of_service ppos,
238: per_assignments_f pa
239: where pa.business_group_id + 0 = g_business_group_id
283: pp.employee_number emp_num,
284: null exclude,
285: fl.file_id,
286: fl.file_data pdf_file
287: from per_kr_assignment_yea_info pkayi,
288: per_all_assignments_f pa,
289: per_periods_of_service ppos,
290: per_people_f pp,
291: fnd_lobs fl
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: --
325: type t_val_by_key_rec is record(
326: key per_kr_assignment_yea_info.ayi_information1%type,
327: val per_kr_assignment_yea_info.ayi_information1%type);
328: type t_val_by_key_tbl is table of t_val_by_key_rec index by binary_integer;
329: --
330: -- -------------------------------------------------------------------------
323: g_pdf_tbl t_pdf_tbl;
324: --
325: type t_val_by_key_rec is record(
326: key per_kr_assignment_yea_info.ayi_information1%type,
327: val per_kr_assignment_yea_info.ayi_information1%type);
328: type t_val_by_key_tbl is table of t_val_by_key_rec index by binary_integer;
329: --
330: -- -------------------------------------------------------------------------
331: -- insert_session
582: p_assignment_yea_info_id in number)
583: is
584: select rowid row_id,
585: object_version_number ovn
586: from per_kr_assignment_yea_info
587: where assignment_yea_info_id = p_assignment_yea_info_id
588: for update nowait;
589: --
590: l_csr_entry_status csr_entry_status%rowtype;
606: close csr_entry_status;
607: --
608: if l_csr_entry_status.row_id is not null then
609: --
610: update per_kr_assignment_yea_info
611: set ayi_information14 = c_upload_status,
612: ayi_information16 = c_process_status,
613: object_version_number = l_csr_entry_status.ovn + 1
614: where rowid = l_csr_entry_status.row_id;
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
725: and pkayi.information_type = 'KR_YEA_ENTRY_STATUS'
726: and pkayi.ayi_information_category = 'KR_YEA_ENTRY_STATUS'
756: --
757: l_assignment_yea_info_id := l_csr_kr_ass_yea.assignment_yea_info_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
785: end if;
786: --
787: else
788: --
789: select per_kr_assignment_yea_info_s.nextval
790: into l_assignment_yea_info_id
791: from dual;
792: --
793: insert into per_kr_assignment_yea_info(
789: select per_kr_assignment_yea_info_s.nextval
790: into l_assignment_yea_info_id
791: from dual;
792: --
793: insert into per_kr_assignment_yea_info(
794: assignment_yea_info_id,
795: assignment_id,
796: information_type,
797: target_year,
980: --
981: -- might update multiple assignment rows for same file id
982: for i in g_ass_yea_tbl.first..g_ass_yea_tbl.last loop
983: --
984: update per_kr_assignment_yea_info
985: set ayi_information16 = 'C',
986: object_version_number = object_version_number + 1
987: where assignment_yea_info_id = g_ass_yea_tbl(i).assignment_yea_info_id;
988: --
1047: --
1048: -- might update multiple assignment rows for same file id
1049: for i in g_ass_yea_tbl.first..g_ass_yea_tbl.last loop
1050: --
1051: update per_kr_assignment_yea_info
1052: set ayi_information14 = null,
1053: ayi_information15 = null,
1054: ayi_information16 = null,
1055: object_version_number = object_version_number + 1
1582: data_node dbms_xmldom.domnode;
1583: item_nodelist dbms_xmldom.domnodelist;
1584: item_node dbms_xmldom.domnode;
1585: --
1586: l_man_key per_kr_assignment_yea_info.ayi_information1%type;
1587: --
1588: l_man_cnt number;
1589: l_data_cnt number;
1590: l_item_cnt number;
1682: item_key_node dbms_xmldom.domnode;
1683: item_nodelist dbms_xmldom.domnodelist;
1684: item_node dbms_xmldom.domnode;
1685: --
1686: l_item_key per_kr_assignment_yea_info.ayi_information1%type;
1687: --
1688: l_man_cnt number;
1689: l_data_cnt number;
1690: l_item_key_cnt number;
1796: l_data_cnt number;
1797: l_sum_cnt number;
1798: l_amt_cnt number;
1799: --
1800: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1801: l_don_name per_kr_assignment_yea_info.ayi_information1%type;
1802: l_don_code per_kr_assignment_yea_info.ayi_information1%type;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1797: l_sum_cnt number;
1798: l_amt_cnt number;
1799: --
1800: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1801: l_don_name per_kr_assignment_yea_info.ayi_information1%type;
1802: l_don_code per_kr_assignment_yea_info.ayi_information1%type;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1805: l_don_date per_kr_assignment_yea_info.ayi_information1%type;
1798: l_amt_cnt number;
1799: --
1800: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1801: l_don_name per_kr_assignment_yea_info.ayi_information1%type;
1802: l_don_code per_kr_assignment_yea_info.ayi_information1%type;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1805: l_don_date per_kr_assignment_yea_info.ayi_information1%type;
1806: l_rec_name per_kr_assignment_yea_info.ayi_information1%type;
1799: --
1800: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1801: l_don_name per_kr_assignment_yea_info.ayi_information1%type;
1802: l_don_code per_kr_assignment_yea_info.ayi_information1%type;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1805: l_don_date per_kr_assignment_yea_info.ayi_information1%type;
1806: l_rec_name per_kr_assignment_yea_info.ayi_information1%type;
1807: l_rec_bg_num per_kr_assignment_yea_info.ayi_information1%type;
1800: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1801: l_don_name per_kr_assignment_yea_info.ayi_information1%type;
1802: l_don_code per_kr_assignment_yea_info.ayi_information1%type;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1805: l_don_date per_kr_assignment_yea_info.ayi_information1%type;
1806: l_rec_name per_kr_assignment_yea_info.ayi_information1%type;
1807: l_rec_bg_num per_kr_assignment_yea_info.ayi_information1%type;
1808: --
1801: l_don_name per_kr_assignment_yea_info.ayi_information1%type;
1802: l_don_code per_kr_assignment_yea_info.ayi_information1%type;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1805: l_don_date per_kr_assignment_yea_info.ayi_information1%type;
1806: l_rec_name per_kr_assignment_yea_info.ayi_information1%type;
1807: l_rec_bg_num per_kr_assignment_yea_info.ayi_information1%type;
1808: --
1809: l_value_ind number := 0;
1802: l_don_code per_kr_assignment_yea_info.ayi_information1%type;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1805: l_don_date per_kr_assignment_yea_info.ayi_information1%type;
1806: l_rec_name per_kr_assignment_yea_info.ayi_information1%type;
1807: l_rec_bg_num per_kr_assignment_yea_info.ayi_information1%type;
1808: --
1809: l_value_ind number := 0;
1810: l_values_tbl t_don_tbl;
1803: l_sum per_kr_assignment_yea_info.ayi_information1%type;
1804: l_amt per_kr_assignment_yea_info.ayi_information1%type;
1805: l_don_date per_kr_assignment_yea_info.ayi_information1%type;
1806: l_rec_name per_kr_assignment_yea_info.ayi_information1%type;
1807: l_rec_bg_num per_kr_assignment_yea_info.ayi_information1%type;
1808: --
1809: l_value_ind number := 0;
1810: l_values_tbl t_don_tbl;
1811: --
1943: l_man_cnt number;
1944: l_data_cnt number;
1945: l_sum_cnt number;
1946: --
1947: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1948: l_dpnt_name per_kr_assignment_yea_info.ayi_information1%type;
1949: l_exp per_kr_assignment_yea_info.ayi_information1%type;
1950: --
1951: l_value_ind number := 0;
1944: l_data_cnt number;
1945: l_sum_cnt number;
1946: --
1947: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1948: l_dpnt_name per_kr_assignment_yea_info.ayi_information1%type;
1949: l_exp per_kr_assignment_yea_info.ayi_information1%type;
1950: --
1951: l_value_ind number := 0;
1952: l_values_tbl t_educ_tbl;
1945: l_sum_cnt number;
1946: --
1947: l_ni_num per_kr_assignment_yea_info.ayi_information1%type;
1948: l_dpnt_name per_kr_assignment_yea_info.ayi_information1%type;
1949: l_exp per_kr_assignment_yea_info.ayi_information1%type;
1950: --
1951: l_value_ind number := 0;
1952: l_values_tbl t_educ_tbl;
1953: l_school_type per_kr_assignment_yea_info.ayi_information1%type;
1949: l_exp per_kr_assignment_yea_info.ayi_information1%type;
1950: --
1951: l_value_ind number := 0;
1952: l_values_tbl t_educ_tbl;
1953: l_school_type per_kr_assignment_yea_info.ayi_information1%type;
1954: --
1955: begin
1956: --
1957: if g_debug then
2072: l_data_cnt number;
2073: l_type_cnt number;
2074: l_sum_cnt number;
2075: --
2076: l_type per_kr_assignment_yea_info.ayi_information1%type;
2077: l_sum per_kr_assignment_yea_info.ayi_information1%type;
2078: -- l_sum_y2 per_kr_assignment_yea_info.ayi_information1%type;
2079: l_sum_y3 per_kr_assignment_yea_info.ayi_information1%type;
2080: --
2073: l_type_cnt number;
2074: l_sum_cnt number;
2075: --
2076: l_type per_kr_assignment_yea_info.ayi_information1%type;
2077: l_sum per_kr_assignment_yea_info.ayi_information1%type;
2078: -- l_sum_y2 per_kr_assignment_yea_info.ayi_information1%type;
2079: l_sum_y3 per_kr_assignment_yea_info.ayi_information1%type;
2080: --
2081: l_value_ind number := 0;
2074: l_sum_cnt number;
2075: --
2076: l_type per_kr_assignment_yea_info.ayi_information1%type;
2077: l_sum per_kr_assignment_yea_info.ayi_information1%type;
2078: -- l_sum_y2 per_kr_assignment_yea_info.ayi_information1%type;
2079: l_sum_y3 per_kr_assignment_yea_info.ayi_information1%type;
2080: --
2081: l_value_ind number := 0;
2082: l_values_tbl t_saving_tbl;
2075: --
2076: l_type per_kr_assignment_yea_info.ayi_information1%type;
2077: l_sum per_kr_assignment_yea_info.ayi_information1%type;
2078: -- l_sum_y2 per_kr_assignment_yea_info.ayi_information1%type;
2079: l_sum_y3 per_kr_assignment_yea_info.ayi_information1%type;
2080: --
2081: l_value_ind number := 0;
2082: l_values_tbl t_saving_tbl;
2083: --
2209: data_node dbms_xmldom.domnode;
2210: item_nodelist dbms_xmldom.domnodelist;
2211: item_node dbms_xmldom.domnode;
2212: --
2213: l_man_key per_kr_assignment_yea_info.ayi_information1%type;
2214: --
2215: l_man_cnt number;
2216: l_data_cnt number;
2217: l_item_cnt number;
2308: data_node dbms_xmldom.domnode;
2309: item_nodelist dbms_xmldom.domnodelist;
2310: item_node dbms_xmldom.domnode;
2311: --
2312: l_man_key per_kr_assignment_yea_info.ayi_information1%type;
2313: --
2314: l_man_cnt number;
2315: l_data_cnt number;
2316: l_item_cnt number;
2422:
2423: yr_rede_key_node dbms_xmldom.domnode;
2424: yr_rede_amt_nodelst dbms_xmldom.domnodelist;
2425: --
2426: l_item_key per_kr_assignment_yea_info.ayi_information1%type;
2427: l_date_key per_kr_assignment_yea_info.ayi_information1%type;
2428: l_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2429: l_fixed_key per_kr_assignment_yea_info.ayi_information1%type;
2430: l_not_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2423: yr_rede_key_node dbms_xmldom.domnode;
2424: yr_rede_amt_nodelst dbms_xmldom.domnodelist;
2425: --
2426: l_item_key per_kr_assignment_yea_info.ayi_information1%type;
2427: l_date_key per_kr_assignment_yea_info.ayi_information1%type;
2428: l_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2429: l_fixed_key per_kr_assignment_yea_info.ayi_information1%type;
2430: l_not_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2431: l_yr_rede_key per_kr_assignment_yea_info.ayi_information1%type;
2424: yr_rede_amt_nodelst dbms_xmldom.domnodelist;
2425: --
2426: l_item_key per_kr_assignment_yea_info.ayi_information1%type;
2427: l_date_key per_kr_assignment_yea_info.ayi_information1%type;
2428: l_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2429: l_fixed_key per_kr_assignment_yea_info.ayi_information1%type;
2430: l_not_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2431: l_yr_rede_key per_kr_assignment_yea_info.ayi_information1%type;
2432: --
2425: --
2426: l_item_key per_kr_assignment_yea_info.ayi_information1%type;
2427: l_date_key per_kr_assignment_yea_info.ayi_information1%type;
2428: l_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2429: l_fixed_key per_kr_assignment_yea_info.ayi_information1%type;
2430: l_not_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2431: l_yr_rede_key per_kr_assignment_yea_info.ayi_information1%type;
2432: --
2433: l_man_cnt number;
2426: l_item_key per_kr_assignment_yea_info.ayi_information1%type;
2427: l_date_key per_kr_assignment_yea_info.ayi_information1%type;
2428: l_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2429: l_fixed_key per_kr_assignment_yea_info.ayi_information1%type;
2430: l_not_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2431: l_yr_rede_key per_kr_assignment_yea_info.ayi_information1%type;
2432: --
2433: l_man_cnt number;
2434: l_data_cnt number;
2427: l_date_key per_kr_assignment_yea_info.ayi_information1%type;
2428: l_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2429: l_fixed_key per_kr_assignment_yea_info.ayi_information1%type;
2430: l_not_debt_key per_kr_assignment_yea_info.ayi_information1%type;
2431: l_yr_rede_key per_kr_assignment_yea_info.ayi_information1%type;
2432: --
2433: l_man_cnt number;
2434: l_data_cnt number;
2435: l_item_key_cnt number;
2610: data_node dbms_xmldom.domnode;
2611: item_nodelist dbms_xmldom.domnodelist;
2612: item_node dbms_xmldom.domnode;
2613: --
2614: l_man_key per_kr_assignment_yea_info.ayi_information1%type;
2615: --
2616: l_man_cnt number;
2617: l_data_cnt number;
2618: l_item_cnt number;
3066: --
3067: cursor csr_don_recipient
3068: is
3069: select assignment_yea_info_id
3070: from per_kr_assignment_yea_info
3071: where assignment_id = p_assignment_id
3072: and target_year = g_target_yyyy
3073: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
3074: and ((ayi_information7 <> p_information7
3221: --
3222: cursor csr_kr_ass_yea
3223: is
3224: select pkayi.assignment_yea_info_id
3225: from per_kr_assignment_yea_info pkayi
3226: where pkayi.assignment_id = p_assignment_id
3227: and pkayi.target_year = p_target_year
3228: and pkayi.information_type = p_information_type
3229: and pkayi.ayi_information_category = p_information_type
3286: hr_utility.set_location(l_proc,10);
3287: end if;
3288: --
3289: delete from
3290: per_kr_assignment_yea_info
3291: where assignment_yea_info_id = l_csr_kr_ass_yea.assignment_yea_info_id;
3292: --
3293: end if;
3294: --
3371: if g_debug then
3372: hr_utility.set_location(l_proc,0);
3373: end if;
3374: --
3375: select per_kr_assignment_yea_info_s.nextval
3376: into l_assignment_yea_info_id
3377: from dual;
3378: --
3379: insert into per_kr_assignment_yea_info(
3375: select per_kr_assignment_yea_info_s.nextval
3376: into l_assignment_yea_info_id
3377: from dual;
3378: --
3379: insert into per_kr_assignment_yea_info(
3380: assignment_yea_info_id,
3381: assignment_id,
3382: information_type,
3383: target_year,
3523: cursor csr_kr_ass_yea
3524: is
3525: select pkayi.assignment_yea_info_id,
3526: pkayi.object_version_number
3527: from per_kr_assignment_yea_info pkayi
3528: where pkayi.assignment_id = p_assignment_id
3529: and pkayi.target_year = p_target_year
3530: and pkayi.information_type = p_information_type
3531: and pkayi.ayi_information_category = p_information_type
3553: --
3554: l_assignment_yea_info_id := l_csr_kr_ass_yea.assignment_yea_info_id;
3555: l_object_version_number := l_csr_kr_ass_yea.object_version_number + 1;
3556: --
3557: update per_kr_assignment_yea_info
3558: set ayi_information1 = decode(p_force_update,'Y',decode(p_information1,'NULL',null,nvl(p_information1,ayi_information1)),nvl(p_information1,ayi_information1)),
3559: ayi_information2 = decode(p_force_update,'Y',decode(p_information2,'NULL',null,nvl(p_information2,ayi_information2)),nvl(p_information2,ayi_information2)),
3560: ayi_information3 = decode(p_force_update,'Y',decode(p_information3,'NULL',null,nvl(p_information3,ayi_information3)),nvl(p_information3,ayi_information3)),
3561: ayi_information4 = decode(p_force_update,'Y',decode(p_information4,'NULL',null,nvl(p_information4,ayi_information4)),nvl(p_information4,ayi_information4)),
4050: l_form_cnt number;
4051: --
4052: l_value_tbl t_char_tbl;
4053: l_values_tbl t_val_by_key_tbl;
4054: --l_value per_kr_assignment_yea_info.ayi_information1%type;
4055: --
4056: l_ass_data_rec t_ass_data_rec;
4057: l_ass_data_rec_n t_ass_data_rec;
4058: --
4096: l_assignment_yea_info_id number;
4097: l_contact_extra_info_id number;
4098: --
4099: l_max_priority number;
4100: l_tmp per_kr_assignment_yea_info.ayi_information1%type;
4101: --
4102: l_return_status varchar2(5);
4103: l_return_message varchar2(300);
4104: l_ff_message0 per_kr_assignment_yea_info.ayi_information1%type;
4100: l_tmp per_kr_assignment_yea_info.ayi_information1%type;
4101: --
4102: l_return_status varchar2(5);
4103: l_return_message varchar2(300);
4104: l_ff_message0 per_kr_assignment_yea_info.ayi_information1%type;
4105: l_ff_message1 per_kr_assignment_yea_info.ayi_information1%type;
4106: l_ff_message2 per_kr_assignment_yea_info.ayi_information1%type;
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4101: --
4102: l_return_status varchar2(5);
4103: l_return_message varchar2(300);
4104: l_ff_message0 per_kr_assignment_yea_info.ayi_information1%type;
4105: l_ff_message1 per_kr_assignment_yea_info.ayi_information1%type;
4106: l_ff_message2 per_kr_assignment_yea_info.ayi_information1%type;
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4102: l_return_status varchar2(5);
4103: l_return_message varchar2(300);
4104: l_ff_message0 per_kr_assignment_yea_info.ayi_information1%type;
4105: l_ff_message1 per_kr_assignment_yea_info.ayi_information1%type;
4106: l_ff_message2 per_kr_assignment_yea_info.ayi_information1%type;
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4103: l_return_message varchar2(300);
4104: l_ff_message0 per_kr_assignment_yea_info.ayi_information1%type;
4105: l_ff_message1 per_kr_assignment_yea_info.ayi_information1%type;
4106: l_ff_message2 per_kr_assignment_yea_info.ayi_information1%type;
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4104: l_ff_message0 per_kr_assignment_yea_info.ayi_information1%type;
4105: l_ff_message1 per_kr_assignment_yea_info.ayi_information1%type;
4106: l_ff_message2 per_kr_assignment_yea_info.ayi_information1%type;
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4112: l_ff_message8 per_kr_assignment_yea_info.ayi_information1%type;
4105: l_ff_message1 per_kr_assignment_yea_info.ayi_information1%type;
4106: l_ff_message2 per_kr_assignment_yea_info.ayi_information1%type;
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4112: l_ff_message8 per_kr_assignment_yea_info.ayi_information1%type;
4113: l_ff_message9 per_kr_assignment_yea_info.ayi_information1%type;
4106: l_ff_message2 per_kr_assignment_yea_info.ayi_information1%type;
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4112: l_ff_message8 per_kr_assignment_yea_info.ayi_information1%type;
4113: l_ff_message9 per_kr_assignment_yea_info.ayi_information1%type;
4114: l_ff_return_status varchar2(30);
4107: l_ff_message3 per_kr_assignment_yea_info.ayi_information1%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4112: l_ff_message8 per_kr_assignment_yea_info.ayi_information1%type;
4113: l_ff_message9 per_kr_assignment_yea_info.ayi_information1%type;
4114: l_ff_return_status varchar2(30);
4115: l_failed_record per_kr_assignment_yea_info.information_type%type;
4108: l_ff_message4 per_kr_assignment_yea_info.ayi_information1%type;
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4112: l_ff_message8 per_kr_assignment_yea_info.ayi_information1%type;
4113: l_ff_message9 per_kr_assignment_yea_info.ayi_information1%type;
4114: l_ff_return_status varchar2(30);
4115: l_failed_record per_kr_assignment_yea_info.information_type%type;
4116: -- Bug 14062211
4109: l_ff_message5 per_kr_assignment_yea_info.ayi_information1%type;
4110: l_ff_message6 per_kr_assignment_yea_info.ayi_information1%type;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4112: l_ff_message8 per_kr_assignment_yea_info.ayi_information1%type;
4113: l_ff_message9 per_kr_assignment_yea_info.ayi_information1%type;
4114: l_ff_return_status varchar2(30);
4115: l_failed_record per_kr_assignment_yea_info.information_type%type;
4116: -- Bug 14062211
4117: p_stat_self number;
4111: l_ff_message7 per_kr_assignment_yea_info.ayi_information1%type;
4112: l_ff_message8 per_kr_assignment_yea_info.ayi_information1%type;
4113: l_ff_message9 per_kr_assignment_yea_info.ayi_information1%type;
4114: l_ff_return_status varchar2(30);
4115: l_failed_record per_kr_assignment_yea_info.information_type%type;
4116: -- Bug 14062211
4117: p_stat_self number;
4118: p_stat_spouse number;
4119: p_stat_child number;
4242: tei.ayi_information8 emp_stock_own_plan_contri,
4243: tei.ayi_information9 credit_card_exp_dpnt,
4244: tei.ayi_information15 pen_prem,
4245: sptei2.ayi_information11 ltci_prem
4246: from per_kr_assignment_yea_info sptei,
4247: per_kr_assignment_yea_info sptei2,
4248: per_kr_assignment_yea_info sptei3,
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4243: tei.ayi_information9 credit_card_exp_dpnt,
4244: tei.ayi_information15 pen_prem,
4245: sptei2.ayi_information11 ltci_prem
4246: from per_kr_assignment_yea_info sptei,
4247: per_kr_assignment_yea_info sptei2,
4248: per_kr_assignment_yea_info sptei3,
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4244: tei.ayi_information15 pen_prem,
4245: sptei2.ayi_information11 ltci_prem
4246: from per_kr_assignment_yea_info sptei,
4247: per_kr_assignment_yea_info sptei2,
4248: per_kr_assignment_yea_info sptei3,
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4245: sptei2.ayi_information11 ltci_prem
4246: from per_kr_assignment_yea_info sptei,
4247: per_kr_assignment_yea_info sptei2,
4248: per_kr_assignment_yea_info sptei3,
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4253: per_kr_assignment_yea_info tei2,
4246: from per_kr_assignment_yea_info sptei,
4247: per_kr_assignment_yea_info sptei2,
4248: per_kr_assignment_yea_info sptei3,
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4253: per_kr_assignment_yea_info tei2,
4254: per_kr_assignment_yea_info eed,
4247: per_kr_assignment_yea_info sptei2,
4248: per_kr_assignment_yea_info sptei3,
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4253: per_kr_assignment_yea_info tei2,
4254: per_kr_assignment_yea_info eed,
4255: per_kr_assignment_yea_info es
4248: per_kr_assignment_yea_info sptei3,
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4253: per_kr_assignment_yea_info tei2,
4254: per_kr_assignment_yea_info eed,
4255: per_kr_assignment_yea_info es
4256: where sptei.assignment_id = p_assignment_id
4249: per_kr_assignment_yea_info fwtbi,
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4253: per_kr_assignment_yea_info tei2,
4254: per_kr_assignment_yea_info eed,
4255: per_kr_assignment_yea_info es
4256: where sptei.assignment_id = p_assignment_id
4257: and sptei.target_year = g_target_yyyy
4250: per_kr_assignment_yea_info ovtbi,
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4253: per_kr_assignment_yea_info tei2,
4254: per_kr_assignment_yea_info eed,
4255: per_kr_assignment_yea_info es
4256: where sptei.assignment_id = p_assignment_id
4257: and sptei.target_year = g_target_yyyy
4258: and sptei.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
4251: per_kr_assignment_yea_info tbi,
4252: per_kr_assignment_yea_info tei,
4253: per_kr_assignment_yea_info tei2,
4254: per_kr_assignment_yea_info eed,
4255: per_kr_assignment_yea_info es
4256: where sptei.assignment_id = p_assignment_id
4257: and sptei.target_year = g_target_yyyy
4258: and sptei.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
4259: and sptei2.assignment_id = sptei.assignment_id
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'
4296: and target_year = g_target_yyyy;
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'
4310: and target_year = g_target_yyyy
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'
4339: and target_year = g_target_yyyy;
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'
4353: and target_year = g_target_yyyy;
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'
4369: and target_year = g_target_yyyy;
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'
4381: and target_year = g_target_yyyy;
6797: if g_debug then
6798: hr_utility.set_location(l_proc,0);
6799: end if;
6800: --
6801: update per_kr_assignment_yea_info
6802: set ayi_information14 = decode(nvl(p_error_code,'X'),'X',decode(nvl(p_status,'X'),'C',c_upload_status,ayi_information14),c_error_status),
6803: ayi_information16 = p_status,
6804: ayi_information17 = p_error_code,
6805: object_version_number = object_version_number + 1
7172: where fl.program_name = 'PAYKRYPIM'
7173: and fl.program_tag = to_char(p_business_group_id)||':'||to_char(p_target_year)
7174: and not exists(
7175: select null
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));
7261: --
7262: fnd_gfm.delete_lob(l_csr_file.file_id);
7263: --
7264: -- leave status because status is not only about pdf
7265: update per_kr_assignment_yea_info
7266: set ayi_information14 = decode(p_with_status,'Y',null,ayi_information14),
7267: ayi_information15 = null,
7268: ayi_information16 = decode(p_with_status,'Y',null,ayi_information16),
7269: object_version_number = object_version_number + 1
7291: is
7292: --
7293: l_proc varchar2(80) := c_package||'mass_delete_pdf';
7294: --
7295: -- this should include file which does not have map into per_kr_assignment_yea_info
7296: cursor csr_mass_file
7297: is
7298: select file_id
7299: from fnd_lobs