eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_ARCHIVE dependencies on PAY_US_PAYROLL_UTILS

Line 137: pay_us_payroll_utils.

133: 18-JUN-2003 sodhingr 115.67 3011003 Commented the cursors
134: c_get_defined_balance_id,
135: c_get_puerto_rico_bal,
136: c_get_1099r_bal and using
137: pay_us_payroll_utils.
138: c_get_defined_balance_id
139: 18-jun-2003 sodhingr 115.66 3011003 Changed the cursors
140: c_get_defined_balance_id,
141: c_get_puerto_rico_bal,

Line 420: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',

416: )
417: IS
418: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
419: select
420: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
421: ppa.legislative_parameters)),
422: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
423: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
424: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),

Line 422: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),

418: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
419: select
420: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
421: ppa.legislative_parameters)),
422: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
423: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
424: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
425: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
426: effective_date,

Line 423: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),

419: select
420: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
421: ppa.legislative_parameters)),
422: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
423: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
424: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
425: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
426: effective_date,
427: start_date,

Line 424: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),

420: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
421: ppa.legislative_parameters)),
422: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
423: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
424: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
425: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
426: effective_date,
427: start_date,
428: business_group_id,

Line 425: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),

421: ppa.legislative_parameters)),
422: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
423: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
424: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
425: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
426: effective_date,
427: start_date,
428: business_group_id,
429: creation_date

Line 641: hr_utility.trace('Opening pay_us_payroll_utils.c_get_defined_balance_id');

637: pay_us_archive.ltr_pr_balances(4).balance_name := 'Territory Taxable Allow' ;
638: pay_us_archive.ltr_pr_balances(5).balance_name := 'Territory Taxable TIPS' ;
639: pay_us_archive.ltr_pr_balances(6).balance_name := 'Territory Retire Contrib' ;
640:
641: hr_utility.trace('Opening pay_us_payroll_utils.c_get_defined_balance_id');
642:
643: loop
644: ln_count := ln_count + 1;
645: IF ln_count > 6 THEN

Line 648: open pay_us_payroll_utils.c_get_defined_balance_id(pay_us_archive.ltr_pr_balances(ln_count).balance_name,

644: ln_count := ln_count + 1;
645: IF ln_count > 6 THEN
646: exit;
647: END IF;
648: open pay_us_payroll_utils.c_get_defined_balance_id(pay_us_archive.ltr_pr_balances(ln_count).balance_name,
649: lv_balance_dimension,
650: NULL);
651: -- open c_get_puerto_rico_bal;
652:

Line 658: fetch pay_us_payroll_utils.c_get_defined_balance_id

654: lv_user_entity_name := '';
655: lv_balance_name := '';
656: ln_defined_balance_id := '';
657:
658: fetch pay_us_payroll_utils.c_get_defined_balance_id
659: into ln_defined_balance_id,
660: lv_user_entity_name;
661:
662: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '

Line 662: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '

658: fetch pay_us_payroll_utils.c_get_defined_balance_id
659: into ln_defined_balance_id,
660: lv_user_entity_name;
661:
662: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
663: ||lv_balance_name);
664:
665: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
666: hr_utility.trace('Going to exit' );

Line 665: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then

661:
662: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
663: ||lv_balance_name);
664:
665: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
666: hr_utility.trace('Going to exit' );
667: exit;
668: end if;
669:

Line 696: close pay_us_payroll_utils.c_get_defined_balance_id;

692:
693: -- pay_us_archive.ltr_pr_balances(ln_count).balance_name := lv_balance_name ;
694: pay_us_archive.ltr_pr_balances(ln_count).defined_balance := ln_defined_balance_id ;
695: pay_us_archive.ltr_pr_balances(ln_count).user_entity_id := ln_arch_user_entity_id ;
696: close pay_us_payroll_utils.c_get_defined_balance_id;
697: end loop;
698:
699: hr_utility.trace('Closed cursor');
700:

Line 834: hr_utility.trace('Opening pay_us_payroll_utils.c_get_defined_balance_id');

830: ln_defined_balance_id := 0 ;
831:
832: lv_balance_dimension := '_PER_GRE_YTD';
833:
834: hr_utility.trace('Opening pay_us_payroll_utils.c_get_defined_balance_id');
835:
836: pay_us_archive.ltr_1099_bal(1).balance_name := 'Capital Gain' ;
837: pay_us_archive.ltr_1099_bal(2).balance_name := 'EE Contributions Or Premiums' ;
838: pay_us_archive.ltr_1099_bal(3).balance_name := 'Other EE Annuity Contract Amt' ;

Line 848: open pay_us_payroll_utils.c_get_defined_balance_id(pay_us_archive.ltr_1099_bal(ln_count).balance_name,

844: ln_count := ln_count + 1;
845: IF ln_count > 5 THEN
846: exit;
847: END IF;
848: open pay_us_payroll_utils.c_get_defined_balance_id(pay_us_archive.ltr_1099_bal(ln_count).balance_name,
849: lv_balance_dimension,
850: NULL);
851: -- open c_get_1099r_bal;
852:

Line 859: fetch pay_us_payroll_utils.c_get_defined_balance_id

855: lv_user_entity_name := '';
856: lv_balance_name := '';
857: ln_defined_balance_id := 0;
858:
859: fetch pay_us_payroll_utils.c_get_defined_balance_id
860: into ln_defined_balance_id
861: ,lv_user_entity_name;
862:
863: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '

Line 863: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '

859: fetch pay_us_payroll_utils.c_get_defined_balance_id
860: into ln_defined_balance_id
861: ,lv_user_entity_name;
862:
863: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
864: ||lv_balance_name);
865:
866: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
867: exit;

Line 866: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then

862:
863: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
864: ||lv_balance_name);
865:
866: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
867: exit;
868: end if;
869:
870: l_step := 21.1;

Line 896: close pay_us_payroll_utils.c_get_defined_balance_id;

892:
893: -- pay_us_archive.ltr_1099_bal(ln_count).balance_name := lv_balance_name ;
894: pay_us_archive.ltr_1099_bal(ln_count).defined_balance := ln_defined_balance_id ;
895: pay_us_archive.ltr_1099_bal(ln_count).user_entity_id := ln_arch_user_entity_id ;
896: close pay_us_payroll_utils.c_get_defined_balance_id;
897:
898: end loop;
899: hr_utility.trace('Closed cursor');
900:

Line 1051: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,

1047: exit;
1048: end if;
1049:
1050: l_step := 15;
1051: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1052: lv_balance_dimension,
1053: p_business_group_id);
1054:
1055: fetch pay_us_payroll_utils.c_get_defined_balance_id

Line 1055: fetch pay_us_payroll_utils.c_get_defined_balance_id

1051: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1052: lv_balance_dimension,
1053: p_business_group_id);
1054:
1055: fetch pay_us_payroll_utils.c_get_defined_balance_id
1056: into ln_defined_balance_id,
1057: lv_user_entity_name;
1058:
1059: lv_arch_user_entity_name := 'A_'||lv_user_entity_name;

Line 1063: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then

1059: lv_arch_user_entity_name := 'A_'||lv_user_entity_name;
1060:
1061: hr_utility.trace('lv_arch_user_entity_name = '||lv_arch_user_entity_name);
1062:
1063: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then
1064:
1065: hr_utility.trace('Into found loop of Box 12 ');
1066: hr_utility.trace('ln_defined_balance_id = '||to_char(ln_defined_balance_id));
1067:

Line 1092: close pay_us_payroll_utils.c_get_defined_balance_id;

1088: pay_us_archive.ltr_pre_tax_bal(ln_count).defined_balance := ln_defined_balance_id ;
1089: pay_us_archive.ltr_pre_tax_bal(ln_count).user_entity_id := ln_arch_user_entity_id ;
1090:
1091: end if;
1092: close pay_us_payroll_utils.c_get_defined_balance_id;
1093:
1094: end loop;
1095: close c_balance;
1096: