APPS.JAI_OPEN_API_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 1004: FROM JAI_CMN_DOCUMENT_TAXES

1000: CURSOR get_tax_ap_count_cur
1001: IS
1002: SELECT
1003: COUNT(SOURCE_DOC_LINE_ID)
1004: FROM JAI_CMN_DOCUMENT_TAXES
1005: WHERE SOURCE_DOC_ID = pn_trx_id;
1006: --AND SOURCE_DOC_LINE_ID = pn_trx_line_id;--Commented by zhiwei for bug#12560873
1007:
1008: --Variable define here

Line 8606: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%TYPE DEFAULT NULL

8602: p_vat_assessable_value NUMBER DEFAULT 0
8603: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
8604: , p_thhold_cat_base_tax_typ JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL -- tax type to be considered as base when calculating threshold taxes
8605: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%TYPE DEFAULT NULL
8606: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%TYPE DEFAULT NULL
8607: , p_source_table_name jai_cmn_document_taxes.source_table_name%TYPE DEFAULT NULL
8608: , p_action VARCHAR2 DEFAULT NULL
8609: /** End bug 5631784 */
8610: , pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/13

Line 8607: , p_source_table_name jai_cmn_document_taxes.source_table_name%TYPE DEFAULT NULL

8603: /** bgowrava for forward porting bug#5631784,Following parameters are added for TCS enh.*/
8604: , p_thhold_cat_base_tax_typ JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL -- tax type to be considered as base when calculating threshold taxes
8605: , p_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%TYPE DEFAULT NULL
8606: , p_source_trx_type jai_cmn_document_taxes.source_doc_type%TYPE DEFAULT NULL
8607: , p_source_table_name jai_cmn_document_taxes.source_table_name%TYPE DEFAULT NULL
8608: , p_action VARCHAR2 DEFAULT NULL
8609: /** End bug 5631784 */
8610: , pv_retroprice_changed IN VARCHAR2 DEFAULT 'N' --Added by Kevin Cheng for Retroactive Price 2008/01/13
8611: , p_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE DEFAULT NULL /*Added for Bug 8241905*/

Line 8884: , 'JAI_CMN_DOCUMENT_TAXES'

8880:
8881: lv_recalculation_sql :=
8882: REPLACE( lv_recalculation_sql
8883: , '$$TAX_SOURCE_TABLE$$'
8884: , 'JAI_CMN_DOCUMENT_TAXES'
8885: );
8886: -- replace join condition
8887: lv_recalculation_sql :=
8888: REPLACE( lv_recalculation_sql

Line 10254: UPDATE jai_cmn_document_taxes

10250: ELSIF transaction_name = 'AP_STANDALONE' THEN
10251: --Added by zhiwei for Bug#12604133 on 20110628 begin
10252: ------------------------------------------------------
10253: if adhoc_flag_tab(row_count) = 'Y' and vat_flag_tab(row_count) = 'Q' and nvl(reverse_flag_tab(I),0) = 1 then
10254: UPDATE jai_cmn_document_taxes
10255: SET tax_amt = ROUND(NVL(tax_amt_tab(row_count), 0), REC.ROUNDING_FACTOR),
10256: --base_tax_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0), NVL(base_tax_amt_tab(row_count), 0)),
10257: func_tax_amt = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
10258: qty_rate = qty_rate_tab(row_count),

Line 10270: UPDATE jai_cmn_document_taxes

10266:
10267: else
10268: ------------------------------------------------------
10269: --Added by zhiwei for Bug#12604133 on 20110628 end
10270: UPDATE jai_cmn_document_taxes
10271: SET tax_amt = ROUND(NVL(tax_amt_tab(row_count), 0), REC.ROUNDING_FACTOR),
10272: --base_tax_amount = DECODE(NVL(base_tax_amt_tab(row_count), 0), 0, NVL(tax_amt_tab(row_count),0), NVL(base_tax_amt_tab(row_count), 0)),
10273: func_tax_amt = NVL(func_tax_amt_tab(row_count),0) * v_currency_conv_factor,
10274: last_update_date = p_last_update_date,

Line 10547: 'INSERT INTO jai_cmn_document_taxes

10543: ln_qty_rate number;--Added by zhiwei for Bug#12604133 on 20110623
10544: BEGIN
10545:
10546: lv_insert_jai_ap_tax_sql :=
10547: 'INSERT INTO jai_cmn_document_taxes
10548: ( doc_tax_id
10549: , tax_line_no
10550: , tax_id
10551: , tax_type

Line 10854: USING jai_cmn_document_taxes_s.nextval

10850: v_modvat_flag := 'N';
10851: END IF;
10852:
10853: EXECUTE IMMEDIATE lv_insert_jai_ap_tax_sql
10854: USING jai_cmn_document_taxes_s.nextval
10855: , tax_lines_rec.lno
10856: , tax_lines_rec.tax_id
10857: , tax_lines_rec.tax_type
10858: , 'INR'

Line 11831: FROM jai_cmn_document_taxes

11827: /* UPDATE ap_invoice_lines_all aila
11828: SET reference_key3 = 'OFI TAX IMPORT.' || upper(lv_taxable_event)
11829: WHERE invoice_id = ln_invoice_id
11830: AND line_number IN (SELECT source_doc_line_id
11831: FROM jai_cmn_document_taxes
11832: WHERE source_doc_id = ln_invoice_id
11833: AND source_doc_parent_line_no = ln_invoice_line_num);
11834: */
11835: