61: l_yyyy NUMBER;
62: l_count INTEGER := 0;
63: l_total_count INTEGER := 0;
64: --
65: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
66: l_federal_reportable_flag po_vendors.federal_reportable_flag%TYPE;
67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
64: --
65: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
66: l_federal_reportable_flag po_vendors.federal_reportable_flag%TYPE;
67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
71: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
72: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
65: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
66: l_federal_reportable_flag po_vendors.federal_reportable_flag%TYPE;
67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
71: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
72: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
73: --
66: l_federal_reportable_flag po_vendors.federal_reportable_flag%TYPE;
67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
71: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
72: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
73: --
74: l_commit_size INTEGER := 10000;
67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
71: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
72: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
73: --
74: l_commit_size INTEGER := 10000;
75: l_min_invoice_distribution_id NUMBER;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
71: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;
72: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;
73: --
74: l_commit_size INTEGER := 10000;
75: l_min_invoice_distribution_id NUMBER;
76: l_max_invoice_distribution_id NUMBER;
106: l_login_id := FND_GLOBAL.login_id;
107: l_program_application_id := FND_GLOBAL.prog_appl_id;
108: l_program_id := FND_GLOBAL.conc_program_id;
109:
110: l_debug_info := 'Get Info from Ap System Parameters';
111: --
112: SELECT NVL(enable_1099_on_awt_flag, 'N'),
113: combined_filing_flag,
114: income_tax_region_flag,
116: INTO l_enable_1099_on_awt_flag,
117: l_combined_filing_flag,
118: l_income_tax_region_flag,
119: l_income_tax_region
120: FROM ap_system_parameters;
121: --
122: SELECT NVL(MIN(invoice_distribution_id),0),
123: NVL(MAX(invoice_distribution_id),0)
124: INTO l_min_invoice_distribution_id, l_max_invoice_distribution_id