DBA Data[Home] [Help]

APPS.AP_UPDATE_1099_AWT_DISTS_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 65: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;

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;

Line 68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%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;

Line 69: l_income_tax_region_asp ap_system_parameters.income_tax_region%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: --

Line 70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%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: --
74: l_commit_size INTEGER := 10000;

Line 71: l_income_tax_region ap_system_parameters.income_tax_region%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;
75: l_min_invoice_distribution_id NUMBER;

Line 72: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%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;
76: l_max_invoice_distribution_id NUMBER;

Line 110: l_debug_info := 'Get Info from Ap System Parameters';

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,

Line 120: FROM ap_system_parameters;

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