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.29.12020000.2 2013/01/30 03:23:50 vkaranam 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 428: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,

424: PROCEDURE generate_schedule(
425: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
426: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
427: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
428: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
429: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
430: p_tax_id IN JAI_CMN_TAXES_ALL.tax_id%TYPE DEFAULT NULL,
431: p_override IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
432: --p_simulate_flag IN VARCHAR2 DEFAULT 'N', --Added for Bug 4950914

Line 449: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)

445: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
446: ORDER BY shipment_line_id;
447:
448: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
449: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
450: IS
451: SELECT transaction_id,
452: transaction_type,
453: transaction_date,

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

468: )
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

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

719:
720: PROCEDURE insert_rcv_lines(
721: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
722: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
723: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
724: p_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE,
725: p_simulate_flag IN VARCHAR2, --File.Sql.35 Cbabu DEFAULT 'N',
726: p_process_status OUT NOCOPY VARCHAR2,
727: p_process_message OUT NOCOPY VARCHAR2)

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

999:
1000: IF upper(lv_default_invoice_setup) in ( 'Y', 'YES') then
1001:
1002: /* Means - We can use the excise invoice number as vat invoice number and excise invoice date as vat invoice date
1003: || Need to check whether the ja_in_rcv_transactions has the excise_invoice_no and excise_invoice_Date stamped
1004: for the shipment line id .
1005: */
1006:
1007: IF rec_lines.excise_invoice_no is not NULL THEN -- Bug# 6109941

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

1168: p_process_message := SUBSTR(SQLERRM,1,200);
1169: END update_rcv_lines;
1170:
1171: PROCEDURE process_vat(
1172: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
1173: p_process_status OUT NOCOPY VARCHAR2,
1174: p_process_message OUT NOCOPY VARCHAR2)
1175: IS
1176: r_trx c_trx%ROWTYPE;

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

1184: lv_account_nature VARCHAR2(100); -- := 'VAT INTERIM';
1185: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1186: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1187: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1188: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1189: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1190: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1191: lv_destination VARCHAR2(10) ; -- := 'G';
1192: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);

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

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
1233: SELECT currency_conversion_rate,
1234: quantity,
1235: DECODE(transaction_type, 'RECEIVE', 1, 'RETURN TO VENDOR', -1, 'CORRECT',

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

1286: lv_account_nature := 'VAT INTERIM';
1287: lv_source_name := 'Purchasing India';
1288: lv_category_name := 'Receiving India';
1289: lv_reference_23 := 'jai_rgm_claim_pkg.process_vat';
1290: lv_reference_24 := 'rcv_transactions';
1291: lv_reference_25 := p_transaction_id;
1292: lv_reference_26 := 'transaction_id';
1293: lv_destination := 'G';
1294: ld_accounting_date := TRUNC(SYSDATE);

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

2009: pv_attribute_code => 'DEFAULT_INVOICE_DETAILS' ); --'DEFAULT_INVOICE_DETAILS');
2010: If upper(lv_default_invoice_setup) in ( 'Y', 'YES') then
2011:
2012: /* Means - We can use the excise invoice number as vat invoice number and excise invoice date as vat invoice date
2013: || and viceversa Need to check whether the ja_in_rcv_transactions has the excise_invoice_no and excise_invoice_Date stamped
2014: for the shipment line id .
2015: */
2016:
2017: IF rec_claims.invoice_no is not NULL and r_vat_invoice.excise_invoice_no is null THEN

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

2140: pn_organization_id => rec_claims.organization_id,
2141: pn_location_id => rec_claims.location_id,
2142: pv_source => jai_constants.source_rcv,
2143: pv_source_trx_type => lv_source_trx_type,
2144: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
2145: pn_source_id => nvl(r_vat_invoice.tax_transaction_id, r_vat_invoice.transaction_id), /* r_claim_schedule.claim_schedule_id, Vijay */
2146: pd_transaction_date => nvl(ld_accounting_date,trunc(sysdate)),--14061440
2147: pv_account_name => lv_account_name,
2148: pn_charge_account_id => ln_code_combination_id,

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 2864: from rcv_transactions

2860: CLOSE cur_check_projects;
2861:
2862: IF nvl(ln_check_projects,0) = 1 THEN
2863: FOR rec_get_rcv_trxs IN ( SELECT transaction_id
2864: from rcv_transactions
2865: WHERE shipment_header_id = r_shipment_lines.shipment_header_id
2866: AND shipment_line_id = r_shipment_lines.shipment_line_id
2867: AND TRANSACTION_TYPE = 'RECEIVE')
2868: LOOP

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

2998:
2999: PROCEDURE do_rtv_accounting(
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,

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 3009: CURSOR c_total_vat_amount(cp_transaction_id IN rcv_transactions.transaction_id%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)
3010: IS
3011: SELECT b.organization_id,
3012: b.location_id,
3013: b.receipt_num,

Line 3038: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,

3034: AND claimed_date IS NOT NULL;
3035:
3036: CURSOR c_total_reversal_amount(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
3037: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
3038: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
3039: cp_tax_type IN VARCHAR2,
3040: cp_installment_no IN NUMBER)
3041: IS
3042: SELECT (NVL(SUM(installment_amount),0) - NVL(SUM(claimed_amount),0))*-1 installment_amount

Line 3066: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,

3062: --AND regime_code = NVL(cp_regime_code, regime_code);
3063:
3064: CURSOR c_claim_schedule(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
3065: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
3066: cp_transaction_id IN rcv_transactions.transaction_id%TYPE,
3067: cp_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE)
3068: IS
3069: SELECT MIN(claim_schedule_id) claim_schedule_id
3070: FROM jai_rcv_rgm_claims

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

3378: pn_organization_id => rec_taxes.organization_id,
3379: pn_location_id => rec_taxes.location_id,
3380: pv_source => jai_constants.source_rcv,
3381: pv_source_trx_type => 'VAT CLAIM',
3382: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3383: pn_source_id => p_transaction_id, /* r_claim_schedule.claim_schedule_id, Vijay */
3384: pd_transaction_date => trunc(sysdate),
3385: pv_account_name => jai_constants.recovery,
3386: -- pn_charge_account_id => ln_rec_ccid,

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

3446: pn_organization_id => rec_taxes.organization_id,
3447: pn_location_id => rec_taxes.location_id,
3448: pv_source => jai_constants.source_rcv,
3449: pv_source_trx_type => 'VAT CLAIM for RTV',
3450: pv_source_table_name => TABLE_RCV_TRANSACTIONS, /* 'JAI_RCV_RGM_CLAIMS', Vijay */
3451: pn_source_id => nvl(r_trx.tax_transaction_id, p_transaction_id), /* r_claim_schedule.claim_schedule_id, Vijay*/
3452: pd_transaction_date => TRUNC(SYSDATE),
3453: pv_account_name => jai_constants.recovery,
3454: pn_charge_account_id => ln_rec_ccid,

Line 3513: p_transaction_id IN rcv_transactions.transaction_id%TYPE,

3509: p_process_message := 'Stmt :'||ln_statement_id||' '||SUBSTR(SQLERRM,1,200);
3510: END do_rtv_accounting;
3511:
3512: PROCEDURE do_rma_accounting(
3513: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
3514: p_process_status OUT NOCOPY VARCHAR2,
3515: p_process_message OUT NOCOPY VARCHAR2)
3516: IS
3517:

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 3551: rcv_transactions rt

3547: -- Added by JMEENA for bug#8302581
3548: Cursor get_item_id(p_transaction_id NUMBER) IS
3549: SELECT item_id
3550: FROM rcv_shipment_lines rsl,
3551: rcv_transactions rt
3552: WHERE rsl.shipment_line_id = rt.shipment_line_id
3553: AND rt.transaction_id = p_transaction_id;
3554:
3555: lv_item_id NUMBER;

Line 3571: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';

3567: lv_account_nature VARCHAR2(100) ; -- := 'Receiving';
3568: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3569: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3570: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3571: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3572: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3573: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3574: lv_destination VARCHAR2(10) ; -- := 'G';
3575: /* End of File.Sql.35 by Brathod */

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;

Line 3598: lv_reference_24 := 'rcv_transactions';

3594: lv_account_nature := 'Receiving';
3595: lv_source_name := 'Purchasing India';
3596: lv_category_name := 'Receiving India';
3597: lv_reference_23 := 'jai_rgm_claim_pkg.do_rma_accounting';
3598: lv_reference_24 := 'rcv_transactions';
3599: lv_reference_25 := p_transaction_id;
3600: lv_reference_26 := 'transaction_id';
3601: lv_destination := 'G';
3602: /* End of File.Sql.35 by Brathod */