44:
45: -- Record to store earning elements
46: TYPE earn_rec IS RECORD
47: (row_id ROWID
48: ,element_name pay_element_types_f.element_name%TYPE
49: ,ptd number
50: ,month number
51: ,qtd number
52: ,ytd number
49: ,ptd number
50: ,month number
51: ,qtd number
52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
50: ,month number
51: ,qtd number
52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
51: ,qtd number
52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );
52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );
60:
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );
60:
61:
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );
60:
61:
62: -- Record to store deduction elements
61:
62: -- Record to store deduction elements
63: TYPE dedn_rec IS RECORD
64: (row_id ROWID
65: ,element_name pay_element_types_f.element_name%TYPE
66: ,ptd number
67: ,month number
68: ,qtd number
69: ,ytd number
69: ,ytd number
70: ,accrued number
71: ,arrears number
72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
70: ,accrued number
71: ,arrears number
72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
71: ,arrears number
72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );
72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );
80:
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );
80:
81:
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );
80:
81:
82: -- Declare tables for records
105: PROCEDURE populate_element_info( p_assignment_id in number,
106: p_assignment_action_id in number,
107: p_classification_id in pay_element_classifications.classification_id%TYPE,
108: p_classification_name in pay_element_classifications.classification_name%TYPE,
109: p_session_date in pay_element_types_f.effective_start_date%TYPE,
110: p_action_date in pay_element_types_f.effective_start_date%TYPE,
111: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
112: p_tax_unit_id in number,
113: p_per_month in number,
106: p_assignment_action_id in number,
107: p_classification_id in pay_element_classifications.classification_id%TYPE,
108: p_classification_name in pay_element_classifications.classification_name%TYPE,
109: p_session_date in pay_element_types_f.effective_start_date%TYPE,
110: p_action_date in pay_element_types_f.effective_start_date%TYPE,
111: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
112: p_tax_unit_id in number,
113: p_per_month in number,
114: p_per_qtd in number,
107: p_classification_id in pay_element_classifications.classification_id%TYPE,
108: p_classification_name in pay_element_classifications.classification_name%TYPE,
109: p_session_date in pay_element_types_f.effective_start_date%TYPE,
110: p_action_date in pay_element_types_f.effective_start_date%TYPE,
111: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
112: p_tax_unit_id in number,
113: p_per_month in number,
114: p_per_qtd in number,
115: p_per_ytd in number,
117: p_asg_month in number,
118: p_asg_qtd in number,
119: p_asg_ytd in number,
120: p_asg_itd in number,
121: p_legislation_code in pay_element_types_f.legislation_code%TYPE,
122: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
123: p_balance_level in varchar2,
124: p_earn_data out nocopy earn_tbl,
125: p_dedn_data out nocopy dedn_tbl,
118: p_asg_qtd in number,
119: p_asg_ytd in number,
120: p_asg_itd in number,
121: p_legislation_code in pay_element_types_f.legislation_code%TYPE,
122: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
123: p_balance_level in varchar2,
124: p_earn_data out nocopy earn_tbl,
125: p_dedn_data out nocopy dedn_tbl,
126: p_element_type_id in out nocopy number,