[Home] [Help]
905: that are created. */
906:
907: l_payroll_action_created boolean := false;
908: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
909: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
910: l_archive_item_id number;
911:
912: /* Variable holding the balance to be tested. */
913:
957: lockingactid number;
958: l_max_aaid number;
959: l_pre_org_id varchar2(17);
960: l_prev_pre_org_id varchar2(17);
961: l_primary_asg pay_assignment_actions.assignment_id%type;
962: ln_no_gross_earnings number;
963:
964:
965: /* For Year End Preprocess we have to archive the assignments
1006: SELECT asg.person_id person_id,
1007: asg.assignment_id assignment_id,
1008: asg.effective_end_date effective_end_date
1009: FROM per_all_assignments_f asg,
1010: pay_assignment_actions paa,
1011: pay_payroll_actions ppa
1012: WHERE ppa.effective_date between l_period_start
1013: and l_period_end
1014: AND ppa.action_type in ('R','Q','V','B','I')
1042: SELECT asg.person_id person_id,
1043: asg.assignment_id assignment_id,
1044: asg.effective_end_date effective_end_date
1045: FROM per_all_assignments_f asg,
1046: pay_assignment_actions paa,
1047: pay_payroll_actions ppa,
1048: pay_population_ranges ppr
1049: WHERE ppa.effective_date between l_period_start
1050: and l_period_end
1103: cp_tax_unit_id number,
1104: cp_period_start date,
1105: cp_period_end date) IS
1106: select paa.assignment_action_id
1107: from pay_assignment_actions paa,
1108: per_all_assignments_f paf,
1109: per_all_people_f ppf,
1110: pay_payroll_actions ppa,
1111: pay_action_classifications pac
1355:
1356: /* Create the assignment action to represnt the person / tax unit
1357: combination. */
1358:
1359: select pay_assignment_actions_s.nextval
1360: into lockingactid
1361: from dual;
1362:
1363: /* Insert into pay_assignment_actions. */
1359: select pay_assignment_actions_s.nextval
1360: into lockingactid
1361: from dual;
1362:
1363: /* Insert into pay_assignment_actions. */
1364:
1365: hr_utility.trace('creating assignment_action');
1366:
1367: /* Passing tax unit id as null */
1376: */
1377:
1378: hr_utility.trace('updating assignment_action' || to_char(lockingactid));
1379:
1380: update pay_assignment_actions aa
1381: set aa.serial_number = to_char(l_person_id)
1382: where aa.assignment_action_id = lockingactid;
1383:
1384: end if; /* end if l_value <> 0 or ln_no_gross_earnings <> 0 */
1892: l_step number := 0;
1893:
1894: cursor c_get_min_chunk is
1895: select min(paa.chunk_number)
1896: from pay_assignment_actions paa
1897: where paa.payroll_action_id = p_payroll_action_id;
1898: begin
1899: open c_get_min_chunk;
1900: fetch c_get_min_chunk into g_min_chunk;
2013:
2014: /* RL2 Slip number generation */
2015:
2016:
2017: FUNCTION gen_rl2_slip_no(p_transmitter_id number,p_asgid pay_assignment_actions.assignment_id%type)
2018: return varchar2 is
2019:
2020: l_rl2_slip_number_last_digit number;
2021: l_rl2_curr_slip_number number;
2099: p_source_of_income_descr in varchar2 default NULL,
2100: p_negative_balance_exists in out NOCOPY varchar2,
2101: p_temp_fi in out NOCOPY number ) IS
2102:
2103: l_aaid pay_assignment_actions.assignment_action_id%type;
2104: l_asgid pay_assignment_actions.assignment_id%type;
2105: l_date_earned date;
2106: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2107: l_reporting_type varchar2(240);
2100: p_negative_balance_exists in out NOCOPY varchar2,
2101: p_temp_fi in out NOCOPY number ) IS
2102:
2103: l_aaid pay_assignment_actions.assignment_action_id%type;
2104: l_asgid pay_assignment_actions.assignment_id%type;
2105: l_date_earned date;
2106: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2107: l_reporting_type varchar2(240);
2108: l_business_group_id number;
2102:
2103: l_aaid pay_assignment_actions.assignment_action_id%type;
2104: l_asgid pay_assignment_actions.assignment_id%type;
2105: l_date_earned date;
2106: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2107: l_reporting_type varchar2(240);
2108: l_business_group_id number;
2109: l_year_start date;
2110: l_year_end date;
2117: l_pre_org_id varchar2(80);
2118:
2119: l_negative_balance_exists varchar2(2);
2120: result number;
2121: l_rl2_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2122: lv_serial_number varchar2(30);
2123: l_user_entity_name_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2124: l_balance_type_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
2125: l_footnote_balance_type_tab varchar2(80);
2130: transmitter PRE */
2131: cursor c_all_gres(asgactid number) is
2132: select hoi.organization_id
2133: from pay_action_information pac,
2134: pay_assignment_actions paa,
2135: hr_organization_information hoi
2136: where paa.assignment_action_id = asgactid
2137: and pac.action_context_id = paa.payroll_action_id
2138: and pac.action_information_category = 'CAEOY TRANSMITTER INFO'
2149: cp_tax_unit_id number,
2150: cp_period_start date,
2151: cp_period_end date) IS
2152: select paa.assignment_action_id
2153: from pay_assignment_actions paa,
2154: per_all_assignments_f paf,
2155: per_all_people_f ppf,
2156: pay_payroll_actions ppa,
2157: pay_action_classifications pac,
2199: l_tax_unit_id,
2200: l_chunk,
2201: l_payroll_action_id,
2202: lv_serial_number
2203: FROM pay_assignment_actions aa
2204: WHERE aa.assignment_action_id = p_assactid;
2205:
2206: l_rl2_tax_unit_id := l_tax_unit_id;
2207:
2441:
2442: PROCEDURE eoy_archive_data(p_assactid in number,
2443: p_effective_date in date) IS
2444:
2445: l_aaid pay_assignment_actions.assignment_action_id%type;
2446: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2447: l_aaseq pay_assignment_actions.action_sequence%type;
2448: l_asgid pay_assignment_actions.assignment_id%type;
2449: l_date_earned date;
2442: PROCEDURE eoy_archive_data(p_assactid in number,
2443: p_effective_date in date) IS
2444:
2445: l_aaid pay_assignment_actions.assignment_action_id%type;
2446: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2447: l_aaseq pay_assignment_actions.action_sequence%type;
2448: l_asgid pay_assignment_actions.assignment_id%type;
2449: l_date_earned date;
2450: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2443: p_effective_date in date) IS
2444:
2445: l_aaid pay_assignment_actions.assignment_action_id%type;
2446: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2447: l_aaseq pay_assignment_actions.action_sequence%type;
2448: l_asgid pay_assignment_actions.assignment_id%type;
2449: l_date_earned date;
2450: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2451: l_reporting_type varchar2(240);
2444:
2445: l_aaid pay_assignment_actions.assignment_action_id%type;
2446: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2447: l_aaseq pay_assignment_actions.action_sequence%type;
2448: l_asgid pay_assignment_actions.assignment_id%type;
2449: l_date_earned date;
2450: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2451: l_reporting_type varchar2(240);
2452: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;
2446: l_aaid1 pay_assignment_actions.assignment_action_id%type;
2447: l_aaseq pay_assignment_actions.action_sequence%type;
2448: l_asgid pay_assignment_actions.assignment_id%type;
2449: l_date_earned date;
2450: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2451: l_reporting_type varchar2(240);
2452: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;
2453: l_business_group_id number;
2454: l_year_start date;
2448: l_asgid pay_assignment_actions.assignment_id%type;
2449: l_date_earned date;
2450: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2451: l_reporting_type varchar2(240);
2452: l_prev_tax_unit_id pay_assignment_actions.tax_unit_id%type := null;
2453: l_business_group_id number;
2454: l_year_start date;
2455: l_year_end date;
2456: l_context_no number := 60;
2554:
2555: ln_status_indian NUMBER := 0;
2556: ln_index NUMBER;
2557: ln_footnote_index NUMBER;
2558: l_rl2_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2559: lv_footnote_bal varchar2(80);
2560:
2561: l_rl2_source_of_income varchar2(150);
2562: l_per_eit_source_of_income varchar2(150);
2620: cursor c_all_gres(asgactid number) is
2621: select hoi.organization_id ,
2622: hoi.org_information5
2623: from pay_action_information pac,
2624: pay_assignment_actions paa,
2625: hr_organization_information hoi
2626: where paa.assignment_action_id = asgactid
2627: and pac.action_context_id = paa.payroll_action_id
2628: and pac.action_information_category = 'CAEOY TRANSMITTER INFO'
2636: cursor c_all_gres_for_footnote(asgactid number) is
2637: select hoi.organization_id ,
2638: hoi.org_information5
2639: from pay_action_information pac,
2640: pay_assignment_actions paa,
2641: hr_organization_information hoi
2642: where paa.assignment_action_id = asgactid
2643: and pac.action_context_id = paa.payroll_action_id
2644: and pac.action_information_category = 'CAEOY TRANSMITTER INFO'
2732: cp_tax_unit_id number,
2733: cp_period_start date,
2734: cp_period_end date) IS
2735: select paa.assignment_action_id
2736: from pay_assignment_actions paa,
2737: per_all_assignments_f paf,
2738: per_all_people_f ppf,
2739: pay_payroll_actions ppa,
2740: pay_action_classifications pac,
2806: l_tax_unit_id,
2807: l_chunk,
2808: l_payroll_action_id,
2809: lv_serial_number
2810: FROM pay_assignment_actions aa
2811: WHERE aa.assignment_action_id = p_assactid;
2812:
2813: l_rl2_tax_unit_id := l_tax_unit_id;
2814:
4082:
4083: sqlstr := 'select distinct asg.person_id
4084: from pay_all_payrolls_f ppy,
4085: pay_payroll_actions ppa,
4086: pay_assignment_actions paa,
4087: per_all_assignments_f asg,
4088: pay_payroll_actions ppa1
4089: where ppa1.payroll_action_id = :payroll_action_id
4090: and ppa.effective_date between