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 RCV_TRANSACTIONS

Line 5: TABLE_RCV_TRANSACTIONS CONSTANT VARCHAR2(30) := 'RCV_TRANSACTIONS';

1: PACKAGE BODY jai_rcv_rgm_claims_pkg AS
2: /* $Header: jai_rcv_rgm_clm.plb 120.15.12010000.2 2008/10/14 10:17:08 lgopalsa ship $ */
3:
4:
5: TABLE_RCV_TRANSACTIONS CONSTANT VARCHAR2(30) := 'RCV_TRANSACTIONS';
6: RECEIVING CONSTANT VARCHAR2(30) := 'RECEIVING';
7: RTV CONSTANT VARCHAR2(15) := 'RTV';
8: CORRECT_RECEIVE CONSTANT VARCHAR2(30) := 'CORRECT-RECEIVE';
9: CORRECT_RTV CONSTANT VARCHAR2(30) := 'CORRECT-RTV';

Line 12: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

8: CORRECT_RECEIVE CONSTANT VARCHAR2(30) := 'CORRECT-RECEIVE';
9: CORRECT_RTV CONSTANT VARCHAR2(30) := 'CORRECT-RTV';
10:
11: PROCEDURE get_location(
12: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
13: p_location_id OUT NOCOPY hr_locations_all.location_id%TYPE,
14: p_process_status OUT NOCOPY VARCHAR2,
15: p_process_message OUT NOCOPY VARCHAR2)
16: IS

Line 19: cp_transaction_type rcv_transactions.transaction_type%type)

15: p_process_message OUT NOCOPY VARCHAR2)
16: IS
17: CURSOR c_dlry_subinventory(cp_shipment_line_id IN NUMBER,
18: cp_receive_trx_id IN NUMBER,
19: cp_transaction_type rcv_transactions.transaction_type%type)
20: IS
21: SELECT subinventory
22: FROM rcv_transactions
23: WHERE shipment_line_id = cp_shipment_line_id

Line 22: FROM rcv_transactions

18: cp_receive_trx_id IN NUMBER,
19: cp_transaction_type rcv_transactions.transaction_type%type)
20: IS
21: SELECT subinventory
22: FROM rcv_transactions
23: WHERE shipment_line_id = cp_shipment_line_id
24: AND parent_transaction_id = cp_receive_trx_id
25: AND transaction_type = cp_transaction_type --'DELIVER' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
26: AND transaction_id > cp_receive_trx_id;

Line 47: lv_subinventory RCV_TRANSACTIONS.subinventory%TYPE;

43: r_parent_trx c_trx%ROWTYPE;
44: r_base_trx c_base_trx%ROWTYPE;
45: r_parent_base_trx c_base_trx%ROWTYPE;
46: r_ancestor_dtls c_base_trx%ROWTYPE;
47: lv_subinventory RCV_TRANSACTIONS.subinventory%TYPE;
48: ln_location_id NUMBER(15);
49: lv_required_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
50: ln_ancestor_trxn_id NUMBER(15);
51: r_subinv_dtls c_loc_linked_to_org_subinv%ROWTYPE;

Line 49: lv_required_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;

45: r_parent_base_trx c_base_trx%ROWTYPE;
46: r_ancestor_dtls c_base_trx%ROWTYPE;
47: lv_subinventory RCV_TRANSACTIONS.subinventory%TYPE;
48: ln_location_id NUMBER(15);
49: lv_required_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
50: ln_ancestor_trxn_id NUMBER(15);
51: r_subinv_dtls c_loc_linked_to_org_subinv%ROWTYPE;
52: ln_organization_id NUMBER(15);
53: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

Line 53: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;

49: lv_required_trx_type RCV_TRANSACTIONS.transaction_type%TYPE;
50: ln_ancestor_trxn_id NUMBER(15);
51: r_subinv_dtls c_loc_linked_to_org_subinv%ROWTYPE;
52: ln_organization_id NUMBER(15);
53: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
54: BEGIN
55: /*****************************************************************************************************************************************************************************************
56: Change History -
57: *****************************************************************************************************************************************************************************************

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 155: - Added a new condition to return from the procedure, if ja_in_rcv_transactions.process_vat_flag is 'SS'.

151: - Added new variable - r_installment_count
152: - In loop of cursor - cur_tax, after calling procedure - generate_term_schedules, added a delete statement
153: - In loop of cursor - cur_tax, after calling procedure - generate_term_schedules, added the code for
154: b) Following changes are done in procedure - process_vat
155: - Added a new condition to return from the procedure, if ja_in_rcv_transactions.process_vat_flag is 'SS'.
156: After this added the call to procedure - generate_schedule
157:
158: c) Following changes are done in procedure - process_claim
159: - Before call to procedure - jai_rgm_trx_recording_pkg.insert_vat_repository_entry, added the condition that

Line 359: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,

355: PROCEDURE generate_schedule(
356: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
357: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
358: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
359: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
360: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
361: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,
362: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
363: --p_simulate_flag IN VARCHAR2 DEFAULT 'N', --Added for Bug 4950914

Line 380: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

376: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
377: ORDER BY shipment_line_id;
378:
379: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
380: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
381: IS
382: SELECT transaction_id,
383: transaction_type,
384: transaction_date,

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 403: CURSOR cur_tax(cp_transaction_id IN rcv_transactions.transaction_id%TYPE,

399: )
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)),

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 653: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

649:
650: PROCEDURE insert_rcv_lines(
651: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
652: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
653: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
654: p_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE,
655: p_simulate_flag IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
656: p_process_status OUT NOCOPY VARCHAR2,
657: p_process_message OUT NOCOPY VARCHAR2)

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 933: || Need to check whether the ja_in_rcv_transactions has the excise_invoice_no and excise_invoice_Date stamped

929:
930: IF upper(lv_default_invoice_setup) in ( 'Y', 'YES') then
931:
932: /* Means - We can use the excise invoice number as vat invoice number and excise invoice date as vat invoice date
933: || Need to check whether the ja_in_rcv_transactions has the excise_invoice_no and excise_invoice_Date stamped
934: for the shipment line id .
935: */
936:
937: IF rec_lines.excise_invoice_no is not NULL THEN -- Bug# 6109941

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 1101: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

1097: p_process_message := SUBSTR(SQLERRM,1,200);
1098: END update_rcv_lines;
1099:
1100: PROCEDURE process_vat(
1101: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
1102: p_process_status OUT NOCOPY VARCHAR2,
1103: p_process_message OUT NOCOPY VARCHAR2)
1104: IS
1105: r_trx c_trx%ROWTYPE;

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 1117: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';

1113: lv_account_nature VARCHAR2(100); -- := 'VAT INTERIM';
1114: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1115: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1116: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1117: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1118: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1119: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1120: lv_destination VARCHAR2(10) ; -- := 'G';
1121: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);

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 1160: /*CURSOR cur_txn(cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

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
1162: SELECT currency_conversion_rate,
1163: quantity,
1164: DECODE(transaction_type, 'RECEIVE', 1, 'RETURN TO VENDOR', -1, 'CORRECT',

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 1219: lv_reference_24 := 'rcv_transactions';

1215: lv_account_nature := 'VAT INTERIM';
1216: lv_source_name := 'Purchasing India';
1217: lv_category_name := 'Receiving India';
1218: lv_reference_23 := 'jai_rgm_claim_pkg.process_vat';
1219: lv_reference_24 := 'rcv_transactions';
1220: lv_reference_25 := p_transaction_id;
1221: lv_reference_26 := 'transaction_id';
1222: lv_destination := 'G';
1223: ld_accounting_date := TRUNC(SYSDATE);

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 1941: || and viceversa Need to check whether the ja_in_rcv_transactions has the excise_invoice_no and excise_invoice_Date stamped

1937: pv_attribute_code => 'DEFAULT_INVOICE_DETAILS' ); --'DEFAULT_INVOICE_DETAILS');
1938: If upper(lv_default_invoice_setup) in ( 'Y', 'YES') then
1939:
1940: /* Means - We can use the excise invoice number as vat invoice number and excise invoice date as vat invoice date
1941: || and viceversa Need to check whether the ja_in_rcv_transactions has the excise_invoice_no and excise_invoice_Date stamped
1942: for the shipment line id .
1943: */
1944:
1945: IF rec_claims.invoice_no is not NULL and r_vat_invoice.excise_invoice_no is null THEN

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 2071: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */

2067: pn_organization_id => rec_claims.organization_id,
2068: pn_location_id => rec_claims.location_id,
2069: pv_source => jai_constants.source_rcv,
2070: pv_source_trx_type => lv_source_trx_type,
2071: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
2072: pn_source_id => nvl(r_vat_invoice.tax_transaction_id, r_vat_invoice.transaction_id), /* r_claim_schedule.claim_schedule_id, Vijay */
2073: pd_transaction_date => trunc(sysdate),
2074: pv_account_name => lv_account_name,
2075: pn_charge_account_id => ln_code_combination_id,

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 2789: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

2785:
2786: PROCEDURE do_rtv_accounting(
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,

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 2796: CURSOR c_total_vat_amount(cp_transaction_id IN rcv_transactions.transaction_id%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)
2797: IS
2798: SELECT b.organization_id,
2799: b.location_id,
2800: b.receipt_num,

Line 2825: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,

2821: AND claimed_date IS NOT NULL;
2822:
2823: CURSOR c_total_reversal_amount(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2824: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2825: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
2826: cp_tax_type IN VARCHAR2,
2827: cp_installment_no IN NUMBER)
2828: IS
2829: SELECT (NVL(SUM(installment_amount),0) - NVL(SUM(claimed_amount),0))*-1 installment_amount

Line 2853: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,

2849: --AND regime_code = NVL(cp_regime_code, regime_code);
2850:
2851: CURSOR c_claim_schedule(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
2852: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
2853: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
2854: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE)
2855: IS
2856: SELECT MIN(claim_schedule_id) claim_schedule_id
2857: FROM jai_rcv_rgm_claims

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 3148: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */

3144: pn_organization_id => rec_taxes.organization_id,
3145: pn_location_id => rec_taxes.location_id,
3146: pv_source => jai_constants.source_rcv,
3147: pv_source_trx_type => 'VAT CLAIM',
3148: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3149: pn_source_id => p_transaction_id, /* r_claim_schedule.claim_schedule_id, Vijay */
3150: pd_transaction_date => trunc(sysdate),
3151: pv_account_name => jai_constants.recovery,
3152: pn_charge_account_id => ln_rec_ccid,

Line 3208: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */

3204: pn_organization_id => rec_taxes.organization_id,
3205: pn_location_id => rec_taxes.location_id,
3206: pv_source => jai_constants.source_rcv,
3207: pv_source_trx_type => 'VAT CLAIM for RTV',
3208: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3209: pn_source_id => nvl(r_trx.tax_transaction_id, p_transaction_id), /* r_claim_schedule.claim_schedule_id, Vijay*/
3210: pd_transaction_date => TRUNC(SYSDATE),
3211: pv_account_name => jai_constants.recovery,
3212: pn_charge_account_id => ln_rec_ccid,

Line 3266: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

3262: p_process_message := 'Stmt :'||ln_statement_id||' '||SUBSTR(SQLERRM,1,200);
3263: END do_rtv_accounting;
3264:
3265: PROCEDURE do_rma_accounting(
3266: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
3267: p_process_status OUT NOCOPY VARCHAR2,
3268: p_process_message OUT NOCOPY VARCHAR2)
3269: IS
3270:

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 3309: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';

3305: lv_account_nature VARCHAR2(100) ; -- := 'Receiving';
3306: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3307: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3308: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3309: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3310: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3311: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3312: lv_destination VARCHAR2(10) ; -- := 'G';
3313: /* End of File.Sql.35 by Brathod */

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;

Line 3336: lv_reference_24 := 'rcv_transactions';

3332: lv_account_nature := 'Receiving';
3333: lv_source_name := 'Purchasing India';
3334: lv_category_name := 'Receiving India';
3335: lv_reference_23 := 'jai_rgm_claim_pkg.do_rma_accounting';
3336: lv_reference_24 := 'rcv_transactions';
3337: lv_reference_25 := p_transaction_id;
3338: lv_reference_26 := 'transaction_id';
3339: lv_destination := 'G';
3340: /* End of File.Sql.35 by Brathod */