[Home] [Help]
2149: min(el.effective_start_date) effective_start_date,
2150: max(el.effective_end_date) effective_end_date
2151: from pay_element_links_f el
2152: where el.element_type_id = p_element_type_id
2153: and el.standard_link_flag = 'N'
2154: and el.business_group_id = p_business_group_id
2155: --
2156: -- make sure EL piece overlaps validation period
2157: --
2626: ee.creator_id,
2627: ee.effective_start_date,
2628: ee.effective_end_date,
2629: el.element_link_id,
2630: el.standard_link_flag,
2631: el.element_type_id
2632: from
2633: pay_element_entries_f ee,
2634: pay_element_links_f el,
2715: and pb.pay_basis_id = asg.pay_basis_id
2716: )
2717: -- change 115.26
2718: or
2719: el.standard_link_flag = 'Y' and
2720: el.pay_basis_id is null and
2721: asg.pay_basis_id is null and
2722: EXISTS
2723: (SELECT pb.pay_basis_id
3779: p_assignment_id number,
3780: p_asg_start_date date,
3781: p_element_link_id number,
3782: p_link_start_date date,
3783: p_standard_link_flag varchar2,
3784: p_entry_start_date out nocopy date,
3785: p_entry_end_date out nocopy date
3786: ) is
3787: --
3806: hr_utility.trace (' p_element_link_id = '
3807: ||to_char (p_element_link_id));
3808: hr_utility.trace (' p_link_start_date = '
3809: ||to_char (p_link_start_date));
3810: hr_utility.trace (' p_standard_link_flag = '
3811: ||p_standard_link_flag);
3812: hr_utility.trace ('');
3813: --
3814: end check_parameters;
3807: ||to_char (p_element_link_id));
3808: hr_utility.trace (' p_link_start_date = '
3809: ||to_char (p_link_start_date));
3810: hr_utility.trace (' p_standard_link_flag = '
3811: ||p_standard_link_flag);
3812: hr_utility.trace ('');
3813: --
3814: end check_parameters;
3815: --
3818: if g_debug then
3819: check_parameters;
3820: end if;
3821: --
3822: -- Only take into account personal qualifying conditions for standard
3823: -- element entries.
3824: --
3825: if p_standard_link_flag = 'Y' then
3826: --
3821: --
3822: -- Only take into account personal qualifying conditions for standard
3823: -- element entries.
3824: --
3825: if p_standard_link_flag = 'Y' then
3826: --
3827: hr_entry.return_qualifying_conditions
3828: (p_assignment_id,
3829: p_element_link_id,
4702: (
4703: p_dt_mode varchar2,
4704: p_assignment_id number,
4705: p_element_link_id number,
4706: p_standard_link_flag varchar2,
4707: p_mult_ent_allowed_flag varchar2,
4708: p_validation_start_date date,
4709: p_validation_end_date date,
4710: p_val_start_date_minus_one date,
4832: hr_utility.trace (' p_assignment_id = '
4833: ||to_char (p_assignment_id));
4834: hr_utility.trace (' p_element_link_id = '
4835: ||to_char (p_element_link_id));
4836: hr_utility.trace (' p_standard_link_flag = '
4837: ||p_standard_link_flag);
4838: hr_utility.trace (' p_mult_ent_allowed_flag = '
4839: ||p_mult_ent_allowed_flag);
4840: hr_utility.trace (' p_validation_start_date = '
4833: ||to_char (p_assignment_id));
4834: hr_utility.trace (' p_element_link_id = '
4835: ||to_char (p_element_link_id));
4836: hr_utility.trace (' p_standard_link_flag = '
4837: ||p_standard_link_flag);
4838: hr_utility.trace (' p_mult_ent_allowed_flag = '
4839: ||p_mult_ent_allowed_flag);
4840: hr_utility.trace (' p_validation_start_date = '
4841: ||to_char (p_validation_start_date));
4853: hr_utility.trace ('');
4854: --
4855: end check_parameters;
4856: --
4857: function standard_element (
4858: --
4859: -- Returns TRUE if the element link specified is a standard
4860: -- one.
4861: --
4855: end check_parameters;
4856: --
4857: function standard_element (
4858: --
4859: -- Returns TRUE if the element link specified is a standard
4860: -- one.
4861: --
4862: p_element_link_id in number,
4863: p_effective_date in date)
4863: p_effective_date in date)
4864: --
4865: return boolean is
4866: --
4867: cursor csr_standard_link is
4868: --
4869: select standard_link_flag
4870: from pay_element_links_f
4871: where element_link_id = p_element_link_id
4865: return boolean is
4866: --
4867: cursor csr_standard_link is
4868: --
4869: select standard_link_flag
4870: from pay_element_links_f
4871: where element_link_id = p_element_link_id
4872: and p_effective_date between effective_start_date
4873: and effective_end_date;
4871: where element_link_id = p_element_link_id
4872: and p_effective_date between effective_start_date
4873: and effective_end_date;
4874: --
4875: l_standard varchar2 (30) := 'N';
4876: no_link_found exception;
4877: --
4878: begin
4879: --
4876: no_link_found exception;
4877: --
4878: begin
4879: --
4880: open csr_standard_link;
4881: fetch csr_standard_link into l_standard;
4882: --
4883: if csr_standard_link%notfound then
4884: close csr_standard_link;
4877: --
4878: begin
4879: --
4880: open csr_standard_link;
4881: fetch csr_standard_link into l_standard;
4882: --
4883: if csr_standard_link%notfound then
4884: close csr_standard_link;
4885: raise no_link_found;
4879: --
4880: open csr_standard_link;
4881: fetch csr_standard_link into l_standard;
4882: --
4883: if csr_standard_link%notfound then
4884: close csr_standard_link;
4885: raise no_link_found;
4886: else
4887: close csr_standard_link;
4880: open csr_standard_link;
4881: fetch csr_standard_link into l_standard;
4882: --
4883: if csr_standard_link%notfound then
4884: close csr_standard_link;
4885: raise no_link_found;
4886: else
4887: close csr_standard_link;
4888: end if;
4883: if csr_standard_link%notfound then
4884: close csr_standard_link;
4885: raise no_link_found;
4886: else
4887: close csr_standard_link;
4888: end if;
4889: --
4890: return (l_standard = 'Y');
4891: --
4886: else
4887: close csr_standard_link;
4888: end if;
4889: --
4890: return (l_standard = 'Y');
4891: --
4892: EXCEPTION
4893: --
4894: when no_link_found then
4898: 'hrentmnt.adjust_recurring_entries');
4899: fnd_message.set_token ('STEP','1');
4900: fnd_message.raise_error;
4901: --
4902: end standard_element;
4903: --
4904: function check_prior_eligibility (p_assignment_id number
4905: ,p_element_link_id number
4906: ,p_effective_date date)
5084: v_first_entry_adjusted := true;
5085: --
5086: -- Existing element entry starts after the calculated start date
5087: -- of new entry so need move the start date backwards. NB This
5088: -- should only be done for standard elements.
5089: --
5090: -- calc entry |------------------------>
5091: -- current entry |------------------->
5092: --
5097: -- backwards in line with the calculated ESD,
5098: -- only in the case where the old hire date is the
5099: -- same as the current entry start date (fix 1711753).
5100: -- nb. this breaks the rule that EEs associated
5101: -- with a non-standard element link should NOT have their
5102: -- ESD/EED altered programatically, however in the case of
5103: -- Salary Proposal EEs this is ok
5104: --
5105: elsif v_entry_start_date > v_calc_entry_start_date and
5105: elsif v_entry_start_date > v_calc_entry_start_date and
5106: v_calc_entry_start_date >= p_validation_start_date and
5107: v_calc_entry_start_date < p_val_end_date_plus_one and
5108: not v_first_entry_adjusted and
5109: (standard_element(v_entry.element_link_id,
5110: v_calc_entry_start_date)
5111: or
5112: (v_entry.creator_type = 'SP'
5113: and p_old_hire_date = v_entry_start_date)
5168: p_entries_changed);
5169: --
5170: -- Existing element entry ends before the calculated end date
5171: -- of new entry so need move the end date forwards. NB This
5172: -- should only be done for standard elements.
5173: -- Bug 514895. Enabled for non standard elements, this makes above sentence
5174: -- invalid.
5175: --
5176: -- calc entry |------------------------------->
5169: --
5170: -- Existing element entry ends before the calculated end date
5171: -- of new entry so need move the end date forwards. NB This
5172: -- should only be done for standard elements.
5173: -- Bug 514895. Enabled for non standard elements, this makes above sentence
5174: -- invalid.
5175: --
5176: -- calc entry |------------------------------->
5177: -- current entry |------------------|
5198: --
5199: -- calc entry |--------------------------|
5200: -- current entry |-----------| (do not extend)
5201: --
5202: -- Bug 514895. Removed condition for standard element. See comments above.
5203: --
5204:
5205: --
5206: -- bug 911328,
5218: (
5219: -- Bugfix 4221603
5220: -- In UPDATE_OVERRIDE mode, only move
5221: -- end date forwards when the entry is
5222: -- a standard entry.
5223: (p_dt_mode = 'UPDATE_OVERRIDE' and
5224: standard_element(v_entry.element_link_id,
5225: v_calc_entry_end_date) and
5226: -- Bugfix 4765204
5220: -- In UPDATE_OVERRIDE mode, only move
5221: -- end date forwards when the entry is
5222: -- a standard entry.
5223: (p_dt_mode = 'UPDATE_OVERRIDE' and
5224: standard_element(v_entry.element_link_id,
5225: v_calc_entry_end_date) and
5226: -- Bugfix 4765204
5227: -- Only continue if entry ends within the
5228: -- 'range of change'.
5243: ) and
5244: (
5245: (p_dt_mode = 'DELETE_NEXT_CHANGE' and
5246: p_val_start_date_minus_one = v_entry_end_date and
5247: standard_element(v_entry.element_link_id,
5248: v_calc_entry_end_date)
5249: )
5250: or
5251: (p_dt_mode = 'DELETE_NEXT_CHANGE' and
5266: (p_dt_mode <> 'DELETE_NEXT_CHANGE')
5267: ) and
5268: -- Bugfix 4354757
5269: -- Only move end date forwards in FUTURE_CHANGE mode
5270: -- for standard entries, salary proposal entries and
5271: -- US tax entries (to be consistent with
5272: -- DELETE_NEXT_CHANGE mode).
5273: (
5274: (p_dt_mode = 'FUTURE_CHANGE' and
5272: -- DELETE_NEXT_CHANGE mode).
5273: (
5274: (p_dt_mode = 'FUTURE_CHANGE' and
5275: p_val_start_date_minus_one = v_entry_end_date and
5276: standard_element(v_entry.element_link_id,
5277: v_calc_entry_end_date)
5278: )
5279: or
5280: (p_dt_mode = 'FUTURE_CHANGE' and
5286: ) and
5287: (
5288: (p_dt_mode = 'CORRECTION' and
5289: p_val_start_date_minus_one = v_entry_end_date and
5290: standard_element(v_entry.element_link_id,
5291: v_calc_entry_end_date)
5292: )
5293: or
5294: (p_dt_mode = 'CORRECTION' and
5300: ) and
5301: (
5302: (p_dt_mode = 'INSERT' and
5303: p_val_start_date_minus_one = v_entry_end_date and
5304: standard_element(v_entry.element_link_id,
5305: v_calc_entry_end_date)
5306: )
5307: or
5308: (p_dt_mode = 'INSERT' and
5586: -- --
5587: -- DESCRIPTION --
5588: -- Adjusts element entries when the personal qualifying conditions for the --
5589: -- assignment are changed ie. DOB or probation period NB. this is only --
5590: -- applied for standard element entries as the user is able to override --
5591: -- personal qualifying conditions when creating discretionary element --
5592: -- entries. --
5593: -- NOTES --
5594: -- Only existing standard element entries are adjusted due to a change in --
5590: -- applied for standard element entries as the user is able to override --
5591: -- personal qualifying conditions when creating discretionary element --
5592: -- entries. --
5593: -- NOTES --
5594: -- Only existing standard element entries are adjusted due to a change in --
5595: -- personal qualifying conditions ie. no new standard element entries are --
5596: -- created during this process. --
5597: ------------------------------------------------------------------------------
5598: --
5591: -- personal qualifying conditions when creating discretionary element --
5592: -- entries. --
5593: -- NOTES --
5594: -- Only existing standard element entries are adjusted due to a change in --
5595: -- personal qualifying conditions ie. no new standard element entries are --
5596: -- created during this process. --
5597: ------------------------------------------------------------------------------
5598: --
5599: procedure adjust_entries_pqc
5603: ) is
5604: --
5605: -- Local Cursors
5606: --
5607: cursor csr_standard_entries is
5608: select ee.element_entry_id,
5609: ee.creator_type,
5610: ee.creator_id,
5611: ee.effective_start_date,
5618: (select null
5619: from pay_element_links_f el,
5620: pay_element_types_f et
5621: where el.element_link_id = ee.element_link_id
5622: and el.standard_link_flag = 'Y'
5623: and et.element_type_id = el.element_type_id
5624: and et.processing_type = 'R')
5625: order by ee.element_link_id, ee.effective_start_date;
5626: --
5653: if g_debug then
5654: check_parameters;
5655: end if;
5656: --
5657: -- Find all standard element entries for the assignment / element link NB.
5658: -- each date effective instance is returned in order for each element entry
5659: -- ie.
5660: --
5661: -- EE1 |-----------|-----------|----------|------------->
5679: -- loop 2 row exists before start date so remove.
5680: -- loop 3 row overlaps with QC start date so adjust.
5681: -- loop 4 leave row alone.
5682: --
5683: for v_entry in csr_standard_entries loop
5684: --
5685: -- Check to see if the qualifying condition start date has already been
5686: -- obtained for the element entry.
5687: --
5906: (
5907: p_business_group_id number,
5908: p_assignment_id number,
5909: p_actual_term_date date,
5910: p_last_standard_date date,
5911: p_final_process_date date,
5912: p_entries_changed in out nocopy varchar2,
5913: p_dt_mode varchar2,
5914: p_old_people_group_id number,
5931: cursor csr_entry
5932: (
5933: p_assignment_id number,
5934: p_actual_term_date date,
5935: p_last_standard_date date,
5936: p_final_process_date date,
5937: p_sot date
5938: ) is
5939: select ee.element_entry_id,
5953: and et.processing_type = 'R')
5954: and ee.effective_end_date =
5955: (select decode(et.post_termination_rule,
5956: 'A',nvl(p_actual_term_date,p_sot),
5957: 'L',nvl(p_last_standard_date,p_sot),
5958: 'F',nvl(p_final_process_date,p_sot),
5959: p_sot)
5960: from pay_element_links_f el,
5961: pay_element_types_f et
6006: hr_utility.trace (' p_assignment_id = '
6007: ||to_char (p_assignment_id));
6008: hr_utility.trace (' p_actual_term_date = '
6009: ||to_char (p_actual_term_date));
6010: hr_utility.trace (' p_last_standard_date = '
6011: ||to_char (p_last_standard_date));
6012: hr_utility.trace (' p_final_process_date = '
6013: ||to_char (p_final_process_date));
6014: hr_utility.trace (' p_entries_changed = '
6007: ||to_char (p_assignment_id));
6008: hr_utility.trace (' p_actual_term_date = '
6009: ||to_char (p_actual_term_date));
6010: hr_utility.trace (' p_last_standard_date = '
6011: ||to_char (p_last_standard_date));
6012: hr_utility.trace (' p_final_process_date = '
6013: ||to_char (p_final_process_date));
6014: hr_utility.trace (' p_entries_changed = '
6015: ||p_entries_changed);
6076: -- employees termination.
6077: --
6078: for v_entry in csr_entry(p_assignment_id,
6079: p_actual_term_date,
6080: p_last_standard_date,
6081: p_final_process_date,
6082: c_sot) loop
6083: --
6084: -- Get the true end date of the recurring entry.
6260: effective_end_date date);
6261: --
6262: cursor csr_link
6263: --
6264: -- Finds all standard links and also any links for which the assignment has
6265: -- entries NB. only those links that exist during the time over which the
6266: -- assignment has been changed are returned.
6267: -- also see bugs 2167881 and 2610904.
6268: --
6287: el.pay_basis_id,
6288: el.employment_category,
6289: el.people_group_id,
6290: el.element_type_id,
6291: el.standard_link_flag
6292: from pay_element_links_f el
6293: where el.business_group_id = p_business_group_id
6294: and ((el.standard_link_flag = 'Y' and
6295: exists
6290: el.element_type_id,
6291: el.standard_link_flag
6292: from pay_element_links_f el
6293: where el.business_group_id = p_business_group_id
6294: and ((el.standard_link_flag = 'Y' and
6295: exists
6296: (select null
6297: from pay_element_links_f el2
6298: where el2.element_link_id = el.element_link_id
6297: from pay_element_links_f el2
6298: where el2.element_link_id = el.element_link_id
6299: and el.effective_start_date <= p_validation_end_date
6300: and el.effective_end_date >= p_validation_start_date))
6301: or (el.standard_link_flag = 'N' and
6302: (exists
6303: (
6304: -- change 115.40
6305: --select null
6315: and ee.effective_start_date <= p_val_end_date_plus_one
6316: and ee.effective_end_date >= p_val_start_date_minus_one)) /*Bug 8879339 reverted fix for 7662923 ,it is now fixed in remove_eligible_recurring */
6317: -- bug 15932432 removed exists() check for 'SP'
6318: -- start of change 115.16 --
6319: -- Ensure this non-standard link has not been changed from/to a standard link
6320: and NOT EXISTS
6321: (SELECT null
6322: FROM PAY_ELEMENT_LINKS_F el_sub
6323: WHERE el_sub.element_link_id = el.element_link_id
6320: and NOT EXISTS
6321: (SELECT null
6322: FROM PAY_ELEMENT_LINKS_F el_sub
6323: WHERE el_sub.element_link_id = el.element_link_id
6324: and el_sub.standard_link_flag = 'Y'
6325: )
6326: -- end of change 115.16 --
6327: ))
6328: -- Change 115.60
6370: el.pay_basis_id,
6371: el.employment_category,
6372: el.people_group_id,
6373: el.element_type_id,
6374: el.standard_link_flag
6375: ;
6376: --
6377: -- Finds all assignment pieces that match the element link eg.
6378: --
6662: hrentmnt.remove_ineligible_recurring(p_assignment_id, p_entries_changed,p_validation_start_date,p_validation_end_date,p_dt_mode);
6663: --
6664: -- By this stage, all that should be left to do is to adjust the dates of
6665: -- any entries which cross the boundary of the criteria change and to insert
6666: -- any standard entries for which the assignment is eligible as a result of
6667: -- the change.
6668: --
6669: -- Find all links that are either standard links or links for which the
6670: -- assignment already has recurring entries.
6665: -- any entries which cross the boundary of the criteria change and to insert
6666: -- any standard entries for which the assignment is eligible as a result of
6667: -- the change.
6668: --
6669: -- Find all links that are either standard links or links for which the
6670: -- assignment already has recurring entries.
6671: --
6672: for v_link in csr_link ( p_business_group_id,
6673: p_assignment_id,
6699: v_link.pay_basis_id,
6700: v_link.employment_category,
6701: v_link.people_group_id);
6702: --
6703: -- Get first assignment piece matching the standard link.
6704: --
6705: fetch csr_assignment into v_assignment;
6706: --
6707: -- Assignment matching standard link has been found.
6703: -- Get first assignment piece matching the standard link.
6704: --
6705: fetch csr_assignment into v_assignment;
6706: --
6707: -- Assignment matching standard link has been found.
6708: --
6709: if csr_assignment%found then
6710: --
6711: v_asg_start_date := v_assignment.effective_start_date;
6710: --
6711: v_asg_start_date := v_assignment.effective_start_date;
6712: v_asg_end_date := v_assignment.effective_end_date;
6713: --
6714: -- Loop for all assignment pieces that match the standard link.
6715: --
6716: while csr_assignment%found loop
6717: --
6718: -- Get next piece of assignment.
6737: hrentmnt.return_entry_dates (p_assignment_id,
6738: v_asg_start_date,
6739: v_link.element_link_id,
6740: v_link.effective_start_date,
6741: v_link.standard_link_flag,
6742: v_entry_start_date,
6743: v_entry_end_date);
6744: --
6745: exception
6809: --
6810: hrentmnt.adjust_recurring_entries ( p_dt_mode,
6811: p_assignment_id,
6812: v_link.element_link_id,
6813: v_link.standard_link_flag,
6814: v_mult_ent_allowed_flag,
6815: p_validation_start_date,
6816: p_validation_end_date,
6817: v_val_start_date_minus_one,
6844: -- NAME --
6845: -- hrentmnt.maintain_entries_el --
6846: -- --
6847: -- DESCRIPTION --
6848: -- Creates element entries on creation of a standard element link. --
6849: -- If p_assignment_id is specified, the element entry is created only for --
6850: -- the assignment. By default all of the eligible assignments will be --
6851: -- processed. --
6852: ------------------------------------------------------------------------------
6870: p_people_group_id number,
6871: p_assignment_id number default null
6872: ) is
6873: --
6874: -- Finds all assignment pieces that match the standard element link eg.
6875: --
6876: -- EL |-----------------------------A------------------------------>
6877: --
6878: -- ASG |---A----|----A----|-----B-----|-----A------|-----A----->
7122: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
7123: hr_utility.raise_error;
7124: end;
7125: --
7126: -- Get first assignment piece matching the standard link.
7127: --
7128: fetch csr_assignment into v_assignment;
7129: --
7130: -- Assignment matching standard link has been found.
7126: -- Get first assignment piece matching the standard link.
7127: --
7128: fetch csr_assignment into v_assignment;
7129: --
7130: -- Assignment matching standard link has been found.
7131: --
7132: if csr_assignment%found then
7133: --
7134: -- Initialise variables for the assignment.
7158: end if;
7159: close csr_sec_asg;
7160:
7161: --
7162: -- Loop for all assignment pieces that match the standard link.
7163: --
7164: while csr_assignment%found loop
7165: --
7166: -- Get next piece of assignment.
7204: -- An element entry needs to be created.
7205: --
7206: if v_entry_start_date is not null then
7207: --
7208: -- Create new element netry for standard link.
7209: --
7210: if g_debug then
7211: hr_utility.trace('********** SL creation');
7212: hr_utility.trace('********** for SL call EE insert interface');
7322: pel.location_id,
7323: pel.grade_id,
7324: pel.pay_basis_id,
7325: pel.link_to_all_payrolls_flag,
7326: pel.standard_link_flag
7327: from pay_element_entries_f pee,
7328: pay_element_links_f pel
7329: where pee.assignment_id = p_assignment_id
7330: and pel.element_link_id = pee.element_link_id;
7383: nvl(to_char(eerec.location_id), '*') || ' ' ||
7384: nvl(to_char(eerec.grade_id), '*') || ' ' ||
7385: nvl(to_char(eerec.pay_basis_id), '*') || ' ' ||
7386: eerec.link_to_all_payrolls_flag || ' ' ||
7387: eerec.standard_link_flag);
7388:
7389: end loop;
7390:
7391: hr_utility.trace('***** dump end *****');
7415: p_new_payroll_id number,
7416: p_business_group_id number,
7417: p_operation varchar2,
7418: p_actual_term_date date,
7419: p_last_standard_date date,
7420: p_final_process_date date,
7421: p_dt_mode varchar2,
7422: p_validation_start_date date,
7423: p_validation_end_date date,
7458: hr_utility.trace (' p_operation = '
7459: ||p_operation);
7460: hr_utility.trace (' p_actual_term_date = '
7461: ||to_char (p_actual_term_date));
7462: hr_utility.trace (' p_last_standard_date = '
7463: ||to_char (p_last_standard_date));
7464: hr_utility.trace (' p_final_process_date = '
7465: ||to_char (p_final_process_date));
7466: hr_utility.trace (' p_dt_mode = '
7459: ||p_operation);
7460: hr_utility.trace (' p_actual_term_date = '
7461: ||to_char (p_actual_term_date));
7462: hr_utility.trace (' p_last_standard_date = '
7463: ||to_char (p_last_standard_date));
7464: hr_utility.trace (' p_final_process_date = '
7465: ||to_char (p_final_process_date));
7466: hr_utility.trace (' p_dt_mode = '
7467: ||p_dt_mode);
7511: hrentmnt.adjust_entries_cncl_term
7512: (p_business_group_id,
7513: p_assignment_id,
7514: p_actual_term_date,
7515: p_last_standard_date,
7516: p_final_process_date,
7517: p_entries_changed,
7518: p_dt_mode,
7519: p_old_people_group_id,
7644: p_new_payroll_id number,
7645: p_business_group_id number,
7646: p_operation varchar2,
7647: p_actual_term_date date,
7648: p_last_standard_date date,
7649: p_final_process_date date,
7650: p_dt_mode varchar2,
7651: p_validation_start_date date,
7652: p_validation_end_date date,
7682: p_new_payroll_id,
7683: p_business_group_id,
7684: p_operation,
7685: p_actual_term_date,
7686: p_last_standard_date,
7687: p_final_process_date,
7688: p_dt_mode,
7689: p_validation_start_date,
7690: p_validation_end_date,
7727: p_assignment_id number,
7728: p_business_group_id number,
7729: p_operation varchar2,
7730: p_actual_term_date date,
7731: p_last_standard_date date,
7732: p_final_process_date date,
7733: p_dt_mode varchar2,
7734: p_validation_start_date date,
7735: p_validation_end_date date
7763: 2,
7764: p_business_group_id,
7765: p_operation,
7766: p_actual_term_date,
7767: p_last_standard_date,
7768: p_final_process_date,
7769: p_dt_mode,
7770: p_validation_start_date,
7771: p_validation_end_date,