[Home] [Help]
89: --v_attribute2 DATE;
90: --v_attribute3 VARCHAR2(150);
91: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range % TYPE;
92: v_division_no JAI_CMN_VENDOR_SITES.excise_duty_division % TYPE;
93: v_claim_modvat_flag JAI_RCV_LINES.claim_modvat_flag % TYPE;
94: v_func_currency gl_sets_of_books.currency_code % TYPE;
95: v_gl_set_of_books_id gl_sets_of_books.set_of_books_id % TYPE;
96: v_conv_factor NUMBER;
97: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
311:
312: cursor c_fetch_receive_quantity(p_shipment_header_id number,
313: p_shipment_line_id number) is
314: select qty_received
315: from JAI_RCV_LINES
316: where shipment_header_id = p_shipment_header_id
317: and shipment_line_id = p_shipment_line_id;
318:
319: cursor c_fetch_transaction_quantity(p_shipment_header_id number,
336: from jai_rcv_interface_trxs
337: where interface_transaction_id = cp_interface_trx_id;
338:
339: r_ja_rcv_interface c_ja_rcv_interface%ROWTYPE;
340: lv_excise_invoice_no JAI_RCV_LINES.excise_invoice_no%TYPE;
341: lv_excise_invoice_date JAI_RCV_LINES.excise_invoice_date%TYPE;
342: lv_online_claim_flag JAI_RCV_LINES.online_claim_flag%TYPE;
343:
344: /* Bug 5243532. Added by Lakshmi Gopalsami
337: where interface_transaction_id = cp_interface_trx_id;
338:
339: r_ja_rcv_interface c_ja_rcv_interface%ROWTYPE;
340: lv_excise_invoice_no JAI_RCV_LINES.excise_invoice_no%TYPE;
341: lv_excise_invoice_date JAI_RCV_LINES.excise_invoice_date%TYPE;
342: lv_online_claim_flag JAI_RCV_LINES.online_claim_flag%TYPE;
343:
344: /* Bug 5243532. Added by Lakshmi Gopalsami
345: * Defined variable for implementing caching logic.
338:
339: r_ja_rcv_interface c_ja_rcv_interface%ROWTYPE;
340: lv_excise_invoice_no JAI_RCV_LINES.excise_invoice_no%TYPE;
341: lv_excise_invoice_date JAI_RCV_LINES.excise_invoice_date%TYPE;
342: lv_online_claim_flag JAI_RCV_LINES.online_claim_flag%TYPE;
343:
344: /* Bug 5243532. Added by Lakshmi Gopalsami
345: * Defined variable for implementing caching logic.
346: */
524: --commented by qiog.liu for bug12717416 2011.07.06 end
525: -----------------------------------------------------------------------
526: --Add by Xiao for Adhoc taxes, reg bug#12589218 on 16-Jun-2011, end
527:
528: --------------------------- Procedure For inserting a record in JAI_RCV_LINES ---------
529: PROCEDURE insert_receipt_line IS
530:
531: lv_mfg_trading JAI_RCV_LINES.mfg_trading%type ;
532: BEGIN
527:
528: --------------------------- Procedure For inserting a record in JAI_RCV_LINES ---------
529: PROCEDURE insert_receipt_line IS
530:
531: lv_mfg_trading JAI_RCV_LINES.mfg_trading%type ;
532: BEGIN
533:
534: --Added by GSRI on 21-OCT-01
535: SELECT COUNT(*) INTO v_chk_receipt_lines
532: BEGIN
533:
534: --Added by GSRI on 21-OCT-01
535: SELECT COUNT(*) INTO v_chk_receipt_lines
536: FROM JAI_RCV_LINES
537: WHERE shipment_line_id = p_shipment_line_id AND
538: shipment_header_id = p_shipment_header_id;
539: IF v_chk_receipt_lines = 0 THEN
540: /*DELETE FROM JAI_RCV_LINES
536: FROM JAI_RCV_LINES
537: WHERE shipment_line_id = p_shipment_line_id AND
538: shipment_header_id = p_shipment_header_id;
539: IF v_chk_receipt_lines = 0 THEN
540: /*DELETE FROM JAI_RCV_LINES
541: WHERE shipment_line_id = p_shipment_line_id AND
542: shipment_header_id = p_shipment_header_id;*/
543: --End Addition by GSRI on 21-OCT-01
544:
543: --End Addition by GSRI on 21-OCT-01
544:
545: lv_mfg_trading := NVL(v_manufacturing, 'N')|| NVL(v_trading, 'N') ; -- Removed minus sign (-) for bug#4519697
546:
547: INSERT INTO JAI_RCV_LINES
548: (shipment_line_id,
549: shipment_header_id,
550: receipt_num,
551: qty_received,
589: p_last_update_login);
590: END IF;
591: END insert_receipt_line;
592:
593: --------------------------- Procedure For updating tax amount in JAI_RCV_LINES --------
594: PROCEDURE update_receipt_line IS
595: BEGIN
596: IF v_tax_total <> 0
597: THEN
594: PROCEDURE update_receipt_line IS
595: BEGIN
596: IF v_tax_total <> 0
597: THEN
598: UPDATE JAI_RCV_LINES
599: SET tax_amount = v_tax_total
600: WHERE shipment_line_id = p_shipment_line_id;
601: END IF;
602: END update_receipt_line;
626: IF p_transaction_type = 'RECEIVE'
627: THEN
628: FOR conf_rec IN (SELECT shipment_line_id,
629: qty_received
630: FROM JAI_RCV_LINES
631: WHERE shipment_line_id = p_shipment_line_id)
632: LOOP
633: v_conf := conf_rec.shipment_line_id;
634: IF NVL(conf_rec.qty_received, 0) <> 0
658: THEN
659: v_tax_total := NVL(v_tax_total, 0) + NVL(v_current_tax, 0);
660: END IF;
661: END LOOP;
662: UPDATE JAI_RCV_LINES
663: SET qty_received = NVL(qty_received, 0) + p_qty_received,
664: tax_amount = v_tax_total
665: WHERE shipment_line_id = p_shipment_line_id;
666: END IF;
1008:
1009: 1. For Bug # 2692052
1010: Commented the calls to ja_in_temp_receipt
1011: Changed the calls to "TO HANDLE DELIVER RTR RTV"
1012: Changed the Insert of JAI_RCV_LINES with 2 columns ( organization_id,transaction_id).
1013:
1014: 2. For Bug # 2808110
1015: Added an Order by Clause in the Fetching
1016: of Tax related Information from JAI_PO_TAXES
1209: functionality as a gateway.
1210: - added a new parameter p_chk_form (OUT Variable) to return back a value, if the receipt transaction that is
1211: begin processed is created after navigating through Localization form
1212: - Instead of submitting the concurrents JAINRVCTP is submitted for processing
1213: - JAI_RCV_LINES.tax_modified_flag will be set now from above mentioned package when submitted from JAINPORE
1214: - Added Validation at the end of Procedure to error out if this is an RTV and Cenvat is not yet Claimed
1215:
1216: ** Please refer to Old Version of the Object incase commented code needs to be looked at **
1217:
1215:
1216: ** Please refer to Old Version of the Object incase commented code needs to be looked at **
1217:
1218: 33 09/02/2005 Vijay Shankar for Bug# 4159557, Version:115.8
1219: Modified the code to assign proper value to JAI_RCV_LINES.tax_modified_flag column based on Receipts
1220: tax modification Value returned by Localization Hook given to customers. the hook is called in ja_in_receipt_tax_insert_trg
1221: trigger and returned value is passed as parameter to this procedure which is used for tax_modified_flag value
1222: determination
1223:
1248: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
1249: This DFF is provided at two places, header and line.
1250: Information from the header DFF is captured into the rcv_shipment_headers table.
1251: Information from the lines DFF is captured into the rcv_transactions table.
1252: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
1253: At this time, a facility has been provided for the user to default the information
1254: given at the header level DFF to all the lines only if these columns are null at the
1255: line level. Else the information in the line level DFF is sustained.
1256: For this NVL conditions have been added where this information gets defaulted.
1432: 64. 25/02/2010 vkaranam for bug#9045278
1433: Issue:
1434: Not able to account the ISO receipt.
1435: Fix:
1436: Jai_rcv_lines.tax_modified_flag has been populated as 'Y' .
1437:
1438: 65. 15/sep/2010 vkaranam for bug#10086567
1439: Issue:
1440: FOR RMA RECEIPT TAX AMOUNTS ARE COMING AS ZERO
1789: and po_header_id = rsl.po_header_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1790: )
1791: and rsl.shipment_line_id in
1792: (select jrl.shipment_line_id
1793: from JAI_RCV_LINES jrl
1794: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE jrl.excise_invoice_no = p_attribute1
1795: -- AND jrl.excise_invoice_date = p_attribute2
1796: WHERE jrl.excise_invoice_no = lv_excise_invoice_no
1797: AND jrl.excise_invoice_date = lv_excise_invoice_date
2363: CLOSE c_jai_cmn_lines;
2364:
2365: v_loc_quantity := r_jai_cmn_lines.quantity;
2366:
2367: update JAI_RCV_LINES
2368: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,
2369: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date
2370: where shipment_line_id = p_shipment_line_id;
2371:
2434: CLOSE c_jai_mtl_Trxs;
2435:
2436: v_loc_quantity := ln_trx_qty;
2437:
2438: update jai_rcv_lines
2439: set excise_invoice_no = r_jai_mtl_trxs.excise_invoice_no ,
2440: excise_invoice_Date = r_jai_mtl_trxs.creation_Date
2441: where shipment_line_id = p_shipment_line_id;
2442:
3956:
3957: -- Added by Eric Ma for bug 10100899 on 17-Nov-2010,Begin
3958: ---------------------------------------------------------------
3959: --1. When populating the JAI_RCV_LINE_TAXES (OFI Receipt Tax Line), amount should be with the currency in corresponding PO tax line
3960: --2. When populating the JAI_RCV_LINES (OFI Receipt Line Detail), amount should be converted to its corresponding PO currency amount.
3961: --3. tax_amt_tab(i) saved the amount in 'INR' before currency conversion
3962: --4. v_cor_amount saved the amount in 'INR' before currency conversion
3963: ---------------------------------------------------------------
3964: -- Added by Eric Ma for bug 10100899 on 17-Nov-2010,Begin
4126:
4127:
4128: IF p_transaction_type = 'MATCH' THEN
4129:
4130: UPDATE JAI_RCV_LINES
4131: SET -- tax_modified_flag = 'N', /* Vijay Shankar for Bug#3940588 RECEIPTS DEPLUG*/
4132: line_location_id = p_line_location_id,
4133: tax_amount = NVL(tax_amount, 0) + v_tax_total,
4134: last_update_date = p_last_update_date,