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_DELIVER_RTR_PKG dependencies on RCV_TRANSACTIONS

Line 50: - started passing the value to newly added parameter by fetching the value from JAI_RCV_TRANSACTIONS table

46:
47: 8 17/03/2005 Vijay Shankar for Bug#4229164, FileVersion:115.7
48: Modified the code in jai_rcv_deliver_rtr_pkg.opm_costing procedure to consider currency rate also which is passed as parameter to the procedure.
49: - Added a new parameter p_currency_conversion_rate to jai_rcv_deliver_rtr_pkg.opm_costing procedure
50: - started passing the value to newly added parameter by fetching the value from JAI_RCV_TRANSACTIONS table
51:
52: 9 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.8
53: modified the procedures to support the functinoality of "VAT UNCLAIM" in similar lines to "CENVAT UNCLAIM".
54: This would be called from jai_rcv_rgm_claims_pkg incase of VAT NOCLAIM selected by user for a receipt line incase

Line 116: 19. 15-Apr_2010 Bo Li For bug9305067 Replace the old attribute_category columns for JAI_RCV_TRANSACTIONS

112: 18. 06-04-2009 FP 12.0: 7539200:RECEIVING AND DELIVERY ACC VISIBLE FROM LOCALISATION SCREEN
113: Fix details: Commented the code which inserts accounting
114: entries in jai_rcv_journal_entries for OPM costing
115:
116: 19. 15-Apr_2010 Bo Li For bug9305067 Replace the old attribute_category columns for JAI_RCV_TRANSACTIONS
117: with new meaningful one
118: 26-nov-2010 Bug 10335708
119: Description : Cenvat credit should be claimable, even if the items are delivered
120: to EXPENSE (not tracked as Inventory). Also, the quantity register should be updated

Line 145: FROM JAI_RCV_TRANSACTIONS

141:
142: /* Cursor Definitions */
143: CURSOR c_trx(cp_transaction_id IN NUMBER) IS
144: SELECT *
145: FROM JAI_RCV_TRANSACTIONS
146: WHERE transaction_id = cp_transaction_id;
147:
148: CURSOR c_base_line_dtls(cp_transaction_id IN NUMBER) IS
149: SELECT quantity, unit_of_measure, source_doc_unit_of_measure, source_doc_quantity

Line 150: from rcv_transactions

146: WHERE transaction_id = cp_transaction_id;
147:
148: CURSOR c_base_line_dtls(cp_transaction_id IN NUMBER) IS
149: SELECT quantity, unit_of_measure, source_doc_unit_of_measure, source_doc_quantity
150: from rcv_transactions
151: where transaction_id = cp_transaction_id;
152:
153: CURSOR c_rcv_trx(cp_transaction_id IN NUMBER) IS
154: SELECT *

Line 155: FROM rcv_transactions

151: where transaction_id = cp_transaction_id;
152:
153: CURSOR c_rcv_trx(cp_transaction_id IN NUMBER) IS
154: SELECT *
155: FROM rcv_transactions
156: where transaction_id = cp_transaction_id;
157:
158: CURSOR c_mtl_trx(cp_organization_id IN NUMBER) IS
159: /* Bug 4941701. Added by Lakshmi Gopalsami

Line 184: lv_destination_type rcv_transactions.destination_type_code%type;

180: lv_statement_id VARCHAR2(4);
181: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
182: lv_accounting_type VARCHAR2(30);
183: lv_include_cenvat_in_costing VARCHAR2(1);
184: lv_destination_type rcv_transactions.destination_type_code%type;
185:
186:
187: /* Number Declarations */
188: ln_apportion_factor NUMBER; --File.Sql.35 Cbabu := 1; -- default value added by Vijay Shankar for Bug#4068823 for RECEIPTS DEPLUG

Line 195: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;

191: ln_other_modvat_amount NUMBER; --File.Sql.35 Cbabu := 0;
192: ln_total NUMBER; --File.Sql.35 Cbabu := 0;
193: ln_opm_total NUMBER; --File.Sql.35 Cbabu := 0;
194: ln_receiving_account_id rcv_parameters.receiving_account_id%type;
195: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
196:
197: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
198: lv_temp VARCHAR2(50);
199:

Line 197: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;

193: ln_opm_total NUMBER; --File.Sql.35 Cbabu := 0;
194: ln_receiving_account_id rcv_parameters.receiving_account_id%type;
195: ln_dlry_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
196:
197: ln_receive_trx_id JAI_RCV_TRANSACTIONS.transaction_id%type;
198: lv_temp VARCHAR2(50);
199:
200: lv_cenvat_costed_flag VARCHAR2(15);
201:

Line 219: /* Fetch all the information from JAI_RCV_TRANSACTIONS */

215: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));
216:
217: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */
218:
219: /* Fetch all the information from JAI_RCV_TRANSACTIONS */
220: OPEN c_trx(p_transaction_id);
221: FETCH c_trx INTO r_trx;
222: CLOSE c_trx;
223:

Line 236: /* Fetch all the information from rcv_transactions for transaction type RECEIVE*/

232: p_required_trx_type => 'RECEIVE'
233: );
234: */
235:
236: /* Fetch all the information from rcv_transactions for transaction type RECEIVE*/
237: OPEN c_base_line_dtls(ln_receive_trx_id);
238: FETCH c_base_line_dtls INTO r_base_line_dtls;
239: CLOSE c_base_line_dtls;
240:

Line 245: p_process_message := 'The Quantity in rcv_transactions for RECEIVE line is Zero';

241: lv_statement_id := '2';
242: if r_base_line_dtls.quantity = 0 THEN
243: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
244: p_process_status := 'E';
245: p_process_message := 'The Quantity in rcv_transactions for RECEIVE line is Zero';
246: goto exit_from_procedure;
247: end if;
248:
249: --p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */

Line 252: /* Fetch the information of certain columns which are not present in JAI_RCV_TRANSACTIONS */

248:
249: --p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
250: --lv_statement_id := '2.1';
251:
252: /* Fetch the information of certain columns which are not present in JAI_RCV_TRANSACTIONS */
253: OPEN c_rcv_trx(p_transaction_id);
254: FETCH c_rcv_trx into r_rcv_trx;
255: CLOSE c_rcv_trx;
256:

Line 667: /*jai_rcv_transactions_pkg.update_attributes(

663: p_codepath := jai_general_pkg.plot_codepath(35, p_codepath);
664:
665: --Modified by Bo Li for replacing the update_attributes with update_cenvat_costed_flag Begin
666: --------------------------------------------------------------------------------------------
667: /*jai_rcv_transactions_pkg.update_attributes(
668: p_transaction_id => p_transaction_id,
669: p_attribute1 => jai_rcv_deliver_rtr_pkg.cenvat_costed_flag,
670: p_attribute2 => lv_cenvat_costed_flag
671: );*/

Line 673: jai_rcv_transactions_pkg.update_cenvat_costed_flag(

669: p_attribute1 => jai_rcv_deliver_rtr_pkg.cenvat_costed_flag,
670: p_attribute2 => lv_cenvat_costed_flag
671: );*/
672:
673: jai_rcv_transactions_pkg.update_cenvat_costed_flag(
674: p_transaction_id => p_transaction_id,
675: p_cenvat_costed_flag => lv_cenvat_costed_flag
676: );
677: --------------------------------------------------------------------------------------------

Line 739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';

735: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
736: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
737: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
738: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
740: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';
741:
742: ln_individual_tax_amount number;--File.Sql.35 Cbabu := 0;
743: ln_rec_account_tax_amount number;--File.Sql.35 Cbabu := 0;

Line 755: lv_reference24 := 'rcv_transactions';

751: lv_reference_10_desc2 := ' For the Transaction Type ';
752: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
753: lv_source := 'Purchasing India';
754: lv_category := 'Receiving India';
755: lv_reference24 := 'rcv_transactions';
756: lv_reference25 := 'transaction_id';
757: ln_individual_tax_amount := 0;
758: ln_rec_account_tax_amount := 0;
759:

Line 964: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is

960: lv_tax_modvat_flag JAI_RCV_LINE_TAXES.modvat_flag%type;
961: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
962: ln_tax_amount NUMBER ; /* Added for bug #13494816 */
963:
964: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is
965: select item_trading_flag,organization_type,excise_in_trading,item_excisable
966: from JAI_RCV_TRANSACTIONS
967: where transaction_id = cp_transaction_id;
968:

Line 966: from JAI_RCV_TRANSACTIONS

962: ln_tax_amount NUMBER ; /* Added for bug #13494816 */
963:
964: cursor c_ja_in_rcv_transactions(cp_transaction_id number) is
965: select item_trading_flag,organization_type,excise_in_trading,item_excisable
966: from JAI_RCV_TRANSACTIONS
967: where transaction_id = cp_transaction_id;
968:
969: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
970:

Line 969: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;

965: select item_trading_flag,organization_type,excise_in_trading,item_excisable
966: from JAI_RCV_TRANSACTIONS
967: where transaction_id = cp_transaction_id;
968:
969: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
970:
971: BEGIN
972:
973: --File.Sql.35 Cbabu

Line 981: OPEN c_ja_in_rcv_transactions(p_transaction_id);

977: lv_debug := 'Y';
978:
979: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.get_tax_amount_breakup' , 'START'); /* 1 */
980:
981: OPEN c_ja_in_rcv_transactions(p_transaction_id);
982: FETCH c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
983: CLOSE c_ja_in_rcv_transactions;
984:
985: FOR tax_rec IN

Line 982: FETCH c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;

978:
979: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.get_tax_amount_breakup' , 'START'); /* 1 */
980:
981: OPEN c_ja_in_rcv_transactions(p_transaction_id);
982: FETCH c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
983: CLOSE c_ja_in_rcv_transactions;
984:
985: FOR tax_rec IN
986: (

Line 983: CLOSE c_ja_in_rcv_transactions;

979: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.get_tax_amount_breakup' , 'START'); /* 1 */
980:
981: OPEN c_ja_in_rcv_transactions(p_transaction_id);
982: FETCH c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
983: CLOSE c_ja_in_rcv_transactions;
984:
985: FOR tax_rec IN
986: (
987: SELECT

Line 1062: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */

1058: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1059: lv_tax_modvat_flag := 'Y';
1060:
1061: elsif tax_rec.modvat_flag = 'N'
1062: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
1063: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
1064: and r_ja_in_rcv_transactions.item_excisable = 'Y'
1065: and r_ja_in_rcv_transactions.organization_type = 'T'
1066: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',

Line 1063: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'

1059: lv_tax_modvat_flag := 'Y';
1060:
1061: elsif tax_rec.modvat_flag = 'N'
1062: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
1063: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
1064: and r_ja_in_rcv_transactions.item_excisable = 'Y'
1065: and r_ja_in_rcv_transactions.organization_type = 'T'
1066: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1067: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI

Line 1064: and r_ja_in_rcv_transactions.item_excisable = 'Y'

1060:
1061: elsif tax_rec.modvat_flag = 'N'
1062: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
1063: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
1064: and r_ja_in_rcv_transactions.item_excisable = 'Y'
1065: and r_ja_in_rcv_transactions.organization_type = 'T'
1066: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1067: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1068: jai_constants.tax_type_exc_edu_cess,

Line 1065: and r_ja_in_rcv_transactions.organization_type = 'T'

1061: elsif tax_rec.modvat_flag = 'N'
1062: and r_ja_in_rcv_transactions.item_trading_flag = 'Y' /* Excise IN RG23D scenario */
1063: and r_ja_in_rcv_transactions.excise_in_trading = 'Y'
1064: and r_ja_in_rcv_transactions.item_excisable = 'Y'
1065: and r_ja_in_rcv_transactions.organization_type = 'T'
1066: and upper(tax_rec.tax_type) IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE', 'CVD',
1067: jai_constants.tax_type_add_cvd , -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1068: jai_constants.tax_type_exc_edu_cess,
1069: jai_constants.tax_type_cvd_edu_cess, -- Vijay Shankar for Bug#4068823 EDUCATION CESS

Line 1247: ln_rcv_quantity rcv_transactions.quantity%TYPE;

1243: /* following parameter added by Vijay Shankar for Bug#4229164 */
1244: p_currency_conversion_rate IN NUMBER
1245: ) IS
1246:
1247: ln_rcv_quantity rcv_transactions.quantity%TYPE;
1248: ln_material_account_id mtl_secondary_inventories.material_account%type;
1249: ln_costing_amount NUMBER;
1250:
1251: lv_accounting_type varchar2(30); --File.Sql.35 Cbabu := 'REGULAR'; /*Hard coded as Localization does not do anything in case of a RTR Transaction */

Line 1272: Only JAI_RCV_JOURNAL_ENTRIES is recorded with above entries But RCV_TRANSACTIONS will be updated only

1268: | DELIVER | Total | Inv.Receiving | |
1269: | DELIVER | Total | | Material Account |
1270: ----------------|-----------------------|---------------------------|--------------------------|
1271:
1272: Only JAI_RCV_JOURNAL_ENTRIES is recorded with above entries But RCV_TRANSACTIONS will be updated only
1273: once.
1274: */
1275:
1276: BEGIN

Line 1286: source doc quantity of RCV_TRANSACTIONS needs to be picked up

1282:
1283: /* This comparison is for Evaluating the Quantity */
1284: /* Meaning of this comparison
1285: if the Unit Of Measure is changed while RECEIVING then
1286: source doc quantity of RCV_TRANSACTIONS needs to be picked up
1287: otherwise
1288: the Quantity of RCV_TRANSACTIONS can be picked up.
1289: */
1290:

Line 1288: the Quantity of RCV_TRANSACTIONS can be picked up.

1284: /* Meaning of this comparison
1285: if the Unit Of Measure is changed while RECEIVING then
1286: source doc quantity of RCV_TRANSACTIONS needs to be picked up
1287: otherwise
1288: the Quantity of RCV_TRANSACTIONS can be picked up.
1289: */
1290:
1291: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.opm_costing', 'START'); /* 1 */
1292:

Line 1351: and also rcv_transactions would be updated */

1347: );
1348: end if;
1349:
1350: /* Destination in this case is O1, which indicates that the JAI_RCV_JOURNAL_ENTRIES would be hit
1351: and also rcv_transactions would be updated */
1352: /* Credit Inventory Receiving Account */
1353: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1354:
1355:

Line 1397: and also rcv_transactions would be updated */

1393: end if;
1394:
1395: /* Debit Material Account
1396: Destination in this case is O1, which indicates that the JAI_RCV_JOURNAL_ENTRIES would be hit
1397: and also rcv_transactions would be updated */
1398:
1399: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1400:
1401: /*

Line 1497: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';

1493: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Expense Accounting';
1494: lv_source VARCHAR2(100); --File.Sql.35 Cbabu := 'Purchasing India';
1495: lv_category VARCHAR2(100); --File.Sql.35 Cbabu := 'Receiving India';
1496: lv_reference23 gl_interface.reference23%type; --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1497: lv_reference24 gl_interface.reference24%type; --File.Sql.35 Cbabu := 'rcv_transactions';
1498: lv_reference25 gl_interface.reference25%type; --File.Sql.35 Cbabu := 'transaction_id';
1499: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
1500: lv_reference_10_desc1 VARCHAR2(75); --File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
1501: lv_reference_10_desc2 VARCHAR2(30); --File.Sql.35 Cbabu := ' For the Transaction Type ';

Line 1515: lv_reference24 := 'rcv_transactions';

1511: lv_account_nature := 'Expense Accounting';
1512: lv_source := 'Purchasing India';
1513: lv_category := 'Receiving India';
1514: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.expense_accounting';
1515: lv_reference24 := 'rcv_transactions';
1516: lv_reference25 := 'transaction_id';
1517: lv_debug := 'Y';
1518: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';
1519: lv_reference_10_desc2 := ' For the Transaction Type ';

Line 1928: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;

1924: lv_category VARCHAR2(30); --File.Sql.35 Cbabu := 'MTL';
1925: lv_account_nature VARCHAR2(30); --File.Sql.35 Cbabu := 'Standard Costing';
1926: --lv_debug varchar2(1) := 'Y';
1927:
1928: --lv_transaction_type JAI_RCV_TRANSACTIONS.transaction_type%TYPE;
1929: lv_reference_10_desc1 VARCHAR2(75);--rchandan for bug#4473022
1930: lv_reference_10_desc2 VARCHAR2(30); --rchandan for bug#4473022
1931: lv_reference_10_desc gl_interface.reference10%type;--rchandan for bug#4473022
1932:

Line 1998: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

1994: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1995: p_accounting_date => p_transaction_date,
1996: p_reference_10 => NULL,
1997: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1998: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
1999: p_reference_25 => NULL,
2000: p_reference_26 => to_char(p_transaction_id),
2001: p_destination => 'S', /*Indicates Standard Costing. */
2002: p_simulate_flag => p_simulate,

Line 2046: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

2042: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
2043: p_accounting_date => p_transaction_date,
2044: p_reference_10 => NULL,
2045: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
2046: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022
2047: p_reference_25 => NULL,
2048: p_reference_26 => to_char(p_transaction_id),
2049: p_destination => 'S', /*Indicates Standard Costing. */
2050: p_simulate_flag => p_simulate,

Line 2398: lv_loc_subinv_type JAI_RCV_TRANSACTIONS.loc_subinv_type%type;

2394: lv_ret_value VARCHAR2(30);
2395:
2396: lv_destination_type varchar2(30);
2397: lv_transaction_type varchar2(30);
2398: lv_loc_subinv_type JAI_RCV_TRANSACTIONS.loc_subinv_type%type;
2399: lv_debug varchar2(1);--File.Sql.35 Cbabu := 'Y';
2400: lv_include_cenvat_in_costing varchar2(1);
2401:
2402: ln_dlry_trx_id NUMBER;

Line 2413: FROM JAI_RCV_TRANSACTIONS

2409: WHERE transaction_id = cp_transaction_id;
2410:
2411: CURSOR c_trx(cp_transaction_id number) is
2412: SELECT *
2413: FROM JAI_RCV_TRANSACTIONS
2414: WHERE transaction_id = cp_transaction_id;
2415:
2416: r_trx c_trx%ROWTYPE;
2417: r_dlry_trx c_trx%ROWTYPE;

Line 2600: (r_trx IN jai_rcv_transactions%ROWTYPE,

2596: end include_cenvat_in_costing;
2597: /*procedures added for bug 10335708*/
2598:
2599: PROCEDURE pr_issue_auto_trans
2600: (r_trx IN jai_rcv_transactions%ROWTYPE,
2601: pn_transaction_id IN NUMBER,
2602: p_rg23_entry IN NUMBER,
2603: p_rg_i_entry IN NUMBER,
2604: p_process_status OUT NOCOPY VARCHAR2,

Line 2609: lv_transaction_type jai_rcv_transactions.transaction_type%TYPE;

2605: p_process_message OUT NOCOPY VARCHAR2)
2606: IS
2607: PRAGMA autonomous_transaction;
2608: ln_register_id NUMBER;
2609: lv_transaction_type jai_rcv_transactions.transaction_type%TYPE;
2610: ln_quantity NUMBER;
2611: lv_slno NUMBER;
2612:
2613: BEGIN

Line 2752: FROM jai_rcv_transactions

2748: IS
2749:
2750: CURSOR c_trx IS
2751: SELECT *
2752: FROM jai_rcv_transactions
2753: WHERE transaction_id = pn_transaction_id;
2754:
2755: CURSOR c_rg23_i_entry (cp_transaction_id NUMBER) IS
2756: SELECT 1