APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on HR_US_W2_REP

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

331:
332: if ltr_ue_name_table.count > 0 then
333: for j in ltr_ue_name_table.first .. ltr_ue_name_table.last
334: loop
335: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,
336: l_payroll_action_id,
337: ltr_ue_name_table(j).ue_name);
338: end loop;
339: end if;

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

871:
872: if ltr_ue_name_table.count > 0 then
873: for j in ltr_ue_name_table.first .. ltr_ue_name_table.last
874: loop
875: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_tax_unit_item (l_tax_unit_id,
876: l_payroll_action_id,
877: ltr_ue_name_table(j).ue_name);
878: end loop;
879: end if;

Line 2057: hr_us_w2_rep.get_per_item( p_ye_assignment_action_id,

2053: LOOP
2054: IF ltr_ue_name_table(j).ue_data_level = 'PER'
2055: THEN
2056: ltr_ue_name_table(j).ue_value :=
2057: hr_us_w2_rep.get_per_item( p_ye_assignment_action_id,
2058: ltr_ue_name_table(j).ue_name);
2059: ELSIF ltr_ue_name_table(J).ue_data_level ='FED' THEN
2060: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2061: p_ye_assignment_action_id

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

2056: ltr_ue_name_table(j).ue_value :=
2057: hr_us_w2_rep.get_per_item( p_ye_assignment_action_id,
2058: ltr_ue_name_table(j).ue_name);
2059: ELSIF ltr_ue_name_table(J).ue_data_level ='FED' THEN
2060: ltr_ue_name_table(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2061: p_ye_assignment_action_id
2062: ,ltr_ue_name_table(j).ue_name
2063: ,p_tax_unit_id
2064: ,'00-000-0000'

Line 2073: hr_us_w2_rep.get_w2_arch_bal(

2069: l_status := 'FAILED';
2070: END IF;
2071: ELSIF ltr_ue_name_table(J).ue_data_level ='STATE' THEN
2072: ltr_ue_name_table(j).ue_value :=
2073: hr_us_w2_rep.get_w2_arch_bal(
2074: p_ye_assignment_action_id
2075: ,ltr_ue_name_table(j).ue_name
2076: ,p_tax_unit_id
2077: ,p_state_code||'-000-0000'

Line 2086: hr_us_w2_rep.get_state_item(

2082: l_status := 'FAILED';
2083: END IF;
2084: ELSIF ltr_ue_name_table(J).ue_data_level ='GRE' THEN
2085: ltr_ue_name_table(j).ue_value :=
2086: hr_us_w2_rep.get_state_item(
2087: p_tax_unit_id,
2088: p_state_code||'-000-0000',
2089: p_payroll_action_id,
2090: ltr_ue_name_table(j).ue_name);

Line 2515: hr_us_w2_rep.get_w2_tax_unit_item (p_tax_unit_id,

2511: /****************************************************************************/
2512: /* Civil Status */
2513:
2514: l_tax_tax_jurisdiction :=
2515: hr_us_w2_rep.get_w2_tax_unit_item (p_tax_unit_id,
2516: p_payroll_action_id,
2517: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2518: HR_UTILITY_TRACE('Tax Jurisdiction Code '||l_tax_tax_jurisdiction);
2519:

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

2746: IF ltr_ue_locality.count > 0 then
2747: FOR j IN ltr_ue_locality.first .. ltr_ue_locality.last
2748: LOOP
2749: IF ltr_ue_locality(j).ue_data_level ='CITY' THEN
2750: ltr_ue_locality(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2751: p_ye_assignment_action_id
2752: ,ltr_ue_locality(j).ue_name
2753: ,p_tax_unit_id
2754: ,l_jurisdiction_code

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

2759: l_status := 'FAILED';
2760: END IF;
2761:
2762: ELSIF ltr_ue_locality(j).ue_data_level ='CITY SCHOOL' THEN
2763: ltr_ue_locality(j).ue_value := hr_us_w2_rep.get_w2_arch_bal(
2764: p_ye_assignment_action_id
2765: ,ltr_ue_locality(j).ue_name
2766: ,p_tax_unit_id
2767: ,l_jurisdiction_code