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.HR_US_W2_REP dependencies on HR_US_W2_REP

Line 1: PACKAGE body hr_us_w2_rep AS

1: PACKAGE body hr_us_w2_rep AS
2: /* $Header: pyusw2pg.pkb 120.2.12010000.4 2008/08/06 08:43:31 ubhat ship $ */
3:
4: /*
5: +=====================================================================+

Line 159: l_jd_context_id := hr_us_w2_rep.get_context_id('JURISDICTION_CODE');

155:
156: --dbms_output.put_line('inside get_w2_bal_amt');
157:
158: l_user_entity_id := get_user_entity_id(w2_balance_name);
159: l_jd_context_id := hr_us_w2_rep.get_context_id('JURISDICTION_CODE');
160: l_tax_context_id := hr_us_w2_rep.get_context_id('TAX_UNIT_ID');
161:
162:
163: if w2_tax_unit_id is not null then

Line 160: l_tax_context_id := hr_us_w2_rep.get_context_id('TAX_UNIT_ID');

156: --dbms_output.put_line('inside get_w2_bal_amt');
157:
158: l_user_entity_id := get_user_entity_id(w2_balance_name);
159: l_jd_context_id := hr_us_w2_rep.get_context_id('JURISDICTION_CODE');
160: l_tax_context_id := hr_us_w2_rep.get_context_id('TAX_UNIT_ID');
161:
162:
163: if w2_tax_unit_id is not null then
164: if w2_jurisdiction_code <> '00-000-0000' then

Line 349: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

345: g_user_name(5) := 'A_FIT_NON_W2_PRE_TAX_DEDNS_PER_GRE_YTD';
346: g_user_name(6) := 'A_PRE_TAX_DEDUCTIONS_PER_GRE_YTD';
347:
348: for i in 1..6 loop
349: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
350: g_user_name(i),
351: to_char(w2_tax_unit_id),
352: '00-000-0000',
353: w2_jurisdiction_level);

Line 376: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

372: g_user_name(2) := 'A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD';
373: g_user_name(3) := 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD';
374:
375: for i in 1..3 loop
376: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
377: g_user_name(i),
378: to_char(w2_tax_unit_id),
379: w2_jurisdiction_code,
380: w2_jurisdiction_level);

Line 406: bal_amt := hr_us_w2_rep.get_w2_arch_bal(

402: if substr(w2_jurisdictioN_code,1,2) = '33' then -- NY testing
403:
404: if get_ny_fed_state_wage_match(w2_tax_unit_id) = 'Y' THEN
405: if bal_amt <> 0 then
406: bal_amt := hr_us_w2_rep.get_w2_arch_bal(
407: w2_asg_act_id,
408: 'A_WAGES',
409: w2_tax_unit_id,
410: '00-000-0000',0);

Line 424: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

420: g_user_name(2) := 'A_CITY_SUBJ_NWHABLE_PER_JD_GRE_YTD';
421: g_user_name(3) := 'A_CITY_PRE_TAX_REDNS_PER_JD_GRE_YTD';
422:
423: for i in 1..3 loop
424: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
425: g_user_name(i),
426: to_char(w2_tax_unit_id),
427: w2_jurisdiction_code,
428: w2_jurisdiction_level);

Line 452: l_city_tax_withheld := hr_us_w2_rep.get_w2_arch_bal(

448: --
449: if w2_jurisdiction_code = '33-119-3230' then
450: -- When City jurisdiction is Yonkers derive city tax withheld
451: --
452: l_city_tax_withheld := hr_us_w2_rep.get_w2_arch_bal(
453: w2_asg_act_id,
454: 'A_CITY_WITHHELD_PER_JD_GRE_YTD' ,
455: to_char(w2_tax_unit_id),
456: w2_jurisdiction_code,

Line 463: bal_amt := hr_us_w2_rep.get_w2_arch_bal(

459: -- Fed wages and assign to City Wages
460: --
461: if get_ny_fed_state_wage_match(w2_tax_unit_id) = 'Y' then
462: if l_city_tax_withheld > 0 then
463: bal_amt := hr_us_w2_rep.get_w2_arch_bal(
464: w2_asg_act_id,
465: 'A_WAGES',
466: w2_tax_unit_id,
467: '00-000-0000',0);

Line 508: l_withheld := hr_us_w2_rep.get_w2_bal_amt(

504: for j in 1..l_count loop
505:
506: for i in 1..3 loop
507:
508: l_withheld := hr_us_w2_rep.get_w2_bal_amt(
509: w2_asg_act_id,
510: 'A_CITY_WITHHELD_PER_JD_GRE_YTD',
511: to_char(w2_tax_unit_id),
512: l_jursd_tbl(j),

Line 517: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(

513: w2_jurisdiction_level);
514: if l_withheld <= 0 then
515: g_element_value(i) := 0;
516: else
517: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(
518: w2_asg_act_id,
519: g_user_name(i),
520: to_char(w2_tax_unit_id),
521: l_jursd_tbl(j),

Line 546: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

542: g_user_name(2) := 'A_COUNTY_SUBJ_NWHABLE_PER_JD_GRE_YTD';
543: g_user_name(3) := 'A_COUNTY_PRE_TAX_REDNS_PER_JD_GRE_YTD';
544:
545: for i in 1..3 loop
546: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
547: g_user_name(i),
548: to_char(w2_tax_unit_id),
549: w2_jurisdiction_code,
550: w2_jurisdiction_level);

Line 573: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

569: g_user_name(2) := 'A_SCHOOL_SUBJ_NWHABLE_PER_JD_GRE_YTD';
570: g_user_name(3) := 'A_SCHOOL_PRE_TAX_REDNS_PER_JD_GRE_YTD';
571:
572: for i in 1..3 loop
573: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
574: g_user_name(i),
575: to_char(w2_tax_unit_id),
576: w2_jurisdiction_code,
577: w2_jurisdiction_level);

Line 597: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

593: elsif w2_balance_name = 'A_W2_GROSS_1099R' then
594:
595: g_user_name(1) := 'A_GROSS_EARNINGS_PER_GRE_YTD';
596:
597: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
598: g_user_name(1),
599: to_char(w2_tax_unit_id),
600: '00-000-0000',
601: w2_jurisdiction_level);

Line 632: l_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

628: bal_amt := 0;
629:
630: for j in 1..l_count loop
631:
632: l_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
633: 'A_CITY_WITHHELD_PER_JD_GRE_YTD',
634: to_char(w2_tax_unit_id),
635: l_jursd_tbl(j),
636: w2_jurisdiction_level);

Line 646: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

642: -- This is to Fix the Social Security Wages Bug 2287844
643: --
644: elsif w2_balance_name = 'A_SS_EE_TAXABLE_PER_GRE_YTD' then
645: bal_amt := /* Social Security Wages */
646: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
647: w2_balance_name,
648: to_char(w2_tax_unit_id),
649: w2_jurisdiction_code,
650: w2_jurisdiction_level)

Line 653: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

649: w2_jurisdiction_code,
650: w2_jurisdiction_level)
651: -
652: /* Social Security Tips - Box 7 */
653: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
654: 'A_W2_BOX_7_PER_GRE_YTD',
655: to_char(w2_tax_unit_id),
656: w2_jurisdiction_code,
657: w2_jurisdiction_level);

Line 660: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

656: w2_jurisdiction_code,
657: w2_jurisdiction_level);
658:
659: elsif w2_balance_name = 'A_W2_401K_PER_GRE_YTD' then
660: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
661: w2_balance_name,
662: to_char(w2_tax_unit_id),
663: w2_jurisdiction_code,
664: w2_jurisdiction_level)

Line 672: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

668: w2_jurisdiction_code ,
669: w2_jurisdiction_level ,
670: '401K');
671: elsif w2_balance_name = 'A_W2_403B_PER_GRE_YTD' then
672: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
673: w2_balance_name,
674: to_char(w2_tax_unit_id),
675: w2_jurisdiction_code,
676: w2_jurisdiction_level)

Line 684: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

680: w2_jurisdiction_code ,
681: w2_jurisdiction_level ,
682: '403B');
683: elsif w2_balance_name = 'A_W2_457_PER_GRE_YTD' then
684: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
685: w2_balance_name,
686: to_char(w2_tax_unit_id),
687: w2_jurisdiction_code,
688: w2_jurisdiction_level)

Line 701: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

697: -- For all other Archived Balance not conditionally computed
698: -- above is derived with the following
699:
700: else
701: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
702: w2_balance_name,
703: to_char(w2_tax_unit_id),
704: w2_jurisdiction_code,
705: w2_jurisdiction_level);

Line 889: return(hr_us_w2_rep.get_w2_box_15 (w2_asg_act_id,

885: w2_jurisdiction_level number
886: ) RETURN VARCHAR2 is
887: BEGIN
888:
889: return(hr_us_w2_rep.get_w2_box_15 (w2_asg_act_id,
890: w2_balance_name,
891: w2_tax_unit_id,
892: w2_jurisdiction_code,
893: w2_jurisdiction_level,

Line 920: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

916:
917: if w2_balance_name = 'A_W2_PENSION_PLAN_PER_GRE_YTD' then
918: -- Changed for EOY 2000
919: if w2_effective_date is null then
920: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
921: (w2_asg_act_id,
922: 'A_W2_BOX_13D_PER_GRE_YTD', /* EOY 2000 */
923: to_char(w2_tax_unit_id),
924: w2_jurisdiction_code,

Line 928: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

924: w2_jurisdiction_code,
925: w2_jurisdiction_level);
926:
927: if l_bal_amt <= 0 or l_bal_amt is null then
928: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
929: (w2_asg_act_id,
930: 'A_W2_BOX_13E_PER_GRE_YTD',
931: to_char(w2_tax_unit_id),
932: w2_jurisdiction_code,

Line 937: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

933: w2_jurisdiction_level);
934: end if;
935:
936: if l_bal_amt <= 0 or l_bal_amt is null then
937: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
938: (w2_asg_act_id,
939: w2_balance_name,
940: to_char(w2_tax_unit_id),
941: w2_jurisdiction_code,

Line 945: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

941: w2_jurisdiction_code,
942: w2_jurisdiction_level);
943: end if;
944: else
945: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
946: (w2_asg_act_id,
947: 'A_W2_401K_PER_GRE_YTD', /* EOY 2001 */
948: to_char(w2_tax_unit_id),
949: w2_jurisdiction_code,

Line 953: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

949: w2_jurisdiction_code,
950: w2_jurisdiction_level);
951:
952: if l_bal_amt <= 0 or l_bal_amt is null then
953: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
954: (w2_asg_act_id,
955: 'A_W2_403B_PER_GRE_YTD',
956: to_char(w2_tax_unit_id),
957: w2_jurisdiction_code,

Line 962: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

958: w2_jurisdiction_level);
959: end if;
960:
961: if l_bal_amt <= 0 or l_bal_amt is null then
962: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
963: (w2_asg_act_id,
964: 'A_W2_408K_PER_GRE_YTD',
965: to_char(w2_tax_unit_id),
966: w2_jurisdiction_code,

Line 971: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

967: w2_jurisdiction_level);
968: end if;
969:
970: if l_bal_amt <= 0 or l_bal_amt is null then
971: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
972: (w2_asg_act_id,
973: 'A_W2_501C_PER_GRE_YTD',
974: to_char(w2_tax_unit_id),
975: w2_jurisdiction_code,

Line 980: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

976: w2_jurisdiction_level);
977: end if;
978:
979: if l_bal_amt <= 0 or l_bal_amt is null then
980: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
981: (w2_asg_act_id,
982: w2_balance_name,
983: to_char(w2_tax_unit_id),
984: w2_jurisdiction_code,

Line 989: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

985: w2_jurisdiction_level);
986: end if;
987:
988: if l_bal_amt <= 0 or l_bal_amt is null then /* 5748431 */
989: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
990: (w2_asg_act_id,
991: 'A_W2_ROTH_403B_PER_GRE_YTD',
992: to_char(w2_tax_unit_id),
993: w2_jurisdiction_code,

Line 1000: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

996:
997:
998:
999: if l_bal_amt <= 0 or l_bal_amt is null then /* 5748431 */
1000: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1001: (w2_asg_act_id,
1002: 'A_W2_ROTH_401K_PER_GRE_YTD',
1003: to_char(w2_tax_unit_id),
1004: w2_jurisdiction_code,

Line 1011: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1007:
1008: end if;
1009: elsif w2_balance_name = 'A_DEF_COMP_401K_PER_GRE_YTD' then
1010: if w2_effective_date is null then
1011: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1012: (w2_asg_act_id,
1013: 'A_W2_BOX_13D_PER_GRE_YTD', /* EOY 2000 */
1014: to_char(w2_tax_unit_id),
1015: w2_jurisdiction_code,

Line 1018: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1014: to_char(w2_tax_unit_id),
1015: w2_jurisdiction_code,
1016: w2_jurisdiction_level);
1017: if l_bal_amt <= 0 or l_bal_amt is null then
1018: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1019: (w2_asg_act_id,
1020: 'A_W2_BOX_13E_PER_GRE_YTD',
1021: to_char(w2_tax_unit_id),
1022: w2_jurisdiction_code,

Line 1026: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1022: w2_jurisdiction_code,
1023: w2_jurisdiction_level);
1024: end if;
1025: if l_bal_amt <= 0 or l_bal_amt is null then
1026: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1027: (w2_asg_act_id,
1028: 'A_W2_BOX_13G_PER_GRE_YTD',
1029: to_char(w2_tax_unit_id),
1030: w2_jurisdiction_code,

Line 1034: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1030: w2_jurisdiction_code,
1031: w2_jurisdiction_level);
1032: end if;
1033: if l_bal_amt <= 0 or l_bal_amt is null then
1034: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1035: (w2_asg_act_id,
1036: w2_balance_name,
1037: to_char(w2_tax_unit_id),
1038: w2_jurisdiction_code,

Line 1042: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1038: w2_jurisdiction_code,
1039: w2_jurisdiction_level);
1040: end if;
1041: else
1042: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1043: (w2_asg_act_id,
1044: 'A_W2_401K_PER_GRE_YTD', /* EOY 2001 */
1045: to_char(w2_tax_unit_id),
1046: w2_jurisdiction_code,

Line 1049: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1045: to_char(w2_tax_unit_id),
1046: w2_jurisdiction_code,
1047: w2_jurisdiction_level);
1048: if l_bal_amt <= 0 or l_bal_amt is null then
1049: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1050: (w2_asg_act_id,
1051: 'A_W2_403B_PER_GRE_YTD',
1052: to_char(w2_tax_unit_id),
1053: w2_jurisdiction_code,

Line 1057: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1053: w2_jurisdiction_code,
1054: w2_jurisdiction_level);
1055: end if;
1056: if l_bal_amt <= 0 or l_bal_amt is null then
1057: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1058: (w2_asg_act_id,
1059: 'A_W2_457_PER_GRE_YTD',
1060: to_char(w2_tax_unit_id),
1061: w2_jurisdiction_code,

Line 1065: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1061: w2_jurisdiction_code,
1062: w2_jurisdiction_level);
1063: end if;
1064: if l_bal_amt <= 0 or l_bal_amt is null then
1065: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1066: (w2_asg_act_id,
1067: w2_balance_name,
1068: to_char(w2_tax_unit_id),
1069: w2_jurisdiction_code,

Line 1076: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1072:
1073: end if;
1074: elsif w2_balance_name = 'A_W2_TP_SICK_PAY_PER_GRE_YTD' then
1075: /* For Sick Pay Indicator, will use only this balance */
1076: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1077: (w2_asg_act_id,
1078: w2_balance_name,
1079: to_char(w2_tax_unit_id),
1080: w2_jurisdiction_code,

Line 1524: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

1520: for userra_db_items IN c_userra_db_items(p_userra_code)
1521: loop
1522: l_balance_name :=userra_db_items.user_name;
1523:
1524: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
1525: l_balance_name,
1526: w2_tax_unit_id,
1527: w2_jurisdiction_code,
1528: w2_jurisdiction_level);

Line 1563: if hr_us_w2_rep.ltr_box17.exists(p_tax_unit_id) then

1559: return ('SDI');
1560:
1561: else
1562:
1563: if hr_us_w2_rep.ltr_box17.exists(p_tax_unit_id) then
1564:
1565: hr_utility.trace('Value exists ');
1566: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1567:

Line 1566: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;

1562:
1563: if hr_us_w2_rep.ltr_box17.exists(p_tax_unit_id) then
1564:
1565: hr_utility.trace('Value exists ');
1566: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1567:
1568: else
1569:
1570: hr_utility.trace('Value does not exists ');

Line 1579: hr_us_w2_rep.ltr_box17(p_tax_unit_id).state_abbrev := p_state_abbrev;

1575: end if;
1576: close c_get_value_gre;
1577:
1578: hr_utility.trace('SQL Value is : '|| l_box17_label);
1579: hr_us_w2_rep.ltr_box17(p_tax_unit_id).state_abbrev := p_state_abbrev;
1580: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1581:
1582: end if;
1583:

Line 1580: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;

1576: close c_get_value_gre;
1577:
1578: hr_utility.trace('SQL Value is : '|| l_box17_label);
1579: hr_us_w2_rep.ltr_box17(p_tax_unit_id).state_abbrev := p_state_abbrev;
1580: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1581:
1582: end if;
1583:
1584: hr_utility.trace('Return Value is : '|| l_box17_label);

Line 1685: end hr_us_w2_rep;

1681: return(' ');
1682: END;
1683:
1684:
1685: end hr_us_w2_rep;