1: PACKAGE BODY PAY_AC_ACTION_ARCH AS
2: /* $Header: pyacxfrp.pkb 120.26.12010000.11 2008/09/16 12:53:47 sudedas ship $ */
3: /*
4: ******************************************************************
5: * *
16: * 500 Oracle Parkway, Redwood City, US, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_ac_action_arch
21:
22: Change List
23: -----------
24: Date Name Vers Bug No Description
321:
322: /******************************************************************
323: ** Package Local Variables
324: ******************************************************************/
325: gv_package VARCHAR2(100) := 'pay_ac_action_arch';
326:
327: gv_dim_asg_tg_ytd VARCHAR2(100) := '_ASG_TG_YTD';
328: gv_dim_asg_gre_ytd VARCHAR2(100) := '_ASG_GRE_YTD';
329: gv_dim_asg_jd_gre_ytd VARCHAR2(100) := '_ASG_JD_GRE_YTD';
478:
479: /******************************************************************
480: Name : initialization_process
481: Purpose : The procedure initializes the PL/SQL table -
482: pay_ac_action_arch.lrr_act_tab
483: Arguments :
484: Notes :
485: ******************************************************************/
486: PROCEDURE initialization_process
501: BEGIN
502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
503: ln_step := 1;
504:
505: if pay_ac_action_arch.lrr_act_tab.count > 0 then
506: for i in pay_ac_action_arch.lrr_act_tab.first ..
507: pay_ac_action_arch.lrr_act_tab.last loop
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
502: hr_utility.set_location(gv_package || lv_procedure_name, 10);
503: ln_step := 1;
504:
505: if pay_ac_action_arch.lrr_act_tab.count > 0 then
506: for i in pay_ac_action_arch.lrr_act_tab.first ..
507: pay_ac_action_arch.lrr_act_tab.last loop
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
503: ln_step := 1;
504:
505: if pay_ac_action_arch.lrr_act_tab.count > 0 then
506: for i in pay_ac_action_arch.lrr_act_tab.first ..
507: pay_ac_action_arch.lrr_act_tab.last loop
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
504:
505: if pay_ac_action_arch.lrr_act_tab.count > 0 then
506: for i in pay_ac_action_arch.lrr_act_tab.first ..
507: pay_ac_action_arch.lrr_act_tab.last loop
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
505: if pay_ac_action_arch.lrr_act_tab.count > 0 then
506: for i in pay_ac_action_arch.lrr_act_tab.first ..
507: pay_ac_action_arch.lrr_act_tab.last loop
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
506: for i in pay_ac_action_arch.lrr_act_tab.first ..
507: pay_ac_action_arch.lrr_act_tab.last loop
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
507: pay_ac_action_arch.lrr_act_tab.last loop
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
508: pay_ac_action_arch.lrr_act_tab(i).action_context_id := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
509: pay_ac_action_arch.lrr_act_tab(i).action_context_type := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
510: pay_ac_action_arch.lrr_act_tab(i).action_info_category := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
511: pay_ac_action_arch.lrr_act_tab(i).jurisdiction_code := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
512: pay_ac_action_arch.lrr_act_tab(i).act_info1 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
513: pay_ac_action_arch.lrr_act_tab(i).act_info2 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
514: pay_ac_action_arch.lrr_act_tab(i).act_info3 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
515: pay_ac_action_arch.lrr_act_tab(i).act_info4 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
516: pay_ac_action_arch.lrr_act_tab(i).act_info5 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
517: pay_ac_action_arch.lrr_act_tab(i).act_info6 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
518: pay_ac_action_arch.lrr_act_tab(i).act_info7 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
519: pay_ac_action_arch.lrr_act_tab(i).act_info8 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
520: pay_ac_action_arch.lrr_act_tab(i).act_info9 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
521: pay_ac_action_arch.lrr_act_tab(i).act_info10 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
522: pay_ac_action_arch.lrr_act_tab(i).act_info11 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
523: pay_ac_action_arch.lrr_act_tab(i).act_info12 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
524: pay_ac_action_arch.lrr_act_tab(i).act_info13 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
525: pay_ac_action_arch.lrr_act_tab(i).act_info14 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
526: pay_ac_action_arch.lrr_act_tab(i).act_info15 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
527: pay_ac_action_arch.lrr_act_tab(i).act_info16 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
528: pay_ac_action_arch.lrr_act_tab(i).act_info17 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
529: pay_ac_action_arch.lrr_act_tab(i).act_info18 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
530: pay_ac_action_arch.lrr_act_tab(i).act_info19 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
531: pay_ac_action_arch.lrr_act_tab(i).act_info20 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
539: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
532: pay_ac_action_arch.lrr_act_tab(i).act_info21 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
539: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
540: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
533: pay_ac_action_arch.lrr_act_tab(i).act_info22 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
539: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
540: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
541: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
534: pay_ac_action_arch.lrr_act_tab(i).act_info23 := null;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
539: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
540: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
541: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
542: end loop;
535: pay_ac_action_arch.lrr_act_tab(i).act_info24 := null;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
539: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
540: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
541: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
542: end loop;
543: end if;
536: pay_ac_action_arch.lrr_act_tab(i).act_info25 := null;
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
539: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
540: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
541: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
542: end loop;
543: end if;
544:
537: pay_ac_action_arch.lrr_act_tab(i).act_info26 := null;
538: pay_ac_action_arch.lrr_act_tab(i).act_info27 := null;
539: pay_ac_action_arch.lrr_act_tab(i).act_info28 := null;
540: pay_ac_action_arch.lrr_act_tab(i).act_info29 := null;
541: pay_ac_action_arch.lrr_act_tab(i).act_info30 := null;
542: end loop;
543: end if;
544:
545: ln_step := 5;
542: end loop;
543: end if;
544:
545: ln_step := 5;
546: pay_ac_action_arch.lrr_act_tab.delete;
547: pay_ac_action_arch.emp_state_jd.delete;
548: pay_ac_action_arch.emp_city_jd.delete;
549: pay_ac_action_arch.emp_county_jd.delete;
550: pay_ac_action_arch.emp_school_jd.delete;
543: end if;
544:
545: ln_step := 5;
546: pay_ac_action_arch.lrr_act_tab.delete;
547: pay_ac_action_arch.emp_state_jd.delete;
548: pay_ac_action_arch.emp_city_jd.delete;
549: pay_ac_action_arch.emp_county_jd.delete;
550: pay_ac_action_arch.emp_school_jd.delete;
551: pay_ac_action_arch.emp_elements_tab.delete;
544:
545: ln_step := 5;
546: pay_ac_action_arch.lrr_act_tab.delete;
547: pay_ac_action_arch.emp_state_jd.delete;
548: pay_ac_action_arch.emp_city_jd.delete;
549: pay_ac_action_arch.emp_county_jd.delete;
550: pay_ac_action_arch.emp_school_jd.delete;
551: pay_ac_action_arch.emp_elements_tab.delete;
552: pay_ac_action_arch.lrr_act_tab.delete;
545: ln_step := 5;
546: pay_ac_action_arch.lrr_act_tab.delete;
547: pay_ac_action_arch.emp_state_jd.delete;
548: pay_ac_action_arch.emp_city_jd.delete;
549: pay_ac_action_arch.emp_county_jd.delete;
550: pay_ac_action_arch.emp_school_jd.delete;
551: pay_ac_action_arch.emp_elements_tab.delete;
552: pay_ac_action_arch.lrr_act_tab.delete;
553:
546: pay_ac_action_arch.lrr_act_tab.delete;
547: pay_ac_action_arch.emp_state_jd.delete;
548: pay_ac_action_arch.emp_city_jd.delete;
549: pay_ac_action_arch.emp_county_jd.delete;
550: pay_ac_action_arch.emp_school_jd.delete;
551: pay_ac_action_arch.emp_elements_tab.delete;
552: pay_ac_action_arch.lrr_act_tab.delete;
553:
554: if gv_reporting_level = 'TAXGRP' then
547: pay_ac_action_arch.emp_state_jd.delete;
548: pay_ac_action_arch.emp_city_jd.delete;
549: pay_ac_action_arch.emp_county_jd.delete;
550: pay_ac_action_arch.emp_school_jd.delete;
551: pay_ac_action_arch.emp_elements_tab.delete;
552: pay_ac_action_arch.lrr_act_tab.delete;
553:
554: if gv_reporting_level = 'TAXGRP' then
555: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
548: pay_ac_action_arch.emp_city_jd.delete;
549: pay_ac_action_arch.emp_county_jd.delete;
550: pay_ac_action_arch.emp_school_jd.delete;
551: pay_ac_action_arch.emp_elements_tab.delete;
552: pay_ac_action_arch.lrr_act_tab.delete;
553:
554: if gv_reporting_level = 'TAXGRP' then
555: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
556: else
556: else
557: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;
558: end if;
559:
560: if pay_ac_action_arch.ltr_summary_labels.count = 0 then
561:
562: i := 0;
563:
564: for lbl in c_arch_labels loop
562: i := 0;
563:
564: for lbl in c_arch_labels loop
565:
566: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
567: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
563:
564: for lbl in c_arch_labels loop
565:
566: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
567: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
564: for lbl in c_arch_labels loop
565:
566: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
567: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
572: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
566: pay_ac_action_arch.ltr_summary_labels(i).language := lbl.language;
567: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
572: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
573:
574: i := i + 1;
567: pay_ac_action_arch.ltr_summary_labels(i).lookup_code := lbl.lookup_code;
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
572: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
573:
574: i := i + 1;
575:
568: pay_ac_action_arch.ltr_summary_labels(i).meaning := lbl.meaning;
569:
570: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).language);
571: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).lookup_code);
572: hr_utility.trace(pay_ac_action_arch.ltr_summary_labels(i).meaning);
573:
574: i := i + 1;
575:
576: end loop;
576: end loop;
577:
578: end if;
579:
580: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
581: pay_ac_action_arch.lrr_act_tab.count);
582: hr_utility.set_location(gv_package || lv_procedure_name, 50);
583: ln_step := 10;
584:
577:
578: end if;
579:
580: hr_utility.trace('pay_ac_action_arch.lrr_act_tab.count = ' ||
581: pay_ac_action_arch.lrr_act_tab.count);
582: hr_utility.set_location(gv_package || lv_procedure_name, 50);
583: ln_step := 10;
584:
585: EXCEPTION
824: ln_step := 1;
825: p_rate_exists := 'N';
826:
827: hr_utility.set_location(gv_package || lv_procedure_name, 10);
828: if pay_ac_action_arch.lrr_act_tab.count > 0 then
829: for i in pay_ac_action_arch.lrr_act_tab.first..
830: pay_ac_action_arch.lrr_act_tab.last
831: loop
832: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
825: p_rate_exists := 'N';
826:
827: hr_utility.set_location(gv_package || lv_procedure_name, 10);
828: if pay_ac_action_arch.lrr_act_tab.count > 0 then
829: for i in pay_ac_action_arch.lrr_act_tab.first..
830: pay_ac_action_arch.lrr_act_tab.last
831: loop
832: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
833: p_xfr_action_id ) and
826:
827: hr_utility.set_location(gv_package || lv_procedure_name, 10);
828: if pay_ac_action_arch.lrr_act_tab.count > 0 then
829: for i in pay_ac_action_arch.lrr_act_tab.first..
830: pay_ac_action_arch.lrr_act_tab.last
831: loop
832: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
833: p_xfr_action_id ) and
834: ( pay_ac_action_arch.lrr_act_tab(i).act_info2 =
828: if pay_ac_action_arch.lrr_act_tab.count > 0 then
829: for i in pay_ac_action_arch.lrr_act_tab.first..
830: pay_ac_action_arch.lrr_act_tab.last
831: loop
832: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
833: p_xfr_action_id ) and
834: ( pay_ac_action_arch.lrr_act_tab(i).act_info2 =
835: p_element_type_id ) )
836: then
830: pay_ac_action_arch.lrr_act_tab.last
831: loop
832: if ( ( pay_ac_action_arch.lrr_act_tab(i).action_context_id =
833: p_xfr_action_id ) and
834: ( pay_ac_action_arch.lrr_act_tab(i).act_info2 =
835: p_element_type_id ) )
836: then
837: p_rate_exists := 'Y';
838: exit;
1120: end if; -- p_pymt_balcall_aaid is not null
1121:
1122: ln_step := 15;
1123: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 then
1124: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1125: if p_element_classification_name in ('Earnings',
1126: 'Supplemental Earnings',
1127: 'Taxable Benefits',
1128: 'Imputed Earnings',
1130: 'Alien/Expat Earnings') then
1131: hr_utility.set_location(gv_package || lv_procedure_name, 125);
1132: lv_action_category := 'AC EARNINGS';
1133: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1134: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1135: := fnd_number.number_to_canonical(ln_current_hours);
1136: */
1137: IF p_ytd_flag = 'N' then
1138: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1134: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1135: := fnd_number.number_to_canonical(ln_current_hours);
1136: */
1137: IF p_ytd_flag = 'N' then
1138: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1139: := fnd_number.number_to_canonical(ln_current_hours);
1140: ELSE
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1142: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1137: IF p_ytd_flag = 'N' then
1138: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1139: := fnd_number.number_to_canonical(ln_current_hours);
1140: ELSE
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1142: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1143: END IF;
1144:
1145: IF ln_current_hours <> 0 AND ln_payments_amount <> 0 THEN
1142: := fnd_number.number_to_canonical((ln_current_hours) - gv_ytd_hour);
1143: END IF;
1144:
1145: IF ln_current_hours <> 0 AND ln_payments_amount <> 0 THEN
1146: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
1147: := ln_payments_amount/ln_current_hours;/*Bug 3311866*/
1148:
1149: ELSE
1150: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := null;
1146: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
1147: := ln_payments_amount/ln_current_hours;/*Bug 3311866*/
1148:
1149: ELSE
1150: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := null;
1151: END IF;
1152:
1153: IF p_ytd_flag = 'N' then
1154: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1150: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := null;
1151: END IF;
1152:
1153: IF p_ytd_flag = 'N' then
1154: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1155: := fnd_number.number_to_canonical(ln_ytd_hours);
1156: ELSE
1157: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1158: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1153: IF p_ytd_flag = 'N' then
1154: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1155: := fnd_number.number_to_canonical(ln_ytd_hours);
1156: ELSE
1157: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1158: := fnd_number.number_to_canonical((ln_ytd_hours) - gv_ytd_hour);
1159: END IF;
1160: end if;
1161:
1161:
1162: hr_utility.set_location(gv_package || lv_procedure_name, 130);
1163: /* Insert this into the plsql table if Current or YTD
1164: amount is not Zero */
1165: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1166: := lv_action_category;
1167: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1168: := nvl(p_jurisdiction_code, '00-000-0000');
1169: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1163: /* Insert this into the plsql table if Current or YTD
1164: amount is not Zero */
1165: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1166: := lv_action_category;
1167: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1168: := nvl(p_jurisdiction_code, '00-000-0000');
1169: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1170: := p_xfr_action_id;
1171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1165: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1166: := lv_action_category;
1167: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1168: := nvl(p_jurisdiction_code, '00-000-0000');
1169: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1170: := p_xfr_action_id;
1171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1172: := p_element_classification_name;
1173: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1167: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1168: := nvl(p_jurisdiction_code, '00-000-0000');
1169: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1170: := p_xfr_action_id;
1171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1172: := p_element_classification_name;
1173: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1174: := p_element_type_id;
1175: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1169: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1170: := p_xfr_action_id;
1171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1172: := p_element_classification_name;
1173: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1174: := p_element_type_id;
1175: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1176: := p_primary_balance_id;
1177: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1171: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1172: := p_element_classification_name;
1173: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1174: := p_element_type_id;
1175: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1176: := p_primary_balance_id;
1177: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1178: := p_processing_priority;
1179: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1173: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1174: := p_element_type_id;
1175: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1176: := p_primary_balance_id;
1177: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1178: := p_processing_priority;
1179: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1180: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1181: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1176: := p_primary_balance_id;
1177: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1178: := p_processing_priority;
1179: /* bug 6702864 We are not subtracting the Retro amount from the base element so added the if condition */
1180: /* pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1181: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1182: */
1183:
1184: IF p_ytd_flag = 'N' then
1181: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1182: */
1183:
1184: IF p_ytd_flag = 'N' then
1185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1186: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1187: ELSE
1188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1189: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1184: IF p_ytd_flag = 'N' then
1185: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1186: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
1187: ELSE
1188: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1189: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0) - gv_ytd_amount);
1190: END IF;
1191:
1192: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1191:
1192: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_payments_amount,0)));
1193:
1194: IF p_ytd_flag = 'N' then
1195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1196: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1197: ELSE
1198: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1199: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1194: IF p_ytd_flag = 'N' then
1195: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1196: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
1197: ELSE
1198: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1199: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1200: END IF;
1201: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1202: := p_reporting_name;
1197: ELSE
1198: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1199: := fnd_number.number_to_canonical((ln_ytd_amount) - gv_ytd_amount);
1200: END IF;
1201: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1202: := p_reporting_name;
1203: IF lv_action_category = 'AC DEDUCTIONS' THEN
1204: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
1205: := p_reporting_name;
1200: END IF;
1201: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1202: := p_reporting_name;
1203: IF lv_action_category = 'AC DEDUCTIONS' THEN
1204: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
1205: := p_reporting_name;
1206: END IF;
1207: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1208: := p_original_date_earned;
1203: IF lv_action_category = 'AC DEDUCTIONS' THEN
1204: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
1205: := p_reporting_name;
1206: END IF;
1207: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1208: := p_original_date_earned;
1209: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1210: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1211: := p_effective_start_date;
1206: END IF;
1207: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1208: := p_original_date_earned;
1209: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1210: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1211: := p_effective_start_date;
1212: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1213: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1214: := p_effective_end_date ;
1209: hr_utility.trace('p_original_date_earned :=' || p_original_date_earned );
1210: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1211: := p_effective_start_date;
1212: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1213: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1214: := p_effective_end_date ;
1215: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1216: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1217: := p_category;
1212: hr_utility.trace('p_effective_start_date := ' || p_effective_start_date );
1213: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
1214: := p_effective_end_date ;
1215: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1216: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1217: := p_category;
1218: hr_utility.trace('p_category ' || p_category );
1219: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1220: := p_el_jurisdiction_code;
1215: hr_utility.trace('p_effective_end_date:= ' || p_effective_end_date );
1216: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
1217: := p_category;
1218: hr_utility.trace('p_category ' || p_category );
1219: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
1220: := p_el_jurisdiction_code;
1221:
1222: end if;
1223:
1383: ln_retro_element_entry NUMBER;
1384:
1385: i NUMBER := 0;
1386:
1387: hbr pay_ac_action_arch.hbr_table;
1388:
1389: BEGIN
1390:
1391:
1497: end if;
1498:
1499: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1500: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1502: := ln_ytd_amount;
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1504: := ln_ytd_hours;
1505:
1499: hr_utility.trace('ytd balance = ' || ln_ytd_amount);
1500: hr_utility.trace('ytd hours = ' || ln_ytd_hours);
1501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1502: := ln_ytd_amount;
1503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1504: := ln_ytd_hours;
1505:
1506: ln_ytd_amount := 0;
1507: ln_ytd_hours := 0;
1546: IF nvl(ln_retro_multiple,0) = 0 THEN
1547: ln_retro_multiple := 1;
1548: END IF;
1549:
1550: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1551: hr_utility.trace('ln_index = ' || ln_index);
1552:
1553:
1554: ln_step := 20;
1551: hr_utility.trace('ln_index = ' || ln_index);
1552:
1553:
1554: ln_step := 20;
1555: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1556: := 'AC EARNINGS';
1557:
1558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1559: := '00-000-0000';
1554: ln_step := 20;
1555: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1556: := 'AC EARNINGS';
1557:
1558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1559: := '00-000-0000';
1560: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1561: := lv_classification_name;
1562: hr_utility.trace('action_info_category' || lv_classification_name);
1556: := 'AC EARNINGS';
1557:
1558: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1559: := '00-000-0000';
1560: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1561: := lv_classification_name;
1562: hr_utility.trace('action_info_category' || lv_classification_name);
1563: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1564: := prev_element_type_id;
1559: := '00-000-0000';
1560: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1561: := lv_classification_name;
1562: hr_utility.trace('action_info_category' || lv_classification_name);
1563: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1564: := prev_element_type_id;
1565: hr_utility.trace('act_info2' || prev_element_type_id);
1566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1567: := ln_primary_balance_id;
1562: hr_utility.trace('action_info_category' || lv_classification_name);
1563: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1564: := prev_element_type_id;
1565: hr_utility.trace('act_info2' || prev_element_type_id);
1566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1567: := ln_primary_balance_id;
1568: hr_utility.trace('act_info6' || ln_primary_balance_id);
1569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1570: := ln_processing_priority;
1565: hr_utility.trace('act_info2' || prev_element_type_id);
1566: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1567: := ln_primary_balance_id;
1568: hr_utility.trace('act_info6' || ln_primary_balance_id);
1569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1570: := ln_processing_priority;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1568: hr_utility.trace('act_info6' || ln_primary_balance_id);
1569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1570: := ln_processing_priority;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1574: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1576: := 0;
1571: hr_utility.trace('act_info7' || ln_processing_priority);
1572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1574: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1576: := 0;
1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1578: := lv_reporting_name;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1573: := fnd_number.number_to_canonical(ln_retro_payvalue);
1574: hr_utility.trace('act_info8' || fnd_number.number_to_canonical(ln_retro_payvalue));
1575: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1576: := 0;
1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1578: := lv_reporting_name;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1580: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1576: := 0;
1577: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1578: := lv_reporting_name;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1580: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1582: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1584: := p_xfr_action_id;
1579: hr_utility.trace('act_info10' || lv_reporting_name);
1580: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1581: := fnd_number.number_to_canonical(ln_retro_hours);
1582: hr_utility.trace('act_info11' || fnd_number.number_to_canonical(ln_retro_hours));
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1584: := p_xfr_action_id;
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:
1587: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1583: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1584: := p_xfr_action_id;
1585: hr_utility.trace('action_context_id' || p_xfr_action_id);
1586:
1587: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1588: := fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple);
1589: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1590: END LOOP;
1591: CLOSE c_retro;
1630:
1631: /*Insert this into the plsql table */
1632:
1633: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1634: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1635: hr_utility.trace('ln_index = ' || ln_index);
1636:
1637:
1638: ln_step := 20;
1635: hr_utility.trace('ln_index = ' || ln_index);
1636:
1637:
1638: ln_step := 20;
1639: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1640: := 'AC EARNINGS';
1641: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1642: := '00-000-0000';
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1637:
1638: ln_step := 20;
1639: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1640: := 'AC EARNINGS';
1641: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1642: := '00-000-0000';
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1644: := lv_classification_name;
1645: hr_utility.trace('action_info_category2' || lv_classification_name);
1639: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1640: := 'AC EARNINGS';
1641: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1642: := '00-000-0000';
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1644: := lv_classification_name;
1645: hr_utility.trace('action_info_category2' || lv_classification_name);
1646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1647: := ln_element_type_id;
1642: := '00-000-0000';
1643: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1644: := lv_classification_name;
1645: hr_utility.trace('action_info_category2' || lv_classification_name);
1646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1647: := ln_element_type_id;
1648: hr_utility.trace('act_info22' || prev_element_type_id);
1649: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1650: := ln_primary_balance_id;
1645: hr_utility.trace('action_info_category2' || lv_classification_name);
1646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1647: := ln_element_type_id;
1648: hr_utility.trace('act_info22' || prev_element_type_id);
1649: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1650: := ln_primary_balance_id;
1651: hr_utility.trace('act_info62' || ln_primary_balance_id);
1652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1653: := ln_processing_priority;
1648: hr_utility.trace('act_info22' || prev_element_type_id);
1649: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1650: := ln_primary_balance_id;
1651: hr_utility.trace('act_info62' || ln_primary_balance_id);
1652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1653: := ln_processing_priority;
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1651: hr_utility.trace('act_info62' || ln_primary_balance_id);
1652: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1653: := ln_processing_priority;
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1654: hr_utility.trace('act_info72' || ln_processing_priority);
1655: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1656: := fnd_number.number_to_canonical(ln_payments_amount);
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1660:
1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1662: := lv_reporting_name;
1657: hr_utility.trace('act_info82' || fnd_number.number_to_canonical(ln_retro_payvalue)); /* Bug 3311866*/
1658: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1659: := fnd_number.number_to_canonical(ln_ytd_amount);
1660:
1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1662: := lv_reporting_name;
1663: hr_utility.trace('act_info102' || lv_reporting_name);
1664: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1665: := fnd_number.number_to_canonical(ln_hours);
1660:
1661: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1662: := lv_reporting_name;
1663: hr_utility.trace('act_info102' || lv_reporting_name);
1664: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1665: := fnd_number.number_to_canonical(ln_hours);
1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1663: hr_utility.trace('act_info102' || lv_reporting_name);
1664: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1665: := fnd_number.number_to_canonical(ln_hours);
1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1665: := fnd_number.number_to_canonical(ln_hours);
1666: hr_utility.trace('act_info112' || fnd_number.number_to_canonical(ln_retro_hours));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1672: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1673: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1667: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
1668: := p_xfr_action_id;
1669: -- pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1670: -- := fnd_number.number_to_canonical(ln_ytd_hours);
1671: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1672: := fnd_number.number_to_canonical(ln_rate * nvl(ln_multiple,1));
1673: hr_utility.trace('act_info13' || fnd_number.number_to_canonical(ln_retro_rate * ln_retro_multiple));
1674: prev_element_type_id := ln_element_type_id;
1675: prev_run_asg_act_id := hbr(j).run_asg_act_id;
2424: if lv_element_classification_name like '% Deductions' then
2425: ln_hours_balance_id := null;
2426: end if;
2427: ln_step := 15;
2428: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2429: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2430: := ln_element_type_id;
2431: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2432: := lv_element_classification_name;
2425: ln_hours_balance_id := null;
2426: end if;
2427: ln_step := 15;
2428: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2429: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2430: := ln_element_type_id;
2431: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2432: := lv_element_classification_name;
2433: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2427: ln_step := 15;
2428: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
2429: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2430: := ln_element_type_id;
2431: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2432: := lv_element_classification_name;
2433: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2434: := ln_primary_balance_id;
2435: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2429: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
2430: := ln_element_type_id;
2431: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2432: := lv_element_classification_name;
2433: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2434: := ln_primary_balance_id;
2435: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2436: := ln_processing_priority;
2437: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2431: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
2432: := lv_element_classification_name;
2433: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2434: := ln_primary_balance_id;
2435: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2436: := ln_processing_priority;
2437: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2438: := lv_reporting_name;
2439: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2433: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
2434: := ln_primary_balance_id;
2435: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2436: := ln_processing_priority;
2437: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2438: := lv_reporting_name;
2439: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2440: := ln_hours_balance_id;
2441: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2435: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
2436: := ln_processing_priority;
2437: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2438: := lv_reporting_name;
2439: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2440: := ln_hours_balance_id;
2441: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2442: := '00-000-0000';
2443:
2437: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
2438: := lv_reporting_name;
2439: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
2440: := ln_hours_balance_id;
2441: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
2442: := '00-000-0000';
2443:
2444: hr_utility.set_location(gv_package || lv_procedure_name, 50);
2445: ln_step := 20;
2667: hr_utility.trace('ln_element_type_id = ' ||ln_element_type_id);
2668: hr_utility.trace('ln_primary_balance_id = '||ln_primary_balance_id);
2669: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
2670:
2671: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2672:
2673: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2674: := lv_action_info_category;
2675: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2669: hr_utility.trace('ln_ytd_amount = ' ||ln_ytd_amount);
2670:
2671: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2672:
2673: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2674: := lv_action_info_category;
2675: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2676: := lv_jurisdiction_code;
2677: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2671: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2672:
2673: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2674: := lv_action_info_category;
2675: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2676: := lv_jurisdiction_code;
2677: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2678: := p_xfr_action_id;
2679: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2673: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2674: := lv_action_info_category;
2675: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2676: := lv_jurisdiction_code;
2677: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2678: := p_xfr_action_id;
2679: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2680: := ln_assignment_id;
2681: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2675: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2676: := lv_jurisdiction_code;
2677: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2678: := p_xfr_action_id;
2679: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2680: := ln_assignment_id;
2681: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2682: := lv_element_classfication_name;
2683: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2677: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2678: := p_xfr_action_id;
2679: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2680: := ln_assignment_id;
2681: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2682: := lv_element_classfication_name;
2683: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2684: := ln_element_type_id;
2685: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2679: pay_ac_action_arch.lrr_act_tab(ln_index).assignment_id
2680: := ln_assignment_id;
2681: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2682: := lv_element_classfication_name;
2683: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2684: := ln_element_type_id;
2685: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2686: := ln_primary_balance_id;
2687: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2681: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2682: := lv_element_classfication_name;
2683: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2684: := ln_element_type_id;
2685: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2686: := ln_primary_balance_id;
2687: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2688: := ln_processing_priority;
2689: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2683: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2684: := ln_element_type_id;
2685: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2686: := ln_primary_balance_id;
2687: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2688: := ln_processing_priority;
2689: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2690: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
2691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2685: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2686: := ln_primary_balance_id;
2687: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2688: := ln_processing_priority;
2689: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2690: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
2691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2692: := lv_reporting_name;
2693: if lv_action_info_category = 'AC EARNINGS' then
2687: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2688: := ln_processing_priority;
2689: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2690: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
2691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2692: := lv_reporting_name;
2693: if lv_action_info_category = 'AC EARNINGS' then
2694: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
2695: := fnd_number.number_to_canonical(ln_ytd_hours);
2690: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
2691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2692: := lv_reporting_name;
2693: if lv_action_info_category = 'AC EARNINGS' then
2694: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
2695: := fnd_number.number_to_canonical(ln_ytd_hours);
2696: end if;
2697:
2698: -- Added for Bug# 7348767, Bug# 7348838
2696: end if;
2697:
2698: -- Added for Bug# 7348767, Bug# 7348838
2699: if lv_action_info_category = 'AC DEDUCTIONS' THEN
2700: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
2701: end if;
2702: end if;
2703:
2704: if ln_assignment_id = p_assignment_id then
2701: end if;
2702: end if;
2703:
2704: if ln_assignment_id = p_assignment_id then
2705: if pay_ac_action_arch.emp_elements_tab.count > 0 then
2706: for i in pay_ac_action_arch.emp_elements_tab.first..
2707: pay_ac_action_arch.emp_elements_tab.last LOOP
2708: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2709: = ln_primary_balance_id and
2702: end if;
2703:
2704: if ln_assignment_id = p_assignment_id then
2705: if pay_ac_action_arch.emp_elements_tab.count > 0 then
2706: for i in pay_ac_action_arch.emp_elements_tab.first..
2707: pay_ac_action_arch.emp_elements_tab.last LOOP
2708: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2709: = ln_primary_balance_id and
2710: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
2703:
2704: if ln_assignment_id = p_assignment_id then
2705: if pay_ac_action_arch.emp_elements_tab.count > 0 then
2706: for i in pay_ac_action_arch.emp_elements_tab.first..
2707: pay_ac_action_arch.emp_elements_tab.last LOOP
2708: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2709: = ln_primary_balance_id and
2710: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
2711: = lv_jurisdiction_code then
2704: if ln_assignment_id = p_assignment_id then
2705: if pay_ac_action_arch.emp_elements_tab.count > 0 then
2706: for i in pay_ac_action_arch.emp_elements_tab.first..
2707: pay_ac_action_arch.emp_elements_tab.last LOOP
2708: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2709: = ln_primary_balance_id and
2710: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
2711: = lv_jurisdiction_code then
2712: lv_element_archived := 'Y';
2706: for i in pay_ac_action_arch.emp_elements_tab.first..
2707: pay_ac_action_arch.emp_elements_tab.last LOOP
2708: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
2709: = ln_primary_balance_id and
2710: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
2711: = lv_jurisdiction_code then
2712: lv_element_archived := 'Y';
2713: exit;
2714: end if;
2745: end if;
2746:
2747: if lv_element_archived = 'N' then
2748: /* populate the extra element table */
2749: ln_index := pay_ac_action_arch.emp_elements_tab.count;
2750: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
2751: := ln_element_type_id;
2752: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
2753: := lv_element_classfication_name;
2746:
2747: if lv_element_archived = 'N' then
2748: /* populate the extra element table */
2749: ln_index := pay_ac_action_arch.emp_elements_tab.count;
2750: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
2751: := ln_element_type_id;
2752: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
2753: := lv_element_classfication_name;
2754: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
2748: /* populate the extra element table */
2749: ln_index := pay_ac_action_arch.emp_elements_tab.count;
2750: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
2751: := ln_element_type_id;
2752: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
2753: := lv_element_classfication_name;
2754: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
2755: := lv_jurisdiction_code;
2756: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
2750: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
2751: := ln_element_type_id;
2752: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
2753: := lv_element_classfication_name;
2754: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
2755: := lv_jurisdiction_code;
2756: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
2757: := ln_primary_balance_id;
2758: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
2752: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
2753: := lv_element_classfication_name;
2754: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
2755: := lv_jurisdiction_code;
2756: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
2757: := ln_primary_balance_id;
2758: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
2759: := ln_processing_priority;
2760: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
2754: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
2755: := lv_jurisdiction_code;
2756: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
2757: := ln_primary_balance_id;
2758: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
2759: := ln_processing_priority;
2760: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
2761: := lv_reporting_name;
2762: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
2756: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
2757: := ln_primary_balance_id;
2758: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
2759: := ln_processing_priority;
2760: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
2761: := lv_reporting_name;
2762: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
2763: := ln_hours_balance_id;
2764:
2758: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
2759: := ln_processing_priority;
2760: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
2761: := lv_reporting_name;
2762: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
2763: := ln_hours_balance_id;
2764:
2765: if lv_jurisdiction_code <> '00-000-0000' then
2766: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
2805: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
2806: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
2807:
2808: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
2809: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
2810:
2811: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2812: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2813: hr_utility.trace('ln_index = ' || ln_index);
2808: if (( nvl(ln_ytd_amount, 0) + nvl(ln_payments_amount, 0) <> 0 ) or
2809: ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) ) then
2810:
2811: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2812: ln_index := pay_ac_action_arch.lrr_act_tab.count;
2813: hr_utility.trace('ln_index = ' || ln_index);
2814: ln_step := 20;
2815: if lv_element_classfication_name in ('Earnings',
2816: 'Alien/Expat Earnings',
2818: 'Taxable Benefits',
2819: 'Imputed Earnings',
2820: 'Non-payroll Payments') then
2821: lv_action_info_category := 'AC EARNINGS';
2822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
2823: := fnd_number.number_to_canonical(ln_ytd_hours);
2824: end if;
2825:
2826: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
2823: := fnd_number.number_to_canonical(ln_ytd_hours);
2824: end if;
2825:
2826: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2827: := lv_action_info_category;
2828: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2829: := lv_jurisdiction_code;
2830: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2824: end if;
2825:
2826: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2827: := lv_action_info_category;
2828: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2829: := lv_jurisdiction_code;
2830: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2831: := p_xfr_action_id;
2832: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2826: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
2827: := lv_action_info_category;
2828: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2829: := lv_jurisdiction_code;
2830: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2831: := p_xfr_action_id;
2832: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2833: := lv_element_classfication_name;
2834: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2828: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
2829: := lv_jurisdiction_code;
2830: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2831: := p_xfr_action_id;
2832: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2833: := lv_element_classfication_name;
2834: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2835: := ln_element_type_id;
2836: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2830: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
2831: := p_xfr_action_id;
2832: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2833: := lv_element_classfication_name;
2834: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2835: := ln_element_type_id;
2836: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2837: := ln_primary_balance_id;
2838: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2832: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
2833: := lv_element_classfication_name;
2834: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2835: := ln_element_type_id;
2836: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2837: := ln_primary_balance_id;
2838: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2839: := ln_processing_priority;
2840: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2834: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
2835: := ln_element_type_id;
2836: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2837: := ln_primary_balance_id;
2838: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2839: := ln_processing_priority;
2840: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2841: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
2842: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2836: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2837: := ln_primary_balance_id;
2838: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2839: := ln_processing_priority;
2840: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2841: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
2842: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2843: := fnd_number.number_to_canonical(ln_ytd_amount);
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2838: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2839: := ln_processing_priority;
2840: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2841: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
2842: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2843: := fnd_number.number_to_canonical(ln_ytd_amount);
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2845: := lv_reporting_name;
2846: -- Added for Bug# 7348767, Bug# 7348838
2840: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2841: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
2842: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2843: := fnd_number.number_to_canonical(ln_ytd_amount);
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2845: := lv_reporting_name;
2846: -- Added for Bug# 7348767, Bug# 7348838
2847: if lv_action_info_category = 'AC DEDUCTIONS' THEN
2848: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
2844: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2845: := lv_reporting_name;
2846: -- Added for Bug# 7348767, Bug# 7348838
2847: if lv_action_info_category = 'AC DEDUCTIONS' THEN
2848: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
2849: end if;
2850:
2851: end if;
2852: end if;
3033: ln_hours_balance_id := null;
3034: end if;
3035:
3036: ln_step := 5;
3037: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3038: for i in pay_ac_action_arch.emp_elements_tab.first..
3039: pay_ac_action_arch.emp_elements_tab.last LOOP
3040: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3041: = ln_primary_balance_id and
3034: end if;
3035:
3036: ln_step := 5;
3037: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3038: for i in pay_ac_action_arch.emp_elements_tab.first..
3039: pay_ac_action_arch.emp_elements_tab.last LOOP
3040: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3041: = ln_primary_balance_id and
3042: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3035:
3036: ln_step := 5;
3037: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3038: for i in pay_ac_action_arch.emp_elements_tab.first..
3039: pay_ac_action_arch.emp_elements_tab.last LOOP
3040: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3041: = ln_primary_balance_id and
3042: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3043: = lv_jurisdiction_code then
3036: ln_step := 5;
3037: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3038: for i in pay_ac_action_arch.emp_elements_tab.first..
3039: pay_ac_action_arch.emp_elements_tab.last LOOP
3040: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3041: = ln_primary_balance_id and
3042: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3043: = lv_jurisdiction_code then
3044: lv_element_archived := 'Y';
3038: for i in pay_ac_action_arch.emp_elements_tab.first..
3039: pay_ac_action_arch.emp_elements_tab.last LOOP
3040: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3041: = ln_primary_balance_id and
3042: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3043: = lv_jurisdiction_code then
3044: lv_element_archived := 'Y';
3045: exit;
3046: end if;
3049:
3050: if lv_element_archived = 'N' then
3051: /* populate the extra element table */
3052: ln_step := 10;
3053: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3054: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3055: := ln_element_type_id;
3056: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3057: := lv_element_classfication_name;
3050: if lv_element_archived = 'N' then
3051: /* populate the extra element table */
3052: ln_step := 10;
3053: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3054: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3055: := ln_element_type_id;
3056: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3057: := lv_element_classfication_name;
3058: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3052: ln_step := 10;
3053: ln_index := pay_ac_action_arch.emp_elements_tab.count;
3054: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3055: := ln_element_type_id;
3056: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3057: := lv_element_classfication_name;
3058: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3059: := ln_primary_balance_id;
3060: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3054: pay_ac_action_arch.emp_elements_tab(ln_index).element_type_id
3055: := ln_element_type_id;
3056: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3057: := lv_element_classfication_name;
3058: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3059: := ln_primary_balance_id;
3060: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3061: := ln_processing_priority;
3062: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3056: pay_ac_action_arch.emp_elements_tab(ln_index).element_classfn
3057: := lv_element_classfication_name;
3058: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3059: := ln_primary_balance_id;
3060: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3061: := ln_processing_priority;
3062: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3063: := lv_reporting_name;
3064: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3058: pay_ac_action_arch.emp_elements_tab(ln_index).element_primary_balance_id
3059: := ln_primary_balance_id;
3060: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3061: := ln_processing_priority;
3062: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3063: := lv_reporting_name;
3064: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3065: := ln_hours_balance_id;
3066: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3060: pay_ac_action_arch.emp_elements_tab(ln_index).element_processing_priority
3061: := ln_processing_priority;
3062: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3063: := lv_reporting_name;
3064: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3065: := ln_hours_balance_id;
3066: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3067: := lv_jurisdiction_code;
3068:
3062: pay_ac_action_arch.emp_elements_tab(ln_index).element_reporting_name
3063: := lv_reporting_name;
3064: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3065: := ln_hours_balance_id;
3066: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3067: := lv_jurisdiction_code;
3068:
3069: if lv_jurisdiction_code <> '00-000-0000' then
3070: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3107: end if;
3108:
3109: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3110: if nvl(ln_ytd_amount, 0) <> 0 or nvl(ln_payments_amount, 0) <> 0 then
3111: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3112: hr_utility.trace('ln_index = ' || ln_index);
3113: if lv_element_classfication_name in ('Earnings',
3114: 'Alien/Expat Earnings',
3115: 'Supplemental Earnings',
3116: 'Taxable Benefits',
3117: 'Imputed Earnings',
3118: 'Non-payroll Payments') then
3119: lv_action_info_category := 'AC EARNINGS';
3120: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3121: := fnd_number.number_to_canonical(ln_ytd_hours); /* Bug 3311866*/
3122: end if;
3123:
3124: ln_step := 20;
3121: := fnd_number.number_to_canonical(ln_ytd_hours); /* Bug 3311866*/
3122: end if;
3123:
3124: ln_step := 20;
3125: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3126: := lv_action_info_category;
3127: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3128: := lv_jurisdiction_code;
3129: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3123:
3124: ln_step := 20;
3125: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3126: := lv_action_info_category;
3127: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3128: := lv_jurisdiction_code;
3129: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3130: := p_xfr_action_id ;
3131: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3125: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3126: := lv_action_info_category;
3127: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3128: := lv_jurisdiction_code;
3129: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3130: := p_xfr_action_id ;
3131: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3132: := lv_element_classfication_name;
3133: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3127: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3128: := lv_jurisdiction_code;
3129: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3130: := p_xfr_action_id ;
3131: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3132: := lv_element_classfication_name;
3133: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3134: := ln_element_type_id;
3135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3129: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
3130: := p_xfr_action_id ;
3131: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3132: := lv_element_classfication_name;
3133: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3134: := ln_element_type_id;
3135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3136: := ln_primary_balance_id;
3137: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3131: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3132: := lv_element_classfication_name;
3133: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3134: := ln_element_type_id;
3135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3136: := ln_primary_balance_id;
3137: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3138: := ln_processing_priority;
3139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3133: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3134: := ln_element_type_id;
3135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3136: := ln_primary_balance_id;
3137: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3138: := ln_processing_priority;
3139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3140: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3136: := ln_primary_balance_id;
3137: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3138: := ln_processing_priority;
3139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3140: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3142: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3137: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3138: := ln_processing_priority;
3139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3140: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3142: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3144: := lv_reporting_name;
3145: -- Added for Bug# 7348767, Bug# 7348838
3139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3140: := fnd_number.number_to_canonical(nvl(ln_payments_amount,0));
3141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3142: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
3143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3144: := lv_reporting_name;
3145: -- Added for Bug# 7348767, Bug# 7348838
3146: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3147: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3144: := lv_reporting_name;
3145: -- Added for Bug# 7348767, Bug# 7348838
3146: if lv_action_info_category = 'AC DEDUCTIONS' THEN
3147: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24 := lv_reporting_name;
3148: end if;
3149: end if;
3150: end if;
3151: lv_element_archived := 'N';
3361: ** when archiving the Current Action. If it has been archived
3362: ** skip the element
3363: **********************************************************/
3364: ln_step := 15;
3365: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3366: for i in pay_ac_action_arch.emp_elements_tab.first ..
3367: pay_ac_action_arch.emp_elements_tab.last loop
3368:
3369: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3362: ** skip the element
3363: **********************************************************/
3364: ln_step := 15;
3365: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3366: for i in pay_ac_action_arch.emp_elements_tab.first ..
3367: pay_ac_action_arch.emp_elements_tab.last loop
3368:
3369: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3370: = ln_primary_balance_id and
3363: **********************************************************/
3364: ln_step := 15;
3365: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3366: for i in pay_ac_action_arch.emp_elements_tab.first ..
3367: pay_ac_action_arch.emp_elements_tab.last loop
3368:
3369: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3370: = ln_primary_balance_id and
3371: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3365: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3366: for i in pay_ac_action_arch.emp_elements_tab.first ..
3367: pay_ac_action_arch.emp_elements_tab.last loop
3368:
3369: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3370: = ln_primary_balance_id and
3371: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3372: = lv_jurisdiction_code then
3373:
3367: pay_ac_action_arch.emp_elements_tab.last loop
3368:
3369: if pay_ac_action_arch.emp_elements_tab(i).element_primary_balance_id
3370: = ln_primary_balance_id and
3371: pay_ac_action_arch.emp_elements_tab(i).jurisdiction_code
3372: = lv_jurisdiction_code then
3373:
3374: hr_utility.set_location(gv_package || lv_procedure_name, 65);
3375: lv_element_archived := 'Y';
3380:
3381: if lv_element_archived = 'N' then
3382: ln_step := 20;
3383: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3384: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3385: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3386: := ln_element_type_id;
3387: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3388: := lv_element_classification_name;
3381: if lv_element_archived = 'N' then
3382: ln_step := 20;
3383: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3384: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3385: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3386: := ln_element_type_id;
3387: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3388: := lv_element_classification_name;
3389: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3383: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3384: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
3385: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3386: := ln_element_type_id;
3387: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3388: := lv_element_classification_name;
3389: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3390: := lv_reporting_name;
3391: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3385: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
3386: := ln_element_type_id;
3387: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3388: := lv_element_classification_name;
3389: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3390: := lv_reporting_name;
3391: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3392: := ln_primary_balance_id;
3393: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3387: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
3388: := lv_element_classification_name;
3389: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3390: := lv_reporting_name;
3391: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3392: := ln_primary_balance_id;
3393: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3394: := ln_processing_priority;
3395: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3389: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
3390: := lv_reporting_name;
3391: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3392: := ln_primary_balance_id;
3393: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3394: := ln_processing_priority;
3395: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3396: := ln_hours_balance_id;
3397: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3391: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
3392: := ln_primary_balance_id;
3393: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3394: := ln_processing_priority;
3395: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3396: := ln_hours_balance_id;
3397: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3398: := lv_jurisdiction_code;
3399:
3393: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
3394: := ln_processing_priority;
3395: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
3396: := ln_hours_balance_id;
3397: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
3398: := lv_jurisdiction_code;
3399:
3400: /*****************************************************************
3401: ** The Payment Assignemnt Action is not passed to this procedure
3449: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3450:
3451:
3452: ln_step := 30;
3453: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3454: for i in pay_ac_action_arch.lrr_act_tab.first ..
3455: pay_ac_action_arch.lrr_act_tab.last loop
3456:
3457: hr_utility.trace('after populate_elements ftp' ||
3450:
3451:
3452: ln_step := 30;
3453: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3454: for i in pay_ac_action_arch.lrr_act_tab.first ..
3455: pay_ac_action_arch.lrr_act_tab.last loop
3456:
3457: hr_utility.trace('after populate_elements ftp' ||
3458: ' action_context_id is ' ||
3451:
3452: ln_step := 30;
3453: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3454: for i in pay_ac_action_arch.lrr_act_tab.first ..
3455: pay_ac_action_arch.lrr_act_tab.last loop
3456:
3457: hr_utility.trace('after populate_elements ftp' ||
3458: ' action_context_id is ' ||
3459: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3455: pay_ac_action_arch.lrr_act_tab.last loop
3456:
3457: hr_utility.trace('after populate_elements ftp' ||
3458: ' action_context_id is ' ||
3459: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3460: hr_utility.trace('action_info_category ' ||
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3457: hr_utility.trace('after populate_elements ftp' ||
3458: ' action_context_id is ' ||
3459: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3460: hr_utility.trace('action_info_category ' ||
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3459: to_char(pay_ac_action_arch.lrr_act_tab(i).action_context_id));
3460: hr_utility.trace('action_info_category ' ||
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3461: pay_ac_action_arch.lrr_act_tab(i).action_info_category);
3462: hr_utility.trace('act_info1 is ' ||
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3463: pay_ac_action_arch.lrr_act_tab(i).act_info1);
3464: hr_utility.trace('act_info10 ' ||
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3465: pay_ac_action_arch.lrr_act_tab(i).act_info10);
3466: hr_utility.trace('act_info3 ' ||
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3467: pay_ac_action_arch.lrr_act_tab(i).act_info3);
3468: hr_utility.trace('act_info4 ' ||
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3475: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3469: pay_ac_action_arch.lrr_act_tab(i).act_info4);
3470: hr_utility.trace('act_info5 ' ||
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3475: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3476: hr_utility.trace('act_info8 ' ||
3477: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3471: pay_ac_action_arch.lrr_act_tab(i).act_info5);
3472: hr_utility.trace('act_info6 ' ||
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3475: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3476: hr_utility.trace('act_info8 ' ||
3477: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3478:
3479: end loop;
3473: pay_ac_action_arch.lrr_act_tab(i).act_info6);
3474: hr_utility.trace('act_info7 ' ||
3475: pay_ac_action_arch.lrr_act_tab(i).act_info7);
3476: hr_utility.trace('act_info8 ' ||
3477: pay_ac_action_arch.lrr_act_tab(i).act_info8);
3478:
3479: end loop;
3480: end if;
3481:
3481:
3482: hr_utility.set_location(gv_package || lv_procedure_name, 110);
3483:
3484: ln_step := 35;
3485: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3486: for j in pay_ac_action_arch.emp_elements_tab.first ..
3487: pay_ac_action_arch.emp_elements_tab.last loop
3488:
3489: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3482: hr_utility.set_location(gv_package || lv_procedure_name, 110);
3483:
3484: ln_step := 35;
3485: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3486: for j in pay_ac_action_arch.emp_elements_tab.first ..
3487: pay_ac_action_arch.emp_elements_tab.last loop
3488:
3489: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3490: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3483:
3484: ln_step := 35;
3485: if pay_ac_action_arch.emp_elements_tab.count > 0 then
3486: for j in pay_ac_action_arch.emp_elements_tab.first ..
3487: pay_ac_action_arch.emp_elements_tab.last loop
3488:
3489: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3490: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3491: end loop;
3486: for j in pay_ac_action_arch.emp_elements_tab.first ..
3487: pay_ac_action_arch.emp_elements_tab.last loop
3488:
3489: hr_utility.trace('EMP_ELEMENTS_TAB.element_type ' ||
3490: to_char(pay_ac_action_arch.emp_elements_tab(j).element_type_id));
3491: end loop;
3492: end if;
3493:
3494: hr_utility.set_location(gv_package || lv_procedure_name, 200);
3650:
3651: BEGIN
3652: ln_step := 1;
3653: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3654: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3655: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3656:
3657: ln_step := 2;
3658: for i in pay_ac_action_arch.lrr_act_tab.first ..
3654: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3655: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3656:
3657: ln_step := 2;
3658: for i in pay_ac_action_arch.lrr_act_tab.first ..
3659: pay_ac_action_arch.lrr_act_tab.last loop
3660:
3661: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
3662: = p_xfr_action_id then
3655: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3656:
3657: ln_step := 2;
3658: for i in pay_ac_action_arch.lrr_act_tab.first ..
3659: pay_ac_action_arch.lrr_act_tab.last loop
3660:
3661: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
3662: = p_xfr_action_id then
3663: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
3657: ln_step := 2;
3658: for i in pay_ac_action_arch.lrr_act_tab.first ..
3659: pay_ac_action_arch.lrr_act_tab.last loop
3660:
3661: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
3662: = p_xfr_action_id then
3663: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
3664: = 'AC EARNINGS' then
3665: if pay_ac_action_arch.lrr_act_tab(i).act_info1
3659: pay_ac_action_arch.lrr_act_tab.last loop
3660:
3661: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
3662: = p_xfr_action_id then
3663: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
3664: = 'AC EARNINGS' then
3665: if pay_ac_action_arch.lrr_act_tab(i).act_info1
3666: = 'Earnings' then
3667: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3661: if pay_ac_action_arch.lrr_act_tab(i).action_context_id
3662: = p_xfr_action_id then
3663: if pay_ac_action_arch.lrr_act_tab(i).action_info_category
3664: = 'AC EARNINGS' then
3665: if pay_ac_action_arch.lrr_act_tab(i).act_info1
3666: = 'Earnings' then
3667: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3668: ln_step := 3;
3669: lv_earnings
3667: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3668: ln_step := 3;
3669: lv_earnings
3670: := lv_earnings +
3671: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3672: lv_ytd_earnings
3673: := lv_ytd_earnings +
3674: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3675: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3670: := lv_earnings +
3671: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3672: lv_ytd_earnings
3673: := lv_ytd_earnings +
3674: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3675: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3676: = 'Supplemental Earnings' then
3677: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3678: ln_step := 4;
3671: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3672: lv_ytd_earnings
3673: := lv_ytd_earnings +
3674: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3675: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3676: = 'Supplemental Earnings' then
3677: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3678: ln_step := 4;
3679: lv_supplemental_earnings
3677: hr_utility.set_location(gv_package || lv_procedure_name, 40);
3678: ln_step := 4;
3679: lv_supplemental_earnings
3680: := lv_supplemental_earnings +
3681: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3682: lv_ytd_supplemental_earnings
3683: := lv_ytd_supplemental_earnings +
3684: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3685: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3680: := lv_supplemental_earnings +
3681: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3682: lv_ytd_supplemental_earnings
3683: := lv_ytd_supplemental_earnings +
3684: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3685: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3686: = 'Imputed Earnings' then
3687: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3688: ln_step := 5;
3681: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3682: lv_ytd_supplemental_earnings
3683: := lv_ytd_supplemental_earnings +
3684: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3685: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3686: = 'Imputed Earnings' then
3687: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3688: ln_step := 5;
3689: lv_imputed_earnings
3687: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3688: ln_step := 5;
3689: lv_imputed_earnings
3690: := lv_imputed_earnings +
3691: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3692: lv_ytd_imputed_earnings
3693: := lv_ytd_imputed_earnings +
3694: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3695: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3690: := lv_imputed_earnings +
3691: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3692: lv_ytd_imputed_earnings
3693: := lv_ytd_imputed_earnings +
3694: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3695: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3696: = 'Non-payroll Payments' then
3697: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3698: ln_step := 6;
3691: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3692: lv_ytd_imputed_earnings
3693: := lv_ytd_imputed_earnings +
3694: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3695: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3696: = 'Non-payroll Payments' then
3697: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3698: ln_step := 6;
3699: lv_non_payroll_payments
3697: hr_utility.set_location(gv_package || lv_procedure_name, 50);
3698: ln_step := 6;
3699: lv_non_payroll_payments
3700: := lv_non_payroll_payments +
3701: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3702: lv_ytd_non_payroll_payments
3703: := lv_ytd_non_payroll_payments +
3704: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3705: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3700: := lv_non_payroll_payments +
3701: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3702: lv_ytd_non_payroll_payments
3703: := lv_ytd_non_payroll_payments +
3704: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3705: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3706: = 'Taxable Benefits' then
3707: hr_utility.set_location(gv_package || lv_procedure_name, 55);
3708: ln_step := 7;
3701: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3702: lv_ytd_non_payroll_payments
3703: := lv_ytd_non_payroll_payments +
3704: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3705: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3706: = 'Taxable Benefits' then
3707: hr_utility.set_location(gv_package || lv_procedure_name, 55);
3708: ln_step := 7;
3709: lv_taxable_benefits
3707: hr_utility.set_location(gv_package || lv_procedure_name, 55);
3708: ln_step := 7;
3709: lv_taxable_benefits
3710: := lv_taxable_benefits +
3711: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3712: lv_ytd_taxable_benefits
3713: := lv_ytd_taxable_benefits +
3714: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3715: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3710: := lv_taxable_benefits +
3711: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3712: lv_ytd_taxable_benefits
3713: := lv_ytd_taxable_benefits +
3714: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3715: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3716: = 'Alien/Expat Earnings' then
3717: hr_utility.set_location(gv_package || lv_procedure_name, 56);
3718: ln_step := 8;
3711: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3712: lv_ytd_taxable_benefits
3713: := lv_ytd_taxable_benefits +
3714: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3715: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3716: = 'Alien/Expat Earnings' then
3717: hr_utility.set_location(gv_package || lv_procedure_name, 56);
3718: ln_step := 8;
3719: lv_alien_expat_earnings
3717: hr_utility.set_location(gv_package || lv_procedure_name, 56);
3718: ln_step := 8;
3719: lv_alien_expat_earnings
3720: := lv_alien_expat_earnings +
3721: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3722: lv_ytd_alien_expat_earnings
3723: := lv_ytd_alien_expat_earnings +
3724: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3725: end if;
3720: := lv_alien_expat_earnings +
3721: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3722: lv_ytd_alien_expat_earnings
3723: := lv_ytd_alien_expat_earnings +
3724: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3725: end if;
3726:
3727: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
3728: = 'AC DEDUCTIONS' then
3723: := lv_ytd_alien_expat_earnings +
3724: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3725: end if;
3726:
3727: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
3728: = 'AC DEDUCTIONS' then
3729: if pay_ac_action_arch.lrr_act_tab(i).act_info1
3730: = 'Pre-Tax Deductions' then
3731: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3725: end if;
3726:
3727: elsif pay_ac_action_arch.lrr_act_tab(i).action_info_category
3728: = 'AC DEDUCTIONS' then
3729: if pay_ac_action_arch.lrr_act_tab(i).act_info1
3730: = 'Pre-Tax Deductions' then
3731: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3732: ln_step := 15;
3733: lv_pre_tax_deductions
3731: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3732: ln_step := 15;
3733: lv_pre_tax_deductions
3734: := lv_pre_tax_deductions +
3735: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3736: lv_ytd_pre_tax_deductions
3737: := lv_ytd_pre_tax_deductions +
3738: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3739: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3734: := lv_pre_tax_deductions +
3735: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3736: lv_ytd_pre_tax_deductions
3737: := lv_ytd_pre_tax_deductions +
3738: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3739: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3740: = 'Involuntary Deductions' then
3741: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3742: ln_step := 16;
3735: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3736: lv_ytd_pre_tax_deductions
3737: := lv_ytd_pre_tax_deductions +
3738: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3739: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3740: = 'Involuntary Deductions' then
3741: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3742: ln_step := 16;
3743: lv_involuntary_deductions
3741: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3742: ln_step := 16;
3743: lv_involuntary_deductions
3744: := lv_involuntary_deductions +
3745: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3746: lv_ytd_involuntary_deductions
3747: := lv_ytd_involuntary_deductions +
3748: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3749: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3744: := lv_involuntary_deductions +
3745: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3746: lv_ytd_involuntary_deductions
3747: := lv_ytd_involuntary_deductions +
3748: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3749: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3750: = 'Voluntary Deductions' then
3751: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3752: ln_step := 17;
3745: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3746: lv_ytd_involuntary_deductions
3747: := lv_ytd_involuntary_deductions +
3748: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3749: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3750: = 'Voluntary Deductions' then
3751: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3752: ln_step := 17;
3753: lv_voluntary_deductions
3751: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3752: ln_step := 17;
3753: lv_voluntary_deductions
3754: := lv_voluntary_deductions +
3755: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3756: lv_ytd_voluntary_deductions
3757: := lv_ytd_voluntary_deductions +
3758: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3759: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3754: := lv_voluntary_deductions +
3755: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3756: lv_ytd_voluntary_deductions
3757: := lv_ytd_voluntary_deductions +
3758: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3759: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3760: = 'Tax Deductions' then
3761: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3762: ln_step := 18;
3755: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3756: lv_ytd_voluntary_deductions
3757: := lv_ytd_voluntary_deductions +
3758: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3759: elsif pay_ac_action_arch.lrr_act_tab(i).act_info1
3760: = 'Tax Deductions' then
3761: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3762: ln_step := 18;
3763: lv_tax_deductions
3761: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3762: ln_step := 18;
3763: lv_tax_deductions
3764: := lv_tax_deductions +
3765: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3766: lv_ytd_tax_deductions
3767: := lv_ytd_tax_deductions +
3768: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3769: end if;
3764: := lv_tax_deductions +
3765: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info8),0);
3766: lv_ytd_tax_deductions
3767: := lv_ytd_tax_deductions +
3768: nvl(fnd_number.canonical_to_number(pay_ac_action_arch.lrr_act_tab(i).act_info9),0);
3769: end if;
3770: end if;
3771: end if;
3772: end loop;
3774:
3775: hr_utility.set_location(gv_package || lv_procedure_name, 95);
3776: ln_step := 24;
3777: j := 0;
3778: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
3779: for j in pay_ac_action_arch.ltr_summary_labels.first..
3780: pay_ac_action_arch.ltr_summary_labels.last loop
3781: if pay_ac_action_arch.ltr_summary_labels(j).language
3782: = pay_ac_action_arch.gv_person_lang and
3775: hr_utility.set_location(gv_package || lv_procedure_name, 95);
3776: ln_step := 24;
3777: j := 0;
3778: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
3779: for j in pay_ac_action_arch.ltr_summary_labels.first..
3780: pay_ac_action_arch.ltr_summary_labels.last loop
3781: if pay_ac_action_arch.ltr_summary_labels(j).language
3782: = pay_ac_action_arch.gv_person_lang and
3783: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
3776: ln_step := 24;
3777: j := 0;
3778: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
3779: for j in pay_ac_action_arch.ltr_summary_labels.first..
3780: pay_ac_action_arch.ltr_summary_labels.last loop
3781: if pay_ac_action_arch.ltr_summary_labels(j).language
3782: = pay_ac_action_arch.gv_person_lang and
3783: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
3784: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3777: j := 0;
3778: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
3779: for j in pay_ac_action_arch.ltr_summary_labels.first..
3780: pay_ac_action_arch.ltr_summary_labels.last loop
3781: if pay_ac_action_arch.ltr_summary_labels(j).language
3782: = pay_ac_action_arch.gv_person_lang and
3783: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
3784: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3785: end if;
3778: if pay_ac_action_arch.ltr_summary_labels.count > 0 then
3779: for j in pay_ac_action_arch.ltr_summary_labels.first..
3780: pay_ac_action_arch.ltr_summary_labels.last loop
3781: if pay_ac_action_arch.ltr_summary_labels(j).language
3782: = pay_ac_action_arch.gv_person_lang and
3783: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
3784: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3785: end if;
3786:
3779: for j in pay_ac_action_arch.ltr_summary_labels.first..
3780: pay_ac_action_arch.ltr_summary_labels.last loop
3781: if pay_ac_action_arch.ltr_summary_labels(j).language
3782: = pay_ac_action_arch.gv_person_lang and
3783: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
3784: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3785: end if;
3786:
3787: if pay_ac_action_arch.ltr_summary_labels(j).language
3780: pay_ac_action_arch.ltr_summary_labels.last loop
3781: if pay_ac_action_arch.ltr_summary_labels(j).language
3782: = pay_ac_action_arch.gv_person_lang and
3783: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
3784: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3785: end if;
3786:
3787: if pay_ac_action_arch.ltr_summary_labels(j).language
3788: = pay_ac_action_arch.gv_person_lang and
3783: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'CURRENT' then
3784: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3785: end if;
3786:
3787: if pay_ac_action_arch.ltr_summary_labels(j).language
3788: = pay_ac_action_arch.gv_person_lang and
3789: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
3790: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3791: end if;
3784: lv_current_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3785: end if;
3786:
3787: if pay_ac_action_arch.ltr_summary_labels(j).language
3788: = pay_ac_action_arch.gv_person_lang and
3789: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
3790: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3791: end if;
3792: end loop;
3785: end if;
3786:
3787: if pay_ac_action_arch.ltr_summary_labels(j).language
3788: = pay_ac_action_arch.gv_person_lang and
3789: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
3790: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3791: end if;
3792: end loop;
3793: end if;
3786:
3787: if pay_ac_action_arch.ltr_summary_labels(j).language
3788: = pay_ac_action_arch.gv_person_lang and
3789: pay_ac_action_arch.ltr_summary_labels(j).lookup_code = 'YTD' then
3790: lv_ytd_label := pay_ac_action_arch.ltr_summary_labels(j).meaning;
3791: end if;
3792: end loop;
3793: end if;
3794:
3793: end if;
3794:
3795: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3796: /* Insert one row for CURRENT and one for YTD */
3797: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3798: ln_step := 25;
3799: -- CURRENT
3800: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3801: hr_utility.trace('ln_index = ' || ln_index);
3796: /* Insert one row for CURRENT and one for YTD */
3797: if pay_ac_action_arch.lrr_act_tab.count > 0 then
3798: ln_step := 25;
3799: -- CURRENT
3800: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3801: hr_utility.trace('ln_index = ' || ln_index);
3802: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3803: := 'AC SUMMARY CURRENT';
3804: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3798: ln_step := 25;
3799: -- CURRENT
3800: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3801: hr_utility.trace('ln_index = ' || ln_index);
3802: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3803: := 'AC SUMMARY CURRENT';
3804: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3805: := '00-000-0000';
3806: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3800: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3801: hr_utility.trace('ln_index = ' || ln_index);
3802: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3803: := 'AC SUMMARY CURRENT';
3804: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3805: := '00-000-0000';
3806: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3807: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3802: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3803: := 'AC SUMMARY CURRENT';
3804: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3805: := '00-000-0000';
3806: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3807: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3804: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3805: := '00-000-0000';
3806: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3807: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3806: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3807: := fnd_number.number_to_canonical(lv_earnings); /*Bug 3311866*/
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3808: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3809: := fnd_number.number_to_canonical(lv_supplemental_earnings) ;
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3810: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3811: := fnd_number.number_to_canonical(lv_imputed_earnings);
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3812: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3813: := fnd_number.number_to_canonical(lv_pre_tax_deductions) ;
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3814: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3815: := fnd_number.number_to_canonical(lv_involuntary_deductions);
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3816: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3817: := fnd_number.number_to_canonical(lv_voluntary_deductions) ;
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3824: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3818: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3819: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3824: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3825: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3826: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3820: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3821: := fnd_number.number_to_canonical(lv_taxable_benefits);
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3824: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3825: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3826: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3827: := lv_current_label;
3828:
3822: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3823: := fnd_number.number_to_canonical(lv_alien_expat_earnings);
3824: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3825: := fnd_number.number_to_canonical(lv_non_payroll_payments);
3826: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3827: := lv_current_label;
3828:
3829: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3830: -- YTD
3827: := lv_current_label;
3828:
3829: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3830: -- YTD
3831: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3832: hr_utility.trace('ln_index = ' || ln_index);
3833: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3834: := 'AC SUMMARY YTD';
3835: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3829: hr_utility.set_location(gv_package || lv_procedure_name, 120);
3830: -- YTD
3831: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3832: hr_utility.trace('ln_index = ' || ln_index);
3833: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3834: := 'AC SUMMARY YTD';
3835: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3836: := '00-000-0000';
3837: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3831: ln_index := pay_ac_action_arch.lrr_act_tab.count;
3832: hr_utility.trace('ln_index = ' || ln_index);
3833: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3834: := 'AC SUMMARY YTD';
3835: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3836: := '00-000-0000';
3837: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3838: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3833: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3834: := 'AC SUMMARY YTD';
3835: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3836: := '00-000-0000';
3837: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3838: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3835: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3836: := '00-000-0000';
3837: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3838: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3837: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
3838: := fnd_number.number_to_canonical(lv_ytd_earnings); /*Bug 3311866*/
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3839: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
3840: := fnd_number.number_to_canonical(lv_ytd_supplemental_earnings) ;
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3841: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
3842: := fnd_number.number_to_canonical(lv_ytd_imputed_earnings);
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3843: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3844: := fnd_number.number_to_canonical(lv_ytd_pre_tax_deductions) ;
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3845: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3846: := fnd_number.number_to_canonical(lv_ytd_involuntary_deductions);
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3847: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3848: := fnd_number.number_to_canonical(lv_ytd_voluntary_deductions) ;
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3855: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3849: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3850: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3855: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3856: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3857: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
3852: := fnd_number.number_to_canonical(lv_ytd_taxable_benefits);
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3855: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3856: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3857: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3858: := lv_ytd_label;
3859: end if;
3853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
3854: := fnd_number.number_to_canonical(lv_ytd_alien_expat_earnings);
3855: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
3856: := fnd_number.number_to_canonical(lv_ytd_non_payroll_payments);
3857: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
3858: := lv_ytd_label;
3859: end if;
3860:
3861: hr_utility.set_location(gv_package || lv_procedure_name, 200);
4010:
4011:
4012: if nvl(ln_ytd_amount, 0) <> 0 then
4013: ln_step := 70;
4014: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4015:
4016: hr_utility.trace('ln_element_index = '||ln_element_index);
4017:
4018: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4014: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
4015:
4016: hr_utility.trace('ln_element_index = '||ln_element_index);
4017:
4018: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4019: := ln_element_type_id;
4020: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4021: := lv_element_classification_name;
4022: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4016: hr_utility.trace('ln_element_index = '||ln_element_index);
4017:
4018: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4019: := ln_element_type_id;
4020: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4021: := lv_element_classification_name;
4022: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4023: := lv_reporting_name;
4024: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4018: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_type_id
4019: := ln_element_type_id;
4020: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4021: := lv_element_classification_name;
4022: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4023: := lv_reporting_name;
4024: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4025: := ln_primary_balance_id;
4026: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4020: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
4021: := lv_element_classification_name;
4022: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4023: := lv_reporting_name;
4024: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4025: := ln_primary_balance_id;
4026: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4027: := ln_processing_priority;
4028: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4022: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
4023: := lv_reporting_name;
4024: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4025: := ln_primary_balance_id;
4026: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4027: := ln_processing_priority;
4028: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4029: := ln_hours_balance_id;
4030: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4024: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
4025: := ln_primary_balance_id;
4026: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4027: := ln_processing_priority;
4028: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4029: := ln_hours_balance_id;
4030: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4031: := lv_jurisdiction_code;
4032:
4026: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_processing_priority
4027: := ln_processing_priority;
4028: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_hours_balance_id
4029: := ln_hours_balance_id;
4030: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4031: := lv_jurisdiction_code;
4032:
4033:
4034: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4030: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
4031: := lv_jurisdiction_code;
4032:
4033:
4034: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4035: hr_utility.trace('ln_index = '||ln_index);
4036: if lv_element_classification_name in ('Earnings',
4037: 'Supplemental Earnings',
4038: 'Taxable Benefits',
4043: lv_action_category := 'AC EARNINGS';
4044: hr_utility.trace('ln_current_hours = '||ln_current_hours);
4045: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4046: ln_step := 80;
4047: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4048: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4049: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4050: := fnd_number.number_to_canonical(ln_ytd_hours);
4051: else
4045: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4046: ln_step := 80;
4047: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4048: := fnd_number.number_to_canonical(ln_current_hours); /*Bug 3311866*/
4049: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4050: := fnd_number.number_to_canonical(ln_ytd_hours);
4051: else
4052: lv_action_category := 'AC DEDUCTIONS';
4053: end if;
4057: hr_utility.trace('lv_reporting_name = '||lv_reporting_name);
4058: hr_utility.trace('p_xfr_action_id = '||p_xfr_action_id);
4059: ln_step := 90;
4060:
4061: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4062: := lv_action_category;
4063: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4064: := nvl(lv_jurisdiction_code, '00-000-0000');
4065: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4059: ln_step := 90;
4060:
4061: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4062: := lv_action_category;
4063: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4064: := nvl(lv_jurisdiction_code, '00-000-0000');
4065: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4066: := p_xfr_action_id;
4067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4061: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4062: := lv_action_category;
4063: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4064: := nvl(lv_jurisdiction_code, '00-000-0000');
4065: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4066: := p_xfr_action_id;
4067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4068: := lv_element_classification_name;
4069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4063: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4064: := nvl(lv_jurisdiction_code, '00-000-0000');
4065: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4066: := p_xfr_action_id;
4067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4068: := lv_element_classification_name;
4069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4070: := ln_element_type_id;
4071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4065: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4066: := p_xfr_action_id;
4067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4068: := lv_element_classification_name;
4069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4070: := ln_element_type_id;
4071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4072: := ln_primary_balance_id;
4073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4068: := lv_element_classification_name;
4069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4070: := ln_element_type_id;
4071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4072: := ln_primary_balance_id;
4073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4074: := ln_processing_priority;
4075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4070: := ln_element_type_id;
4071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4072: := ln_primary_balance_id;
4073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4074: := ln_processing_priority;
4075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4076: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4072: := ln_primary_balance_id;
4073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4074: := ln_processing_priority;
4075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4076: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4078: := fnd_number.number_to_canonical(ln_ytd_amount);
4079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4074: := ln_processing_priority;
4075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4076: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4078: := fnd_number.number_to_canonical(ln_ytd_amount);
4079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4080: := lv_reporting_name;
4081:
4075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4076: := fnd_number.number_to_canonical(ln_payments_amount); /*Bug 3311866*/
4077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4078: := fnd_number.number_to_canonical(ln_ytd_amount);
4079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4080: := lv_reporting_name;
4081:
4082: end if;
4083: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4086: CLOSE c_prev_ytd_action_elements;
4087:
4088: ln_step := 110;
4089: hr_utility.trace('------------Looping to see pl/sql table --------');
4090: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4091: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4092:
4093: hr_utility.trace('ln_check_count = '||ln_check_count);
4094: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4087:
4088: ln_step := 110;
4089: hr_utility.trace('------------Looping to see pl/sql table --------');
4090: ln_check_count := pay_ac_action_arch.emp_elements_tab.count;
4091: ln_check_count2 := pay_ac_action_arch.lrr_act_tab.count;
4092:
4093: hr_utility.trace('ln_check_count = '||ln_check_count);
4094: hr_utility.trace('ln_check_count2 = '||ln_check_count2);
4095: hr_utility.trace('============= End of Processing '||p_assignment_id||
4549:
4550: lv_action_category := 'AC DEDUCTIONS';
4551:
4552: ln_step := 15;
4553: ln_index := pay_ac_action_arch.lrr_act_tab.count;
4554:
4555: if p_element_classification_name in ('Earnings',
4556: 'Supplemental Earnings',
4557: 'Taxable Benefits',
4560: 'Alien/Expat Earnings') then
4561:
4562: lv_action_category := 'AC EARNINGS';
4563:
4564: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4565: := fnd_number.number_to_canonical(ln_hours);
4566:
4567:
4568: -- YTD Hours
4565: := fnd_number.number_to_canonical(ln_hours);
4566:
4567:
4568: -- YTD Hours
4569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
4570: := ln_rate;
4571:
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4573: := fnd_number.number_to_canonical(0);
4568: -- YTD Hours
4569: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
4570: := ln_rate;
4571:
4572: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4573: := fnd_number.number_to_canonical(0);
4574:
4575: end if; -- Classification Earnings
4576:
4579: /* Insert this into the plsql table if Current or YTD
4580: amount is not Zero */
4581:
4582: ln_step :=21;
4583: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4584: := lv_action_category;
4585: ln_step :=22;
4586: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4587: := '00-000-0000' ;
4582: ln_step :=21;
4583: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4584: := lv_action_category;
4585: ln_step :=22;
4586: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4587: := '00-000-0000' ;
4588: ln_step :=23;
4589: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4590: := p_xfr_action_id;
4585: ln_step :=22;
4586: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4587: := '00-000-0000' ;
4588: ln_step :=23;
4589: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4590: := p_xfr_action_id;
4591: ln_step :=24;
4592: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4593: := p_element_classification_name;
4588: ln_step :=23;
4589: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
4590: := p_xfr_action_id;
4591: ln_step :=24;
4592: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4593: := p_element_classification_name;
4594: ln_step :=25;
4595: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4596: := p_element_type_id;
4591: ln_step :=24;
4592: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
4593: := p_element_classification_name;
4594: ln_step :=25;
4595: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4596: := p_element_type_id;
4597: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4598: := p_primary_balance_id;
4599: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4593: := p_element_classification_name;
4594: ln_step :=25;
4595: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4596: := p_element_type_id;
4597: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4598: := p_primary_balance_id;
4599: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4600: := p_processing_priority;
4601: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4595: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
4596: := p_element_type_id;
4597: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4598: := p_primary_balance_id;
4599: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4600: := p_processing_priority;
4601: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4602: := fnd_number.number_to_canonical(nvl(ln_amount,0));
4603:
4597: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4598: := p_primary_balance_id;
4599: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
4600: := p_processing_priority;
4601: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4602: := fnd_number.number_to_canonical(nvl(ln_amount,0));
4603:
4604: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
4605:
4602: := fnd_number.number_to_canonical(nvl(ln_amount,0));
4603:
4604: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
4605:
4606: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4607: := p_reporting_name;
4608: IF lv_action_category = 'AC DEDUCTIONS' THEN
4609: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
4610: := p_reporting_name;
4605:
4606: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4607: := p_reporting_name;
4608: IF lv_action_category = 'AC DEDUCTIONS' THEN
4609: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
4610: := p_reporting_name;
4611: END IF;
4612: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
4613: := lv_original_date_earned;
4608: IF lv_action_category = 'AC DEDUCTIONS' THEN
4609: pay_ac_action_arch.lrr_act_tab(ln_index).act_info24
4610: := p_reporting_name;
4611: END IF;
4612: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
4613: := lv_original_date_earned;
4614: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
4615: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
4616: := lv_effective_start_date;
4611: END IF;
4612: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
4613: := lv_original_date_earned;
4614: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
4615: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
4616: := lv_effective_start_date;
4617: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
4618: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
4619: := lv_effective_end_date ;
4614: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
4615: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
4616: := lv_effective_start_date;
4617: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
4618: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
4619: := lv_effective_end_date ;
4620: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
4621: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
4622: := lv_category;
4617: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
4618: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
4619: := lv_effective_end_date ;
4620: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
4621: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
4622: := lv_category;
4623: hr_utility.trace('lv_category ' || lv_category );
4624: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
4625: := lv_jurisdiction_flag;
4620: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
4621: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
4622: := lv_category;
4623: hr_utility.trace('lv_category ' || lv_category );
4624: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
4625: := lv_jurisdiction_flag;
4626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4627: := fnd_number.number_to_canonical(0);
4628:
4622: := lv_category;
4623: hr_utility.trace('lv_category ' || lv_category );
4624: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
4625: := lv_jurisdiction_flag;
4626: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4627: := fnd_number.number_to_canonical(0);
4628:
4629: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4630:
4687: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4688: end if;
4689: end if;
4690:
4691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4692: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4693: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4694:
4695: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4691: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4692: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4693: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4694:
4695: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4696: = 'AC EARNINGS' then
4697:
4698: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4699: := fnd_number.number_to_canonical(ln_ytd_hours);
4694:
4695: if pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
4696: = 'AC EARNINGS' then
4697:
4698: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4699: := fnd_number.number_to_canonical(ln_ytd_hours);
4700: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
4701:
4702: end if;
4704: ELSE
4705: -- Global Variable Setting Needed Here
4706: -- That Can be Subtracted during Base Population
4707: --
4708: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4709: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4710: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4711: gv_ytd_amount := ln_ytd_amount ;
4712:
4709: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
4710: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
4711: gv_ytd_amount := ln_ytd_amount ;
4712:
4713: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4714: := fnd_number.number_to_canonical(ln_ytd_hours);
4715: gv_ytd_hour := ln_ytd_hours ;
4716:
4717: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5078:
5079: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
5080: lv_action_category := 'AC EARNINGS';
5081: ln_step := 15;
5082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5083:
5084: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5085: := fnd_number.number_to_canonical(ln_hours);
5086: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5080: lv_action_category := 'AC EARNINGS';
5081: ln_step := 15;
5082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5083:
5084: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5085: := fnd_number.number_to_canonical(ln_hours);
5086: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5087: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5088: /* Insert this into the plsql table if Current or YTD
5082: ln_index := pay_ac_action_arch.lrr_act_tab.count;
5083:
5084: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
5085: := fnd_number.number_to_canonical(ln_hours);
5086: hr_utility.trace('pay_ac_action_arch.lrr_act_tab(ln_index).act_info11' || pay_ac_action_arch.lrr_act_tab(ln_index).act_info11 );/*Bug 3311866*/
5087: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5088: /* Insert this into the plsql table if Current or YTD
5089: amount is not Zero */
5090: ln_step :=21;
5087: hr_utility.set_location(gv_package || lv_procedure_name, 130);
5088: /* Insert this into the plsql table if Current or YTD
5089: amount is not Zero */
5090: ln_step :=21;
5091: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5092: := lv_action_category;
5093: ln_step :=22;
5094: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5095: := '00-000-0000' ;
5090: ln_step :=21;
5091: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
5092: := lv_action_category;
5093: ln_step :=22;
5094: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5095: := '00-000-0000' ;
5096: ln_step :=23;
5097: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5098: := p_xfr_action_id;
5093: ln_step :=22;
5094: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
5095: := '00-000-0000' ;
5096: ln_step :=23;
5097: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5098: := p_xfr_action_id;
5099: ln_step :=24;
5100: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5101: := p_element_classification_name;
5096: ln_step :=23;
5097: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
5098: := p_xfr_action_id;
5099: ln_step :=24;
5100: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5101: := p_element_classification_name;
5102: ln_step :=25;
5103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5104: := p_element_type_id;
5099: ln_step :=24;
5100: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
5101: := p_element_classification_name;
5102: ln_step :=25;
5103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5104: := p_element_type_id;
5105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5106: := p_primary_balance_id;
5107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5101: := p_element_classification_name;
5102: ln_step :=25;
5103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5104: := p_element_type_id;
5105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5106: := p_primary_balance_id;
5107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5108: := p_processing_priority;
5109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
5104: := p_element_type_id;
5105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5106: := p_primary_balance_id;
5107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5108: := p_processing_priority;
5109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5110: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5105: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
5106: := p_primary_balance_id;
5107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5108: := p_processing_priority;
5109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5110: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5112: := fnd_number.number_to_canonical(0);
5113:
5107: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
5108: := p_processing_priority;
5109: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
5110: := fnd_number.number_to_canonical(nvl(ln_amount,0));
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5112: := fnd_number.number_to_canonical(0);
5113:
5114: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5111: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5112: := fnd_number.number_to_canonical(0);
5113:
5114: hr_utility.trace('ln_amount := '||fnd_number.number_to_canonical(nvl(ln_amount,0)));
5115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5116: := p_reporting_name;
5117:
5118: IF lv_temp_AAA <> 'AAA' THEN
5119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5115: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
5116: := p_reporting_name;
5117:
5118: IF lv_temp_AAA <> 'AAA' THEN
5119: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
5120: := lv_original_date_earned;
5121: hr_utility.trace('lv_original_date_earned :=' || lv_original_date_earned );
5122:
5123: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
5122:
5123: IF lv_check_date = nvl(lv_original_date_earned,p_pymt_eff_date) THEN
5124: count_j := ln_index;
5125: END IF;
5126: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5127: := lv_effective_start_date;
5128: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5129: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5130: := lv_effective_end_date ;
5125: END IF;
5126: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
5127: := lv_effective_start_date;
5128: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5129: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5130: := lv_effective_end_date ;
5131: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5132: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5133: := lv_category;
5128: hr_utility.trace('lv_effective_start_date := ' || lv_effective_start_date );
5129: pay_ac_action_arch.lrr_act_tab(ln_index).act_info19
5130: := lv_effective_end_date ;
5131: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5132: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5133: := lv_category;
5134: hr_utility.trace('lv_category ' || lv_category );
5135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5136: := lv_jurisdiction_flag;
5131: hr_utility.trace('lv_effective_end_date:= ' || lv_effective_end_date );
5132: pay_ac_action_arch.lrr_act_tab(ln_index).act_info20
5133: := lv_category;
5134: hr_utility.trace('lv_category ' || lv_category );
5135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5136: := lv_jurisdiction_flag;
5137: END IF;
5138:
5139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5135: pay_ac_action_arch.lrr_act_tab(ln_index).act_info21
5136: := lv_jurisdiction_flag;
5137: END IF;
5138:
5139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5140: := ln_rate;
5141: /*
5142: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
5143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5138:
5139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5140: := ln_rate;
5141: /*
5142: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
5143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5144: END IF;
5145: */
5146:
5139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22
5140: := ln_rate;
5141: /*
5142: IF pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 IS NULL THEN
5143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info22 := 'N/A';
5144: END IF;
5145: */
5146:
5147: hr_utility.set_location(gv_package || lv_procedure_name, 150);
5278: end if; -- p_pymt_balcall_aaid is not null
5279:
5280: ln_step := 15;
5281:
5282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5283: := fnd_number.number_to_canonical(ln_ytd_amount);
5284: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5283: := fnd_number.number_to_canonical(ln_ytd_amount);
5284: hr_utility.trace('ln_ytd_amount' || nvl(ln_ytd_amount,0));
5285:
5286: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5287: := fnd_number.number_to_canonical(ln_ytd_hours);
5288: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5289:
5290: /* Following later to be re-valuated IF worth doing wrt Cost
5289:
5290: /* Following later to be re-valuated IF worth doing wrt Cost
5291:
5292: IF count_j is null THEN
5293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5294: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5295: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5296: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5297: := fnd_number.number_to_canonical(ln_ytd_hours);
5292: IF count_j is null THEN
5293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
5294: := fnd_number.number_to_canonical(nvl(ln_ytd_amount,0));
5295: hr_utility.trace('ln_ytd_amount' || ln_ytd_amount);
5296: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
5297: := fnd_number.number_to_canonical(ln_ytd_hours);
5298: hr_utility.trace('ln_ytd_hours' || ln_ytd_hours);
5299: END IF;
5300: */
5305: hr_utility.trace('error occured at step ' || ln_step );
5306:
5307: END Archive_addnl_elements;
5308:
5309: END pay_ac_action_arch;