[Home] [Help]
1869: min(el.effective_start_date) effective_start_date,
1870: max(el.effective_end_date) effective_end_date
1871: from pay_element_links_f el
1872: where el.element_type_id = p_element_type_id
1873: and el.standard_link_flag = 'N'
1874: and el.business_group_id = p_business_group_id
1875: --
1876: -- make sure EL piece overlaps validation period
1877: --
2295: ee.creator_id,
2296: ee.effective_start_date,
2297: ee.effective_end_date,
2298: el.element_link_id,
2299: el.standard_link_flag,
2300: el.element_type_id
2301: from
2302: pay_element_entries_f ee,
2303: pay_element_links_f el,
2384: and pb.pay_basis_id = asg.pay_basis_id
2385: )
2386: -- change 115.26
2387: or
2388: el.standard_link_flag = 'Y' and
2389: el.pay_basis_id is null and
2390: asg.pay_basis_id is null and
2391: EXISTS
2392: (SELECT pb.pay_basis_id
3142: p_assignment_id number,
3143: p_asg_start_date date,
3144: p_element_link_id number,
3145: p_link_start_date date,
3146: p_standard_link_flag varchar2,
3147: p_entry_start_date out nocopy date,
3148: p_entry_end_date out nocopy date
3149: ) is
3150: --
3169: hr_utility.trace (' p_element_link_id = '
3170: ||to_char (p_element_link_id));
3171: hr_utility.trace (' p_link_start_date = '
3172: ||to_char (p_link_start_date));
3173: hr_utility.trace (' p_standard_link_flag = '
3174: ||p_standard_link_flag);
3175: hr_utility.trace ('');
3176: --
3177: end check_parameters;
3170: ||to_char (p_element_link_id));
3171: hr_utility.trace (' p_link_start_date = '
3172: ||to_char (p_link_start_date));
3173: hr_utility.trace (' p_standard_link_flag = '
3174: ||p_standard_link_flag);
3175: hr_utility.trace ('');
3176: --
3177: end check_parameters;
3178: --
3181: if g_debug then
3182: check_parameters;
3183: end if;
3184: --
3185: -- Only take into account personal qualifying conditions for standard
3186: -- element entries.
3187: --
3188: if p_standard_link_flag = 'Y' then
3189: --
3184: --
3185: -- Only take into account personal qualifying conditions for standard
3186: -- element entries.
3187: --
3188: if p_standard_link_flag = 'Y' then
3189: --
3190: hr_entry.return_qualifying_conditions
3191: (p_assignment_id,
3192: p_element_link_id,
3967: (
3968: p_dt_mode varchar2,
3969: p_assignment_id number,
3970: p_element_link_id number,
3971: p_standard_link_flag varchar2,
3972: p_mult_ent_allowed_flag varchar2,
3973: p_validation_start_date date,
3974: p_validation_end_date date,
3975: p_val_start_date_minus_one date,
4096: hr_utility.trace (' p_assignment_id = '
4097: ||to_char (p_assignment_id));
4098: hr_utility.trace (' p_element_link_id = '
4099: ||to_char (p_element_link_id));
4100: hr_utility.trace (' p_standard_link_flag = '
4101: ||p_standard_link_flag);
4102: hr_utility.trace (' p_mult_ent_allowed_flag = '
4103: ||p_mult_ent_allowed_flag);
4104: hr_utility.trace (' p_validation_start_date = '
4097: ||to_char (p_assignment_id));
4098: hr_utility.trace (' p_element_link_id = '
4099: ||to_char (p_element_link_id));
4100: hr_utility.trace (' p_standard_link_flag = '
4101: ||p_standard_link_flag);
4102: hr_utility.trace (' p_mult_ent_allowed_flag = '
4103: ||p_mult_ent_allowed_flag);
4104: hr_utility.trace (' p_validation_start_date = '
4105: ||to_char (p_validation_start_date));
4117: hr_utility.trace ('');
4118: --
4119: end check_parameters;
4120: --
4121: function standard_element (
4122: --
4123: -- Returns TRUE if the element link specified is a standard
4124: -- one.
4125: --
4119: end check_parameters;
4120: --
4121: function standard_element (
4122: --
4123: -- Returns TRUE if the element link specified is a standard
4124: -- one.
4125: --
4126: p_element_link_id in number,
4127: p_effective_date in date)
4127: p_effective_date in date)
4128: --
4129: return boolean is
4130: --
4131: cursor csr_standard_link is
4132: --
4133: select standard_link_flag
4134: from pay_element_links_f
4135: where element_link_id = p_element_link_id
4129: return boolean is
4130: --
4131: cursor csr_standard_link is
4132: --
4133: select standard_link_flag
4134: from pay_element_links_f
4135: where element_link_id = p_element_link_id
4136: and p_effective_date between effective_start_date
4137: and effective_end_date;
4135: where element_link_id = p_element_link_id
4136: and p_effective_date between effective_start_date
4137: and effective_end_date;
4138: --
4139: l_standard varchar2 (30) := 'N';
4140: no_link_found exception;
4141: --
4142: begin
4143: --
4140: no_link_found exception;
4141: --
4142: begin
4143: --
4144: open csr_standard_link;
4145: fetch csr_standard_link into l_standard;
4146: --
4147: if csr_standard_link%notfound then
4148: close csr_standard_link;
4141: --
4142: begin
4143: --
4144: open csr_standard_link;
4145: fetch csr_standard_link into l_standard;
4146: --
4147: if csr_standard_link%notfound then
4148: close csr_standard_link;
4149: raise no_link_found;
4143: --
4144: open csr_standard_link;
4145: fetch csr_standard_link into l_standard;
4146: --
4147: if csr_standard_link%notfound then
4148: close csr_standard_link;
4149: raise no_link_found;
4150: else
4151: close csr_standard_link;
4144: open csr_standard_link;
4145: fetch csr_standard_link into l_standard;
4146: --
4147: if csr_standard_link%notfound then
4148: close csr_standard_link;
4149: raise no_link_found;
4150: else
4151: close csr_standard_link;
4152: end if;
4147: if csr_standard_link%notfound then
4148: close csr_standard_link;
4149: raise no_link_found;
4150: else
4151: close csr_standard_link;
4152: end if;
4153: --
4154: return (l_standard = 'Y');
4155: --
4150: else
4151: close csr_standard_link;
4152: end if;
4153: --
4154: return (l_standard = 'Y');
4155: --
4156: EXCEPTION
4157: --
4158: when no_link_found then
4162: 'hrentmnt.adjust_recurring_entries');
4163: fnd_message.set_token ('STEP','1');
4164: fnd_message.raise_error;
4165: --
4166: end standard_element;
4167: --
4168: begin
4169: --
4170: if g_debug then
4334: v_first_entry_adjusted := true;
4335: --
4336: -- Existing element entry starts after the calculated start date
4337: -- of new entry so need move the start date backwards. NB This
4338: -- should only be done for standard elements.
4339: --
4340: -- calc entry |------------------------>
4341: -- current entry |------------------->
4342: --
4347: -- backwards in line with the calculated ESD,
4348: -- only in the case where the old hire date is the
4349: -- same as the current entry start date (fix 1711753).
4350: -- nb. this breaks the rule that EEs associated
4351: -- with a non-standard element link should NOT have their
4352: -- ESD/EED altered programatically, however in the case of
4353: -- Salary Proposal EEs this is ok
4354: --
4355: elsif v_entry_start_date > v_calc_entry_start_date and
4355: elsif v_entry_start_date > v_calc_entry_start_date and
4356: v_calc_entry_start_date >= p_validation_start_date and
4357: v_calc_entry_start_date < p_val_end_date_plus_one and
4358: not v_first_entry_adjusted and
4359: (standard_element(v_entry.element_link_id,
4360: v_calc_entry_start_date)
4361: or
4362: (v_entry.creator_type = 'SP'
4363: and p_old_hire_date = v_entry_start_date)
4418: p_entries_changed);
4419: --
4420: -- Existing element entry ends before the calculated end date
4421: -- of new entry so need move the end date forwards. NB This
4422: -- should only be done for standard elements.
4423: -- Bug 514895. Enabled for non standard elements, this makes above sentence
4424: -- invalid.
4425: --
4426: -- calc entry |------------------------------->
4419: --
4420: -- Existing element entry ends before the calculated end date
4421: -- of new entry so need move the end date forwards. NB This
4422: -- should only be done for standard elements.
4423: -- Bug 514895. Enabled for non standard elements, this makes above sentence
4424: -- invalid.
4425: --
4426: -- calc entry |------------------------------->
4427: -- current entry |------------------|
4448: --
4449: -- calc entry |--------------------------|
4450: -- current entry |-----------| (do not extend)
4451: --
4452: -- Bug 514895. Removed condition for standard element. See comments above.
4453: --
4454:
4455: --
4456: -- bug 911328,
4468: (
4469: -- Bugfix 4221603
4470: -- In UPDATE_OVERRIDE mode, only move
4471: -- end date forwards when the entry is
4472: -- a standard entry.
4473: (p_dt_mode = 'UPDATE_OVERRIDE' and
4474: standard_element(v_entry.element_link_id,
4475: v_calc_entry_end_date) and
4476: -- Bugfix 4765204
4470: -- In UPDATE_OVERRIDE mode, only move
4471: -- end date forwards when the entry is
4472: -- a standard entry.
4473: (p_dt_mode = 'UPDATE_OVERRIDE' and
4474: standard_element(v_entry.element_link_id,
4475: v_calc_entry_end_date) and
4476: -- Bugfix 4765204
4477: -- Only continue if entry ends within the
4478: -- 'range of change'.
4493: ) and
4494: (
4495: (p_dt_mode = 'DELETE_NEXT_CHANGE' and
4496: p_val_start_date_minus_one = v_entry_end_date and
4497: standard_element(v_entry.element_link_id,
4498: v_calc_entry_end_date)
4499: )
4500: or
4501: (p_dt_mode = 'DELETE_NEXT_CHANGE' and
4508: (p_dt_mode <> 'DELETE_NEXT_CHANGE')
4509: ) and
4510: -- Bugfix 4354757
4511: -- Only move end date forwards in FUTURE_CHANGE mode
4512: -- for standard entries, salary proposal entries and
4513: -- US tax entries (to be consistent with
4514: -- DELETE_NEXT_CHANGE mode).
4515: (
4516: (p_dt_mode = 'FUTURE_CHANGE' and
4514: -- DELETE_NEXT_CHANGE mode).
4515: (
4516: (p_dt_mode = 'FUTURE_CHANGE' and
4517: p_val_start_date_minus_one = v_entry_end_date and
4518: standard_element(v_entry.element_link_id,
4519: v_calc_entry_end_date)
4520: )
4521: or
4522: (p_dt_mode = 'FUTURE_CHANGE' and
4528: ) and
4529: (
4530: (p_dt_mode = 'CORRECTION' and
4531: p_val_start_date_minus_one = v_entry_end_date and
4532: standard_element(v_entry.element_link_id,
4533: v_calc_entry_end_date)
4534: )
4535: or
4536: (p_dt_mode = 'CORRECTION' and
4814: -- --
4815: -- DESCRIPTION --
4816: -- Adjusts element entries when the personal qualifying conditions for the --
4817: -- assignment are changed ie. DOB or probation period NB. this is only --
4818: -- applied for standard element entries as the user is able to override --
4819: -- personal qualifying conditions when creating discretionary element --
4820: -- entries. --
4821: -- NOTES --
4822: -- Only existing standard element entries are adjusted due to a change in --
4818: -- applied for standard element entries as the user is able to override --
4819: -- personal qualifying conditions when creating discretionary element --
4820: -- entries. --
4821: -- NOTES --
4822: -- Only existing standard element entries are adjusted due to a change in --
4823: -- personal qualifying conditions ie. no new standard element entries are --
4824: -- created during this process. --
4825: ------------------------------------------------------------------------------
4826: --
4819: -- personal qualifying conditions when creating discretionary element --
4820: -- entries. --
4821: -- NOTES --
4822: -- Only existing standard element entries are adjusted due to a change in --
4823: -- personal qualifying conditions ie. no new standard element entries are --
4824: -- created during this process. --
4825: ------------------------------------------------------------------------------
4826: --
4827: procedure adjust_entries_pqc
4831: ) is
4832: --
4833: -- Local Cursors
4834: --
4835: cursor csr_standard_entries is
4836: select ee.element_entry_id,
4837: ee.creator_type,
4838: ee.creator_id,
4839: ee.effective_start_date,
4846: (select null
4847: from pay_element_links_f el,
4848: pay_element_types_f et
4849: where el.element_link_id = ee.element_link_id
4850: and el.standard_link_flag = 'Y'
4851: and et.element_type_id = el.element_type_id
4852: and et.processing_type = 'R')
4853: order by ee.element_link_id, ee.effective_start_date;
4854: --
4881: if g_debug then
4882: check_parameters;
4883: end if;
4884: --
4885: -- Find all standard element entries for the assignment / element link NB.
4886: -- each date effective instance is returned in order for each element entry
4887: -- ie.
4888: --
4889: -- EE1 |-----------|-----------|----------|------------->
4907: -- loop 2 row exists before start date so remove.
4908: -- loop 3 row overlaps with QC start date so adjust.
4909: -- loop 4 leave row alone.
4910: --
4911: for v_entry in csr_standard_entries loop
4912: --
4913: -- Check to see if the qualifying condition start date has already been
4914: -- obtained for the element entry.
4915: --
5134: (
5135: p_business_group_id number,
5136: p_assignment_id number,
5137: p_actual_term_date date,
5138: p_last_standard_date date,
5139: p_final_process_date date,
5140: p_entries_changed in out nocopy varchar2,
5141: p_dt_mode varchar2,
5142: p_old_people_group_id number,
5153: cursor csr_entry
5154: (
5155: p_assignment_id number,
5156: p_actual_term_date date,
5157: p_last_standard_date date,
5158: p_final_process_date date,
5159: p_sot date
5160: ) is
5161: select ee.element_entry_id,
5175: and et.processing_type = 'R')
5176: and ee.effective_end_date =
5177: (select decode(et.post_termination_rule,
5178: 'A',nvl(p_actual_term_date,p_sot),
5179: 'L',nvl(p_last_standard_date,p_sot),
5180: 'F',nvl(p_final_process_date,p_sot),
5181: p_sot)
5182: from pay_element_links_f el,
5183: pay_element_types_f et
5208: hr_utility.trace (' p_assignment_id = '
5209: ||to_char (p_assignment_id));
5210: hr_utility.trace (' p_actual_term_date = '
5211: ||to_char (p_actual_term_date));
5212: hr_utility.trace (' p_last_standard_date = '
5213: ||to_char (p_last_standard_date));
5214: hr_utility.trace (' p_final_process_date = '
5215: ||to_char (p_final_process_date));
5216: hr_utility.trace (' p_entries_changed = '
5209: ||to_char (p_assignment_id));
5210: hr_utility.trace (' p_actual_term_date = '
5211: ||to_char (p_actual_term_date));
5212: hr_utility.trace (' p_last_standard_date = '
5213: ||to_char (p_last_standard_date));
5214: hr_utility.trace (' p_final_process_date = '
5215: ||to_char (p_final_process_date));
5216: hr_utility.trace (' p_entries_changed = '
5217: ||p_entries_changed);
5261: -- employees termination.
5262: --
5263: for v_entry in csr_entry(p_assignment_id,
5264: p_actual_term_date,
5265: p_last_standard_date,
5266: p_final_process_date,
5267: c_sot) loop
5268: --
5269: -- Get the true end date of the recurring entry.
5428: effective_end_date date);
5429: --
5430: cursor csr_link
5431: --
5432: -- Finds all standard links and also any links for which the assignment has
5433: -- entries NB. only those links that exist during the time over which the
5434: -- assignment has been changed are returned.
5435: -- also see bugs 2167881 and 2610904.
5436: --
5455: el.pay_basis_id,
5456: el.employment_category,
5457: el.people_group_id,
5458: el.element_type_id,
5459: el.standard_link_flag
5460: from pay_element_links_f el
5461: where el.business_group_id = p_business_group_id
5462: and ((el.standard_link_flag = 'Y' and
5463: exists
5458: el.element_type_id,
5459: el.standard_link_flag
5460: from pay_element_links_f el
5461: where el.business_group_id = p_business_group_id
5462: and ((el.standard_link_flag = 'Y' and
5463: exists
5464: (select null
5465: from pay_element_links_f el2
5466: where el2.element_link_id = el.element_link_id
5465: from pay_element_links_f el2
5466: where el2.element_link_id = el.element_link_id
5467: and el.effective_start_date <= p_validation_end_date
5468: and el.effective_end_date >= p_validation_start_date))
5469: or (el.standard_link_flag = 'N' and
5470: exists
5471: (
5472: -- change 115.40
5473: --select null
5481: and ee.element_link_id = el.element_link_id
5482: and ee.effective_start_date <= p_val_end_date_plus_one
5483: and ee.effective_end_date >= p_val_start_date_minus_one)
5484: -- start of change 115.16 --
5485: -- Ensure this non-standard link has not been changed from/to a standard link
5486: and NOT EXISTS
5487: (SELECT null
5488: FROM PAY_ELEMENT_LINKS_F el_sub
5489: WHERE el_sub.element_link_id = el.element_link_id
5486: and NOT EXISTS
5487: (SELECT null
5488: FROM PAY_ELEMENT_LINKS_F el_sub
5489: WHERE el_sub.element_link_id = el.element_link_id
5490: and el_sub.standard_link_flag = 'Y'
5491: )
5492: -- end of change 115.16 --
5493: ))
5494: -- Change 115.60
5515: el.pay_basis_id,
5516: el.employment_category,
5517: el.people_group_id,
5518: el.element_type_id,
5519: el.standard_link_flag
5520: ;
5521: --
5522: -- Finds all assignment pieces that match the element link eg.
5523: --
5792: hrentmnt.remove_ineligible_recurring(p_assignment_id, p_entries_changed,p_validation_start_date,p_validation_end_date,p_dt_mode);
5793: --
5794: -- By this stage, all that should be left to do is to adjust the dates of
5795: -- any entries which cross the boundary of the criteria change and to insert
5796: -- any standard entries for which the assignment is eligible as a result of
5797: -- the change.
5798: --
5799: -- Find all links that are either standard links or links for which the
5800: -- assignment already has recurring entries.
5795: -- any entries which cross the boundary of the criteria change and to insert
5796: -- any standard entries for which the assignment is eligible as a result of
5797: -- the change.
5798: --
5799: -- Find all links that are either standard links or links for which the
5800: -- assignment already has recurring entries.
5801: --
5802: for v_link in csr_link ( p_business_group_id,
5803: p_assignment_id,
5829: v_link.pay_basis_id,
5830: v_link.employment_category,
5831: v_link.people_group_id);
5832: --
5833: -- Get first assignment piece matching the standard link.
5834: --
5835: fetch csr_assignment into v_assignment;
5836: --
5837: -- Assignment matching standard link has been found.
5833: -- Get first assignment piece matching the standard link.
5834: --
5835: fetch csr_assignment into v_assignment;
5836: --
5837: -- Assignment matching standard link has been found.
5838: --
5839: if csr_assignment%found then
5840: --
5841: v_asg_start_date := v_assignment.effective_start_date;
5840: --
5841: v_asg_start_date := v_assignment.effective_start_date;
5842: v_asg_end_date := v_assignment.effective_end_date;
5843: --
5844: -- Loop for all assignment pieces that match the standard link.
5845: --
5846: while csr_assignment%found loop
5847: --
5848: -- Get next piece of assignment.
5867: hrentmnt.return_entry_dates (p_assignment_id,
5868: v_asg_start_date,
5869: v_link.element_link_id,
5870: v_link.effective_start_date,
5871: v_link.standard_link_flag,
5872: v_entry_start_date,
5873: v_entry_end_date);
5874: --
5875: exception
5939: --
5940: hrentmnt.adjust_recurring_entries ( p_dt_mode,
5941: p_assignment_id,
5942: v_link.element_link_id,
5943: v_link.standard_link_flag,
5944: v_mult_ent_allowed_flag,
5945: p_validation_start_date,
5946: p_validation_end_date,
5947: v_val_start_date_minus_one,
5974: -- NAME --
5975: -- hrentmnt.maintain_entries_el --
5976: -- --
5977: -- DESCRIPTION --
5978: -- Creates element entries on creation of a standard element link. --
5979: -- If p_assignment_id is specified, the element entry is created only for --
5980: -- the assignment. By default all of the eligible assignments will be --
5981: -- processed. --
5982: ------------------------------------------------------------------------------
6000: p_people_group_id number,
6001: p_assignment_id number default null
6002: ) is
6003: --
6004: -- Finds all assignment pieces that match the standard element link eg.
6005: --
6006: -- EL |-----------------------------A------------------------------>
6007: --
6008: -- ASG |---A----|----A----|-----B-----|-----A------|-----A----->
6212: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
6213: hr_utility.raise_error;
6214: end;
6215: --
6216: -- Get first assignment piece matching the standard link.
6217: --
6218: fetch csr_assignment into v_assignment;
6219: --
6220: -- Assignment matching standard link has been found.
6216: -- Get first assignment piece matching the standard link.
6217: --
6218: fetch csr_assignment into v_assignment;
6219: --
6220: -- Assignment matching standard link has been found.
6221: --
6222: if csr_assignment%found then
6223: --
6224: -- Initialise variables for the assignment.
6248: end if;
6249: close csr_sec_asg;
6250:
6251: --
6252: -- Loop for all assignment pieces that match the standard link.
6253: --
6254: while csr_assignment%found loop
6255: --
6256: -- Get next piece of assignment.
6294: -- An element entry needs to be created.
6295: --
6296: if v_entry_start_date is not null then
6297: --
6298: -- Create new element netry for standard link.
6299: --
6300: if g_debug then
6301: hr_utility.trace('********** SL creation');
6302: hr_utility.trace('********** for SL call EE insert interface');
6412: pel.location_id,
6413: pel.grade_id,
6414: pel.pay_basis_id,
6415: pel.link_to_all_payrolls_flag,
6416: pel.standard_link_flag
6417: from pay_element_entries_f pee,
6418: pay_element_links_f pel
6419: where pee.assignment_id = p_assignment_id
6420: and pel.element_link_id = pee.element_link_id;
6473: nvl(to_char(eerec.location_id), '*') || ' ' ||
6474: nvl(to_char(eerec.grade_id), '*') || ' ' ||
6475: nvl(to_char(eerec.pay_basis_id), '*') || ' ' ||
6476: eerec.link_to_all_payrolls_flag || ' ' ||
6477: eerec.standard_link_flag);
6478:
6479: end loop;
6480:
6481: hr_utility.trace('***** dump end *****');
6505: p_new_payroll_id number,
6506: p_business_group_id number,
6507: p_operation varchar2,
6508: p_actual_term_date date,
6509: p_last_standard_date date,
6510: p_final_process_date date,
6511: p_dt_mode varchar2,
6512: p_validation_start_date date,
6513: p_validation_end_date date,
6534: hr_utility.trace (' p_operation = '
6535: ||p_operation);
6536: hr_utility.trace (' p_actual_term_date = '
6537: ||to_char (p_actual_term_date));
6538: hr_utility.trace (' p_last_standard_date = '
6539: ||to_char (p_last_standard_date));
6540: hr_utility.trace (' p_final_process_date = '
6541: ||to_char (p_final_process_date));
6542: hr_utility.trace (' p_dt_mode = '
6535: ||p_operation);
6536: hr_utility.trace (' p_actual_term_date = '
6537: ||to_char (p_actual_term_date));
6538: hr_utility.trace (' p_last_standard_date = '
6539: ||to_char (p_last_standard_date));
6540: hr_utility.trace (' p_final_process_date = '
6541: ||to_char (p_final_process_date));
6542: hr_utility.trace (' p_dt_mode = '
6543: ||p_dt_mode);
6583: hrentmnt.adjust_entries_cncl_term
6584: (p_business_group_id,
6585: p_assignment_id,
6586: p_actual_term_date,
6587: p_last_standard_date,
6588: p_final_process_date,
6589: p_entries_changed,
6590: p_dt_mode,
6591: p_old_people_group_id,
6684: p_assignment_id number,
6685: p_business_group_id number,
6686: p_operation varchar2,
6687: p_actual_term_date date,
6688: p_last_standard_date date,
6689: p_final_process_date date,
6690: p_dt_mode varchar2,
6691: p_validation_start_date date,
6692: p_validation_end_date date
6709: hr_utility.trace (' p_operation = '
6710: ||p_operation);
6711: hr_utility.trace (' p_actual_term_date = '
6712: ||to_char (p_actual_term_date));
6713: hr_utility.trace (' p_last_standard_date = '
6714: ||to_char (p_last_standard_date));
6715: hr_utility.trace (' p_final_process_date = '
6716: ||to_char (p_final_process_date));
6717: hr_utility.trace (' p_dt_mode = '
6710: ||p_operation);
6711: hr_utility.trace (' p_actual_term_date = '
6712: ||to_char (p_actual_term_date));
6713: hr_utility.trace (' p_last_standard_date = '
6714: ||to_char (p_last_standard_date));
6715: hr_utility.trace (' p_final_process_date = '
6716: ||to_char (p_final_process_date));
6717: hr_utility.trace (' p_dt_mode = '
6718: ||p_dt_mode);
6740: 2,
6741: p_business_group_id,
6742: p_operation,
6743: p_actual_term_date,
6744: p_last_standard_date,
6745: p_final_process_date,
6746: p_dt_mode,
6747: p_validation_start_date,
6748: p_validation_end_date,