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 168: pay_us_payroll_utils.

164: 18-JUN-2003 sodhingr 115.67 3011003 Commented the cursors
165: c_get_defined_balance_id,
166: c_get_puerto_rico_bal,
167: c_get_1099r_bal and using
168: pay_us_payroll_utils.
169: c_get_defined_balance_id
170: 18-jun-2003 sodhingr 115.66 3011003 Changed the cursors
171: c_get_defined_balance_id,
172: c_get_puerto_rico_bal,

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

448: )
449: IS
450: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
451: select
452: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
453: ppa.legislative_parameters)),
454: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
455: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
456: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),

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

450: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
451: select
452: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
453: ppa.legislative_parameters)),
454: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
455: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
456: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
457: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
458: effective_date,

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

451: select
452: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
453: ppa.legislative_parameters)),
454: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
455: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
456: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
457: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
458: effective_date,
459: start_date,

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

452: to_number(pay_us_payroll_utils.get_parameter('TRANSFER_GRE',
453: ppa.legislative_parameters)),
454: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
455: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
456: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
457: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
458: effective_date,
459: start_date,
460: business_group_id,

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

453: ppa.legislative_parameters)),
454: to_number(pay_us_payroll_utils.get_parameter('PER_ID',ppa.legislative_parameters)),
455: pay_us_payroll_utils.get_parameter('SSN',ppa.legislative_parameters),
456: to_number(pay_us_payroll_utils.get_parameter('ASG_SET',ppa.legislative_parameters)),
457: to_number(pay_us_payroll_utils.get_parameter('YEAR',ppa.legislative_parameters)),
458: effective_date,
459: start_date,
460: business_group_id,
461: creation_date

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

672: /* Bug 13449377 - Code modified to archive following new balances. */
673: pay_us_archive.ltr_pr_balances(7).balance_name := 'PR W2 Charitable Contributions' ;
674: pay_us_archive.ltr_pr_balances(8).balance_name := 'PR W2 Contr To Save and Double Money' ;
675:
676: hr_utility.trace('Opening pay_us_payroll_utils.c_get_defined_balance_id');
677:
678: loop
679: ln_count := ln_count + 1;
680: /* Bug 13449377 - increased from 6 to 8 to accomodate the new archive balances for PuertoRico */

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

680: /* Bug 13449377 - increased from 6 to 8 to accomodate the new archive balances for PuertoRico */
681: IF ln_count > 8 THEN
682: exit;
683: END IF;
684: open pay_us_payroll_utils.c_get_defined_balance_id(pay_us_archive.ltr_pr_balances(ln_count).balance_name,
685: lv_balance_dimension,
686: NULL);
687: -- open c_get_puerto_rico_bal;
688:

Line 694: fetch pay_us_payroll_utils.c_get_defined_balance_id

690: lv_user_entity_name := '';
691: lv_balance_name := '';
692: ln_defined_balance_id := '';
693:
694: fetch pay_us_payroll_utils.c_get_defined_balance_id
695: into ln_defined_balance_id,
696: lv_user_entity_name;
697:
698: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '

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

694: fetch pay_us_payroll_utils.c_get_defined_balance_id
695: into ln_defined_balance_id,
696: lv_user_entity_name;
697:
698: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
699: ||lv_balance_name);
700:
701: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
702: hr_utility.trace('Going to exit' );

Line 701: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then

697:
698: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
699: ||lv_balance_name);
700:
701: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
702: hr_utility.trace('Going to exit' );
703: exit;
704: end if;
705:

Line 732: close pay_us_payroll_utils.c_get_defined_balance_id;

728:
729: -- pay_us_archive.ltr_pr_balances(ln_count).balance_name := lv_balance_name ;
730: pay_us_archive.ltr_pr_balances(ln_count).defined_balance := ln_defined_balance_id ;
731: pay_us_archive.ltr_pr_balances(ln_count).user_entity_id := ln_arch_user_entity_id ;
732: close pay_us_payroll_utils.c_get_defined_balance_id;
733: end loop;
734:
735: hr_utility.trace('Closed cursor');
736:

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

873: ln_defined_balance_id := 0 ;
874:
875: lv_balance_dimension := '_PER_GRE_YTD';
876:
877: hr_utility.trace('Opening pay_us_payroll_utils.c_get_defined_balance_id');
878:
879: pay_us_archive.ltr_1099_bal(1).balance_name := 'Capital Gain' ;
880: pay_us_archive.ltr_1099_bal(2).balance_name := 'EE Contributions Or Premiums' ;
881: pay_us_archive.ltr_1099_bal(3).balance_name := 'Other EE Annuity Contract Amt' ;

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

888: ln_count := ln_count + 1;
889: IF ln_count > 6 THEN
890: exit;
891: END IF;
892: open pay_us_payroll_utils.c_get_defined_balance_id(pay_us_archive.ltr_1099_bal(ln_count).balance_name,
893: lv_balance_dimension,
894: NULL);
895: -- open c_get_1099r_bal;
896:

Line 903: fetch pay_us_payroll_utils.c_get_defined_balance_id

899: lv_user_entity_name := '';
900: lv_balance_name := '';
901: ln_defined_balance_id := 0;
902:
903: fetch pay_us_payroll_utils.c_get_defined_balance_id
904: into ln_defined_balance_id
905: ,lv_user_entity_name;
906:
907: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '

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

903: fetch pay_us_payroll_utils.c_get_defined_balance_id
904: into ln_defined_balance_id
905: ,lv_user_entity_name;
906:
907: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
908: ||lv_balance_name);
909:
910: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
911: exit;

Line 910: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then

906:
907: hr_utility.trace('Fetched pay_us_payroll_utils.c_get_defined_balance_id '
908: ||lv_balance_name);
909:
910: if pay_us_payroll_utils.c_get_defined_balance_id%NOTFOUND then
911: exit;
912: end if;
913:
914: l_step := 21.1;

Line 940: close pay_us_payroll_utils.c_get_defined_balance_id;

936:
937: -- pay_us_archive.ltr_1099_bal(ln_count).balance_name := lv_balance_name ;
938: pay_us_archive.ltr_1099_bal(ln_count).defined_balance := ln_defined_balance_id ;
939: pay_us_archive.ltr_1099_bal(ln_count).user_entity_id := ln_arch_user_entity_id ;
940: close pay_us_payroll_utils.c_get_defined_balance_id;
941:
942: end loop;
943: hr_utility.trace('Closed cursor');
944:

Line 1094: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,

1090: exit;
1091: end if;
1092:
1093: l_step := 15;
1094: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1095: lv_balance_dimension,
1096: p_business_group_id);
1097:
1098: fetch pay_us_payroll_utils.c_get_defined_balance_id

Line 1098: fetch pay_us_payroll_utils.c_get_defined_balance_id

1094: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1095: lv_balance_dimension,
1096: p_business_group_id);
1097:
1098: fetch pay_us_payroll_utils.c_get_defined_balance_id
1099: into ln_defined_balance_id,
1100: lv_user_entity_name;
1101:
1102: lv_arch_user_entity_name := 'A_'||lv_user_entity_name;

Line 1106: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then

1102: lv_arch_user_entity_name := 'A_'||lv_user_entity_name;
1103:
1104: hr_utility.trace('lv_arch_user_entity_name = '||lv_arch_user_entity_name);
1105:
1106: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then
1107:
1108: hr_utility.trace('Into found loop of Box 12 ');
1109: hr_utility.trace('ln_defined_balance_id = '||to_char(ln_defined_balance_id));
1110:

Line 1135: close pay_us_payroll_utils.c_get_defined_balance_id;

1131: pay_us_archive.ltr_pre_tax_bal(ln_count).defined_balance := ln_defined_balance_id ;
1132: pay_us_archive.ltr_pre_tax_bal(ln_count).user_entity_id := ln_arch_user_entity_id ;
1133:
1134: end if;
1135: close pay_us_payroll_utils.c_get_defined_balance_id;
1136:
1137: end loop;
1138: close c_balance;
1139:

Line 1232: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,

1228: exit;
1229: end if;
1230:
1231: l_step := 2;
1232: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1233: '_PER_JD_GRE_YTD',
1234: p_business_group_id);
1235:
1236: fetch pay_us_payroll_utils.c_get_defined_balance_id

Line 1236: fetch pay_us_payroll_utils.c_get_defined_balance_id

1232: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1233: '_PER_JD_GRE_YTD',
1234: p_business_group_id);
1235:
1236: fetch pay_us_payroll_utils.c_get_defined_balance_id
1237: into ln_defined_balance_id,
1238: lv_user_entity_name;
1239:
1240: lv_arch_user_entity_name := 'A_'||lv_user_entity_name;

Line 1247: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then

1243: hr_utility.trace('lv_balance_name = '||lv_balance_name);
1244: hr_utility.trace('lv_balance_dimension = '||lv_balance_dimension);
1245: hr_utility.trace('p_business_group_id = '||p_business_group_id);
1246:
1247: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then
1248:
1249: hr_utility.trace('Into found loop of PSD balances ');
1250: hr_utility.trace('ln_defined_balance_id = '||to_char(ln_defined_balance_id));
1251:

Line 1276: close pay_us_payroll_utils.c_get_defined_balance_id;

1272: pay_us_archive.ltr_psd_tax_bal(psd_count).defined_balance := ln_defined_balance_id ;
1273: pay_us_archive.ltr_psd_tax_bal(psd_count).user_entity_id := ln_arch_user_entity_id ;
1274:
1275: end if;
1276: close pay_us_payroll_utils.c_get_defined_balance_id;
1277:
1278: end loop;
1279: close c_get_psd_balance;
1280:

Line 1356: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,

1352: fetch c_balance into lv_balance_name ;
1353: hr_utility.trace('Fetched c_balance '||lv_balance_name);
1354: exit when c_balance%notfound;
1355: l_step := 2;
1356: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1357: lv_balance_dimension,
1358: p_business_group_id);
1359:
1360: fetch pay_us_payroll_utils.c_get_defined_balance_id

Line 1360: fetch pay_us_payroll_utils.c_get_defined_balance_id

1356: open pay_us_payroll_utils.c_get_defined_balance_id(lv_balance_name,
1357: lv_balance_dimension,
1358: p_business_group_id);
1359:
1360: fetch pay_us_payroll_utils.c_get_defined_balance_id
1361: into ln_defined_balance_id,
1362: lv_user_entity_name;
1363:
1364: lv_arch_user_entity_name := 'A_'||lv_user_entity_name;

Line 1368: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then

1364: lv_arch_user_entity_name := 'A_'||lv_user_entity_name;
1365:
1366: hr_utility.trace('lv_arch_user_entity_name = '||lv_arch_user_entity_name);
1367:
1368: if pay_us_payroll_utils.c_get_defined_balance_id%FOUND then
1369:
1370: hr_utility.trace('Into found loop of Box 12 ');
1371: hr_utility.trace('ln_defined_balance_id = '||to_char(ln_defined_balance_id));
1372:

Line 1397: close pay_us_payroll_utils.c_get_defined_balance_id;

1393: pay_us_archive.ltr_w2_box_bal(ln_count).defined_balance := ln_defined_balance_id ;
1394: pay_us_archive.ltr_w2_box_bal(ln_count).user_entity_id := ln_arch_user_entity_id ;
1395:
1396: end if;
1397: close pay_us_payroll_utils.c_get_defined_balance_id;
1398:
1399: end loop;
1400: close c_balance;
1401:

Line 5205: open pay_us_payroll_utils.c_get_defined_balance_id('PSD Withheld',

5201: --check if PSD Withheld balances are <>0
5202:
5203: l_psd_user_entity_id:= get_user_entity_id('PSD_WITHHELD_PER_JD_GRE_YTD');
5204:
5205: open pay_us_payroll_utils.c_get_defined_balance_id('PSD Withheld',
5206: '_PER_JD_GRE_YTD',
5207: ln_business_group_id);
5208:
5209: fetch pay_us_payroll_utils.c_get_defined_balance_id

Line 5209: fetch pay_us_payroll_utils.c_get_defined_balance_id

5205: open pay_us_payroll_utils.c_get_defined_balance_id('PSD Withheld',
5206: '_PER_JD_GRE_YTD',
5207: ln_business_group_id);
5208:
5209: fetch pay_us_payroll_utils.c_get_defined_balance_id
5210: into l_psd_def_bal_id,
5211: lv_user_entity_name;
5212: close pay_us_payroll_utils.c_get_defined_balance_id;
5213:

Line 5212: close pay_us_payroll_utils.c_get_defined_balance_id;

5208:
5209: fetch pay_us_payroll_utils.c_get_defined_balance_id
5210: into l_psd_def_bal_id,
5211: lv_user_entity_name;
5212: close pay_us_payroll_utils.c_get_defined_balance_id;
5213:
5214: l_psd_balance_value := fnd_number.number_to_canonical(
5215: nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_psd_def_bal_id
5216: ,p_assignment_action_id => l_aaid),0));