eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 62: modified the code in get_location procedure, so that location_id value is fetched from JAI_RCV_TRANSACTIONS

58: 1. 27-Jan-2005 Sanjikum for Bug #4248727 Version #115.1
59: New Package created for creating VAT Processing
60:
61: 2 25/03/2005 Vijay Shankar for Bug#4250171. Version: 115.2
62: modified the code in get_location procedure, so that location_id value is fetched from JAI_RCV_TRANSACTIONS
63: incase of OPM Receipts
64:
65: 3 01/04/2005 Vijay Shankar for Bug#4278511. Version:115.3
66: Incase of ISO receipts, location_id has to be derived from SUBINVENTORY attached to the transaction if present, otherwise

Line 391: FROM JAI_RCV_TRANSACTIONS

387: currency_conversion_rate,
388: quantity,
389: DECODE(transaction_type, 'RECEIVE', 1, 'RETURN TO VENDOR', -1, 'CORRECT',
390: DECODE(parent_transaction_type, 'RECEIVE', SIGN(quantity), 'RETURN TO VENDOR', SIGN(quantity)*-1)) quantity_multiplier
391: FROM JAI_RCV_TRANSACTIONS
392: WHERE shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
393: AND transaction_id = NVL(cp_transaction_id, transaction_id)
394: AND (
395: transaction_type IN ('RECEIVE', 'RETURN TO VENDOR')

Line 404: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

400: )
401: ORDER BY transaction_id;
402:
403: CURSOR cur_tax(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
404: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
405: IS
406: SELECT ROUND(--added by Nitin for bug no 6681800
407: DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*cp_currency_conversion_rate*(b.mod_cr_percentage/100)),
408: NVL(b.rounding_factor, 0)

Line 748: lv_def_vat_invoice_no jai_rcv_transactions.excise_invoice_no%type;

744: ln_vat_exists NUMBER ;
745:
746: -- ended, Ramananda for bug # 4519719
747: /*bduvarag Bug 5899383 Start*/
748: lv_def_vat_invoice_no jai_rcv_transactions.excise_invoice_no%type;
749: ld_def_vat_invoice_Date jai_rcv_transactions.excise_invoice_date%type;
750: lv_default_invoice_setup VARCHAR2(100);
751: /*bduvarag Bug 5899383 End*/
752:

Line 749: ld_def_vat_invoice_Date jai_rcv_transactions.excise_invoice_date%type;

745:
746: -- ended, Ramananda for bug # 4519719
747: /*bduvarag Bug 5899383 Start*/
748: lv_def_vat_invoice_no jai_rcv_transactions.excise_invoice_no%type;
749: ld_def_vat_invoice_Date jai_rcv_transactions.excise_invoice_date%type;
750: lv_default_invoice_setup VARCHAR2(100);
751: /*bduvarag Bug 5899383 End*/
752:
753: BEGIN

Line 1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',

1028: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1029: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1030: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1031: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1034: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1035: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1036: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,

Line 1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),

1029: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1030: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1031: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1034: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1035: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1036: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1037: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,

Line 1108: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. lv_vat_invoice_no JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE;

1104: IS
1105: r_trx c_trx%ROWTYPE;
1106: r_base_trx c_base_trx%ROWTYPE;
1107:
1108: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. lv_vat_invoice_no JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE;
1109:
1110: lv_accounting_type VARCHAR2(100);
1111:
1112: /* File.Sql.35 by Brathod */

Line 1136: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

1132: ln_location_id NUMBER;
1133: ln_statement_id NUMBER;
1134:
1135: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
1136: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
1137: IS
1138: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1139: FROM JAI_RCV_LINE_TAXES
1140: WHERE transaction_id = cp_transaction_id

Line 1157: FROM JAI_RCV_TRANSACTIONS

1153:
1154: CURSOR c_vat_invoice(cp_transaction_id IN NUMBER)
1155: IS
1156: SELECT vat_invoice_no, vat_invoice_date
1157: FROM JAI_RCV_TRANSACTIONS
1158: WHERE transaction_id = cp_transaction_id;
1159:
1160: /*CURSOR cur_txn(cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1161: IS

Line 1166: FROM JAI_RCV_TRANSACTIONS

1162: SELECT currency_conversion_rate,
1163: quantity,
1164: DECODE(transaction_type, 'RECEIVE', 1, 'RETURN TO VENDOR', -1, 'CORRECT',
1165: DECODE(parent_transaction_type, 'RECEIVE', SIGN(quantity), 'RETURN TO VENDOR', SIGN(quantity)*-1)) quantity_multiplier
1166: FROM JAI_RCV_TRANSACTIONS
1167: WHERE transaction_id = cp_transaction_id
1168: AND (
1169: transaction_type IN ('RECEIVE', 'RETURN TO VENDOR')
1170: OR

Line 1194: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

1190: --ln_total_cenvat_amount NUMBER;
1191: ln_tax_amount NUMBER;
1192: --ln_apportion_factor NUMBER;
1193:
1194: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
1195: lv_setup VARCHAR2(10);
1196: r_vat_invoice c_vat_invoice%ROWTYPE;
1197: --r_txn cur_txn%ROWTYPE;
1198:

Line 1547: UPDATE JAI_RCV_TRANSACTIONS

1543: FETCH c_vat_invoice INTO r_vat_invoice;
1544: CLOSE c_vat_invoice;
1545:
1546: ln_statement_id := 21;
1547: UPDATE JAI_RCV_TRANSACTIONS
1548: SET vat_invoice_no = r_vat_invoice.vat_invoice_no,
1549: vat_invoice_date = r_vat_invoice.vat_invoice_date
1550: WHERE transaction_id = r_trx.transaction_id;
1551:

Line 1653: --Update the VAT Invoice no in JAI_RCV_TRANSACTIONS

1649: CLOSE c_trx;
1650:
1651: ln_statement_id := 27;
1652:
1653: --Update the VAT Invoice no in JAI_RCV_TRANSACTIONS
1654: UPDATE JAI_RCV_TRANSACTIONS
1655: SET vat_invoice_no = r_trx.vat_invoice_no,
1656: vat_invoice_date = TRUNC(SYSDATE)
1657: WHERE transaction_id = r_base_trx.transaction_id; --r_trx now points to the parent transaction

Line 1654: UPDATE JAI_RCV_TRANSACTIONS

1650:
1651: ln_statement_id := 27;
1652:
1653: --Update the VAT Invoice no in JAI_RCV_TRANSACTIONS
1654: UPDATE JAI_RCV_TRANSACTIONS
1655: SET vat_invoice_no = r_trx.vat_invoice_no,
1656: vat_invoice_date = TRUNC(SYSDATE)
1657: WHERE transaction_id = r_base_trx.transaction_id; --r_trx now points to the parent transaction
1658:

Line 1730: UPDATE JAI_RCV_TRANSACTIONS

1726:
1727: END IF;
1728: END IF;
1729: <>
1730: UPDATE JAI_RCV_TRANSACTIONS
1731: SET PROCESS_VAT_STATUS = SUBSTR(p_process_status,1,2),
1732: process_vat_message = SUBSTR(p_process_message,1,1000)
1733: WHERE transaction_id = p_transaction_id;
1734:

Line 1752: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

1748: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
1749: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1750: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
1751: p_force IN VARCHAR2 DEFAULT NULL,
1752: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
1753: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
1754: p_called_from IN VARCHAR2,
1755: p_process_status OUT NOCOPY VARCHAR2,
1756: p_process_message OUT NOCOPY VARCHAR2)

Line 1753: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

1749: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1750: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
1751: p_force IN VARCHAR2 DEFAULT NULL,
1752: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
1753: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
1754: p_called_from IN VARCHAR2,
1755: p_process_status OUT NOCOPY VARCHAR2,
1756: p_process_message OUT NOCOPY VARCHAR2)
1757: IS

Line 1828: FROM JAI_RCV_TRANSACTIONS a,

1824: cp_shipment_line_id IN NUMBER)
1825: IS
1826: SELECT a.vat_invoice_no, a.vat_invoice_date, b.transaction_id, a.tax_transaction_id,
1827: a.excise_invoice_no , a.excise_invoice_Date /*bduvarag Bug5899383*/
1828: FROM JAI_RCV_TRANSACTIONS a,
1829: JAI_RCV_LINES b
1830: WHERE a.transaction_id = b.transaction_id
1831: AND b.shipment_header_id = cp_shipment_header_id
1832: AND b.shipment_line_id = cp_shipment_line_id;

Line 1852: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;

1848: ln_code_combination_id NUMBER;
1849: ln_entered_dr NUMBER;
1850: ln_entered_cr NUMBER;
1851: lv_reference_25 gl_interface.reference25%TYPE;
1852: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
1853: lv_process_status VARCHAR2(2);
1854: lv_process_message VARCHAR2(1000);
1855: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
1856: r_claim_schedule c_claim_schedule%ROWTYPE;

Line 1857: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

1853: lv_process_status VARCHAR2(2);
1854: lv_process_message VARCHAR2(1000);
1855: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
1856: r_claim_schedule c_claim_schedule%ROWTYPE;
1857: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
1858: ln_interim_recovery_account NUMBER;
1859: r_vat_invoice c_vat_invoice%ROWTYPE;
1860: lv_source_trx_type VARCHAR2(50);
1861: lv_account_name VARCHAR2(50);

Line 1924: UPDATE JAI_RCV_TRANSACTIONS

1920: CLOSE c_vat_invoice;
1921:
1922: IF r_vat_invoice.vat_invoice_no IS NULL OR r_vat_invoice.vat_invoice_date IS NULL THEN
1923:
1924: UPDATE JAI_RCV_TRANSACTIONS
1925: SET vat_invoice_no = rec_claims.invoice_no,
1926: vat_invoice_date = rec_claims.invoice_date
1927: WHERE transaction_id = r_vat_invoice.transaction_id;
1928: END IF;

Line 1959: UPDATE jai_rcv_transactions

1955: WHERE shipment_header_id = rec_claims.shipment_header_id
1956: AND excise_invoice_no IS NULL;
1957:
1958:
1959: UPDATE jai_rcv_transactions
1960: SET excise_invoice_no = rec_claims.invoice_no,
1961: excise_invoice_Date = rec_claims.invoice_date
1962: WHERE transaction_id = r_vat_invoice.transaction_id
1963: AND excise_invoice_no IS NULL;

Line 2314: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

2310: AND a.location_id = b.location_id
2311: AND b.process_status_flag = 'Z'; /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
2312:
2313: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2314: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2315: IS
2316: SELECT jtl.tax_type,
2317: /*Added by Nitin for Bug # 6681800 */ SUM(DECODE(jtl.currency, jai_constants.func_curr, jtl.tax_amount*(rtl.mod_cr_percentage/100), jtl.tax_amount*(rtl.mod_cr_percentage/100)*cp_currency_conversion_rate)) tax_amount
2318: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/

Line 2329: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

2325: AND jtl.tax_id = rtl.tax_id -- Bug 7454592. Added by Lakshmi Gopalsami
2326: GROUP BY jtl.tax_type;
2327:
2328: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2329: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2330: IS
2331: SELECT SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, /*Added by Nitin for bug # 6681800*/a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,1))) tax_amount
2332: FROM JAI_RCV_LINE_TAXES a,
2333: JAI_CMN_TAXES_ALL b

Line 2348: FROM JAI_RCV_TRANSACTIONS

2344: SELECT transaction_id,
2345: organization_id,
2346: location_id,
2347: currency_conversion_rate
2348: FROM JAI_RCV_TRANSACTIONS
2349: WHERE shipment_header_id = cp_shipment_header_id
2350: AND shipment_line_id = cp_shipment_line_id
2351: AND transaction_type = 'RECEIVE';
2352:

Line 2366: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;

2362: SELECT receiving_account_id
2363: FROM rcv_parameters
2364: WHERE organization_id = cp_organization_id;
2365:
2366: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2367: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2368: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2369: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2370:

Line 2367: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;

2363: FROM rcv_parameters
2364: WHERE organization_id = cp_organization_id;
2365:
2366: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2367: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2368: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2369: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2370:
2371: CURSOR c_receive_correct_txns(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE, /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 2368: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;

2364: WHERE organization_id = cp_organization_id;
2365:
2366: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2367: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2368: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2369: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2370:
2371: CURSOR c_receive_correct_txns(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE, /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2372: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

Line 2369: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;

2365:
2366: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2367: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2368: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2369: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2370:
2371: CURSOR c_receive_correct_txns(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE, /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2372: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2373: IS

Line 2376: FROM JAI_RCV_TRANSACTIONS

2372: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2373: IS
2374: SELECT transaction_id,
2375: tax_transaction_id
2376: FROM JAI_RCV_TRANSACTIONS
2377: WHERE shipment_header_id = cp_shipment_header_id
2378: AND shipment_line_id = cp_shipment_line_id
2379: AND ( transaction_type = lv_ttype_receive --'RECEIVE'
2380: OR

Line 2392: FROM JAI_RCV_TRANSACTIONS

2388: IS
2389: SELECT transaction_id,
2390: tax_transaction_id,
2391: SIGN(quantity) quantity_multiplier
2392: FROM JAI_RCV_TRANSACTIONS
2393: WHERE shipment_header_id = cp_shipment_header_id
2394: AND shipment_line_id = cp_shipment_line_id
2395: AND ( transaction_type IN (lv_ttype_deliver, lv_ttype_rtr) --('DELIVER', 'RETURN TO RECEIVING')
2396: OR

Line 2415: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';

2411: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2412: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2413: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2414: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2415: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2416: lv_reference_25 gl_interface.reference25%TYPE ;
2417: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2418: lv_destination VARCHAR2(10) ; -- := 'G';
2419: /* End of File.Sql.35 by Brathod */

Line 2429: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

2425:
2426: lv_code_path VARCHAR2(1996);
2427: lv_process_status VARCHAR2(2);
2428: lv_process_message VARCHAR2(1000);
2429: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
2430: rec_total_tax cur_total_tax%ROWTYPE;
2431: ln_process_special_amount NUMBER;
2432: ln_apportion_factor NUMBER;
2433:

Line 2443: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';

2439: lv_category_name := 'Receiving India';
2440: ld_accounting_date := TRUNC(SYSDATE);
2441: lv_reference_10 := 'VAT Unclaim of the Receiving Entries';
2442: lv_reference_23 := 'jai_rgm_claim_pkg.process_no_claim';
2443: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';
2444: lv_reference_26 := 'transaction_id';
2445: lv_destination := 'G';
2446: /* End of File.Sql.35 by Brathod */
2447:

Line 2685: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

2681: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2682: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
2683: p_force IN VARCHAR2 DEFAULT NULL,
2684: p_commit_switch IN VARCHAR2,
2685: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
2686: pv_invoice_date IN VARCHAR2, /* rallamse bug#4336482 changed to VARCHAR2 from DATE */
2687: p_called_from IN VARCHAR2)
2688: IS
2689: lv_process_status VARCHAR2(2);

Line 2691: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

2687: p_called_from IN VARCHAR2)
2688: IS
2689: lv_process_status VARCHAR2(2);
2690: lv_process_message VARCHAR2(1996);
2691: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
2692:
2693: /* rallamse bug#4336482 */
2694: p_invoice_date CONSTANT DATE DEFAULT fnd_date.canonical_to_date(pv_invoice_date);
2695: /* End of Bug# 4336482 */

Line 2791: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

2787: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2788: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2789: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
2790: p_called_from IN VARCHAR2,
2791: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
2792: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
2793: p_process_status OUT NOCOPY VARCHAR2,
2794: p_process_message OUT NOCOPY VARCHAR2)
2795: IS

Line 2792: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

2788: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2789: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
2790: p_called_from IN VARCHAR2,
2791: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
2792: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
2793: p_process_status OUT NOCOPY VARCHAR2,
2794: p_process_message OUT NOCOPY VARCHAR2)
2795: IS
2796: CURSOR c_total_vat_amount(cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

Line 2878: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';

2874: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
2875: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2876: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2877: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
2878: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2879: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
2880: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2881: lv_destination VARCHAR2(10) ; -- := 'G';
2882: /* End of File.Sql.35 by Brathod */

Line 2905: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';

2901: lv_source_name := 'Purchasing India';
2902: lv_category_name := 'Receiving India';
2903: ld_accounting_date := TRUNC(SYSDATE);
2904: lv_reference_23 := 'jai_rgm_claim_pkg.process_vat';
2905: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';
2906: lv_reference_25 := p_transaction_id;
2907: lv_reference_26 := 'transaction_id';
2908: lv_destination := 'G';
2909: /* End of File.Sql.35 by Brathod */

Line 3272: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

3268: p_process_message OUT NOCOPY VARCHAR2)
3269: IS
3270:
3271: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
3272: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
3273: IS
3274: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3275: SUM(ROUND(DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100), a.tax_amount*(b.mod_cr_percentage/100)*cp_currency_conversion_rate),NVL(b.rounding_factor,0))) tax_amount
3276: FROM JAI_RCV_LINE_TAXES a,

Line 3320: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;

3316: ln_entered_cr NUMBER;
3317: lv_currency_code VARCHAR2(10);
3318: ld_accounting_date DATE;
3319: lv_reference_10 gl_interface.reference10%TYPE;
3320: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
3321: lv_process_status VARCHAR2(2);
3322: lv_process_message VARCHAR2(1000);
3323: ln_apportion_factor NUMBER;
3324: ln_tax_amount NUMBER;