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

Line 1000: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt

996: jrl.tax_type tax_type,
997: jrl.modvat_flag,
998: jrl.tax_line_no tax_line_no --modified by kunkumar for bug 5593895
999: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
1000: FROM JAI_RCV_LINE_TAXES jrl,rcv_shipment_lines rsl,rcv_transactions rt
1001: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1002: AND rt.shipment_line_id = rsl.shipment_line_id
1003: AND rt.transaction_id = tran_id
1004: AND jrl.vendor_id = ven_id

Line 1036: , RCV_TRANSACTIONS RT

1032:
1033: FROM
1034: JAI_RCV_LINE_TAXES jrl
1035: , RCV_SHIPMENT_LINES RSL
1036: , RCV_TRANSACTIONS RT
1037: , jai_cmn_taxes_all jcta
1038: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1039: AND rt.shipment_line_id = rsl.shipment_line_id
1040: AND rt.transaction_id = tran_id

Line 1082: , rcv_transactions rt

1078: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12697697
1079: FROM
1080: jai_rcv_line_taxes jrl
1081: , rcv_shipment_lines rsl
1082: , rcv_transactions rt
1083: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
1084: WHERE jrl.shipment_line_id = rsl.shipment_line_id
1085: AND rt.shipment_line_id = rsl.shipment_line_id
1086: AND rt.transaction_id = tran_id

Line 1118: , rcv_transactions rt

1114: ,nvl(jcta.adhoc_flag,'N') ADHOC_FLAG --12697697
1115: FROM
1116: jai_retro_tax_changes jrl
1117: , rcv_shipment_lines rsl
1118: , rcv_transactions rt
1119: , jai_retro_line_changes jrlc
1120: , jai_cmn_taxes_all jcta
1121: WHERE jrlc.doc_line_id = rsl.shipment_line_id
1122: AND jrlc.line_change_id = jrl.line_change_id

Line 1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,

1279: AND sysdate between ja.start_date and ja.end_date;
1280:
1281:
1282:
1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308

Line 1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308

1280:
1281:
1282:
1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is

Line 1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308

1281:
1282:
1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag

Line 1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308

1282:
1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag
1290: from jai_rcv_transactions jrcvt

Line 1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308

1283: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1284: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
1285: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag
1290: from jai_rcv_transactions jrcvt
1291: where jrcvt.parent_transaction_id = cp_rcv_transaction_id

Line 1290: from jai_rcv_transactions jrcvt

1286: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
1287: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
1288: is
1289: select attribute2 excise_costing_flag
1290: from jai_rcv_transactions jrcvt
1291: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
1292: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
1293: and jrcvt.shipment_header_id = cp_shipment_header_id --Added by Bgowrava for Bug#7503308
1294: and jrcvt.transaction_type = cp_txn_type --'DELIVER' --Modified by Bgowrava for Bug#7503308

Line 1304: cursor c_rcv_transactions(p_transaction_id number) is

1300: -- Bug 5401111. Added by Lakshmi Gopalsami
1301: lv_account_type gl_code_combinations.account_type%TYPE;
1302:
1303: /* Service Tax */
1304: cursor c_rcv_transactions(p_transaction_id number) is
1305: select po_line_id, organization_id
1306: from rcv_transactions
1307: where transaction_id = p_transaction_id;
1308:

Line 1306: from rcv_transactions

1302:
1303: /* Service Tax */
1304: cursor c_rcv_transactions(p_transaction_id number) is
1305: select po_line_id, organization_id
1306: from rcv_transactions
1307: where transaction_id = p_transaction_id;
1308:
1309:
1310: cursor c_po_lines_all(p_po_line_id number) is

Line 1335: r_rcv_transactions c_rcv_transactions%rowtype;

1331: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
1332: and attribute_code = cp_tax_type;
1333:
1334:
1335: r_rcv_transactions c_rcv_transactions%rowtype;
1336: r_po_lines_all c_po_lines_all%rowtype;
1337: r_jai_regimes c_jai_regimes%rowtype;
1338: r_service_regime_tax_type c_regime_tax_type%rowtype;
1339: lv_is_item_an_expense varchar2(20); /* Service */

Line 1679: Populate the po distribution id and rcv_transactions id for the tax

1675: Added the Fnd_File.put_line(Fnd_File.LOG,'') statements to
1676: generate the log also.
1677:
1678: 9. 09/10/2002 Aparajita for bug # 2483164 Version#615.1
1679: Populate the po distribution id and rcv_transactions id for the tax
1680: lines for backtracking tax to purchasing side.
1681:
1682:
1683: 10. 03/11/2002 Aparajita for bug # 2567799 Version#615.2

Line 1726: line location id from rcv_transactions to get the price.

1722: Added code to compare the above prices and apportion the calculated
1723: tax in case of change.
1724:
1725: Used the cursor for_line_qty in case of receipt matching with the
1726: line location id from rcv_transactions to get the price.
1727: Price of a receipt cannot be changed, so same as po price.
1728: Logic of apportioning was also added in receipt matching cases.
1729:
1730: 14 31/01/2003 Aparajita for bug # 2775043. Version # 615.6

Line 1935: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.

1931:
1932: 38 08/07/2004 Aparajita for bug#3752887. Version#115.3. Clean up.
1933:
1934: Function apportion_tax_pay_on_rect_f was considering the quantity
1935: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.
1936: This fails when there have been corrections as taxes are modified as
1937: per the corrected quantity.
1938:
1939: Cleaned the entire logic of apportioning of tax from PO to AP.

Line 2067: Reason: full table scan on JAI_RCV_TRANSACTIONS table in cursor c_get_excise_costing_flag

2063: based on v_assets_tracking_flag and removed the condition of account_type.
2064:
2065: 57. 12-Dec-2008 Added by Bgowrava for Bug#7503308, File Version 120.7.12000000.15, 120.34.12010000.4, 120.38
2066: Issue: INDIA - TO INSERT TAXES FOR PAY ON RECEIPT REQUESTPERFORMANCE ISSUE
2067: Reason: full table scan on JAI_RCV_TRANSACTIONS table in cursor c_get_excise_costing_flag
2068: Fix: Added organization_id and shipment_headder_id columns
2069:
2070: 58. 06-Apr-2010 Bgowrava For Bug#9499146, File Version 120.34.12010000.14,
2071: Issue: WRONG AP ACCRUAL ACCOUNT TAKING FOR RECOVERABLE TAXES LIKE EXCISE IN AP INVOICE

Line 2543: open c_rcv_transactions(rcv_tran_id);

2539: -- bug#3752887
2540:
2541: /* service Start */
2542:
2543: open c_rcv_transactions(rcv_tran_id);
2544: fetch c_rcv_transactions into r_rcv_transactions;
2545: close c_rcv_transactions;
2546:
2547: /*following fetches added/modified for bug 6595773*/

Line 2544: fetch c_rcv_transactions into r_rcv_transactions;

2540:
2541: /* service Start */
2542:
2543: open c_rcv_transactions(rcv_tran_id);
2544: fetch c_rcv_transactions into r_rcv_transactions;
2545: close c_rcv_transactions;
2546:
2547: /*following fetches added/modified for bug 6595773*/
2548: OPEN from_po_distributions(po_dist_id);

Line 2545: close c_rcv_transactions;

2541: /* service Start */
2542:
2543: open c_rcv_transactions(rcv_tran_id);
2544: fetch c_rcv_transactions into r_rcv_transactions;
2545: close c_rcv_transactions;
2546:
2547: /*following fetches added/modified for bug 6595773*/
2548: OPEN from_po_distributions(po_dist_id);
2549: FETCH from_po_distributions INTO from_po_distributions_rec;

Line 2560: p_organization_id => r_rcv_transactions.organization_id,

2556:
2557: lv_is_item_an_expense := null;
2558: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2559: (
2560: p_organization_id => r_rcv_transactions.organization_id,
2561: p_item_id => r_po_lines_all.item_id
2562: );
2563:
2564: /*lv_accounting_method_option := jai_general_pkg.get_accounting_method

Line 2568: p_organization_id => r_rcv_transactions.organization_id

2564: /*lv_accounting_method_option := jai_general_pkg.get_accounting_method
2565: (
2566: p_org_id => v_org_id,
2567: p_sob_id => for_dist_insertion_rec.set_of_books_id,
2568: p_organization_id => r_rcv_transactions.organization_id
2569: );*/
2570:
2571: /*bug 9346307*/
2572: OPEN c_po_details;

Line 4081: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308

4077:
4078: /* Begin 5763527 */
4079: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4080: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
4081: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
4082: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
4083: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308
4084: ,cp_attribute1 => 'CENVAT_COSTED_FLAG'); --Added by Bgowrava for Bug#7503308
4085: fetch c_get_excise_costing_flag into lv_excise_costing_flag;

Line 4993: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308

4989:
4990: /* Begin 5763527 */
4991: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4992: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
4993: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
4994: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
4995: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308
4996: ,cp_attribute1 => 'CENVAT_COSTED_FLAG'); --Added by Bgowrava for Bug#7503308
4997: fetch c_get_excise_costing_flag into lv_excise_costing_flag;

Line 5902: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308

5898:
5899: /* Begin 5763527 */
5900: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
5901: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
5902: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
5903: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
5904: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308
5905: ,cp_attribute1 => 'CENVAT_COSTED_FLAG'); --Added by Bgowrava for Bug#7503308
5906: fetch c_get_excise_costing_flag into lv_excise_costing_flag;

Line 7392: , rcv_transactions rt

7388: , NVL(jcta.inclusive_tax_flag,'N') inc_tax_flag --Added by Eric for Inclusive Tax
7389: FROM
7390: JAI_RCV_LINE_TAXES jrl
7391: , rcv_shipment_lines rsl
7392: , rcv_transactions rt
7393: , jai_cmn_taxes_all jcta
7394: WHERE jrl.shipment_line_id = rsl.shipment_line_id
7395: AND rt.shipment_line_id = rsl.shipment_line_id
7396: AND rt.transaction_id = tran_id

Line 7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,

7563: lv_tax_line_to_inst_flag VARCHAR2(1); --added by eric for inclusive tax
7564:
7565:
7566:
7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308

Line 7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308

7564:
7565:
7566:
7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is

Line 7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308

7565:
7566:
7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag

Line 7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308

7566:
7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag
7574: from jai_rcv_transactions jrcvt

Line 7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308

7567: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
7568: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
7569: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308
7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag
7574: from jai_rcv_transactions jrcvt
7575: where jrcvt.parent_transaction_id = cp_rcv_transaction_id

Line 7574: from jai_rcv_transactions jrcvt

7570: cp_txn_type JAI_RCV_TRANSACTIONS.transaction_type%type, --Added by Bgowrava for Bug#7503308
7571: cp_attribute1 JAI_RCV_TRANSACTIONS.attribute1%type) --Added by Bgowrava for Bug#7503308
7572: is
7573: select attribute2 excise_costing_flag
7574: from jai_rcv_transactions jrcvt
7575: where jrcvt.parent_transaction_id = cp_rcv_transaction_id
7576: and jrcvt.organization_id = cp_organization_id --Added by Bgowrava for Bug#7503308
7577: and jrcvt.shipment_header_id = cp_shipment_header_id
7578: and jrcvt.transaction_type = cp_txn_type --'DELIVER' --Modified by Bgowrava for Bug#7503308

Line 7583: cursor c_rcv_transactions(p_transaction_id number) is

7579: and jrcvt.attribute1= cp_attribute1 ; --'CENVAT_COSTED_FLAG'; --Modified by Bgowrava for Bug#7503308
7580: /* End 5763527 */
7581:
7582: /* Service Tax */
7583: cursor c_rcv_transactions(p_transaction_id number) is
7584: select po_line_id, organization_id
7585: from rcv_transactions
7586: where transaction_id = p_transaction_id;
7587:

Line 7585: from rcv_transactions

7581:
7582: /* Service Tax */
7583: cursor c_rcv_transactions(p_transaction_id number) is
7584: select po_line_id, organization_id
7585: from rcv_transactions
7586: where transaction_id = p_transaction_id;
7587:
7588: cursor c_po_lines_all(p_po_line_id number) is
7589: select item_id

Line 7620: r_rcv_transactions c_rcv_transactions%rowtype;

7616: from jai_cmn_taxes_all
7617: where tax_id = cp_tax_id ;
7618: /*End, Added by kunkumar for bug#5593895*/
7619:
7620: r_rcv_transactions c_rcv_transactions%rowtype;
7621: r_po_lines_all c_po_lines_all%rowtype;
7622: r_jai_regimes c_jai_regimes%rowtype;
7623: r_service_regime_tax_type c_regime_tax_type%rowtype;
7624: lv_is_item_an_expense varchar2(20); /* Service */

Line 7807: Populate the po distribution id and rcv_transactions id for the tax

7803: org id that is supplied as a parameter to this program. Without this
7804: the org id gets defaulted from the session variables and may go wrong.
7805:
7806: 3. 09/10/2002 Aparajita for bug # 2483164 Version# 615.1
7807: Populate the po distribution id and rcv_transactions id for the tax
7808: lines for backtracking tax to purchasing side.
7809:
7810: Deleted the code for supplementary invoices as this is only for pay on
7811: receipt. This code was here as this procedure was extracted from

Line 8035: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.

8031:
8032: 36 08/07/2004 Aparajita for bug#3752887. Version#115.1, Clean up.
8033:
8034: Function apportion_tax_pay_on_rect_f was considering the quantity
8035: from rcv_transactions and taxes from JAI_RCV_LINE_TAXES.
8036: This fails when there have been corrections as taxes are modified as
8037: per the corrected quantity.
8038:
8039: Cleaned the entire logic of apportioning of tax from PO to AP.

Line 8313: open c_rcv_transactions(rcv_tran_id);

8309: -- bug#3752887
8310:
8311: /* service Start */
8312:
8313: open c_rcv_transactions(rcv_tran_id);
8314: fetch c_rcv_transactions into r_rcv_transactions;
8315: close c_rcv_transactions;
8316:
8317: open c_po_lines_all(po_dist_id);

Line 8314: fetch c_rcv_transactions into r_rcv_transactions;

8310:
8311: /* service Start */
8312:
8313: open c_rcv_transactions(rcv_tran_id);
8314: fetch c_rcv_transactions into r_rcv_transactions;
8315: close c_rcv_transactions;
8316:
8317: open c_po_lines_all(po_dist_id);
8318: fetch c_po_lines_all into r_po_lines_all;

Line 8315: close c_rcv_transactions;

8311: /* service Start */
8312:
8313: open c_rcv_transactions(rcv_tran_id);
8314: fetch c_rcv_transactions into r_rcv_transactions;
8315: close c_rcv_transactions;
8316:
8317: open c_po_lines_all(po_dist_id);
8318: fetch c_po_lines_all into r_po_lines_all;
8319: close c_po_lines_all;

Line 8324: p_organization_id => r_rcv_transactions.organization_id,

8320:
8321: lv_is_item_an_expense :=
8322: jai_general_pkg.is_item_an_expense
8323: (
8324: p_organization_id => r_rcv_transactions.organization_id,
8325: p_item_id => r_po_lines_all.item_id
8326: );
8327:
8328: /*lv_accounting_method_option :=

Line 8332: p_organization_id => r_rcv_transactions.organization_id,

8328: /*lv_accounting_method_option :=
8329: jai_general_pkg.get_accounting_method
8330: (
8331: p_org_id => v_org_id,
8332: p_organization_id => r_rcv_transactions.organization_id,
8333: p_sob_id => for_dist_insertion_rec.set_of_books_id
8334: );*/
8335: --commented the above by Sanjikum for Bug#4474501
8336:

Line 8367: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308

8363: IF rcv_tran_id IS NOT NULL THEN
8364:
8365: /* Begin 5763527 */
8366: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
8367: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
8368: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
8369: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308
8370: ,cp_attribute1 => 'CENVAT_COSTED_FLAG'); --Added by Bgowrava for Bug#7503308
8371: fetch c_get_excise_costing_flag into lv_excise_costing_flag;