APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on HR_US_W2_REP

Line 42: also to the function hr_us_w2_rep.get_w2_arch_bal and

38: State Code should be passed as two character long Code
39: to the cursor c_locality_jurisdiction
40: 04-Dec-08 kagangul 115.9 Bug No : 7592972
41: State Code should be passed as two character long Code
42: also to the function hr_us_w2_rep.get_w2_arch_bal and
43: hr_us_w2_rep.get_state_item
44: 23-Dec-08 kagangul 115.10 Bug No : 7637211
45: Added Tag EXCEPTION_DETAILS under EXCEPTION Tag at
46: EMPLOYEE level to provide more details on the exception

Line 43: hr_us_w2_rep.get_state_item

39: to the cursor c_locality_jurisdiction
40: 04-Dec-08 kagangul 115.9 Bug No : 7592972
41: State Code should be passed as two character long Code
42: also to the function hr_us_w2_rep.get_w2_arch_bal and
43: hr_us_w2_rep.get_state_item
44: 23-Dec-08 kagangul 115.10 Bug No : 7637211
45: Added Tag EXCEPTION_DETAILS under EXCEPTION Tag at
46: EMPLOYEE level to provide more details on the exception
47: for employees under EXCEPTION=FAILED

Line 365: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,

361:
362: if ltr_ue_name_table.count > 0 then
363: for j in ltr_ue_name_table.first .. ltr_ue_name_table.last
364: loop
365: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,
366: l_payroll_action_id,
367: ltr_ue_name_table(j).ue_name);
368: end loop;
369: end if;

Line 915: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,

911:
912: if ltr_ue_name_table.count > 0 then
913: for j in ltr_ue_name_table.first .. ltr_ue_name_table.last
914: loop
915: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,
916: l_payroll_action_id,
917: ltr_ue_name_table(j).ue_name);
918: end loop;
919: end if;

Line 2173: hr_us_w2_rep.get_per_item( p_ye_assignment_action_id,

2169: LOOP
2170: IF ltr_ue_name_table(j).ue_data_level = 'PER'
2171: THEN
2172: ltr_ue_name_table(j).ue_value :=
2173: hr_us_w2_rep.get_per_item( p_ye_assignment_action_id,
2174: ltr_ue_name_table(j).ue_name);
2175: ELSIF ltr_ue_name_table(J).ue_data_level ='FED' THEN
2176: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2177: p_ye_assignment_action_id

Line 2176: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(

2172: ltr_ue_name_table(j).ue_value :=
2173: hr_us_w2_rep.get_per_item( p_ye_assignment_action_id,
2174: ltr_ue_name_table(j).ue_name);
2175: ELSIF ltr_ue_name_table(J).ue_data_level ='FED' THEN
2176: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2177: p_ye_assignment_action_id
2178: ,ltr_ue_name_table(j).ue_name
2179: ,p_tax_unit_id
2180: ,'00-000-0000'

Line 2192: hr_us_w2_rep.get_w2_arch_bal(

2188: /* Bug 7637211 : End */
2189: END IF;
2190: ELSIF ltr_ue_name_table(J).ue_data_level ='STATE' THEN
2191: ltr_ue_name_table(j).ue_value :=
2192: hr_us_w2_rep.get_w2_arch_bal(
2193: p_ye_assignment_action_id
2194: ,ltr_ue_name_table(j).ue_name
2195: ,p_tax_unit_id
2196: /* Bug 7592972 : State Code should be passed as

Line 2211: hr_us_w2_rep.get_state_item(

2207: /* Bug 7637211 : End */
2208: END IF;
2209: ELSIF ltr_ue_name_table(J).ue_data_level ='GRE' THEN
2210: ltr_ue_name_table(j).ue_value :=
2211: hr_us_w2_rep.get_state_item(
2212: p_tax_unit_id,
2213: /* Bug 7592972 : State Code should be passed as
2214: two character long code
2215: p_state_code||'-000-0000',*/

Line 2674: hr_us_w2_rep.get_w2_tax_unit_item (p_tax_unit_id,

2670: /****************************************************************************/
2671: /* Civil Status */
2672:
2673: l_tax_tax_jurisdiction :=
2674: hr_us_w2_rep.get_w2_tax_unit_item (p_tax_unit_id,
2675: p_payroll_action_id,
2676: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2677: HR_UTILITY_TRACE('Tax Jurisdiction Code '||l_tax_tax_jurisdiction);
2678:

Line 2940: ltr_ue_locality(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(

2936: IF ltr_ue_locality.count > 0 then
2937: FOR j IN ltr_ue_locality.first .. ltr_ue_locality.last
2938: LOOP
2939: IF ltr_ue_locality(j).ue_data_level ='CITY' THEN
2940: ltr_ue_locality(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2941: p_ye_assignment_action_id
2942: ,ltr_ue_locality(j).ue_name
2943: ,p_tax_unit_id
2944: ,l_jurisdiction_code

Line 2956: ltr_ue_locality(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(

2952: /* Bug 7637211 : End */
2953: END IF;
2954:
2955: ELSIF ltr_ue_locality(j).ue_data_level ='CITY SCHOOL' THEN
2956: ltr_ue_locality(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2957: p_ye_assignment_action_id
2958: ,ltr_ue_locality(j).ue_name
2959: ,p_tax_unit_id
2960: ,l_jurisdiction_code