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 460: FROM JAI_RCV_TRANSACTIONS

456: currency_conversion_rate,
457: quantity,
458: DECODE(transaction_type, 'RECEIVE', 1, 'RETURN TO VENDOR', -1, 'CORRECT',
459: DECODE(parent_transaction_type, 'RECEIVE', SIGN(quantity), 'RETURN TO VENDOR', SIGN(quantity)*-1)) quantity_multiplier
460: FROM JAI_RCV_TRANSACTIONS
461: WHERE shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
462: AND transaction_id = NVL(cp_transaction_id, transaction_id)
463: AND (
464: transaction_type IN ('RECEIVE', 'RETURN TO VENDOR')

Line 473: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

469: )
470: ORDER BY transaction_id;
471:
472: CURSOR cur_tax(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
473: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
474: IS
475: SELECT DECODE(a.currency, jai_constants.func_curr, a.tax_amount*(b.mod_cr_percentage/100),
476: a.tax_amount*cp_currency_conversion_rate*(b.mod_cr_percentage/100)) tax_amount --Removed Round condition by Bgowrava for Bug#8414075
477: /*DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),

Line 818: lv_def_vat_invoice_no jai_rcv_transactions.excise_invoice_no%type;

814: ln_vat_exists NUMBER ;
815:
816: -- ended, Ramananda for bug # 4519719
817: /*bduvarag Bug 5899383 Start*/
818: lv_def_vat_invoice_no jai_rcv_transactions.excise_invoice_no%type;
819: ld_def_vat_invoice_Date jai_rcv_transactions.excise_invoice_date%type;
820: lv_default_invoice_setup VARCHAR2(100);
821: /*bduvarag Bug 5899383 End*/
822:

Line 819: ld_def_vat_invoice_Date jai_rcv_transactions.excise_invoice_date%type;

815:
816: -- ended, Ramananda for bug # 4519719
817: /*bduvarag Bug 5899383 Start*/
818: lv_def_vat_invoice_no jai_rcv_transactions.excise_invoice_no%type;
819: ld_def_vat_invoice_Date jai_rcv_transactions.excise_invoice_date%type;
820: lv_default_invoice_setup VARCHAR2(100);
821: /*bduvarag Bug 5899383 End*/
822:
823: BEGIN

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

1098: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1099: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1100: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1101: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1102: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1103: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1104: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1105: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1106: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,

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

1099: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1100: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1101: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1102: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1103: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1104: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1105: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,
1106: p_correct_receive_qty IN jai_rcv_rgm_lines.correct_receive_qty%TYPE DEFAULT NULL,
1107: p_rtv_qty IN jai_rcv_rgm_lines.rtv_qty%TYPE DEFAULT NULL,

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

1175: IS
1176: r_trx c_trx%ROWTYPE;
1177: r_base_trx c_base_trx%ROWTYPE;
1178:
1179: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. lv_vat_invoice_no JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE;
1180:
1181: lv_accounting_type VARCHAR2(100);
1182:
1183: /* File.Sql.35 by Brathod */

Line 1207: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

1203: ln_location_id NUMBER;
1204: ln_statement_id NUMBER;
1205:
1206: /*CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
1207: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
1208: IS
1209: SELECT SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount
1210: FROM JAI_RCV_LINE_TAXES
1211: WHERE transaction_id = cp_transaction_id

Line 1228: FROM JAI_RCV_TRANSACTIONS

1224:
1225: CURSOR c_vat_invoice(cp_transaction_id IN NUMBER)
1226: IS
1227: SELECT vat_invoice_no, vat_invoice_date
1228: FROM JAI_RCV_TRANSACTIONS
1229: WHERE transaction_id = cp_transaction_id;
1230:
1231: /*CURSOR cur_txn(cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
1232: IS

Line 1237: FROM JAI_RCV_TRANSACTIONS

1233: SELECT currency_conversion_rate,
1234: quantity,
1235: DECODE(transaction_type, 'RECEIVE', 1, 'RETURN TO VENDOR', -1, 'CORRECT',
1236: DECODE(parent_transaction_type, 'RECEIVE', SIGN(quantity), 'RETURN TO VENDOR', SIGN(quantity)*-1)) quantity_multiplier
1237: FROM JAI_RCV_TRANSACTIONS
1238: WHERE transaction_id = cp_transaction_id
1239: AND (
1240: transaction_type IN ('RECEIVE', 'RETURN TO VENDOR')
1241: OR

Line 1265: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

1261: --ln_total_cenvat_amount NUMBER;
1262: ln_tax_amount NUMBER;
1263: --ln_apportion_factor NUMBER;
1264:
1265: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
1266: lv_setup VARCHAR2(10);
1267: r_vat_invoice c_vat_invoice%ROWTYPE;
1268: --r_txn cur_txn%ROWTYPE;
1269:

Line 1618: UPDATE JAI_RCV_TRANSACTIONS

1614: FETCH c_vat_invoice INTO r_vat_invoice;
1615: CLOSE c_vat_invoice;
1616:
1617: ln_statement_id := 21;
1618: UPDATE JAI_RCV_TRANSACTIONS
1619: SET vat_invoice_no = r_vat_invoice.vat_invoice_no,
1620: vat_invoice_date = r_vat_invoice.vat_invoice_date
1621: WHERE transaction_id = r_trx.transaction_id;
1622:

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

1720: CLOSE c_trx;
1721:
1722: ln_statement_id := 27;
1723:
1724: --Update the VAT Invoice no in JAI_RCV_TRANSACTIONS
1725: UPDATE JAI_RCV_TRANSACTIONS
1726: SET vat_invoice_no = r_trx.vat_invoice_no,
1727: vat_invoice_date = TRUNC(SYSDATE)
1728: WHERE transaction_id = r_base_trx.transaction_id; --r_trx now points to the parent transaction

Line 1725: UPDATE JAI_RCV_TRANSACTIONS

1721:
1722: ln_statement_id := 27;
1723:
1724: --Update the VAT Invoice no in JAI_RCV_TRANSACTIONS
1725: UPDATE JAI_RCV_TRANSACTIONS
1726: SET vat_invoice_no = r_trx.vat_invoice_no,
1727: vat_invoice_date = TRUNC(SYSDATE)
1728: WHERE transaction_id = r_base_trx.transaction_id; --r_trx now points to the parent transaction
1729:

Line 1801: UPDATE JAI_RCV_TRANSACTIONS

1797:
1798: END IF;
1799: END IF;
1800: <>
1801: UPDATE JAI_RCV_TRANSACTIONS
1802: SET PROCESS_VAT_STATUS = SUBSTR(p_process_status,1,2),
1803: process_vat_message = SUBSTR(p_process_message,1,1000)
1804: WHERE transaction_id = p_transaction_id;
1805:

Line 1823: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

1819: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
1820: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1821: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
1822: p_force IN VARCHAR2 DEFAULT NULL,
1823: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
1824: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
1825: p_called_from IN VARCHAR2,
1826: p_process_status OUT NOCOPY VARCHAR2,
1827: p_process_message OUT NOCOPY VARCHAR2)

Line 1824: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

1820: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1821: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
1822: p_force IN VARCHAR2 DEFAULT NULL,
1823: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
1824: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
1825: p_called_from IN VARCHAR2,
1826: p_process_status OUT NOCOPY VARCHAR2,
1827: p_process_message OUT NOCOPY VARCHAR2)
1828: IS

Line 1900: FROM JAI_RCV_TRANSACTIONS a,

1896: IS
1897: SELECT a.vat_invoice_no, a.vat_invoice_date, b.transaction_id, a.tax_transaction_id,
1898: a.excise_invoice_no , a.excise_invoice_Date /*bduvarag Bug5899383*/
1899: ,a.transaction_date /*added by vkaranam for bug#14061440*/
1900: FROM JAI_RCV_TRANSACTIONS a,
1901: JAI_RCV_LINES b
1902: WHERE a.transaction_id = b.transaction_id
1903: AND b.shipment_header_id = cp_shipment_header_id
1904: AND b.shipment_line_id = cp_shipment_line_id;

Line 1924: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;

1920: ln_code_combination_id NUMBER;
1921: ln_entered_dr NUMBER;
1922: ln_entered_cr NUMBER;
1923: lv_reference_25 gl_interface.reference25%TYPE;
1924: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
1925: lv_process_status VARCHAR2(2);
1926: lv_process_message VARCHAR2(1000);
1927: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
1928: r_claim_schedule c_claim_schedule%ROWTYPE;

Line 1929: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

1925: lv_process_status VARCHAR2(2);
1926: lv_process_message VARCHAR2(1000);
1927: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
1928: r_claim_schedule c_claim_schedule%ROWTYPE;
1929: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
1930: ln_interim_recovery_account NUMBER;
1931: r_vat_invoice c_vat_invoice%ROWTYPE;
1932: lv_source_trx_type VARCHAR2(50);
1933: lv_account_name VARCHAR2(50);

Line 1996: UPDATE JAI_RCV_TRANSACTIONS

1992: CLOSE c_vat_invoice;
1993:
1994: IF r_vat_invoice.vat_invoice_no IS NULL OR r_vat_invoice.vat_invoice_date IS NULL THEN
1995:
1996: UPDATE JAI_RCV_TRANSACTIONS
1997: SET vat_invoice_no = rec_claims.invoice_no,
1998: vat_invoice_date = rec_claims.invoice_date
1999: WHERE transaction_id = r_vat_invoice.transaction_id;
2000: END IF;

Line 2031: UPDATE jai_rcv_transactions

2027: WHERE shipment_header_id = rec_claims.shipment_header_id
2028: AND excise_invoice_no IS NULL;
2029:
2030:
2031: UPDATE jai_rcv_transactions
2032: SET excise_invoice_no = rec_claims.invoice_no,
2033: excise_invoice_Date = rec_claims.invoice_date
2034: WHERE transaction_id = r_vat_invoice.transaction_id
2035: AND excise_invoice_no IS NULL;

Line 2394: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

2390: AND a.location_id = b.location_id
2391: AND b.process_status_flag = 'Z'; /* 'Z' meaning the line is marked for UNCLAIM, but not yet processed*/
2392:
2393: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2394: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2395: IS
2396: SELECT jtl.tax_type,
2397: /*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
2398: /*Commented by Nitin for bug :6681800 SUM(DECODE(currency, jai_constants.func_curr, tax_amount, tax_amount*cp_currency_conversion_rate)) tax_amount*/

Line 2409: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

2405: AND jtl.tax_id = rtl.tax_id -- Bug 7454592. Added by Lakshmi Gopalsami
2406: GROUP BY jtl.tax_type;
2407:
2408: CURSOR cur_total_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
2409: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
2410: IS
2411: 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
2412: FROM JAI_RCV_LINE_TAXES a,
2413: JAI_CMN_TAXES_ALL b

Line 2428: FROM JAI_RCV_TRANSACTIONS

2424: SELECT transaction_id,
2425: organization_id,
2426: location_id,
2427: currency_conversion_rate
2428: FROM JAI_RCV_TRANSACTIONS
2429: WHERE shipment_header_id = cp_shipment_header_id
2430: AND shipment_line_id = cp_shipment_line_id
2431: AND transaction_type = 'RECEIVE';
2432:

Line 2446: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;

2442: SELECT receiving_account_id
2443: FROM rcv_parameters
2444: WHERE organization_id = cp_organization_id;
2445:
2446: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2447: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2448: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2449: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2450:

Line 2447: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;

2443: FROM rcv_parameters
2444: WHERE organization_id = cp_organization_id;
2445:
2446: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2447: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2448: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2449: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2450:
2451: 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 2448: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;

2444: WHERE organization_id = cp_organization_id;
2445:
2446: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2447: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2448: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2449: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2450:
2451: 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*/
2452: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

Line 2449: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;

2445:
2446: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2447: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;
2448: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type;
2449: lv_ttype_rtr JAI_RCV_TRANSACTIONS.transaction_type%type;
2450:
2451: 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*/
2452: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2453: IS

Line 2456: FROM JAI_RCV_TRANSACTIONS

2452: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2453: IS
2454: SELECT transaction_id,
2455: tax_transaction_id
2456: FROM JAI_RCV_TRANSACTIONS
2457: WHERE shipment_header_id = cp_shipment_header_id
2458: AND shipment_line_id = cp_shipment_line_id
2459: AND ( transaction_type = lv_ttype_receive --'RECEIVE'
2460: OR

Line 2472: FROM JAI_RCV_TRANSACTIONS

2468: IS
2469: SELECT transaction_id,
2470: tax_transaction_id,
2471: SIGN(quantity) quantity_multiplier
2472: FROM JAI_RCV_TRANSACTIONS
2473: WHERE shipment_header_id = cp_shipment_header_id
2474: AND shipment_line_id = cp_shipment_line_id
2475: AND ( transaction_type IN (lv_ttype_deliver, lv_ttype_rtr) --('DELIVER', 'RETURN TO RECEIVING')
2476: OR

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

2511: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2512: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2513: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2514: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2515: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2516: lv_reference_25 gl_interface.reference25%TYPE ;
2517: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2518: lv_destination VARCHAR2(10) ; -- := 'G';
2519: /* End of File.Sql.35 by Brathod */

Line 2529: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

2525:
2526: lv_code_path VARCHAR2(1996);
2527: lv_process_status VARCHAR2(2);
2528: lv_process_message VARCHAR2(1000);
2529: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
2530: rec_total_tax cur_total_tax%ROWTYPE;
2531: ln_process_special_amount NUMBER;
2532: ln_apportion_factor NUMBER;
2533:

Line 2547: FROM JAI_RCV_TRANSACTIONS

2543: CURSOR c_receive_correct_qty(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2544: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2545: IS
2546: SELECT SUM(quantity)
2547: FROM JAI_RCV_TRANSACTIONS
2548: WHERE shipment_header_id = cp_shipment_header_id
2549: AND shipment_line_id = cp_shipment_line_id
2550: AND ( transaction_type = 'RECEIVE'
2551: OR

Line 2560: FROM JAI_RCV_TRANSACTIONS

2556: CURSOR c_rtv_correct_qty(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2557: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
2558: IS
2559: SELECT SUM(quantity)
2560: FROM JAI_RCV_TRANSACTIONS
2561: WHERE shipment_header_id = cp_shipment_header_id
2562: AND shipment_line_id = cp_shipment_line_id
2563: AND ( transaction_type = 'RETURN TO VENDOR'
2564: OR

Line 2583: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';

2579: lv_category_name := 'Receiving India';
2580: ld_accounting_date := TRUNC(SYSDATE);
2581: lv_reference_10 := 'VAT Unclaim of the Receiving Entries';
2582: lv_reference_23 := 'jai_rgm_claim_pkg.process_no_claim';
2583: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';
2584: lv_reference_26 := 'transaction_id';
2585: lv_destination := 'G';
2586: /* End of File.Sql.35 by Brathod */
2587:

Line 2898: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

2894: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2895: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
2896: p_force IN VARCHAR2 DEFAULT NULL,
2897: p_commit_switch IN VARCHAR2,
2898: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
2899: pv_invoice_date IN VARCHAR2, /* rallamse bug#4336482 changed to VARCHAR2 from DATE */
2900: p_called_from IN VARCHAR2)
2901: IS
2902: lv_process_status VARCHAR2(2);

Line 2904: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;

2900: p_called_from IN VARCHAR2)
2901: IS
2902: lv_process_status VARCHAR2(2);
2903: lv_process_message VARCHAR2(1996);
2904: lv_codepath JAI_RCV_TRANSACTIONS.codepath%TYPE;
2905:
2906: /* rallamse bug#4336482 */
2907: p_invoice_date CONSTANT DATE DEFAULT fnd_date.canonical_to_date(pv_invoice_date);
2908: /* End of Bug# 4336482 */

Line 3004: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,

3000: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
3001: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
3002: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
3003: p_called_from IN VARCHAR2,
3004: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
3005: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
3006: p_process_status OUT NOCOPY VARCHAR2,
3007: p_process_message OUT NOCOPY VARCHAR2)
3008: IS

Line 3005: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,

3001: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
3002: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
3003: p_called_from IN VARCHAR2,
3004: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE,
3005: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE,
3006: p_process_status OUT NOCOPY VARCHAR2,
3007: p_process_message OUT NOCOPY VARCHAR2)
3008: IS
3009: CURSOR c_total_vat_amount(cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

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

3087: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3088: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3089: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
3090: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
3091: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
3092: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3093: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3094: lv_destination VARCHAR2(10) ; -- := 'G';
3095: /* End of File.Sql.35 by Brathod */

Line 3119: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';

3115: lv_source_name := 'Purchasing India';
3116: lv_category_name := 'Receiving India';
3117: ld_accounting_date := TRUNC(SYSDATE);
3118: lv_reference_23 := 'jai_rgm_claim_pkg.process_vat';
3119: lv_reference_24 := 'JAI_RCV_TRANSACTIONS';
3120: lv_reference_25 := p_transaction_id;
3121: lv_reference_26 := 'transaction_id';
3122: lv_destination := 'G';
3123: /* End of File.Sql.35 by Brathod */

Line 3519: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)

3515: p_process_message OUT NOCOPY VARCHAR2)
3516: IS
3517:
3518: CURSOR cur_tax(cp_transaction_id IN JAI_RCV_LINE_TAXES.transaction_id%TYPE,
3519: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
3520: IS
3521: SELECT a.tax_type,/*COL (b.mod_cr_percentage/100) added by Nitin for bug #6681800*/
3522: 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
3523: FROM JAI_RCV_LINE_TAXES a,

Line 3582: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;

3578: ln_entered_cr NUMBER;
3579: lv_currency_code VARCHAR2(10);
3580: ld_accounting_date DATE;
3581: lv_reference_10 gl_interface.reference10%TYPE;
3582: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
3583: lv_process_status VARCHAR2(2);
3584: lv_process_message VARCHAR2(1000);
3585: ln_apportion_factor NUMBER;
3586: ln_tax_amount NUMBER;