[Home] [Help]
176: -- AWT and INTEREST: Withholding Tax and Interest invoices do not require
177: -- tax calculation.
178: -- QUICKDEFAULT and QUICKMATCH: These defined types for invoices are only
179: -- entry mechanisms. When the invoice is commit
180: -- the type is STANDARD.
181:
182: IF (P_Invoice_Type_Lookup_Code IN ('STANDARD',
183: 'CREDIT',
184: 'DEBIT',
178: -- QUICKDEFAULT and QUICKMATCH: These defined types for invoices are only
179: -- entry mechanisms. When the invoice is commit
180: -- the type is STANDARD.
181:
182: IF (P_Invoice_Type_Lookup_Code IN ('STANDARD',
183: 'CREDIT',
184: 'DEBIT',
185: 'MIXED',
186: 'ADJUSTMENT',
190: 'RETAINAGE RELEASE',
191: 'PAYMENT REQUEST')) THEN -- for bug 5948586
192:
193: ------------------------------------------------------------------
194: l_debug_info := 'Step 1: Event Class Code is STANDARD INVOICES';
195: ------------------------------------------------------------------
196: P_Event_Class_Code := 'STANDARD INVOICES';
197:
198:
192:
193: ------------------------------------------------------------------
194: l_debug_info := 'Step 1: Event Class Code is STANDARD INVOICES';
195: ------------------------------------------------------------------
196: P_Event_Class_Code := 'STANDARD INVOICES';
197:
198:
199: ELSIF (P_Invoice_Type_Lookup_Code IN ('PREPAYMENT')) THEN
200:
285: l_curr_calling_sequence := 'AP_ETAX_UTILITY_PKG.Get_Event_Type_Code<-' ||
286: P_calling_sequence;
287:
288: -- There are 3 different event classes defined for AP to handle tax in 11ix.
289: -- They are: STANDARD INVOICES, PREPAYMENT INVOICES and EXPENSE REPORTS.
290: -- There are different event type codes per event type and event class due to
291: -- a requirement of SLA. The event type code should be unique per product.
292: -- So, we can say the event type code is composed of 2 sections:
293: -- The class section (STANDARD, PREPAYMENT or EXPENSE REPORT) and the
289: -- They are: STANDARD INVOICES, PREPAYMENT INVOICES and EXPENSE REPORTS.
290: -- There are different event type codes per event type and event class due to
291: -- a requirement of SLA. The event type code should be unique per product.
292: -- So, we can say the event type code is composed of 2 sections:
293: -- The class section (STANDARD, PREPAYMENT or EXPENSE REPORT) and the
294: -- action section that determines the action ocurred to the class
295: -- (CREATE, UPDATE, CANCELLED, FROZEN, etc).
296:
297: ------------------------------------------------------------------
297: ------------------------------------------------------------------
298: l_debug_info := 'Step 1: Event Class Code is: '||p_event_class_code;
299: ------------------------------------------------------------------
300:
301: IF ( P_Event_Class_Code = 'STANDARD INVOICES' ) THEN
302: l_class_section := 'STANDARD ';
303:
304: ELSIF ( P_Event_Class_Code = 'PREPAYMENT INVOICES' ) THEN
305: l_class_section := 'PREPAYMENT ';
298: l_debug_info := 'Step 1: Event Class Code is: '||p_event_class_code;
299: ------------------------------------------------------------------
300:
301: IF ( P_Event_Class_Code = 'STANDARD INVOICES' ) THEN
302: l_class_section := 'STANDARD ';
303:
304: ELSIF ( P_Event_Class_Code = 'PREPAYMENT INVOICES' ) THEN
305: l_class_section := 'PREPAYMENT ';
306:
1026: (SELECT zl.summary_tax_line_id
1027: FROM zx_lines_summary zl
1028: WHERE zl.application_id = 200
1029: AND zl.entity_code = 'AP_INVOICES'
1030: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1031: AND zl.trx_id = ail.invoice_id
1032: AND zl.tax_regime_code = ail.tax_regime_code
1033: AND zl.tax = ail.tax
1034: AND zl.tax_status_code = ail.tax_status_code
1201: FROM zx_lines zl
1202: WHERE zl.application_id = 200
1203: AND zl.entity_code = 'AP_INVOICES'
1204: AND zl.event_class_code IN
1205: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1206: AND zl.trx_id = ail.invoice_id
1207: AND zl.tax_regime_code = ail.tax_regime_code
1208: AND zl.tax = ail.tax
1209: AND zl.tax_status_code = ail.tax_status_code
1704: AND ai.vendor_id = ap.vendor_id
1705: AND ai.vendor_site_id = aps.vendor_site_id
1706: AND zls.application_id = 200
1707: AND zls.entity_code = 'AP_INVOICES'
1708: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1709: AND zls.trx_id = ai.invoice_id
1710: AND NVL(zls.tax_amt_included_flag, 'N') = 'N'
1711: AND NVL(zls.self_assessed_flag, 'N') = 'N'
1712: AND NVL(zls.reporting_only_flag, 'N') = 'N'
1760: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
1761: FROM zx_lines zl
1762: WHERE zl.application_id = 200
1763: AND zl.entity_code = 'AP_INVOICES'
1764: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1765: AND zl.trx_id = ail.invoice_id
1766: AND zl.trx_line_id = ail.line_number
1767: AND NVL(zl.self_assessed_flag, 'N') = 'N'
1768: AND NVL(zl.reporting_only_flag, 'N') = 'N'
1852: 0))
1853: FROM zx_lines_summary zls
1854: WHERE zls.application_id = 200
1855: AND zls.entity_code = 'AP_INVOICES'
1856: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1857: AND zls.trx_id = ai.invoice_id
1858: AND NVL(zls.reporting_only_flag, 'N') = 'N')
1859: WHERE ai.invoice_id = P_Invoice_Header_Rec.invoice_id
1860: RETURNING ai.total_tax_amount, ai.self_assessed_tax_amount
4797: FROM zx_trx_headers_gt gt,
4798: ap_invoice_distributions_all dist
4799: WHERE gt.application_id = 200
4800: AND gt.entity_code = 'AP_INVOICES'
4801: AND gt.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
4802: AND gt.trx_id = dist.invoice_id
4803: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
4804: AND dist.invoice_line_number NOT IN
4805: (SELECT line_number
4907: FROM zx_validation_errors_gt ve,
4908: ap_invoice_lines_interface ail
4909: WHERE ve.application_id = 200
4910: AND ve.entity_code = 'AP_INVOICES'
4911: AND ve.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
4912: AND ve.trx_id = P_Invoice_Header_Rec.invoice_id
4913: AND ail.invoice_id = ve.trx_id;
4914: --AND ail.line_number = ve.trx_line_id; -- bug6255826
4915:
5153: NVL(ail.base_amount,0) - SUM(NVL(zdl.tax_amt_funcl_curr,0))
5154: FROM zx_detail_tax_lines_gt zdl
5155: WHERE zdl.application_id = 200
5156: AND zdl.entity_code = 'AP_INVOICES'
5157: AND zdl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5158: AND zdl.trx_id = ail.invoice_id
5159: AND zdl.trx_line_id = ail.line_number
5160: AND NVL(zdl.self_assessed_flag, 'N') = 'N'
5161: AND NVL(zdl.tax_amt_included_flag, 'N') = 'N')
5314: WHERE trx_id = p_invoice_id
5315: AND application_id = 200
5316: AND entity_code = 'AP_INVOICES'
5317: AND event_class_code IN
5318: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5319: AND ROWNUM=1;
5320: --- End for bug 6485124
5321: -- commented for bug 6485124
5322: /* FROM ap_invoice_lines_all
5966: | PARAMETERS
5967: | p_org_id - Operating unit identifier
5968: | p_legal_entity_id - Legal entity identifier.
5969: | p_transaction_date - Transaction Date.
5970: | P_Related_Doc_Date - Date of the related document. (Eg: Standard PO)
5971: | P_Adjusted_Doc_Date - Date of the adjusted document. (Eg: DM/CM applied to Invoice)
5972: |
5973: | MODIFICATION HISTORY
5974: | DATE Author Action
7456:
7457: l_curr_calling_sequence := 'AP_ETAX_UTILITY_PKG.Get_Line_Class_Code<-' ||
7458: P_calling_sequence;
7459:
7460: IF (P_Invoice_Type_Lookup_Code IN ('STANDARD',
7461: 'MIXED',
7462: 'ADJUSTMENT',
7463: 'PO PRICE ADJUST',
7464: 'INVOICE REQUEST')) THEN
7462: 'ADJUSTMENT',
7463: 'PO PRICE ADJUST',
7464: 'INVOICE REQUEST')) THEN
7465:
7466: P_Line_Class := 'STANDARD INVOICES';
7467:
7468: ELSIF (P_Invoice_Type_Lookup_Code IN ('CREDIT', 'CREDIT MEMO REQUEST')) THEN
7469:
7470: P_Line_Class := 'AP_CREDIT_MEMO';