[Home] [Help]
276: procedure range_code
277: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
278: p_sql out nocopy varchar2) is
279: begin
280: g_debug := hr_utility.debug_enabled;
281: IF g_debug THEN
282: hr_utility.set_location('Start of range_code',1);
283: END if;
284: /* Bug#3043049*/
278: p_sql out nocopy varchar2) is
279: begin
280: g_debug := hr_utility.debug_enabled;
281: IF g_debug THEN
282: hr_utility.set_location('Start of range_code',1);
283: END if;
284: /* Bug#3043049*/
285: p_sql := ' select distinct p.person_id' ||
286: ' from per_people_f p,' ||
288: ' where pa.payroll_action_id = :payroll_action_id' ||
289: ' and p.business_group_id = pa.business_group_id' ||
290: ' order by p.person_id';
291: IF g_debug THEN
292: hr_utility.set_location('End of range_code',2);
293: END if;
294: end range_code;
295:
296:
436:
437: l_procedure constant varchar2(80) := g_package || '.initialization_code';
438: --
439: begin
440: g_debug := hr_utility.debug_enabled;
441: if g_debug then
442: hr_utility.set_location('Start of initialization_code',1);
443: end if;
444: --
438: --
439: begin
440: g_debug := hr_utility.debug_enabled;
441: if g_debug then
442: hr_utility.set_location('Start of initialization_code',1);
443: end if;
444: --
445: open c_union_balance;
446: fetch c_union_balance into g_balance_type_id;
457: p_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
458: end loop;
459:
460: if g_debug then
461: hr_utility.set_location('Defined Balance Ids for balances are:' , 15);
462: hr_utility.trace('--------------------------------------------');
463: hr_utility.trace('CDEP ===>' || p_balance_value_tab(1).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
458: end loop;
459:
460: if g_debug then
461: hr_utility.set_location('Defined Balance Ids for balances are:' , 15);
462: hr_utility.trace('--------------------------------------------');
463: hr_utility.trace('CDEP ===>' || p_balance_value_tab(1).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
459:
460: if g_debug then
461: hr_utility.set_location('Defined Balance Ids for balances are:' , 15);
462: hr_utility.trace('--------------------------------------------');
463: hr_utility.trace('CDEP ===>' || p_balance_value_tab(1).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
460: if g_debug then
461: hr_utility.set_location('Defined Balance Ids for balances are:' , 15);
462: hr_utility.trace('--------------------------------------------');
463: hr_utility.trace('CDEP ===>' || p_balance_value_tab(1).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
461: hr_utility.set_location('Defined Balance Ids for balances are:' , 15);
462: hr_utility.trace('--------------------------------------------');
463: hr_utility.trace('CDEP ===>' || p_balance_value_tab(1).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
462: hr_utility.trace('--------------------------------------------');
463: hr_utility.trace('CDEP ===>' || p_balance_value_tab(1).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
463: hr_utility.trace('CDEP ===>' || p_balance_value_tab(1).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
464: hr_utility.trace('Leave Payments Marginal ===>' || p_balance_value_tab(2).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
465: hr_utility.trace('Earnings_Total ===>' || p_balance_value_tab(16).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
466: hr_utility.trace('Workplace Giving ===>' || p_balance_value_tab(17).defined_balance_id); /*4015082 */
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
467: hr_utility.trace('Lump Sum A Deductions ===>' || p_balance_value_tab(3).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
468: hr_utility.trace('Lump Sum A Payments ===>' || p_balance_value_tab(4).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
469: hr_utility.trace('Lump Sum B Deductions ===>' || p_balance_value_tab(5).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
470: hr_utility.trace('Lump Sum B Payments ===>' || p_balance_value_tab(6).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
471: hr_utility.trace('Lump Sum C Deductions ===>' || p_balance_value_tab(7).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
472: hr_utility.trace('Lump Sum C Payments ===>' || p_balance_value_tab(8).defined_balance_id);
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
473: hr_utility.trace('Lump Sum D Payments ===>' || p_balance_value_tab(9).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
474: hr_utility.trace('Total_Tax_Deduction ===>' || p_balance_value_tab(10).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
475: hr_utility.trace('Termination Deductions ===>' || p_balance_value_tab(11).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
476: hr_utility.trace('Other Income ===>' || p_balance_value_tab(12).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
477: hr_utility.trace('Union Fees ===>' || p_balance_value_tab(13).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
485: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_balance_value_tab(23).defined_balance_id);
478: hr_utility.trace('Invalidity Payments ===>' || p_balance_value_tab(14).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
485: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_balance_value_tab(23).defined_balance_id);
486: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_balance_value_tab(24).defined_balance_id);
479: hr_utility.trace('Lump Sum E Payments ===>' || p_balance_value_tab(15).defined_balance_id);
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
485: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_balance_value_tab(23).defined_balance_id);
486: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_balance_value_tab(24).defined_balance_id);
487: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_balance_value_tab(25).defined_balance_id);/*End Bug 6192381 */
480: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_balance_value_tab(18).defined_balance_id);/*Begin Bug 6192381 */
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
485: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_balance_value_tab(23).defined_balance_id);
486: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_balance_value_tab(24).defined_balance_id);
487: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_balance_value_tab(25).defined_balance_id);/*End Bug 6192381 */
488:
481: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_balance_value_tab(19).defined_balance_id);
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
485: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_balance_value_tab(23).defined_balance_id);
486: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_balance_value_tab(24).defined_balance_id);
487: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_balance_value_tab(25).defined_balance_id);/*End Bug 6192381 */
488:
489: end if;
482: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(20).defined_balance_id);
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
485: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_balance_value_tab(23).defined_balance_id);
486: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_balance_value_tab(24).defined_balance_id);
487: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_balance_value_tab(25).defined_balance_id);/*End Bug 6192381 */
488:
489: end if;
490:
483: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_balance_value_tab(21).defined_balance_id);
484: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_balance_value_tab(22).defined_balance_id);
485: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_balance_value_tab(23).defined_balance_id);
486: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_balance_value_tab(24).defined_balance_id);
487: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_balance_value_tab(25).defined_balance_id);/*End Bug 6192381 */
488:
489: end if;
490:
491: /*Bug 6192381 For fetching Defined Balance Id's for new ETP payment Balances */
496: end loop;
497:
498:
499: if g_debug then
500: hr_utility.set_location('Defined Balance Ids for ETP Payment balances are:' , 15);
501: hr_utility.trace('--------------------------------------------');
502: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_balance_value_tab(1).defined_balance_id);
503: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_balance_value_tab(2).defined_balance_id);
504: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_balance_value_tab(3).defined_balance_id);
497:
498:
499: if g_debug then
500: hr_utility.set_location('Defined Balance Ids for ETP Payment balances are:' , 15);
501: hr_utility.trace('--------------------------------------------');
502: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_balance_value_tab(1).defined_balance_id);
503: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_balance_value_tab(2).defined_balance_id);
504: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_balance_value_tab(3).defined_balance_id);
505: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_balance_value_tab(4).defined_balance_id);
498:
499: if g_debug then
500: hr_utility.set_location('Defined Balance Ids for ETP Payment balances are:' , 15);
501: hr_utility.trace('--------------------------------------------');
502: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_balance_value_tab(1).defined_balance_id);
503: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_balance_value_tab(2).defined_balance_id);
504: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_balance_value_tab(3).defined_balance_id);
505: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_balance_value_tab(4).defined_balance_id);
506: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_balance_value_tab(5).defined_balance_id);
499: if g_debug then
500: hr_utility.set_location('Defined Balance Ids for ETP Payment balances are:' , 15);
501: hr_utility.trace('--------------------------------------------');
502: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_balance_value_tab(1).defined_balance_id);
503: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_balance_value_tab(2).defined_balance_id);
504: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_balance_value_tab(3).defined_balance_id);
505: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_balance_value_tab(4).defined_balance_id);
506: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_balance_value_tab(5).defined_balance_id);
507: end if;
500: hr_utility.set_location('Defined Balance Ids for ETP Payment balances are:' , 15);
501: hr_utility.trace('--------------------------------------------');
502: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_balance_value_tab(1).defined_balance_id);
503: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_balance_value_tab(2).defined_balance_id);
504: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_balance_value_tab(3).defined_balance_id);
505: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_balance_value_tab(4).defined_balance_id);
506: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_balance_value_tab(5).defined_balance_id);
507: end if;
508:
501: hr_utility.trace('--------------------------------------------');
502: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_balance_value_tab(1).defined_balance_id);
503: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_balance_value_tab(2).defined_balance_id);
504: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_balance_value_tab(3).defined_balance_id);
505: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_balance_value_tab(4).defined_balance_id);
506: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_balance_value_tab(5).defined_balance_id);
507: end if;
508:
509: /* Bug 6470581 - Initialize g_payment_summary_type */
502: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_balance_value_tab(1).defined_balance_id);
503: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_balance_value_tab(2).defined_balance_id);
504: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_balance_value_tab(3).defined_balance_id);
505: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_balance_value_tab(4).defined_balance_id);
506: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_balance_value_tab(5).defined_balance_id);
507: end if;
508:
509: /* Bug 6470581 - Initialize g_payment_summary_type */
510: g_payment_summary_type := 'O';
520: CLOSE c_get_fbt_global;
521:
522:
523: if g_debug then
524: hr_utility.set_location('g_fbt_threshold '||g_fbt_threshold,19);
525: hr_utility.set_location('End of initialization_code',20);
526: end if;
527: /* End Changes Bug 6470581 */
528: exception
521:
522:
523: if g_debug then
524: hr_utility.set_location('g_fbt_threshold '||g_fbt_threshold,19);
525: hr_utility.set_location('End of initialization_code',20);
526: end if;
527: /* End Changes Bug 6470581 */
528: exception
529: when others then
527: /* End Changes Bug 6470581 */
528: exception
529: when others then
530: if g_debug then
531: hr_utility.set_location('Error in initialization_code',100);
532: end if;
533: raise;
534:
535: end initialization_code;
570: l_report_param_val varchar2(30);
571:
572: BEGIN
573:
574: g_debug := hr_utility.debug_enabled;
575:
576: IF g_debug
577: THEN
578: hr_utility.set_location('range_person_on',10);
574: g_debug := hr_utility.debug_enabled;
575:
576: IF g_debug
577: THEN
578: hr_utility.set_location('range_person_on',10);
579: END IF;
580:
581: BEGIN
582:
585: close csr_action_parameter;
586:
587: IF g_debug
588: THEN
589: hr_utility.set_location('range_person_on',20);
590: END IF;
591:
592: open csr_range_format_param;
593: fetch csr_range_format_param into l_report_param_val;
593: fetch csr_range_format_param into l_report_param_val;
594: close csr_range_format_param;
595: IF g_debug
596: THEN
597: hr_utility.set_location('range_person_on',30);
598: END IF;
599: EXCEPTION WHEN NO_DATA_FOUND THEN
600: l_return := FALSE;
601: END;
601: END;
602: --
603: IF g_debug
604: THEN
605: hr_utility.set_location('range_person_on',40);
606: END IF;
607:
608: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
609: l_return := TRUE;
609: l_return := TRUE;
610:
611: IF g_debug
612: THEN
613: hr_utility.trace('Range Person = True');
614: END IF;
615: ELSE
616: l_return := FALSE;
617: END IF;
977:
978:
979:
980: begin
981: g_debug := hr_utility.debug_enabled;
982:
983:
984: IF g_debug THEN
985: hr_utility.set_location('Start of assignment_action_code',1);
981: g_debug := hr_utility.debug_enabled;
982:
983:
984: IF g_debug THEN
985: hr_utility.set_location('Start of assignment_action_code',1);
986: END IF;
987: -------------------------------------------------------------
988: -- get the paramters for archival process
989: -------------------------------------------------------------
1033: open c_get_fbt_global (add_months(v_fin_year_end,-3)); /* Add_months included for bug 5333143 */
1034: fetch c_get_fbt_global into g_fbt_threshold;
1035: close c_get_fbt_global;
1036:
1037: hr_utility.set_location('Anitha g_fbt_threshold Value in ass_action_code '||g_fbt_threshold,1000);
1038:
1039: v_reg_emp := to_number(v_registered_employer); /*added-sun*/
1040:
1041: if (v_assignment_id <> '%' and v_payroll_id <> '%') then /*Added for bug 3019374*/
1047: open next_action_id;
1048: fetch next_action_id into v_next_action_id;
1049: close next_action_id;
1050: IF g_debug THEN
1051: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||process_rec.assignment_id,2);
1052: END if;
1053:
1054: hr_nonrun_asact.insact(v_next_action_id,
1055: process_rec.assignment_id,
1056: p_payroll_action_id,
1057: p_chunk,
1058: null);
1059: IF g_debug THEN
1060: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
1061: END if;
1062: end loop;
1063:
1064: else
1078: OPEN next_action_id;
1079: FETCH next_action_id INTO v_next_action_id;
1080: CLOSE next_action_id;
1081: IF g_debug THEN
1082: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||csr_rec.assignment_id,2);
1083: END if;
1084:
1085: hr_nonrun_asact.insact(v_next_action_id,
1086: csr_rec.assignment_id,
1087: p_payroll_action_id,
1088: p_chunk,
1089: null);
1090: IF g_debug THEN
1091: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
1092: END IF;
1093: END LOOP;
1094:
1095: ELSE /* Retain Old Logic - No Range Person */
1101: open next_action_id;
1102: fetch next_action_id into v_next_action_id;
1103: close next_action_id;
1104: IF g_debug THEN
1105: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||process_rec.assignment_id,2);
1106: END if;
1107: hr_nonrun_asact.insact(v_next_action_id,
1108: process_rec.assignment_id,
1109: p_payroll_action_id,
1109: p_payroll_action_id,
1110: p_chunk,
1111: null);
1112: IF g_debug THEN
1113: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
1114: END if;
1115: end loop;
1116:
1117: END IF; /* End Range Person check */
1118:
1119: end if;
1120:
1121: IF g_debug THEN
1122: hr_utility.set_location('End of assignment_action_code',4);
1123: END if;
1124:
1125:
1126: exception
1125:
1126: exception
1127: when others then
1128: IF g_debug THEN
1129: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
1130: END if;
1131: raise;
1132: end assignment_action_code;
1133:
1203:
1204: i_index NUMBER; /* Bug 6470581 */
1205:
1206: begin
1207: g_debug := hr_utility.debug_enabled;
1208:
1209: IF g_debug THEN
1210: hr_utility.set_location('Start of create_extract_archive_details',15);
1211: hr_utility.set_location('Assignment action id is :' || p_assignment_action_id,16);
1206: begin
1207: g_debug := hr_utility.debug_enabled;
1208:
1209: IF g_debug THEN
1210: hr_utility.set_location('Start of create_extract_archive_details',15);
1211: hr_utility.set_location('Assignment action id is :' || p_assignment_action_id,16);
1212: hr_utility.set_location('Database item name is :' || p_user_entity_name,16);
1213: hr_utility.set_location('Value is :' || p_value,17);
1214: END if;
1207: g_debug := hr_utility.debug_enabled;
1208:
1209: IF g_debug THEN
1210: hr_utility.set_location('Start of create_extract_archive_details',15);
1211: hr_utility.set_location('Assignment action id is :' || p_assignment_action_id,16);
1212: hr_utility.set_location('Database item name is :' || p_user_entity_name,16);
1213: hr_utility.set_location('Value is :' || p_value,17);
1214: END if;
1215:
1208:
1209: IF g_debug THEN
1210: hr_utility.set_location('Start of create_extract_archive_details',15);
1211: hr_utility.set_location('Assignment action id is :' || p_assignment_action_id,16);
1212: hr_utility.set_location('Database item name is :' || p_user_entity_name,16);
1213: hr_utility.set_location('Value is :' || p_value,17);
1214: END if;
1215:
1216: /* Bug 6470581 - Added Changes for Amended Payment Summary Type
1209: IF g_debug THEN
1210: hr_utility.set_location('Start of create_extract_archive_details',15);
1211: hr_utility.set_location('Assignment action id is :' || p_assignment_action_id,16);
1212: hr_utility.set_location('Database item name is :' || p_user_entity_name,16);
1213: hr_utility.set_location('Value is :' || p_value,17);
1214: END if;
1215:
1216: /* Bug 6470581 - Added Changes for Amended Payment Summary Type
1217: i. If g_payment_summary_type = 'O' (Original) - Archive values in ff_archive_items
1221: IF g_payment_summary_type = 'O'
1222: THEN
1223:
1224: open get_user_entity_id (p_user_entity_name);
1225: hr_utility.trace('the value of the user entity is '||p_user_entity_name);
1226: fetch get_user_entity_id into v_user_Entity_id,
1227: v_data_type;
1228:
1229: -----------------------------------------------------------------------------------------------+
1256: else
1257:
1258: close get_user_entity_id;
1259: IF g_debug THEN
1260: hr_utility.set_location('User entity not found :'||p_user_entity_name,20);
1261: END if;
1262: end if;
1263:
1264: ELSE
1274: THEN
1275: CLOSE get_user_entity_id;
1276: IF g_debug
1277: THEN
1278: hr_utility.set_location('Amended Payment Summary - Update the archive PL/SQL table',2000);
1279: hr_utility.set_location('p_user_entity_name '||p_user_entity_name,2000);
1280: END IF;
1281: i_index := NVL(p_all_dbi_tab.LAST,-1) + 1;
1282: p_all_dbi_tab(i_index).db_item_name := p_user_entity_name;
1275: CLOSE get_user_entity_id;
1276: IF g_debug
1277: THEN
1278: hr_utility.set_location('Amended Payment Summary - Update the archive PL/SQL table',2000);
1279: hr_utility.set_location('p_user_entity_name '||p_user_entity_name,2000);
1280: END IF;
1281: i_index := NVL(p_all_dbi_tab.LAST,-1) + 1;
1282: p_all_dbi_tab(i_index).db_item_name := p_user_entity_name;
1283: p_all_dbi_tab(i_index).db_item_value := p_value;
1283: p_all_dbi_tab(i_index).db_item_value := p_value;
1284:
1285: IF g_debug
1286: THEN
1287: hr_utility.set_location('Updated Index '||i_index,2010);
1288: END IF;
1289: ELSE
1290: CLOSE get_user_entity_id;
1291: IF g_debug THEN
1288: END IF;
1289: ELSE
1290: CLOSE get_user_entity_id;
1291: IF g_debug THEN
1292: hr_utility.set_location('User entity not found :'||p_user_entity_name,2020);
1293: END if;
1294: END IF;
1295: END IF;
1296:
1294: END IF;
1295: END IF;
1296:
1297: IF g_debug THEN
1298: hr_utility.set_location('End of create_extract_archive_detail',18);
1299: END if;
1300:
1301: exception
1302: when others then
1302: when others then
1303: if get_user_entity_id%isopen then
1304: close get_user_entity_id;
1305: IF g_debug THEN
1306: hr_utility.set_location('closing..',117);
1307: END if;
1308: end if;
1309: IF g_debug THEN
1310: hr_utility.set_location('Error in create_extract_archive_details',20);
1306: hr_utility.set_location('closing..',117);
1307: END if;
1308: end if;
1309: IF g_debug THEN
1310: hr_utility.set_location('Error in create_extract_archive_details',20);
1311: END if;
1312: raise;
1313: end create_extract_archive_details;
1314:
1452: sum_various := 0;
1453: counter := 1;
1454:
1455: IF g_debug THEN
1456: hr_utility.set_location('Start of create_extract_archive_balance',1);
1457: hr_utility.set_location('Start of p_assg_action_id '|| p_assignment_action_id,2);
1458: hr_utility.set_location('Start of p_database_item_name '|| p_database_item_name,3);
1459: END if;
1460:
1453: counter := 1;
1454:
1455: IF g_debug THEN
1456: hr_utility.set_location('Start of create_extract_archive_balance',1);
1457: hr_utility.set_location('Start of p_assg_action_id '|| p_assignment_action_id,2);
1458: hr_utility.set_location('Start of p_database_item_name '|| p_database_item_name,3);
1459: END if;
1460:
1461: ------------------------------------------------------------+
1454:
1455: IF g_debug THEN
1456: hr_utility.set_location('Start of create_extract_archive_balance',1);
1457: hr_utility.set_location('Start of p_assg_action_id '|| p_assignment_action_id,2);
1458: hr_utility.set_location('Start of p_database_item_name '|| p_database_item_name,3);
1459: END if;
1460:
1461: ------------------------------------------------------------+
1462: -- get the balance value for the database item
1474:
1475: if c_archive_fbt_info%found AND v_bal_value > to_number(g_fbt_threshold) THEN --Bug: 3549553- To fetch only ASG_YTD level balances
1476: close c_archive_fbt_info;
1477: IF g_debug THEN
1478: hr_utility.set_location('Calling create_extract_archive_details for item :'|| p_database_item_name,4);
1479: END if;
1480:
1481: ----------------------------------------------------
1482: -- get global values for MEDICARE_LEVY and FBT_RATE
1516: ,l_reporting_amt);
1517:
1518: else
1519: IF g_debug THEN
1520: hr_utility.set_location('FBT Below Reportable limit for this balance:'||p_database_item_name,5);
1521: END if;
1522: v_bal_value := 0;
1523: close c_archive_fbt_info;
1524: end if;
1585: v_earnings_ytd := v_earnings_ytd - v_lump_sum_E_ytd;
1586: end if;
1587:
1588: IF g_debug THEN
1589: hr_utility.set_location('Calling create_extract_archive_details for item :'|| p_database_item_name,4);
1590: END if;
1591:
1592: create_extract_archive_details(p_assignment_action_id
1593: ,p_database_item_name
1596: ,'X_LUMP_SUM_E_PAYMENTS_ASG_YTD'
1597: ,v_lump_sum_E_ytd);
1598: else
1599: IF g_debug THEN
1600: hr_utility.set_location('Balance value not found for this balance:'||p_database_item_name,5);
1601: END if;
1602: /* close c_archive_total_earnings_info; */ --Bug 3172963
1603: end if;
1604:
1622: v_bal_value := p_result_table(10).balance_value + p_result_table(11).balance_value
1623: - p_result_table(7).balance_value;
1624:
1625: IF g_debug THEN
1626: hr_utility.set_location('Calling create_extract_archive_details for item :'|| p_database_item_name,4);
1627: END if;
1628: create_extract_archive_details(p_assignment_action_id
1629: ,p_database_item_name
1630: ,v_bal_value);
1686: v_bal_value := p_result_table(25).balance_value;
1687: end if; /* End 6192381 */
1688:
1689: IF g_debug THEN
1690: hr_utility.set_location('Calling create_extract_archive_details for item :'|| p_database_item_name,4);
1691: END if;
1692: create_extract_archive_details(p_assignment_action_id
1693: ,p_database_item_name
1694: ,v_bal_value);
1694: ,v_bal_value);
1695:
1696: /* else
1697: IF g_debug THEN
1698: hr_utility.set_location('Balance value not found for this balance:'||p_database_item_name,5);
1699: END if;
1700: close c_archive_info;
1701: end if;
1702: */
1706:
1707: exception
1708: when e_bad_global then
1709: IF g_debug THEN
1710: hr_utility.set_location('archive_balance_details : Global value not found ',15);
1711: END if;
1712: close c_get_global;
1713: when zero_divide then
1714: IF g_debug THEN
1711: END if;
1712: close c_get_global;
1713: when zero_divide then
1714: IF g_debug THEN
1715: hr_utility.set_location('archive_balance_details : Division By Zero ',15);
1716: END if;
1717: when others then
1718: IF g_debug THEN
1719: hr_utility.set_location('Error in archive_balance_details procedure',15);
1715: hr_utility.set_location('archive_balance_details : Division By Zero ',15);
1716: END if;
1717: when others then
1718: IF g_debug THEN
1719: hr_utility.set_location('Error in archive_balance_details procedure',15);
1720: END if;
1721: raise;
1722:
1723: end archive_balance_details;
1825: retro_type varchar2(50);
1826: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;
1827:
1828: Begin
1829: g_debug := hr_utility.debug_enabled;
1830: ret_counter := 1;
1831: /* Bug# 5846278 */
1832: /* Checked for legislation rule.*/
1833:
1847: LOOP
1848: FETCH Get_retro_Entry_ids INTO rec_ret_entry_ids;
1849: IF Get_retro_Entry_ids%NOTFOUND Then
1850: IF g_debug THEN
1851: hr_utility.set_location('Get_retro_Entry_Id: not found',1);
1852: END if;
1853: Exit;
1854: End If;
1855: IF g_debug THEN
1852: END if;
1853: Exit;
1854: End If;
1855: IF g_debug THEN
1856: hr_utility.set_location('Calling Get Retro Periods',2);
1857: END if;
1858:
1859: x:=pay_au_paye_ff.get_retro_period(rec_ret_entry_ids.element_entry_id,
1860: rec_ret_entry_ids.date_earned,
1862: retro_start,
1863: retro_end);
1864:
1865: IF g_debug THEN
1866: hr_utility.set_location('Back from call to Get Retro Periods',3);
1867: END if;
1868:
1869: IF months_between(rec_ret_entry_ids.date_earned,retro_end) > 12 then
1870: IF g_debug THEN
1867: END if;
1868:
1869: IF months_between(rec_ret_entry_ids.date_earned,retro_end) > 12 then
1870: IF g_debug THEN
1871: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);
1872: END if;
1873:
1874: OPEN Get_retro_Allowances(rec_ret_entry_ids.element_entry_id);
1875: FETCH Get_retro_Allowances INTO rec_retro_Allowances;
1912: LOOP
1913: FETCH Get_retro_Entry_ids INTO rec_ret_entry_ids;
1914: IF Get_retro_Entry_ids%NOTFOUND Then
1915: IF g_debug THEN
1916: hr_utility.set_location('Get_retro_Entry_Id: not found',1);
1917: END if;
1918: Exit;
1919: End If;
1920: IF g_debug THEN
1917: END if;
1918: Exit;
1919: End If;
1920: IF g_debug THEN
1921: hr_utility.set_location('Calling Get Retro Time Span',2);
1922: END if;
1923:
1924: x:= pay_au_paye_ff.get_retro_time_span(rec_ret_entry_ids.element_entry_id,
1925: rec_ret_entry_ids.date_earned,
1930: retro_eff_date,
1931: time_span,
1932: retro_type);
1933: IF g_debug THEN
1934: hr_utility.set_location('Back from call to Get Retro Time Span',3);
1935: END if;
1936: IF time_span ='GT12' then
1937: IF g_debug THEN
1938: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);
1934: hr_utility.set_location('Back from call to Get Retro Time Span',3);
1935: END if;
1936: IF time_span ='GT12' then
1937: IF g_debug THEN
1938: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);
1939: END if;
1940: OPEN Get_retro_Allowances(rec_ret_entry_ids.element_entry_id);
1941: FETCH Get_retro_Allowances INTO rec_retro_Allowances;
1942: CLOSE Get_retro_Allowances;
2001: --
2002: for i in p_limit..p_table.count
2003: loop
2004: if g_debug then
2005: hr_utility.set_location(l_procedure,5);
2006: end if;
2007: if p_table.exists(i) then
2008: l_total_value := l_total_value + p_table(i).balance_value;
2009: end if;
2017: for i in 1..(p_limit)
2018: loop
2019: if p_table.exists(i) then
2020: if g_debug then
2021: hr_utility.set_location(l_procedure||' : archiving',20);
2022: end if;
2023:
2024: create_extract_archive_details
2025: (p_assignment_action_id
2107: t_allowance_2006 tab_allownace_balance;
2108: --
2109: begin
2110: if g_debug then
2111: hr_utility.set_location(l_procedure, 1);
2112: hr_utility.trace('p_assignment_action_id.....= ' || p_assignment_action_id);
2113: hr_utility.trace('p_max_assignment_action_id.= ' || p_max_assignment_action_id);
2114: hr_utility.trace('p_registered_employer......= ' || p_registered_employer);
2115: hr_utility.trace('p_year_start...............= ' || p_year_start);
2108: --
2109: begin
2110: if g_debug then
2111: hr_utility.set_location(l_procedure, 1);
2112: hr_utility.trace('p_assignment_action_id.....= ' || p_assignment_action_id);
2113: hr_utility.trace('p_max_assignment_action_id.= ' || p_max_assignment_action_id);
2114: hr_utility.trace('p_registered_employer......= ' || p_registered_employer);
2115: hr_utility.trace('p_year_start...............= ' || p_year_start);
2116: hr_utility.trace('p_year_end.................= ' || p_year_end);
2109: begin
2110: if g_debug then
2111: hr_utility.set_location(l_procedure, 1);
2112: hr_utility.trace('p_assignment_action_id.....= ' || p_assignment_action_id);
2113: hr_utility.trace('p_max_assignment_action_id.= ' || p_max_assignment_action_id);
2114: hr_utility.trace('p_registered_employer......= ' || p_registered_employer);
2115: hr_utility.trace('p_year_start...............= ' || p_year_start);
2116: hr_utility.trace('p_year_end.................= ' || p_year_end);
2117: hr_utility.trace('p_assignment_id............= ' || p_assignment_id);
2110: if g_debug then
2111: hr_utility.set_location(l_procedure, 1);
2112: hr_utility.trace('p_assignment_action_id.....= ' || p_assignment_action_id);
2113: hr_utility.trace('p_max_assignment_action_id.= ' || p_max_assignment_action_id);
2114: hr_utility.trace('p_registered_employer......= ' || p_registered_employer);
2115: hr_utility.trace('p_year_start...............= ' || p_year_start);
2116: hr_utility.trace('p_year_end.................= ' || p_year_end);
2117: hr_utility.trace('p_assignment_id............= ' || p_assignment_id);
2118: end if;
2111: hr_utility.set_location(l_procedure, 1);
2112: hr_utility.trace('p_assignment_action_id.....= ' || p_assignment_action_id);
2113: hr_utility.trace('p_max_assignment_action_id.= ' || p_max_assignment_action_id);
2114: hr_utility.trace('p_registered_employer......= ' || p_registered_employer);
2115: hr_utility.trace('p_year_start...............= ' || p_year_start);
2116: hr_utility.trace('p_year_end.................= ' || p_year_end);
2117: hr_utility.trace('p_assignment_id............= ' || p_assignment_id);
2118: end if;
2119: --
2112: hr_utility.trace('p_assignment_action_id.....= ' || p_assignment_action_id);
2113: hr_utility.trace('p_max_assignment_action_id.= ' || p_max_assignment_action_id);
2114: hr_utility.trace('p_registered_employer......= ' || p_registered_employer);
2115: hr_utility.trace('p_year_start...............= ' || p_year_start);
2116: hr_utility.trace('p_year_end.................= ' || p_year_end);
2117: hr_utility.trace('p_assignment_id............= ' || p_assignment_id);
2118: end if;
2119: --
2120: -----------------------------------------------------------------------------------------
2113: hr_utility.trace('p_max_assignment_action_id.= ' || p_max_assignment_action_id);
2114: hr_utility.trace('p_registered_employer......= ' || p_registered_employer);
2115: hr_utility.trace('p_year_start...............= ' || p_year_start);
2116: hr_utility.trace('p_year_end.................= ' || p_year_end);
2117: hr_utility.trace('p_assignment_id............= ' || p_assignment_id);
2118: end if;
2119: --
2120: -----------------------------------------------------------------------------------------
2121: -- Archive the Allowances
2135: loop
2136: fetch get_allowance_balances into rec_allowance_balances;
2137: if get_allowance_balances%notfound then
2138: if g_debug then
2139: hr_utility.set_location(l_procedure, 3);
2140: end if;
2141: exit;
2142: end if;
2143: --
2148: end if ;
2149: --
2150: if nvl(rec_allowance_balances.balance_value,0) > 0 then
2151: if g_debug then
2152: hr_utility.set_location(l_procedure, 3);
2153: hr_utility.set_location(l_procedure || ' : balance_name... = '||rec_allowance_balances.balance_name,1);
2154: hr_utility.set_location(l_procedure || ' : balance_value.. = '||rec_allowance_balances.balance_value,1);
2155: end if;
2156: t_allowance_balance(counter).balance_name := rec_allowance_balances.balance_name;
2149: --
2150: if nvl(rec_allowance_balances.balance_value,0) > 0 then
2151: if g_debug then
2152: hr_utility.set_location(l_procedure, 3);
2153: hr_utility.set_location(l_procedure || ' : balance_name... = '||rec_allowance_balances.balance_name,1);
2154: hr_utility.set_location(l_procedure || ' : balance_value.. = '||rec_allowance_balances.balance_value,1);
2155: end if;
2156: t_allowance_balance(counter).balance_name := rec_allowance_balances.balance_name;
2157: t_allowance_balance(counter).balance_value := rec_allowance_balances.balance_value;
2150: if nvl(rec_allowance_balances.balance_value,0) > 0 then
2151: if g_debug then
2152: hr_utility.set_location(l_procedure, 3);
2153: hr_utility.set_location(l_procedure || ' : balance_name... = '||rec_allowance_balances.balance_name,1);
2154: hr_utility.set_location(l_procedure || ' : balance_value.. = '||rec_allowance_balances.balance_value,1);
2155: end if;
2156: t_allowance_balance(counter).balance_name := rec_allowance_balances.balance_name;
2157: t_allowance_balance(counter).balance_value := rec_allowance_balances.balance_value;
2158: counter := counter + 1;
2199: -- then we perform the additional archive.
2200: --
2201: if to_number(to_char(p_year_start,'YYYY')) >= 2006 then
2202: if g_debug then
2203: hr_utility.set_location(l_procedure, 30);
2204: end if;
2205: --
2206: archive_limited_values
2207: (p_assignment_action_id => p_assignment_action_id
2224: end if;
2225: ---------------------------------------------------------
2226: t_allowance_balance.delete; /* 2968127- cleared PL/SQL table */
2227: if g_debug then
2228: hr_utility.set_location(l_procedure,999);
2229: end if;
2230: exception
2231: when others then
2232: if g_debug then
2229: end if;
2230: exception
2231: when others then
2232: if g_debug then
2233: hr_utility.set_location(l_procedure,000);
2234: end if;
2235: raise;
2236: end archive_allowance_details;
2237: --
2396: l_etp_paid_date);
2397: exception
2398: when others then
2399: IF g_debug THEN
2400: hr_utility.set_location('Error in archive_etp_payment_details ',99);
2401: END if;
2402: Raise;
2403: end archive_etp_payment_details ;
2404: --
2473: l_4_name pay_balance_types.balance_name%type;
2474: l_total_value number := 0;
2475: l_balance_type pay_balance_types.balance_type_id%type;
2476: begin
2477: g_debug := hr_utility.debug_enabled;
2478: --
2479: -- If the financial year permits then perform the union fees archive for 2006/2007.
2480: --
2481: if to_number(to_char(p_year_start,'YYYY')) >= 2006 then
2485: --
2486: -- 4863149 - Raise error when there is no defined balance id for allowance balance
2487: --
2488: if g_debug then
2489: hr_utility.set_location(l_procedure, 3);
2490: end if;
2491: --
2492: if rec_union.def_id is null then
2493: raise_application_error(-20101, 'Balance ID ' || rec_union.bal_type_id || ' not associated with dimension _ASG_LE_YTD');
2496: -- Store all the values in a table
2497: --
2498: if nvl(rec_union.balance_value,0) > 0 then
2499: if g_debug then
2500: hr_utility.set_location(l_procedure, 3);
2501: hr_utility.set_location(l_procedure || ' : balance_name... = '||rec_union.balance_name,3);
2502: hr_utility.set_location(l_procedure || ' : balance_value.. = '||rec_union.balance_value,3);
2503: end if;
2504: t_union_table(l_counter).balance_name := rec_union.balance_name;
2497: --
2498: if nvl(rec_union.balance_value,0) > 0 then
2499: if g_debug then
2500: hr_utility.set_location(l_procedure, 3);
2501: hr_utility.set_location(l_procedure || ' : balance_name... = '||rec_union.balance_name,3);
2502: hr_utility.set_location(l_procedure || ' : balance_value.. = '||rec_union.balance_value,3);
2503: end if;
2504: t_union_table(l_counter).balance_name := rec_union.balance_name;
2505: t_union_table(l_counter).balance_value := rec_union.balance_value;
2498: if nvl(rec_union.balance_value,0) > 0 then
2499: if g_debug then
2500: hr_utility.set_location(l_procedure, 3);
2501: hr_utility.set_location(l_procedure || ' : balance_name... = '||rec_union.balance_name,3);
2502: hr_utility.set_location(l_procedure || ' : balance_value.. = '||rec_union.balance_value,3);
2503: end if;
2504: t_union_table(l_counter).balance_name := rec_union.balance_name;
2505: t_union_table(l_counter).balance_value := rec_union.balance_value;
2506: l_counter := l_counter + 1;
2548: -- Only archive if the values exist
2549: --
2550: if t_union_table.exists(i) then
2551: if g_debug then
2552: hr_utility.set_location(l_procedure,20);
2553: end if;
2554: create_extract_archive_details(p_assignment_action_id,'X_UNION_' || i || '_NAME',t_union_table(i).balance_name);
2555: create_extract_archive_details(p_assignment_action_id,'X_UNION_' || i || '_VALUE',t_union_table(i).balance_value);
2556: l_total_value := l_total_value + t_union_table(i).balance_value;
2559: --
2560: -- We still need to archive the 4th position... if it exists
2561: --
2562: if g_debug then
2563: hr_utility.trace('There are '||t_union_table.count||' union elements');
2564: hr_utility.trace('Already archived value is '||l_total_value);
2565: end if;
2566: --
2567: -- The definitive figure for Union Fees is stored in the legislative union balance 'Union Fees'.
2560: -- We still need to archive the 4th position... if it exists
2561: --
2562: if g_debug then
2563: hr_utility.trace('There are '||t_union_table.count||' union elements');
2564: hr_utility.trace('Already archived value is '||l_total_value);
2565: end if;
2566: --
2567: -- The definitive figure for Union Fees is stored in the legislative union balance 'Union Fees'.
2568: -- It is possible that there may be a combination of old and new union elements being used.
2596: --
2597: -- Check if the values added up equal the value stored in the definitive balance.
2598: --
2599: if g_debug then
2600: hr_utility.set_location(l_procedure,35);
2601: end if;
2602: --
2603: if (l_total_value + t_union_table(4).balance_value) = p_result_table(13).balance_value then
2604: --
2605: -- All elements have been setup using the new method and therefore the values are correct.
2606: -- We can store the 4th value in its corresponding position
2607: --
2608: if g_debug then
2609: hr_utility.set_location(l_procedure,40);
2610: end if;
2611: --
2612: l_4_name := t_union_table(4).balance_name;
2613: l_4_value := t_union_table(4).balance_value;
2709: l_count number := 0;
2710: l_2006_union_setup_found boolean;
2711: --
2712: begin
2713: g_debug := hr_utility.debug_enabled;
2714: if g_debug then
2715: hr_utility.set_location(l_procedure,1);
2716: end if;
2717: --
2711: --
2712: begin
2713: g_debug := hr_utility.debug_enabled;
2714: if g_debug then
2715: hr_utility.set_location(l_procedure,1);
2716: end if;
2717: --
2718: -------------------------------------------
2719: -- if two or more elements feed the balance
2749: l_reporting_name :='MISCELLANEOUS';
2750: end if;
2751: --
2752: if g_debug then
2753: hr_utility.trace('reporting name : '||l_reporting_name);
2754: end if;
2755: --
2756: end if;
2757: --
2756: end if;
2757: --
2758: if l_reporting_name is not null then
2759: if g_debug then
2760: hr_utility.set_location(l_procedure, 20);
2761: end if;
2762: --
2763: create_extract_archive_details
2764: (p_assignment_action_id
2770: -- If the new setup has been performed then archive for this case
2771: --
2772: if l_2006_union_setup_found then
2773: if g_debug then
2774: hr_utility.set_location(l_procedure, 30);
2775: end if;
2776: archive_2006_unions
2777: (p_assignment_id => p_assignment_id
2778: ,p_assignment_action_id => p_assignment_action_id
2788: -- into the new archive items, assuming the financial year
2789: -- is 2006/2007 and above
2790: --
2791: if g_debug then
2792: hr_utility.set_location(l_procedure, 40);
2793: end if;
2794: --
2795: if to_number(to_char(p_year_start,'YYYY')) >= 2006 then
2796: if g_debug then
2793: end if;
2794: --
2795: if to_number(to_char(p_year_start,'YYYY')) >= 2006 then
2796: if g_debug then
2797: hr_utility.set_location(l_procedure, 50);
2798: hr_utility.trace('l_reporting_name => '||l_reporting_name);
2799: hr_utility.trace('l_value_13 => '||p_result_table(13).balance_value);
2800: end if;
2801: -- /* Bug#4925547 */
2794: --
2795: if to_number(to_char(p_year_start,'YYYY')) >= 2006 then
2796: if g_debug then
2797: hr_utility.set_location(l_procedure, 50);
2798: hr_utility.trace('l_reporting_name => '||l_reporting_name);
2799: hr_utility.trace('l_value_13 => '||p_result_table(13).balance_value);
2800: end if;
2801: -- /* Bug#4925547 */
2802: -- Format the misc name correctly for 2006 layout
2795: if to_number(to_char(p_year_start,'YYYY')) >= 2006 then
2796: if g_debug then
2797: hr_utility.set_location(l_procedure, 50);
2798: hr_utility.trace('l_reporting_name => '||l_reporting_name);
2799: hr_utility.trace('l_value_13 => '||p_result_table(13).balance_value);
2800: end if;
2801: -- /* Bug#4925547 */
2802: -- Format the misc name correctly for 2006 layout
2803: --
2809: end if;
2810: end if;
2811: --
2812: if g_debug then
2813: hr_utility.set_location(l_procedure,999);
2814: end if;
2815: exception
2816: when others then
2817: if g_debug then
2814: end if;
2815: exception
2816: when others then
2817: if g_debug then
2818: hr_utility.set_location(l_procedure, 000);
2819: end if;
2820: raise;
2821: end archive_union_name;
2822:
2985: lv_transitional_flag VARCHAR2(1);
2986: lv_part_prev_etp_flag VARCHAR2(1);
2987: Begin
2988: IF g_debug THEN
2989: hr_utility.set_location('Start of archive etp details procedure.. ', 1);
2990: hr_utility.set_location('Assignment action id : '||p_assignment_action_id, 2);
2991: END if;
2992:
2993: lv_transitional_flag :='N';
2986: lv_part_prev_etp_flag VARCHAR2(1);
2987: Begin
2988: IF g_debug THEN
2989: hr_utility.set_location('Start of archive etp details procedure.. ', 1);
2990: hr_utility.set_location('Assignment action id : '||p_assignment_action_id, 2);
2991: END if;
2992:
2993: lv_transitional_flag :='N';
2994: lv_part_prev_etp_flag :='N';
3004:
3005: if etp_details%found then
3006: close etp_details;
3007: IF g_debug THEN
3008: hr_utility.set_location('etp tfn ' || l_etp_details.tax_file_number, 1);
3009: END if;
3010:
3011: create_extract_archive_details(p_assignment_action_id,
3012: 'X_ETP_TAX_FILE_NUMBER',
3076: l_etp_details.death_benefit_type);
3077:
3078: else
3079: IF g_debug THEN
3080: hr_utility.set_location('Details for terminated employee not found ', 3);
3081: END if;
3082: close etp_details;
3083: end if;
3084:
3121: p_year_start,
3122: p_year_end );
3123:
3124: IF g_debug THEN
3125: hr_utility.set_location('exiting archive etp details procedure ', 3);
3126: END if;
3127: exception
3128: when others then
3129: if etp_details%isopen then
3129: if etp_details%isopen then
3130: close etp_details;
3131: end if;
3132: IF g_debug THEN
3133: hr_utility.set_location('Error in archive etp details. ', 300);
3134: END if;
3135: raise;
3136: End archive_etp_details;
3137:
3206: tab_etp_bal_name etp_bal_type ;
3207:
3208: begin
3209: IF g_debug THEN
3210: hr_utility.set_location('Start of archive_prepost_details',15);
3211: hr_utility.set_location('Start of p_assg_action_id '|| p_assignment_action_id,16);
3212: END if;
3213:
3214: --------------------------------------------------------------------------------+
3207:
3208: begin
3209: IF g_debug THEN
3210: hr_utility.set_location('Start of archive_prepost_details',15);
3211: hr_utility.set_location('Start of p_assg_action_id '|| p_assignment_action_id,16);
3212: END if;
3213:
3214: --------------------------------------------------------------------------------+
3215: -- if the employee type is not current then archive the following termination details
3258: --------------------------------------------------------------------------------+
3259: -- this procedure gets the ratios to calculate prejul83 balance and postjun83 balance
3260: --------------------------------------------------------------------------------+
3261: IF g_debug THEN
3262: hr_utility.set_location('calling pay_au_terminations.etp_prepost_ratios ',17);
3263: END if;
3264:
3265: l_result := pay_au_terminations.etp_prepost_ratios(
3266: p_assignment_id -- number in
3288: ,p_output_table => p_etp_result_table
3289: );
3290:
3291: if g_debug then
3292: hr_utility.trace('------------------------------------------------');
3293: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_result_table(1).balance_value);
3294: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_result_table(2).balance_value);
3295: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_result_table(3).balance_value);
3296: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_result_table(4).balance_value);
3289: );
3290:
3291: if g_debug then
3292: hr_utility.trace('------------------------------------------------');
3293: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_result_table(1).balance_value);
3294: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_result_table(2).balance_value);
3295: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_result_table(3).balance_value);
3296: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_result_table(4).balance_value);
3297: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_result_table(5).balance_value);
3290:
3291: if g_debug then
3292: hr_utility.trace('------------------------------------------------');
3293: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_result_table(1).balance_value);
3294: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_result_table(2).balance_value);
3295: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_result_table(3).balance_value);
3296: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_result_table(4).balance_value);
3297: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_result_table(5).balance_value);
3298: end if;
3291: if g_debug then
3292: hr_utility.trace('------------------------------------------------');
3293: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_result_table(1).balance_value);
3294: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_result_table(2).balance_value);
3295: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_result_table(3).balance_value);
3296: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_result_table(4).balance_value);
3297: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_result_table(5).balance_value);
3298: end if;
3299:
3292: hr_utility.trace('------------------------------------------------');
3293: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_result_table(1).balance_value);
3294: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_result_table(2).balance_value);
3295: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_result_table(3).balance_value);
3296: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_result_table(4).balance_value);
3297: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_result_table(5).balance_value);
3298: end if;
3299:
3300: tab_etp_bal_name(1) := 'ETP Payments Transitional Not Part of Prev Term';
3293: hr_utility.trace('ETP Payments Transitional Not Part of Prev Term ===>' || p_etp_result_table(1).balance_value);
3294: hr_utility.trace('ETP Payments Transitional Part of Prev Term ===>' || p_etp_result_table(2).balance_value);
3295: hr_utility.trace('ETP Payments Life Benefit Not Part of Prev Term ===>' || p_etp_result_table(3).balance_value);
3296: hr_utility.trace('ETP Payments Life Benefit Part of Prev Term ===>' || p_etp_result_table(4).balance_value);
3297: hr_utility.trace('Lump Sum C Payments ===>' || p_etp_result_table(5).balance_value);
3298: end if;
3299:
3300: tab_etp_bal_name(1) := 'ETP Payments Transitional Not Part of Prev Term';
3301: tab_etp_bal_name(2) := 'ETP Payments Transitional Part of Prev Term';
3308: for etp_pay_rec in 1..tab_etp_bal_name.count
3309: loop
3310:
3311: if g_debug then
3312: hr_utility.trace('Balance Name '||tab_etp_bal_name(etp_pay_rec)|| ' Balance Value '||p_etp_result_table(etp_pay_rec).balance_value);
3313: end if;
3314:
3315:
3316: if l_result = 0 then
3488: end loop;
3489:
3490:
3491: IF g_debug THEN
3492: hr_utility.set_location('End of archive_prepost_details',18);
3493: END if;
3494:
3495: exception
3496: when e_prepost_error then
3494:
3495: exception
3496: when e_prepost_error then
3497: IF g_debug THEN
3498: hr_utility.set_location('error from pay_au_terminations.etp_prepost_ratios',20);
3499: END if;
3500: when others then
3501: IF g_debug THEN
3502: hr_utility.set_location('error in archive_prepost_details',21);
3498: hr_utility.set_location('error from pay_au_terminations.etp_prepost_ratios',20);
3499: END if;
3500: when others then
3501: IF g_debug THEN
3502: hr_utility.set_location('error in archive_prepost_details',21);
3503: END if;
3504: raise;
3505: end archive_prepost_details;
3506:
3586:
3587:
3588: Begin
3589: IF g_debug THEN
3590: hr_utility.set_location('Start of archive employer details ..',0);
3591: END if;
3592: open employer_details ;
3593: fetch employer_details into
3594: l_group_act_no
3608: ,l_country ;
3609: if employer_details%found then
3610: close employer_details;
3611: IF g_debug THEN
3612: hr_utility.set_location('Creating archive Item X_EMPLOYER_BUSINESS_NAME',1);
3613: END if;
3614: create_extract_archive_details(p_assignment_action_id,
3615: 'X_EMPLOYER_BUSINESS_NAME',
3616: l_business_name);
3614: create_extract_archive_details(p_assignment_action_id,
3615: 'X_EMPLOYER_BUSINESS_NAME',
3616: l_business_name);
3617: IF g_debug THEN
3618: hr_utility.set_location('Creating archive Item X_EMPLOYER_GROUP_ACT_NO',2);
3619: END if;
3620: create_extract_archive_details(p_assignment_action_id,
3621: 'X_EMPLOYER_GROUP_ACT_NO',
3622: l_group_act_no);
3620: create_extract_archive_details(p_assignment_action_id,
3621: 'X_EMPLOYER_GROUP_ACT_NO',
3622: l_group_act_no);
3623: IF g_debug THEN
3624: hr_utility.set_location('Creating archive Item X_EMPLOYER_TRADING_NAME',3);
3625: END if;
3626: create_extract_archive_details(p_assignment_action_id,
3627: 'X_EMPLOYER_TRADING_NAME',
3628: l_trading_name);
3626: create_extract_archive_details(p_assignment_action_id,
3627: 'X_EMPLOYER_TRADING_NAME',
3628: l_trading_name);
3629: IF g_debug THEN
3630: hr_utility.set_location('Creating archive Item X_EMPLOYER_BRANCH_NUMBER',114);
3631: END if;
3632: create_extract_archive_details(p_assignment_action_id,
3633: 'X_EMPLOYER_BRANCH_NUMBER',
3634: l_branch_number);
3632: create_extract_archive_details(p_assignment_action_id,
3633: 'X_EMPLOYER_BRANCH_NUMBER',
3634: l_branch_number);
3635: IF g_debug THEN
3636: hr_utility.set_location('Creating archive Item X_EMPLOYER_ABN',114);
3637: END if;
3638: create_extract_archive_details(p_assignment_action_id,
3639: 'X_EMPLOYER_ABN',
3640: l_abn);
3638: create_extract_archive_details(p_assignment_action_id,
3639: 'X_EMPLOYER_ABN',
3640: l_abn);
3641: IF g_debug THEN
3642: hr_utility.set_location('Creating archive Item X_EMPLOYER_CONTACT_NAME',5);
3643: END if;
3644: create_extract_archive_details(p_assignment_action_id,
3645: 'X_EMPLOYER_CONTACT_NAME',
3646: l_contact_name);
3644: create_extract_archive_details(p_assignment_action_id,
3645: 'X_EMPLOYER_CONTACT_NAME',
3646: l_contact_name);
3647: IF g_debug THEN
3648: hr_utility.set_location('Creating archive Item X_EMPLOYER_CONTACT_TELEPHONE',6);
3649: END if;
3650: create_extract_archive_details(p_assignment_action_id,
3651: 'X_EMPLOYER_CONTACT_TELEPHONE',
3652: l_tel_number);
3650: create_extract_archive_details(p_assignment_action_id,
3651: 'X_EMPLOYER_CONTACT_TELEPHONE',
3652: l_tel_number);
3653: IF g_debug THEN
3654: hr_utility.set_location('Creating archive Item X_EMPLOYER_ADDRESS_1',7);
3655: END if;
3656: create_extract_archive_details(p_assignment_action_id,
3657: 'X_EMPLOYER_ADDRESS_1',
3658: l_address_1);
3656: create_extract_archive_details(p_assignment_action_id,
3657: 'X_EMPLOYER_ADDRESS_1',
3658: l_address_1);
3659: IF g_debug THEN
3660: hr_utility.set_location('Creating archive Item X_EMPLOYER_ADDRESS_2',8);
3661: END if;
3662: create_extract_archive_details(p_assignment_action_id,
3663: 'X_EMPLOYER_ADDRESS_2',
3664: l_address_2);
3662: create_extract_archive_details(p_assignment_action_id,
3663: 'X_EMPLOYER_ADDRESS_2',
3664: l_address_2);
3665: IF g_debug THEN
3666: hr_utility.set_location('Creating archive Item X_EMPLOYER_ADDRESS_3',8);
3667: END if;
3668: create_extract_archive_details(p_assignment_action_id,
3669: 'X_EMPLOYER_ADDRESS_3',
3670: l_address_3);
3668: create_extract_archive_details(p_assignment_action_id,
3669: 'X_EMPLOYER_ADDRESS_3',
3670: l_address_3);
3671: IF g_debug THEN
3672: hr_utility.set_location('Creating archive Item X_EMPLOYER_SUBURB',9);
3673: END if;
3674: create_extract_archive_details(p_assignment_action_id,
3675: 'X_EMPLOYER_SUBURB',
3676: l_suburb);
3674: create_extract_archive_details(p_assignment_action_id,
3675: 'X_EMPLOYER_SUBURB',
3676: l_suburb);
3677: IF g_debug THEN
3678: hr_utility.set_location('Creating archive Item X_EMPLOYER_STATE',10);
3679: END if;
3680: create_extract_archive_details(p_assignment_action_id,
3681: 'X_EMPLOYER_STATE',
3682: l_state);
3680: create_extract_archive_details(p_assignment_action_id,
3681: 'X_EMPLOYER_STATE',
3682: l_state);
3683: IF g_debug THEN
3684: hr_utility.set_location('Creating archive Item X_EMPLOYER_POSTCODE',11);
3685: END if;
3686: create_extract_archive_details(p_assignment_action_id,
3687: 'X_EMPLOYER_POSTCODE',
3688: l_postcode);
3686: create_extract_archive_details(p_assignment_action_id,
3687: 'X_EMPLOYER_POSTCODE',
3688: l_postcode);
3689: IF g_debug THEN
3690: hr_utility.set_location('Creating archive Item X_EMPLOYER_COUNTRY',12);
3691: END if;
3692: create_extract_archive_details(p_assignment_action_id,
3693: 'X_EMPLOYER_COUNTRY',
3694: l_country);
3695: --------------------------------
3696: -- Added for Bug No :1789886
3697: --------------------------------
3698: IF g_debug THEN
3699: hr_utility.set_location('Creating archive Item X_PAYMENT_SUMMARY_SIGNATORY',12);
3700: END if;
3701: create_extract_archive_details(p_assignment_action_id,
3702: 'X_PAYMENT_SUMMARY_SIGNATORY',
3703: l_signatory);
3719: end if;
3720: exception
3721: when e_employer_nf then
3722: IF g_debug THEN
3723: hr_utility.set_location('No employer Details found for the assigment id ',20);
3724: END if;
3725: when others then
3726: IF g_debug THEN
3727: hr_utility.set_location('Error in archive_employer_details ',99);
3723: hr_utility.set_location('No employer Details found for the assigment id ',20);
3724: END if;
3725: when others then
3726: IF g_debug THEN
3727: hr_utility.set_location('Error in archive_employer_details ',99);
3728: END if;
3729: raise;
3730: End archive_employer_details ;
3731:
3945:
3946: Begin
3947:
3948: IF g_debug THEN
3949: hr_utility.set_location('Start of archive employee details ..',0);
3950: END if;
3951: open employee_details ;
3952: fetch employee_details into
3953: l_first_name
3982: FETCH c_get_payroll_name INTO l_payroll;
3983: CLOSE c_get_payroll_name;
3984:
3985: IF g_debug THEN
3986: hr_utility.set_location('In Archive_employee_details ',1000);
3987: hr_utility.set_location('l_first_name '||l_first_name,1000);
3988: hr_utility.set_location('l_surname '||l_surname,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3983: CLOSE c_get_payroll_name;
3984:
3985: IF g_debug THEN
3986: hr_utility.set_location('In Archive_employee_details ',1000);
3987: hr_utility.set_location('l_first_name '||l_first_name,1000);
3988: hr_utility.set_location('l_surname '||l_surname,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3984:
3985: IF g_debug THEN
3986: hr_utility.set_location('In Archive_employee_details ',1000);
3987: hr_utility.set_location('l_first_name '||l_first_name,1000);
3988: hr_utility.set_location('l_surname '||l_surname,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3985: IF g_debug THEN
3986: hr_utility.set_location('In Archive_employee_details ',1000);
3987: hr_utility.set_location('l_first_name '||l_first_name,1000);
3988: hr_utility.set_location('l_surname '||l_surname,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3986: hr_utility.set_location('In Archive_employee_details ',1000);
3987: hr_utility.set_location('l_first_name '||l_first_name,1000);
3988: hr_utility.set_location('l_surname '||l_surname,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3987: hr_utility.set_location('l_first_name '||l_first_name,1000);
3988: hr_utility.set_location('l_surname '||l_surname,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3988: hr_utility.set_location('l_surname '||l_surname,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3989: hr_utility.set_location('l_address_1 '||l_address_1,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3990: hr_utility.set_location('l_address_style '||l_address_style,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3998: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
3991: hr_utility.set_location('l_start_date '||l_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3998: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
3999: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
3992: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3998: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
3999: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4000: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
3993: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3998: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
3999: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4000: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4001: END if;
3994: hr_utility.set_location('l_emp_no '||l_emp_no,1000);
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3998: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
3999: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4000: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4001: END if;
4002:
3995: hr_utility.set_location('l_emp_type '||l_emp_type,1000);
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3998: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
3999: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4000: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4001: END if;
4002:
4003: if employee_details%found then
3996: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
3997: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
3998: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
3999: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4000: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4001: END if;
4002:
4003: if employee_details%found then
4004: close employee_details;
4039: END IF;
4040: ----------------------------------------------------------------
4041:
4042: IF g_debug THEN
4043: hr_utility.set_location('In Archive_employee_details, after adjsutments ',1000);
4044: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
4045: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4040: ----------------------------------------------------------------
4041:
4042: IF g_debug THEN
4043: hr_utility.set_location('In Archive_employee_details, after adjsutments ',1000);
4044: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
4045: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4048: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
4041:
4042: IF g_debug THEN
4043: hr_utility.set_location('In Archive_employee_details, after adjsutments ',1000);
4044: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
4045: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4048: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
4049: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4042: IF g_debug THEN
4043: hr_utility.set_location('In Archive_employee_details, after adjsutments ',1000);
4044: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
4045: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4048: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
4049: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4050: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4043: hr_utility.set_location('In Archive_employee_details, after adjsutments ',1000);
4044: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
4045: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4048: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
4049: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4050: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4051: END if;
4044: hr_utility.set_location('l_termination_date '||l_termination_date,1000);
4045: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4048: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
4049: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4050: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4051: END if;
4052:
4045: hr_utility.set_location('l_final_process_date '||l_final_process_date,1000);
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4048: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
4049: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4050: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4051: END if;
4052:
4053:
4046: hr_utility.set_location('l_date_earned '||l_date_earned,1000);
4047: hr_utility.set_location('l_effective_date '||l_effective_date,1000);
4048: hr_utility.set_location('l_actual_termination_date '||l_actual_termination_date,1000);
4049: hr_utility.set_location('l_le_start_date '||l_le_start_date,1000);
4050: hr_utility.set_location('l_le_end_date '||l_le_end_date,1000);
4051: END if;
4052:
4053:
4054: open tfn_number(p_assignment_id,l_date_earned); /*Bug3019374*/
4054: open tfn_number(p_assignment_id,l_date_earned); /*Bug3019374*/
4055: fetch tfn_number into l_tfn_no;
4056:
4057: IF g_debug THEN
4058: hr_utility.set_location('tfn_number '||l_tfn_no,1000);
4059: END IF;
4060:
4061:
4062: If tfn_number%FOUND then /*If Tax File details found then archive employe details*/
4062: If tfn_number%FOUND then /*If Tax File details found then archive employe details*/
4063: close tfn_number;
4064:
4065: IF g_debug THEN
4066: hr_utility.set_location('Creating archive Item X_EMPLOYEE_TAX_FILE_NUMBER',1);
4067: END if;
4068: create_extract_archive_details(p_assignment_action_id,
4069: 'X_EMPLOYEE_TAX_FILE_NUMBER',
4070: l_tfn_no);
4069: 'X_EMPLOYEE_TAX_FILE_NUMBER',
4070: l_tfn_no);
4071:
4072: IF g_debug THEN
4073: hr_utility.set_location('Creating archive Item X_EMPLOYEE_FIRST_NAME',3);
4074: END if;
4075: create_extract_archive_details(p_assignment_action_id,
4076: 'X_EMPLOYEE_FIRST_NAME',
4077: l_first_name);
4075: create_extract_archive_details(p_assignment_action_id,
4076: 'X_EMPLOYEE_FIRST_NAME',
4077: l_first_name);
4078: IF g_debug THEN
4079: hr_utility.set_location('Creating archive Item X_EMPLOYEE_MIDDLE_NAME',4);
4080: END if;
4081: create_extract_archive_details(p_assignment_action_id,
4082: 'X_EMPLOYEE_MIDDLE_NAME',
4083: l_middle_name);
4081: create_extract_archive_details(p_assignment_action_id,
4082: 'X_EMPLOYEE_MIDDLE_NAME',
4083: l_middle_name);
4084: IF g_debug THEN
4085: hr_utility.set_location('Creating archive Item X_EMPLOYEE_SURNAME',5);
4086: END if;
4087: create_extract_archive_details(p_assignment_action_id,
4088: 'X_EMPLOYEE_SURNAME',
4089: l_surname);
4087: create_extract_archive_details(p_assignment_action_id,
4088: 'X_EMPLOYEE_SURNAME',
4089: l_surname);
4090: IF g_debug THEN
4091: hr_utility.set_location('Creating archive Item X_EMPLOYEE_ADDRESS_1',7);
4092: END if;
4093: create_extract_archive_details(p_assignment_action_id,
4094: 'X_EMPLOYEE_ADDRESS_1',
4095: l_address_1);
4093: create_extract_archive_details(p_assignment_action_id,
4094: 'X_EMPLOYEE_ADDRESS_1',
4095: l_address_1);
4096: IF g_debug THEN
4097: hr_utility.set_location('Creating archive Item X_EMPLOYEE_ADDRESS_2',8);
4098: END if;
4099: create_extract_archive_details(p_assignment_action_id,
4100: 'X_EMPLOYEE_ADDRESS_2',
4101: l_address_2);
4099: create_extract_archive_details(p_assignment_action_id,
4100: 'X_EMPLOYEE_ADDRESS_2',
4101: l_address_2);
4102: IF g_debug THEN
4103: hr_utility.set_location('Creating archive Item X_EMPLOYEE_ADDRESS_3',8);
4104: END if;
4105: create_extract_archive_details(p_assignment_action_id,
4106: 'X_EMPLOYEE_ADDRESS_3',
4107: l_address_3);
4105: create_extract_archive_details(p_assignment_action_id,
4106: 'X_EMPLOYEE_ADDRESS_3',
4107: l_address_3);
4108: IF g_debug THEN
4109: hr_utility.set_location('Creating archive Item X_EMPLOYEE_SUBURB',9);
4110: END if;
4111: create_extract_archive_details(p_assignment_action_id,
4112: 'X_EMPLOYEE_SUBURB',
4113: l_suburb);
4111: create_extract_archive_details(p_assignment_action_id,
4112: 'X_EMPLOYEE_SUBURB',
4113: l_suburb);
4114: IF g_debug THEN
4115: hr_utility.set_location('Creating archive Item X_EMPLOYEE_STATE',10);
4116: END if;
4117: create_extract_archive_details(p_assignment_action_id,
4118: 'X_EMPLOYEE_STATE',
4119: l_state);
4117: create_extract_archive_details(p_assignment_action_id,
4118: 'X_EMPLOYEE_STATE',
4119: l_state);
4120: IF g_debug THEN
4121: hr_utility.set_location('Creating archive Item X_EMPLOYEE_POSTCODE',11);
4122: END if;
4123: create_extract_archive_details(p_assignment_action_id,
4124: 'X_EMPLOYEE_POSTCODE',
4125: l_postcode);
4132: l_country := l_add_country;
4133: END IF;
4134:
4135: IF g_debug THEN
4136: hr_utility.set_location('Creating archive Item X_EMPLOYEE_COUNTRY',12);
4137: END if;
4138: create_extract_archive_details(p_assignment_action_id,
4139: 'X_EMPLOYEE_COUNTRY',
4140: l_country);
4138: create_extract_archive_details(p_assignment_action_id,
4139: 'X_EMPLOYEE_COUNTRY',
4140: l_country);
4141: IF g_debug THEN
4142: hr_utility.set_location('Creating archive Item X_EMPLOYEE_START_DATE',12);
4143: END if;
4144: create_extract_archive_details(p_assignment_action_id,
4145: 'X_EMPLOYEE_START_DATE',
4146: l_start_date);
4147:
4148: /* 3098353 Employee End Date Archived in main Archive_Code */
4149:
4150: IF g_debug THEN
4151: hr_utility.set_location('Creating archive Item X_EMPLOYEE_DATE_OF_BIRTH',12);
4152: END if;
4153: create_extract_archive_details(p_assignment_action_id,
4154: 'X_EMPLOYEE_DATE_OF_BIRTH',
4155: l_dob);
4154: 'X_EMPLOYEE_DATE_OF_BIRTH',
4155: l_dob);
4156: /* bug 3098353 */
4157: IF g_debug THEN
4158: hr_utility.set_location('Creating archive Item X_EMPLOYEE_FINAL_PROCESS_DATE',12);
4159: END if;
4160: l_fpd_archive := to_char(l_final_process_date,'DDMMYYYY');
4161: create_extract_archive_details(p_assignment_action_id,
4162: 'X_EMPLOYEE_FINAL_PROCESS_DATE',
4164: ---------------------------------------------------------------
4165: -- archive sort details
4166: ---------------------------------------------------------------
4167: IF g_debug THEN
4168: hr_utility.set_location('Creating archive Item X_SORT_EMPLOYEE_NUMBER',12);
4169: END if;
4170: create_extract_archive_details(p_assignment_action_id,
4171: 'X_SORT_EMPLOYEE_NUMBER',
4172: l_emp_no );
4170: create_extract_archive_details(p_assignment_action_id,
4171: 'X_SORT_EMPLOYEE_NUMBER',
4172: l_emp_no );
4173: IF g_debug THEN
4174: hr_utility.set_location('Creating archive Item X_SORT_ASSIGNMENT_LOCATION',12);
4175: END if;
4176: create_extract_archive_details(p_assignment_action_id,
4177: 'X_SORT_ASSIGNMENT_LOCATION',
4178: l_asgmnt_loc );
4176: create_extract_archive_details(p_assignment_action_id,
4177: 'X_SORT_ASSIGNMENT_LOCATION',
4178: l_asgmnt_loc );
4179: IF g_debug THEN
4180: hr_utility.set_location('Creating archive Item X_SORT_PAYROLL',12);
4181: END if;
4182: create_extract_archive_details(p_assignment_action_id,
4183: 'X_SORT_PAYROLL',
4184: l_payroll );
4182: create_extract_archive_details(p_assignment_action_id,
4183: 'X_SORT_PAYROLL',
4184: l_payroll );
4185: IF g_debug THEN
4186: hr_utility.set_location('Creating archive Item X_SORT_EMPLOYEE_TYPE',12);
4187: END if;
4188: create_extract_archive_details(p_assignment_action_id,
4189: 'X_SORT_EMPLOYEE_TYPE',
4190: l_emp_type );
4188: create_extract_archive_details(p_assignment_action_id,
4189: 'X_SORT_EMPLOYEE_TYPE',
4190: l_emp_type );
4191: IF g_debug THEN
4192: hr_utility.set_location('Creating archive Item X_SORT_EMPLOYEE_LAST_NAME',5);
4193: END if;
4194: create_extract_archive_details(p_assignment_action_id,
4195: 'X_SORT_EMPLOYEE_LAST_NAME',
4196: l_surname);
4197:
4198:
4199: ----------------------------2610141--------------------------------
4200: IF g_debug THEN
4201: hr_utility.set_location('Creating archive Item X_EMPLOYEE_LE_START_DATE',5);
4202: END if;
4203: l_le_etp_service_date := l_le_etp_start_date; /* Bug 4177679, Bug# 5075662 */
4204:
4205: /*Bug# 4363057 - If condition introduced so that the X_EMPLOYEE_LE_START_DATE gets archived only once.
4216: create_extract_archive_details(p_assignment_action_id,
4217: 'X_ETP_EMPLOYEE_START_DATE',
4218: l_le_etp_service_date);
4219: IF g_debug THEN
4220: hr_utility.set_location('End of archive_prepost_details',18);
4221: END if;
4222: g_le_etp_flag := 'Y';
4223: end if ;
4224:
4223: end if ;
4224:
4225:
4226: IF g_debug THEN
4227: hr_utility.set_location('Creating archive Item X_EMPLOYEE_LE_END_DATE',5);
4228: END if;
4229:
4230: IF p_end_date_flag = 'N' THEN
4231: create_extract_archive_details(p_assignment_action_id,
4241: end if;
4242: exception
4243: when e_employee_nf then
4244: IF g_debug THEN
4245: hr_utility.set_location('No employee Details found for the assigment id ',20);
4246: END if;
4247: when others then
4248: IF g_debug THEN
4249: hr_utility.set_location('Error in archive_employee_details ',99);
4245: hr_utility.set_location('No employee Details found for the assigment id ',20);
4246: END if;
4247: when others then
4248: IF g_debug THEN
4249: hr_utility.set_location('Error in archive_employee_details ',99);
4250: END if;
4251: raise;
4252: End archive_employee_details;
4253:
4318: where pap.person_id=p.person_id);
4319:
4320: Begin
4321: IF g_debug THEN
4322: hr_utility.set_location('Archiving Supplier Details ',1);
4323: hr_utility.set_location('Assignments action id is '||p_assignment_action_id,2);
4324: END if;
4325:
4326:
4319:
4320: Begin
4321: IF g_debug THEN
4322: hr_utility.set_location('Archiving Supplier Details ',1);
4323: hr_utility.set_location('Assignments action id is '||p_assignment_action_id,2);
4324: END if;
4325:
4326:
4327: for sd in supplier_details
4327: for sd in supplier_details
4328: loop
4329:
4330: IF g_debug THEN
4331: hr_utility.set_location('Creating Archive Item X_REPORT_END_DATE',3);
4332: END if;
4333: create_extract_archive_details (p_assignment_action_id
4334: ,'X_REPORT_END_DATE'
4335: ,sd.report_end_date);
4334: ,'X_REPORT_END_DATE'
4335: ,sd.report_end_date);
4336:
4337: IF g_debug THEN
4338: hr_utility.set_location('Creating archive Item X_SUPPLIER_NUMBER',3);
4339: END if;
4340: create_extract_archive_details(p_assignment_action_id,
4341: 'X_SUPPLIER_NUMBER',
4342: sd.supplier_number);
4340: create_extract_archive_details(p_assignment_action_id,
4341: 'X_SUPPLIER_NUMBER',
4342: sd.supplier_number);
4343: IF g_debug THEN
4344: hr_utility.set_location('Creating archive Item X_SUPPLIER_NAME',3);
4345: END if;
4346: create_extract_archive_details(p_assignment_action_id,
4347: 'X_SUPPLIER_NAME',
4348: sd.supplier_name);
4346: create_extract_archive_details(p_assignment_action_id,
4347: 'X_SUPPLIER_NAME',
4348: sd.supplier_name);
4349: IF g_debug THEN
4350: hr_utility.set_location('Creating archive Item X_SUPPLIER_ABN',3);
4351: END if;
4352: create_extract_archive_details(p_assignment_action_id,
4353: 'X_SUPPLIER_ABN',
4354: sd.supplier_abn);
4352: create_extract_archive_details(p_assignment_action_id,
4353: 'X_SUPPLIER_ABN',
4354: sd.supplier_abn);
4355: IF g_debug THEN
4356: hr_utility.set_location('Creating archive Item X_SUPPLIER_CONTACT_NAME',3);
4357: END if;
4358: create_extract_archive_details(p_assignment_action_id,
4359: 'X_SUPPLIER_CONTACT_NAME',
4360: sd.supplier_contact_name);
4358: create_extract_archive_details(p_assignment_action_id,
4359: 'X_SUPPLIER_CONTACT_NAME',
4360: sd.supplier_contact_name);
4361: IF g_debug THEN
4362: hr_utility.set_location('Creating archive Item X_SUPPLIER_CONTACT_PHONE',3);
4363: END if;
4364: create_extract_archive_details(p_assignment_action_id,
4365: 'X_SUPPLIER_CONTACT_TELEPHONE',
4366: sd.supplier_contacT_phone);
4364: create_extract_archive_details(p_assignment_action_id,
4365: 'X_SUPPLIER_CONTACT_TELEPHONE',
4366: sd.supplier_contacT_phone);
4367: IF g_debug THEN
4368: hr_utility.set_location('Creating archive Item X_SUPPLIER_EMAIL',3);
4369: END if;
4370: create_extract_archive_details(p_assignment_action_id,
4371: 'X_SUPPLIER_EMAIL',
4372: sd.email_address);
4370: create_extract_archive_details(p_assignment_action_id,
4371: 'X_SUPPLIER_EMAIL',
4372: sd.email_address);
4373: IF g_debug THEN
4374: hr_utility.set_location('Creating archive Item X_SUPPLIER_ADDRESS_1',3);
4375: END if;
4376: create_extract_archive_details(p_assignment_action_id,
4377: 'X_SUPPLIER_ADDRESS_1',
4378: sd.supplier_address_1);
4376: create_extract_archive_details(p_assignment_action_id,
4377: 'X_SUPPLIER_ADDRESS_1',
4378: sd.supplier_address_1);
4379: IF g_debug THEN
4380: hr_utility.set_location('Creating archive Item X_SUPPLIER_ADDRESS_2',3);
4381: END if;
4382: create_extract_archive_details(p_assignment_action_id,
4383: 'X_SUPPLIER_ADDRESS_2',
4384: sd.supplier_address_2);
4383: 'X_SUPPLIER_ADDRESS_2',
4384: sd.supplier_address_2);
4385:
4386: IF g_debug THEN
4387: hr_utility.set_location('Creating archive Item X_SUPPLIER_ADDRESS_3',3);
4388: END if;
4389: create_extract_archive_details(p_assignment_action_id,
4390: 'X_SUPPLIER_ADDRESS_3',
4391: sd.supplier_address_3);
4389: create_extract_archive_details(p_assignment_action_id,
4390: 'X_SUPPLIER_ADDRESS_3',
4391: sd.supplier_address_3);
4392: IF g_debug THEN
4393: hr_utility.set_location('Creating archive Item X_SUPPLIER_SUBURB',3);
4394: END if;
4395: create_extract_archive_details(p_assignment_action_id,
4396: 'X_SUPPLIER_SUBURB',
4397: sd.supplier_suburb);
4395: create_extract_archive_details(p_assignment_action_id,
4396: 'X_SUPPLIER_SUBURB',
4397: sd.supplier_suburb);
4398: IF g_debug THEN
4399: hr_utility.set_location('Creating archive Item X_SUPPLIER_STATE',3);
4400: END if;
4401: create_extract_archive_details(p_assignment_action_id,
4402: 'X_SUPPLIER_STATE',
4403: sd.supplier_state);
4401: create_extract_archive_details(p_assignment_action_id,
4402: 'X_SUPPLIER_STATE',
4403: sd.supplier_state);
4404: IF g_debug THEN
4405: hr_utility.set_location('Creating archive Item X_SUPPLIER_POSTCODE',3);
4406: END if;
4407: create_extract_archive_details(p_assignment_action_id,
4408: 'X_SUPPLIER_POSTCODE',
4409: sd.supplier_postcode);
4408: 'X_SUPPLIER_POSTCODE',
4409: sd.supplier_postcode);
4410:
4411: IF g_debug THEN
4412: hr_utility.set_location('Creating archive Item X_SUPPLIER_COUNTRY',3);
4413: END if;
4414: create_extract_archive_details(p_assignment_action_id,
4415: 'X_SUPPLIER_COUNTRY',
4416: sd.supplier_country);
4417:
4418:
4419: end loop;
4420: IF g_debug THEN
4421: hr_utility.set_location('Archived all the supplier details',200);
4422: END if;
4423: exception
4424: when others then
4425: IF g_debug THEN
4422: END if;
4423: exception
4424: when others then
4425: IF g_debug THEN
4426: hr_utility.set_location('Error in archiving supplier details ',10);
4427: END if;
4428: raise;
4429:
4430: End archive_supplier_details;
4443: l_old_etp_ded NUMBER;
4444: l_old_inv_pay NUMBER;
4445:
4446: Begin
4447: g_debug := hr_utility.debug_enabled;
4448:
4449: if g_debug then
4450: hr_utility.set_location(l_procedure, 1);
4451: hr_utility.trace('In p_trans_etp_flag '||p_trans_etp_flag);
4446: Begin
4447: g_debug := hr_utility.debug_enabled;
4448:
4449: if g_debug then
4450: hr_utility.set_location(l_procedure, 1);
4451: hr_utility.trace('In p_trans_etp_flag '||p_trans_etp_flag);
4452: hr_utility.trace('In p_part_of_prev_etp_flag '||p_part_of_prev_etp_flag);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4447: g_debug := hr_utility.debug_enabled;
4448:
4449: if g_debug then
4450: hr_utility.set_location(l_procedure, 1);
4451: hr_utility.trace('In p_trans_etp_flag '||p_trans_etp_flag);
4452: hr_utility.trace('In p_part_of_prev_etp_flag '||p_part_of_prev_etp_flag);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4448:
4449: if g_debug then
4450: hr_utility.set_location(l_procedure, 1);
4451: hr_utility.trace('In p_trans_etp_flag '||p_trans_etp_flag);
4452: hr_utility.trace('In p_part_of_prev_etp_flag '||p_part_of_prev_etp_flag);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4449: if g_debug then
4450: hr_utility.set_location(l_procedure, 1);
4451: hr_utility.trace('In p_trans_etp_flag '||p_trans_etp_flag);
4452: hr_utility.trace('In p_part_of_prev_etp_flag '||p_part_of_prev_etp_flag);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4450: hr_utility.set_location(l_procedure, 1);
4451: hr_utility.trace('In p_trans_etp_flag '||p_trans_etp_flag);
4452: hr_utility.trace('In p_part_of_prev_etp_flag '||p_part_of_prev_etp_flag);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4451: hr_utility.trace('In p_trans_etp_flag '||p_trans_etp_flag);
4452: hr_utility.trace('In p_part_of_prev_etp_flag '||p_part_of_prev_etp_flag);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4452: hr_utility.trace('In p_part_of_prev_etp_flag '||p_part_of_prev_etp_flag);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4453: hr_utility.trace('------------------------------------------------');
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4461: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
4454: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4461: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
4462: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
4455: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4461: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
4462: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
4463: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
4456: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4461: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
4462: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
4463: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
4464:
4457: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4461: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
4462: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
4463: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
4464:
4465: end if;
4458: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4461: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
4462: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
4463: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
4464:
4465: end if;
4466:
4459: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
4460: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
4461: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
4462: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
4463: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
4464:
4465: end if;
4466:
4467: l_old_etp_ded := 0;
4491: l_old_inv_pay := p_result_table(14).balance_value - (p_result_table(22).balance_value + p_result_table(23).balance_value +
4492: p_result_table(24).balance_value + p_result_table(25).balance_value );
4493:
4494: if g_debug then
4495: hr_utility.trace('l_old_etp_ded ===>' || l_old_etp_ded);
4496: hr_utility.trace('l_old_inv_pay ===>' || l_old_inv_pay);
4497: end if;
4498:
4499:
4492: p_result_table(24).balance_value + p_result_table(25).balance_value );
4493:
4494: if g_debug then
4495: hr_utility.trace('l_old_etp_ded ===>' || l_old_etp_ded);
4496: hr_utility.trace('l_old_inv_pay ===>' || l_old_inv_pay);
4497: end if;
4498:
4499:
4500: if ( l_old_etp_ded > 0 ) then
4537:
4538: exception
4539: when others then
4540: IF g_debug THEN
4541: hr_utility.set_location('Error in adjust_old_etp_values ',10);
4542: END if;
4543:
4544: End adjust_old_etp_values;
4545:
4817: lv_trans_etp_flag varchar2(1);
4818: lv_part_of_prev_etp_flag varchar2(1);
4819:
4820: begin
4821: g_debug := hr_utility.debug_enabled;
4822: if g_debug then
4823: hr_utility.set_location(l_procedure, 1);
4824: hr_utility.set_location(l_procedure ||' => assignment action:'||p_assignment_action_id,2);
4825: end if;
4819:
4820: begin
4821: g_debug := hr_utility.debug_enabled;
4822: if g_debug then
4823: hr_utility.set_location(l_procedure, 1);
4824: hr_utility.set_location(l_procedure ||' => assignment action:'||p_assignment_action_id,2);
4825: end if;
4826: --
4827:
4820: begin
4821: g_debug := hr_utility.debug_enabled;
4822: if g_debug then
4823: hr_utility.set_location(l_procedure, 1);
4824: hr_utility.set_location(l_procedure ||' => assignment action:'||p_assignment_action_id,2);
4825: end if;
4826: --
4827:
4828: lv_trans_etp_flag :='N';
4964: l_fbt_year_start := to_date('01-01-1900','DD-MM-YYYY');
4965: end if;
4966: --
4967: if g_debug then
4968: hr_utility.set_location(l_procedure ||' => 1 assignment_id :' || l_assignment_id, 2);
4969: end if;
4970: --------------------------------------------------------+
4971: -- archival of data for terminated employees
4972: --------------------------------------------------------+
4978: -- lump_sum_c_found is used to indicate whether Lump Sum C Payment amount exists for the employee
4979: --
4980: if pkg_lump_sum_c_def_bal_id is null or pkg_lump_sum_c_def_bal_id = 0 then
4981: if g_debug then
4982: hr_utility.set_location(l_procedure ,6 );
4983: end if;
4984: --
4985: open balance_exists;
4986: fetch balance_exists
4988: --
4989: if balance_exists%notfound then
4990: pkg_lump_sum_c_def_bal_id := -1;
4991: if g_debug then
4992: hr_utility.set_location(l_procedure ,7 );
4993: end if;
4994: end if;
4995: close balance_exists;
4996: end if;
5015: if etp_code%found then -- 3019374
5016: if (pay_balance_pkg.get_value(pkg_lump_sum_c_def_bal_id, l_max_assignment_action_id, l_registered_employer,null,null,null,null) > 0) then --2610141
5017: lump_sum_c_found := true;
5018: if g_debug then
5019: hr_utility.set_location('Lump Sum C Payment found.' ,9 );
5020: end if;
5021: end if;
5022: --
5023: -- 3263659
5039: end if;
5040:
5041: if lump_sum_c_found = false then
5042: if g_debug then
5043: hr_utility.set_location('Lump Sum C Payment balance does not exists ',101);
5044: end if;
5045: end if;
5046: --
5047: /* Bug3263659 l_actual_termination_date AND clause added to prevent etp being archive in case its
5054: --
5055: -- 2448446 , 2646912
5056: --
5057: if g_debug then
5058: hr_utility.set_location('creating etp details for assignment id: ' ||l_assignment_id, 7);
5059: end if;
5060: --
5061: ------------------------------------------------------+
5062: -- call procedure to archive details of terminated employees
5084: ,l_term_date
5085: );
5086: --
5087: if g_debug then
5088: hr_utility.set_location('creating prejul83 and post jun 83 details for assignment id :' ||l_assignment_id, 7);
5089: end if;
5090: --
5091: archive_prepost_details
5092: (p_assignment_action_id
5156: end loop;
5157: --
5158: else -- 3172963
5159: if g_debug then
5160: hr_utility.set_location('Get assignment_action_id for BBR call, for assignment id: ' || l_assignment_id, 11);
5161: end if;
5162: --
5163: -- 4738470 - Get the Maximum assignment_action_id
5164: --
5174: , l_bbr_action_sequence;
5175: close c_max_asg_action_id;
5176: --
5177: if g_debug then
5178: hr_utility.set_location(l_procedure, 12);
5179: hr_utility.trace('Using ASSIGNMENT_ACTION_ID: ' || l_bbr_assignment_action_id);
5180: end if;
5181: --
5182: -- 4866934 - Flush balance values in PL/SQL table
5175: close c_max_asg_action_id;
5176: --
5177: if g_debug then
5178: hr_utility.set_location(l_procedure, 12);
5179: hr_utility.trace('Using ASSIGNMENT_ACTION_ID: ' || l_bbr_assignment_action_id);
5180: end if;
5181: --
5182: -- 4866934 - Flush balance values in PL/SQL table
5183: --
5196: --
5197: -- Changes made for bug 2610141 Ends here
5198: --
5199: if g_debug then
5200: hr_utility.set_location(l_procedure, 13);
5201: hr_utility.trace('------------------------------------------------');
5202: hr_utility.trace('CDEP ===>' || p_result_table(1).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5197: -- Changes made for bug 2610141 Ends here
5198: --
5199: if g_debug then
5200: hr_utility.set_location(l_procedure, 13);
5201: hr_utility.trace('------------------------------------------------');
5202: hr_utility.trace('CDEP ===>' || p_result_table(1).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5198: --
5199: if g_debug then
5200: hr_utility.set_location(l_procedure, 13);
5201: hr_utility.trace('------------------------------------------------');
5202: hr_utility.trace('CDEP ===>' || p_result_table(1).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5199: if g_debug then
5200: hr_utility.set_location(l_procedure, 13);
5201: hr_utility.trace('------------------------------------------------');
5202: hr_utility.trace('CDEP ===>' || p_result_table(1).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5200: hr_utility.set_location(l_procedure, 13);
5201: hr_utility.trace('------------------------------------------------');
5202: hr_utility.trace('CDEP ===>' || p_result_table(1).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5201: hr_utility.trace('------------------------------------------------');
5202: hr_utility.trace('CDEP ===>' || p_result_table(1).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5202: hr_utility.trace('CDEP ===>' || p_result_table(1).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5203: hr_utility.trace('Leave Payments Marginal ===>' || p_result_table(2).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5204: hr_utility.trace('Lump Sum A Deductions ===>' || p_result_table(3).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5205: hr_utility.trace('Lump Sum A Payments ===>' || p_result_table(4).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5206: hr_utility.trace('Lump Sum B Deductions ===>' || p_result_table(5).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5207: hr_utility.trace('Lump Sum B Payments ===>' || p_result_table(6).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5208: hr_utility.trace('Lump Sum C Deductions ===>' || p_result_table(7).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5209: hr_utility.trace('Lump Sum C Payments ===>' || p_result_table(8).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5210: hr_utility.trace('Lump Sum D Payments ===>' || p_result_table(9).balance_value);
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5211: hr_utility.trace('Total_Tax_Deduction ===>' || p_result_table(10).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5212: hr_utility.trace('Termination Deductions ===>' || p_result_table(11).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5213: hr_utility.trace('Other Income ===>' || p_result_table(12).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5214: hr_utility.trace('Union Fees ===>' || p_result_table(13).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5215: hr_utility.trace('Invalidity Payments ===>' || p_result_table(14).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5216: hr_utility.trace('Lump Sum E Payments ===>' || p_result_table(15).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5224: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
5217: hr_utility.trace('Earnings_Total ===>' || p_result_table(16).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5224: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
5225: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
5218: hr_utility.trace('Workplace Giving ===>' || p_result_table(17).balance_value); /* 4015082 */
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5224: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
5225: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
5226: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
5219: hr_utility.trace('ETP Deductions Transitional Not Part of Prev Term ===>' || p_result_table(18).balance_value);
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5224: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
5225: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
5226: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
5227: end if;
5220: hr_utility.trace('ETP Deductions Transitional Part of Prev Term ===>' || p_result_table(19).balance_value);
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5224: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
5225: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
5226: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
5227: end if;
5228:
5221: hr_utility.trace('ETP Deductions Life Benefit Not Part of Prev Term ===>' || p_result_table(20).balance_value);
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5224: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
5225: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
5226: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
5227: end if;
5228:
5229: if g_debug then
5222: hr_utility.trace('ETP Deductions Life Benefit Part of Prev Term ===>' || p_result_table(21).balance_value);
5223: hr_utility.trace('Invalidity Payments Life Benefit Not Part of Prev Term ===>' || p_result_table(22).balance_value);
5224: hr_utility.trace('Invalidity Payments Life Benefit Part of Prev Term ===>' || p_result_table(23).balance_value);
5225: hr_utility.trace('Invalidity Payments Transitional Not Part of Prev Term ===>' || p_result_table(24).balance_value);
5226: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
5227: end if;
5228:
5229: if g_debug then
5230: hr_utility.set_location('lv_trans_etp_flag :' ||lv_trans_etp_flag, 7);
5226: hr_utility.trace('Invalidity Payments Transitional Part of Prev Term ===>' || p_result_table(25).balance_value);
5227: end if;
5228:
5229: if g_debug then
5230: hr_utility.set_location('lv_trans_etp_flag :' ||lv_trans_etp_flag, 7);
5231: hr_utility.set_location('lv_part_of_prev_etp_flag:' ||lv_part_of_prev_etp_flag, 7);
5232: end if;
5233:
5234: /*Bug 6192381 Procedure to adjust old etp deduction and old Invalidity Payments */
5227: end if;
5228:
5229: if g_debug then
5230: hr_utility.set_location('lv_trans_etp_flag :' ||lv_trans_etp_flag, 7);
5231: hr_utility.set_location('lv_part_of_prev_etp_flag:' ||lv_part_of_prev_etp_flag, 7);
5232: end if;
5233:
5234: /*Bug 6192381 Procedure to adjust old etp deduction and old Invalidity Payments */
5235: adjust_old_etp_values(lv_trans_etp_flag
5237: --
5238: for cnt in 1..tab_bal_name.count
5239: loop
5240: if g_debug then
5241: hr_utility.set_location('creating '||tab_bal_name(cnt)||' balance for ass action id: '|| l_bbr_assignment_action_id,14);
5242: hr_utility.set_location('Death benefit type:'||l_death_benefit_type,113);
5243: end if;
5244: --
5245: ---------------------------------+
5238: for cnt in 1..tab_bal_name.count
5239: loop
5240: if g_debug then
5241: hr_utility.set_location('creating '||tab_bal_name(cnt)||' balance for ass action id: '|| l_bbr_assignment_action_id,14);
5242: hr_utility.set_location('Death benefit type:'||l_death_benefit_type,113);
5243: end if;
5244: --
5245: ---------------------------------+
5246: -- call procedure to archive all balances
5381: if (l_net_balance - l_fbt_balance) = 0 and l_alw_bal_exist = 'FALSE' and l_fbt_balance <> 0 then
5382: l_actual_termination_date := l_year_start;
5383: l_term_date := to_char(l_actual_termination_date,'DDMMYYYY');
5384: if g_debug then
5385: hr_utility.set_location('Creating archive Item X_EMPLOYEE_END_DATE',12);
5386: end if;
5387: --
5388: -- 2610141
5389: --
5409: --
5410: -- 2610141
5411: --
5412: if g_debug then
5413: hr_utility.set_location('Creating archive Item X_EMPLOYEE_END_DATE',12);
5414: end if;
5415: --
5416: l_term_date := to_char(l_actual_termination_date,'DDMMYYYY');
5417: create_extract_archive_details
5447: ,l_year_end
5448: );
5449: --
5450: if g_debug then
5451: hr_utility.set_location('creating employee details for assignment id: ' || l_assignment_id, 9);
5452: end if;
5453: --
5454: ------------------------------------------------------+
5455: --call procedure to archive employee details
5534: --
5535: -- 4363057
5536: --
5537: if g_debug then
5538: hr_utility.set_location('creating employer details for assignment id: ' || l_assignment_id, 10);
5539: end if;
5540: --
5541: ------------------------------------------------------+
5542: --call procedure to archive employer details
5566:
5567: END IF;
5568:
5569: if g_debug then
5570: hr_utility.set_location('End of archive code', 37);
5571: end if;
5572:
5573: exception
5574: when others then
5572:
5573: exception
5574: when others then
5575: if g_debug then
5576: hr_utility.set_location('error in archive code - assignment id :' ||l_assignment_id,11);
5577: end if;
5578: raise;
5579: end archive_code;
5580:
5606:
5607:
5608: begin
5609:
5610: g_debug := hr_utility.debug_enabled;
5611:
5612: IF g_debug THEN
5613: hr_utility.set_location('Start of get archive value ',1);
5614: END if;
5609:
5610: g_debug := hr_utility.debug_enabled;
5611:
5612: IF g_debug THEN
5613: hr_utility.set_location('Start of get archive value ',1);
5614: END if;
5615:
5616: open csr_get_value(p_user_entity_name,
5617: p_assignment_action_id);
5625: close csr_get_value;
5626: end if;
5627: return(l_value);
5628: IF g_debug THEN
5629: hr_utility.set_location('End of get archive value ',2);
5630: END if;
5631:
5632:
5633: exception
5632:
5633: exception
5634: when e_no_value_found then
5635: IF g_debug THEN
5636: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
5637: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
5638: END if;
5639: return (null);
5640: when others then
5633: exception
5634: when e_no_value_found then
5635: IF g_debug THEN
5636: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
5637: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
5638: END if;
5639: return (null);
5640: when others then
5641: IF g_debug THEN
5638: END if;
5639: return (null);
5640: when others then
5641: IF g_debug THEN
5642: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
5643: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
5644: END if;
5645: return (null);
5646: Raise;
5639: return (null);
5640: when others then
5641: IF g_debug THEN
5642: hr_utility.set_location('error in get archive value - assignment_action_id:' ||p_assignment_action_id,3);
5643: hr_utility.set_location('error in get archive value - user entity name :' ||p_user_entity_name,3);
5644: END if;
5645: return (null);
5646: Raise;
5647: end get_archive_value;
5697: Begin
5698:
5699: ps_request_id :=-1;
5700: l_TEST_EFILE :='N';
5701: g_debug := hr_utility.debug_enabled;
5702:
5703: OPEN csr_magtape_params(p_payroll_action_id);
5704: FETCH csr_magtape_params
5705: INTO l_TEST_EFILE,