[Home] [Help]
108: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
109: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
110: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
111: org_id ap_invoice_distributions_all.org_id%TYPE,
112: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
113: tax_id zx_rec_nrec_dist.tax_id%TYPE,
114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
109: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
110: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
111: org_id ap_invoice_distributions_all.org_id%TYPE,
112: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
113: tax_id zx_rec_nrec_dist.tax_id%TYPE,
114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
110: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
111: org_id ap_invoice_distributions_all.org_id%TYPE,
112: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
113: tax_id zx_rec_nrec_dist.tax_id%TYPE,
114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
125: batch_id ap_invoice_distributions_all.batch_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
125: batch_id ap_invoice_distributions_all.batch_id%TYPE,
126: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
127: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
128: );
129:
130: PROCEDURE insert_tax_distributions
131: (p_invoice_header_rec IN ap_invoices_all%ROWTYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2078: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2079: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);
2080:
2081:
2082: TYPE ins_tax_dist_type IS TABLE OF r_ins_tax_dist_info;
2083: TYPE upd_tax_dist_type IS TABLE OF r_upd_tax_dist_info;
2095:
2096: CURSOR insert_tax_dist IS
2097: SELECT /*+ leading(gt,zd) cardinality(gt,1) */
2098: zd.gl_date accounting_date , --Bug6809792
2099: /*For tax distributions accounting date will be stamped from zx_rec_nrec_dist
2100: Ebtax will now store accounting date of opne period in their table*/
2101: decode(NVL(zl.tax_only_line_flag,'N'),
2102: 'Y',parent_tax_line.default_dist_ccid,
2103: parent_taxable_dist.dist_code_combination_id) dist_code_combination_id, ---for 6010950
2304: ai.batch_id batch_id,
2305: ai.set_of_books_id set_of_books_id,
2306: zd.account_source_tax_rate_id account_source_tax_rate_id
2307: FROM zx_trx_headers_gt gt,
2308: zx_rec_nrec_dist zd,
2309: zx_lines zl,
2310: ap_invoices_all ai,
2311: ap_supplier_sites_all pvs,
2312: ap_system_parameters_all asp,
2376:
2377: CURSOR insert_tax_variances IS
2378: SELECT /*+ leading(gt,zd) cardinality(gt,1) */
2379: zd.gl_date accounting_date , --Bug6809792
2380: /*For tax distributions accounting date will be stamped from zx_rec_nrec_dist
2381: Ebtax will now store accounting date of opne period in their table*/
2382: (CASE dist.line_type
2383: WHEN 'TERV' THEN
2384: DECODE(pd.destination_type_code, 'EXPENSE', pd.code_combination_id,
2617: ai.batch_id batch_id,
2618: ai.set_of_books_id set_of_books_id,
2619: zd.account_source_tax_rate_id account_source_tax_rate_id
2620: FROM zx_trx_headers_gt gt,
2621: zx_rec_nrec_dist zd,
2622: zx_lines zl,
2623: ap_invoices_all ai,
2624: ap_supplier_sites_all pvs,
2625: ap_system_parameters_all asp,
2703:
2704: CURSOR update_tax_dist IS
2705: SELECT /*+ leading(gt,zd) cardinality(gt,1) */
2706: zd.gl_date accounting_date , --Bug6809792
2707: /*For tax distributions accounting date will be stamped from zx_rec_nrec_dist
2708: Ebtax will now store accounting date of opne period in their table*/
2709: parent_taxable_dist.dist_code_combination_id dist_code_combination_id,
2710: -- this ccid is a temporary value that will be used if other conditions
2711: -- are met before inserting the tax distribution
2875: NULL) prepay_tax_diff_amount,
2876: aid.invoice_distribution_id invoice_distribution_id,
2877: zd.account_source_tax_rate_id
2878: FROM zx_trx_headers_gt gt,
2879: zx_rec_nrec_dist zd,
2880: zx_lines zl,
2881: ap_invoices_all ai,
2882: ap_invoice_distributions_all aid,
2883: ap_supplier_sites_all pvs,
2913:
2914: CURSOR update_tax_variances IS
2915: SELECT /*+ leading(gt,zd) cardinality(gt,1) */
2916: zd.gl_date accounting_date , --Bug6809792
2917: /*For tax distributions accounting date will be stamped from zx_rec_nrec_dist
2918: Ebtax will now store accounting date of opne period in their table*/
2919: (CASE aid.line_type_lookup_code
2920: WHEN 'TERV' THEN
2921: DECODE(pd.destination_type_code, 'EXPENSE', pd.code_combination_id,
3105: NULL prepay_tax_diff_amount,
3106: aid.invoice_distribution_id invoice_distribution_id,
3107: zd.account_source_tax_rate_id account_source_tax_rate_id
3108: FROM zx_trx_headers_gt gt,
3109: zx_rec_nrec_dist zd,
3110: zx_lines zl,
3111: ap_invoices_all ai,
3112: ap_invoice_distributions_all aid,
3113: ap_supplier_sites_all pvs,
3143:
3144:
3145: -- Cursors for self assessed distributions
3146: CURSOR insert_tax_self IS
3147: SELECT /*+ leading(gt,zd) cardinality(gt,1) INDEX (ZD ZX_REC_NREC_DIST_U3) */
3148: zd.gl_date accounting_date , --Bug6809792
3149: /*For tax distributions accounting date will be stamped from zx_rec_nrec_dist
3150: Ebtax will now store accounting date of opne period in their table*/
3151: parent_taxable_dist.dist_code_combination_id dist_code_combination_id,
3145: -- Cursors for self assessed distributions
3146: CURSOR insert_tax_self IS
3147: SELECT /*+ leading(gt,zd) cardinality(gt,1) INDEX (ZD ZX_REC_NREC_DIST_U3) */
3148: zd.gl_date accounting_date , --Bug6809792
3149: /*For tax distributions accounting date will be stamped from zx_rec_nrec_dist
3150: Ebtax will now store accounting date of opne period in their table*/
3151: parent_taxable_dist.dist_code_combination_id dist_code_combination_id,
3152: -- this ccid is a temporary value that will be used if other conditions
3153: -- are met before inserting the tax distribution
3308: ai.batch_id batch_id,
3309: ai.set_of_books_id set_of_books_id,
3310: zd.account_source_tax_rate_id account_source_tax_rate_id
3311: FROM zx_trx_headers_gt gt,
3312: zx_rec_nrec_dist zd,
3313: zx_lines zl,
3314: ap_invoices_all ai,
3315: ap_supplier_sites_all pvs,
3316: ap_system_parameters_all asp,
3352:
3353: CURSOR update_tax_self IS
3354: SELECT /*+ leading(gt,zd) cardinality(gt,1) */
3355: zd.gl_date accounting_date , --Bug6809792
3356: /*For tax distributions accounting date will be stamped from zx_rec_nrec_dist
3357: Ebtax will now store accounting date of opne period in their table*/
3358: parent_taxable_dist.dist_code_combination_id dist_code_combination_id,
3359: -- this ccid is a temporary value that will be used if other conditions
3360: -- are met before inserting the tax distribution
3503: NULL) prepay_tax_diff_amount,
3504: aid.invoice_distribution_id invoice_distribution_id,
3505: zd.account_source_tax_rate_id
3506: FROM zx_trx_headers_gt gt,
3507: zx_rec_nrec_dist zd,
3508: zx_lines zl,
3509: ap_invoices_all ai,
3510: ap_self_assessed_tax_dist_all aid,
3511: ap_supplier_sites_all pvs,
4744: AND gt.trx_id = dist.invoice_id
4745: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
4746: AND NOT EXISTS
4747: (SELECT 'Tax Distributions'
4748: FROM zx_rec_nrec_dist zd
4749: WHERE zd.rec_nrec_tax_dist_id = dist.detail_tax_dist_id
4750: AND NVL(SELF_ASSESSED_FLAG, 'N') = 'N')-- bug 7422547
4751: ); --Bug7634436
4752:
4772: AND gt.trx_id = dist.invoice_id
4773: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX')
4774: AND NOT EXISTS
4775: (SELECT 'Tax Distributions'
4776: FROM zx_rec_nrec_dist zd
4777: WHERE zd.rec_nrec_tax_dist_id = dist.detail_tax_dist_id
4778: AND NVL(SELF_ASSESSED_FLAG, 'N') = 'Y')-- bug 7422547
4779: ); --bug7634436
4780:
5713: /*
5714: SELECT zl.discarded_flag
5715: INTO l_discarded_flag
5716: FROM zx_lines zl,
5717: zx_rec_nrec_dist zd,
5718: ap_invoice_distributions aid
5719: WHERE zl.tax_line_id = zd.tax_line_id
5720: AND nvl(zl.reporting_only_flag, 'N') = 'N'
5721: AND zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id
5901:
5902: CURSOR Tax_Distributions IS
5903: SELECT aid.invoice_distribution_id
5904: FROM ap_invoice_distributions aid,
5905: zx_rec_nrec_dist zd
5906: WHERE aid.invoice_id = p_invoice_id
5907: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
5908: AND zd.tax_line_id = p_detail_tax_line_id;
5909: