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.9.12020000.3 2012/11/01 17:28:24 emunisek ship $ */
3:
4: /*
5: +=====================================================================+

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

161:
162: --dbms_output.put_line('inside get_w2_bal_amt');
163:
164: l_user_entity_id := get_user_entity_id(w2_balance_name);
165: l_jd_context_id := hr_us_w2_rep.get_context_id('JURISDICTION_CODE');
166: l_tax_context_id := hr_us_w2_rep.get_context_id('TAX_UNIT_ID');
167:
168:
169: if w2_tax_unit_id is not null then

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

162: --dbms_output.put_line('inside get_w2_bal_amt');
163:
164: l_user_entity_id := get_user_entity_id(w2_balance_name);
165: l_jd_context_id := hr_us_w2_rep.get_context_id('JURISDICTION_CODE');
166: l_tax_context_id := hr_us_w2_rep.get_context_id('TAX_UNIT_ID');
167:
168:
169: if w2_tax_unit_id is not null then
170: if w2_jurisdiction_code <> '00-000-0000' then

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

408: g_user_name(2) := 'A_FIT_SUBJ_NWHABLE_PER_GRE_YTD';
409: g_user_name(3) := 'A_FIT_PRE_TAX_REDNS_PER_GRE_YTD';
410:
411: for i in 1..3 loop
412: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
413: g_user_name(i),
414: to_char(w2_tax_unit_id),
415: '00-000-0000',
416: w2_jurisdiction_level);

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

438: g_user_name(5) := 'A_FIT_NON_W2_PRE_TAX_DEDNS_PER_GRE_YTD';
439: g_user_name(6) := 'A_PRE_TAX_DEDUCTIONS_PER_GRE_YTD';
440:
441: for i in 1..6 loop
442: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
443: g_user_name(i),
444: to_char(w2_tax_unit_id),
445: '00-000-0000',
446: w2_jurisdiction_level);

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

467: g_user_name(2) := 'A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD';
468: g_user_name(3) := 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD';
469:
470: for i in 1..3 loop
471: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
472: g_user_name(i),
473: to_char(w2_tax_unit_id),
474: w2_jurisdiction_code,
475: w2_jurisdiction_level);

Line 501: bal_amt := hr_us_w2_rep.get_w2_arch_bal(

497: if substr(w2_jurisdictioN_code,1,2) = '33' then -- NY testing
498:
499: if get_ny_fed_state_wage_match(w2_tax_unit_id) = 'Y' THEN
500: if bal_amt <> 0 then
501: bal_amt := hr_us_w2_rep.get_w2_arch_bal(
502: w2_asg_act_id,
503: 'A_WAGES',
504: w2_tax_unit_id,
505: '00-000-0000',0);

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

515: g_user_name(2) := 'A_CITY_SUBJ_NWHABLE_PER_JD_GRE_YTD';
516: g_user_name(3) := 'A_CITY_PRE_TAX_REDNS_PER_JD_GRE_YTD';
517:
518: for i in 1..3 loop
519: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
520: g_user_name(i),
521: to_char(w2_tax_unit_id),
522: w2_jurisdiction_code,
523: w2_jurisdiction_level);

Line 547: l_city_tax_withheld := hr_us_w2_rep.get_w2_arch_bal(

543: --
544: if w2_jurisdiction_code = '33-119-3230' then
545: -- When City jurisdiction is Yonkers derive city tax withheld
546: --
547: l_city_tax_withheld := hr_us_w2_rep.get_w2_arch_bal(
548: w2_asg_act_id,
549: 'A_CITY_WITHHELD_PER_JD_GRE_YTD' ,
550: to_char(w2_tax_unit_id),
551: w2_jurisdiction_code,

Line 558: bal_amt := hr_us_w2_rep.get_w2_arch_bal(

554: -- Fed wages and assign to City Wages
555: --
556: if get_ny_fed_state_wage_match(w2_tax_unit_id) = 'Y' then
557: if l_city_tax_withheld > 0 then
558: bal_amt := hr_us_w2_rep.get_w2_arch_bal(
559: w2_asg_act_id,
560: 'A_WAGES',
561: w2_tax_unit_id,
562: '00-000-0000',0);

Line 603: l_withheld := hr_us_w2_rep.get_w2_bal_amt(

599: for j in 1..l_count loop
600:
601: for i in 1..3 loop
602:
603: l_withheld := hr_us_w2_rep.get_w2_bal_amt(
604: w2_asg_act_id,
605: 'A_CITY_WITHHELD_PER_JD_GRE_YTD',
606: to_char(w2_tax_unit_id),
607: l_jursd_tbl(j),

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

608: w2_jurisdiction_level);
609: if l_withheld <= 0 then
610: g_element_value(i) := 0;
611: else
612: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(
613: w2_asg_act_id,
614: g_user_name(i),
615: to_char(w2_tax_unit_id),
616: l_jursd_tbl(j),

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

637: g_user_name(2) := 'A_COUNTY_SUBJ_NWHABLE_PER_JD_GRE_YTD';
638: g_user_name(3) := 'A_COUNTY_PRE_TAX_REDNS_PER_JD_GRE_YTD';
639:
640: for i in 1..3 loop
641: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
642: g_user_name(i),
643: to_char(w2_tax_unit_id),
644: w2_jurisdiction_code,
645: w2_jurisdiction_level);

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

664: g_user_name(2) := 'A_SCHOOL_SUBJ_NWHABLE_PER_JD_GRE_YTD';
665: g_user_name(3) := 'A_SCHOOL_PRE_TAX_REDNS_PER_JD_GRE_YTD';
666:
667: for i in 1..3 loop
668: g_element_value(i) := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
669: g_user_name(i),
670: to_char(w2_tax_unit_id),
671: w2_jurisdiction_code,
672: w2_jurisdiction_level);

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

688: elsif w2_balance_name = 'A_W2_GROSS_1099R' then
689:
690: g_user_name(1) := 'A_GROSS_EARNINGS_PER_GRE_YTD';
691:
692: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
693: g_user_name(1),
694: to_char(w2_tax_unit_id),
695: '00-000-0000',
696: w2_jurisdiction_level);

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

723: bal_amt := 0;
724:
725: for j in 1..l_count loop
726:
727: l_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
728: 'A_CITY_WITHHELD_PER_JD_GRE_YTD',
729: to_char(w2_tax_unit_id),
730: l_jursd_tbl(j),
731: w2_jurisdiction_level);

Line 741: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

737: -- This is to Fix the Social Security Wages Bug 2287844
738: --
739: elsif w2_balance_name = 'A_SS_EE_TAXABLE_PER_GRE_YTD' then
740: bal_amt := /* Social Security Wages */
741: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
742: w2_balance_name,
743: to_char(w2_tax_unit_id),
744: w2_jurisdiction_code,
745: w2_jurisdiction_level)

Line 748: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,

744: w2_jurisdiction_code,
745: w2_jurisdiction_level)
746: -
747: /* Social Security Tips - Box 7 */
748: hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
749: 'A_W2_BOX_7_PER_GRE_YTD',
750: to_char(w2_tax_unit_id),
751: w2_jurisdiction_code,
752: w2_jurisdiction_level);

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

751: w2_jurisdiction_code,
752: w2_jurisdiction_level);
753:
754: elsif w2_balance_name = 'A_W2_401K_PER_GRE_YTD' then
755: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
756: w2_balance_name,
757: to_char(w2_tax_unit_id),
758: w2_jurisdiction_code,
759: w2_jurisdiction_level)

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

763: w2_jurisdiction_code ,
764: w2_jurisdiction_level ,
765: '401K');
766: elsif w2_balance_name = 'A_W2_403B_PER_GRE_YTD' then
767: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
768: w2_balance_name,
769: to_char(w2_tax_unit_id),
770: w2_jurisdiction_code,
771: w2_jurisdiction_level)

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

775: w2_jurisdiction_code ,
776: w2_jurisdiction_level ,
777: '403B');
778: elsif w2_balance_name = 'A_W2_457_PER_GRE_YTD' then
779: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
780: w2_balance_name,
781: to_char(w2_tax_unit_id),
782: w2_jurisdiction_code,
783: w2_jurisdiction_level)

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

792: -- For all other Archived Balance not conditionally computed
793: -- above is derived with the following
794:
795: else
796: bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
797: w2_balance_name,
798: to_char(w2_tax_unit_id),
799: w2_jurisdiction_code,
800: w2_jurisdiction_level);

Line 1004: return(hr_us_w2_rep.get_w2_box_15 (w2_asg_act_id,

1000: w2_jurisdiction_level number
1001: ) RETURN VARCHAR2 is
1002: BEGIN
1003:
1004: return(hr_us_w2_rep.get_w2_box_15 (w2_asg_act_id,
1005: w2_balance_name,
1006: w2_tax_unit_id,
1007: w2_jurisdiction_code,
1008: w2_jurisdiction_level,

Line 1035: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1031:
1032: if w2_balance_name = 'A_W2_PENSION_PLAN_PER_GRE_YTD' then
1033: -- Changed for EOY 2000
1034: if w2_effective_date is null then
1035: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1036: (w2_asg_act_id,
1037: 'A_W2_BOX_13D_PER_GRE_YTD', /* EOY 2000 */
1038: to_char(w2_tax_unit_id),
1039: w2_jurisdiction_code,

Line 1043: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1039: w2_jurisdiction_code,
1040: w2_jurisdiction_level);
1041:
1042: if l_bal_amt <= 0 or l_bal_amt is null then
1043: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1044: (w2_asg_act_id,
1045: 'A_W2_BOX_13E_PER_GRE_YTD',
1046: to_char(w2_tax_unit_id),
1047: w2_jurisdiction_code,

Line 1052: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1048: w2_jurisdiction_level);
1049: end if;
1050:
1051: if l_bal_amt <= 0 or l_bal_amt is null then
1052: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1053: (w2_asg_act_id,
1054: w2_balance_name,
1055: to_char(w2_tax_unit_id),
1056: w2_jurisdiction_code,

Line 1060: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1056: w2_jurisdiction_code,
1057: w2_jurisdiction_level);
1058: end if;
1059: else
1060: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1061: (w2_asg_act_id,
1062: 'A_W2_401K_PER_GRE_YTD', /* EOY 2001 */
1063: to_char(w2_tax_unit_id),
1064: w2_jurisdiction_code,

Line 1068: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1064: w2_jurisdiction_code,
1065: w2_jurisdiction_level);
1066:
1067: if l_bal_amt <= 0 or l_bal_amt is null then
1068: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1069: (w2_asg_act_id,
1070: 'A_W2_403B_PER_GRE_YTD',
1071: to_char(w2_tax_unit_id),
1072: w2_jurisdiction_code,

Line 1077: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1073: w2_jurisdiction_level);
1074: end if;
1075:
1076: if l_bal_amt <= 0 or l_bal_amt is null then
1077: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1078: (w2_asg_act_id,
1079: 'A_W2_408K_PER_GRE_YTD',
1080: to_char(w2_tax_unit_id),
1081: w2_jurisdiction_code,

Line 1086: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1082: w2_jurisdiction_level);
1083: end if;
1084:
1085: if l_bal_amt <= 0 or l_bal_amt is null then
1086: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1087: (w2_asg_act_id,
1088: 'A_W2_501C_PER_GRE_YTD',
1089: to_char(w2_tax_unit_id),
1090: w2_jurisdiction_code,

Line 1095: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1091: w2_jurisdiction_level);
1092: end if;
1093:
1094: if l_bal_amt <= 0 or l_bal_amt is null then
1095: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1096: (w2_asg_act_id,
1097: w2_balance_name,
1098: to_char(w2_tax_unit_id),
1099: w2_jurisdiction_code,

Line 1104: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1100: w2_jurisdiction_level);
1101: end if;
1102:
1103: if l_bal_amt <= 0 or l_bal_amt is null then /* 5748431 */
1104: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1105: (w2_asg_act_id,
1106: 'A_W2_ROTH_403B_PER_GRE_YTD',
1107: to_char(w2_tax_unit_id),
1108: w2_jurisdiction_code,

Line 1115: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1111:
1112:
1113:
1114: if l_bal_amt <= 0 or l_bal_amt is null then /* 5748431 */
1115: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1116: (w2_asg_act_id,
1117: 'A_W2_ROTH_401K_PER_GRE_YTD',
1118: to_char(w2_tax_unit_id),
1119: w2_jurisdiction_code,

Line 1126: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1122:
1123: end if;
1124: elsif w2_balance_name = 'A_DEF_COMP_401K_PER_GRE_YTD' then
1125: if w2_effective_date is null then
1126: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1127: (w2_asg_act_id,
1128: 'A_W2_BOX_13D_PER_GRE_YTD', /* EOY 2000 */
1129: to_char(w2_tax_unit_id),
1130: w2_jurisdiction_code,

Line 1133: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1129: to_char(w2_tax_unit_id),
1130: w2_jurisdiction_code,
1131: w2_jurisdiction_level);
1132: if l_bal_amt <= 0 or l_bal_amt is null then
1133: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1134: (w2_asg_act_id,
1135: 'A_W2_BOX_13E_PER_GRE_YTD',
1136: to_char(w2_tax_unit_id),
1137: w2_jurisdiction_code,

Line 1141: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1137: w2_jurisdiction_code,
1138: w2_jurisdiction_level);
1139: end if;
1140: if l_bal_amt <= 0 or l_bal_amt is null then
1141: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1142: (w2_asg_act_id,
1143: 'A_W2_BOX_13G_PER_GRE_YTD',
1144: to_char(w2_tax_unit_id),
1145: w2_jurisdiction_code,

Line 1149: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1145: w2_jurisdiction_code,
1146: w2_jurisdiction_level);
1147: end if;
1148: if l_bal_amt <= 0 or l_bal_amt is null then
1149: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1150: (w2_asg_act_id,
1151: w2_balance_name,
1152: to_char(w2_tax_unit_id),
1153: w2_jurisdiction_code,

Line 1157: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1153: w2_jurisdiction_code,
1154: w2_jurisdiction_level);
1155: end if;
1156: else
1157: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1158: (w2_asg_act_id,
1159: 'A_W2_401K_PER_GRE_YTD', /* EOY 2001 */
1160: to_char(w2_tax_unit_id),
1161: w2_jurisdiction_code,

Line 1164: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1160: to_char(w2_tax_unit_id),
1161: w2_jurisdiction_code,
1162: w2_jurisdiction_level);
1163: if l_bal_amt <= 0 or l_bal_amt is null then
1164: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1165: (w2_asg_act_id,
1166: 'A_W2_403B_PER_GRE_YTD',
1167: to_char(w2_tax_unit_id),
1168: w2_jurisdiction_code,

Line 1172: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1168: w2_jurisdiction_code,
1169: w2_jurisdiction_level);
1170: end if;
1171: if l_bal_amt <= 0 or l_bal_amt is null then
1172: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1173: (w2_asg_act_id,
1174: 'A_W2_457_PER_GRE_YTD',
1175: to_char(w2_tax_unit_id),
1176: w2_jurisdiction_code,

Line 1180: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1176: w2_jurisdiction_code,
1177: w2_jurisdiction_level);
1178: end if;
1179: if l_bal_amt <= 0 or l_bal_amt is null then
1180: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1181: (w2_asg_act_id,
1182: w2_balance_name,
1183: to_char(w2_tax_unit_id),
1184: w2_jurisdiction_code,

Line 1191: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt

1187:
1188: end if;
1189: elsif w2_balance_name = 'A_W2_TP_SICK_PAY_PER_GRE_YTD' then
1190: /* For Sick Pay Indicator, will use only this balance */
1191: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt
1192: (w2_asg_act_id,
1193: w2_balance_name,
1194: to_char(w2_tax_unit_id),
1195: w2_jurisdiction_code,

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

1635: for userra_db_items IN c_userra_db_items(p_userra_code)
1636: loop
1637: l_balance_name :=userra_db_items.user_name;
1638:
1639: l_bal_amt := hr_us_w2_rep.get_w2_bal_amt(w2_asg_act_id,
1640: l_balance_name,
1641: w2_tax_unit_id,
1642: w2_jurisdiction_code,
1643: w2_jurisdiction_level);

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

1674: return ('SDI');
1675:
1676: else
1677:
1678: if hr_us_w2_rep.ltr_box17.exists(p_tax_unit_id) then
1679:
1680: hr_utility.trace('Value exists ');
1681: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1682:

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

1677:
1678: if hr_us_w2_rep.ltr_box17.exists(p_tax_unit_id) then
1679:
1680: hr_utility.trace('Value exists ');
1681: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1682:
1683: else
1684:
1685: hr_utility.trace('Value does not exists ');

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

1690: end if;
1691: close c_get_value_gre;
1692:
1693: hr_utility.trace('SQL Value is : '|| l_box17_label);
1694: hr_us_w2_rep.ltr_box17(p_tax_unit_id).state_abbrev := p_state_abbrev;
1695: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1696:
1697: end if;
1698:

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

1691: close c_get_value_gre;
1692:
1693: hr_utility.trace('SQL Value is : '|| l_box17_label);
1694: hr_us_w2_rep.ltr_box17(p_tax_unit_id).state_abbrev := p_state_abbrev;
1695: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1696:
1697: end if;
1698:
1699: hr_utility.trace('Return Value is : '|| l_box17_label);

Line 1800: end hr_us_w2_rep;

1796: return(' ');
1797: END;
1798:
1799:
1800: end hr_us_w2_rep;