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_RETRO_PRC_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 743: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE

739: --
740: -- 14-JAN-2008 Eric Ma created
741: --==========================================================================
742: Function Get_Jai_Rcv_Trans_Record
743: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
744: )
745: RETURN jai_rcv_transactions%ROWTYPE
746: IS
747:

Line 745: RETURN jai_rcv_transactions%ROWTYPE

741: --==========================================================================
742: Function Get_Jai_Rcv_Trans_Record
743: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
744: )
745: RETURN jai_rcv_transactions%ROWTYPE
746: IS
747:
748: CURSOR get_jai_rcv_transactions_cur
749: IS

Line 748: CURSOR get_jai_rcv_transactions_cur

744: )
745: RETURN jai_rcv_transactions%ROWTYPE
746: IS
747:
748: CURSOR get_jai_rcv_transactions_cur
749: IS
750: SELECT
751: *
752: FROM

Line 753: jai_rcv_transactions

749: IS
750: SELECT
751: *
752: FROM
753: jai_rcv_transactions
754: WHERE transaction_id = pn_transaction_id;
755:
756:
757: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

Line 757: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

753: jai_rcv_transactions
754: WHERE transaction_id = pn_transaction_id;
755:
756:
757: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
758:
759: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
760: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
761: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 773: OPEN get_jai_rcv_transactions_cur;

769: , 'Enter procedure'
770: );
771: END IF; --l_proc_level>=l_dbg_level
772:
773: OPEN get_jai_rcv_transactions_cur;
774: FETCH get_jai_rcv_transactions_cur
775: INTO jai_rcv_transactions_rec;
776: CLOSE get_jai_rcv_transactions_cur;
777:

Line 774: FETCH get_jai_rcv_transactions_cur

770: );
771: END IF; --l_proc_level>=l_dbg_level
772:
773: OPEN get_jai_rcv_transactions_cur;
774: FETCH get_jai_rcv_transactions_cur
775: INTO jai_rcv_transactions_rec;
776: CLOSE get_jai_rcv_transactions_cur;
777:
778: --logging for debug

Line 775: INTO jai_rcv_transactions_rec;

771: END IF; --l_proc_level>=l_dbg_level
772:
773: OPEN get_jai_rcv_transactions_cur;
774: FETCH get_jai_rcv_transactions_cur
775: INTO jai_rcv_transactions_rec;
776: CLOSE get_jai_rcv_transactions_cur;
777:
778: --logging for debug
779: IF (ln_proc_level >= ln_dbg_level)

Line 776: CLOSE get_jai_rcv_transactions_cur;

772:
773: OPEN get_jai_rcv_transactions_cur;
774: FETCH get_jai_rcv_transactions_cur
775: INTO jai_rcv_transactions_rec;
776: CLOSE get_jai_rcv_transactions_cur;
777:
778: --logging for debug
779: IF (ln_proc_level >= ln_dbg_level)
780: THEN

Line 786: RETURN jai_rcv_transactions_rec;

782: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
783: , 'Exit procedure'
784: );
785: END IF; -- (ln_proc_level>=ln_dbg_level)
786: RETURN jai_rcv_transactions_rec;
787: EXCEPTION
788: WHEN OTHERS THEN
789: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: THEN

Line 820: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE

816: --
817: -- 14-JAN-2008 Eric Ma created
818: --==========================================================================
819: Function Get_Jai_Rcv_Lines_Record
820: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
821: )
822: RETURN jai_rcv_lines%ROWTYPE
823: IS
824:

Line 930: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;

926: WHERE
927: organization_id = pn_organization_id;
928:
929: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
930: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
931: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
932: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
933: ln_expense_account mtl_parameters.expense_account%TYPE;
934: lv_process_message VARCHAR2(500);

Line 931: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;

927: organization_id = pn_organization_id;
928:
929: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
930: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
931: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
932: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
933: ln_expense_account mtl_parameters.expense_account%TYPE;
934: lv_process_message VARCHAR2(500);
935: lv_process_status VARCHAR2(500);

Line 932: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;

928:
929: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
930: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
931: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
932: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
933: ln_expense_account mtl_parameters.expense_account%TYPE;
934: lv_process_message VARCHAR2(500);
935: lv_process_status VARCHAR2(500);
936: lv_code_path VARCHAR2(500);

Line 2263: jai_rcv_transactions

2259: IS
2260: SELECT
2261: *
2262: FROM
2263: jai_rcv_transactions
2264: WHERE
2265: transaction_id = pn_transaction_id;
2266:
2267: CURSOR get_rcv_cenvat_claim_cur

Line 2333: --Get the record from jai_rcv_transactions for the current transaction_id

2329: RETURN;
2330: END IF;
2331:
2332:
2333: --Get the record from jai_rcv_transactions for the current transaction_id
2334: OPEN get_jai_transaction_cur;
2335: FETCH get_jai_transaction_cur
2336: INTO jai_transaction_rec;
2337: CLOSE get_jai_transaction_cur;

Line 2351: END IF;--(jai_rcv_transactions.organization_type = 'T')

2347: THEN --Trading
2348: lv_tax_breakup_type := 'RG23D';
2349: ELSE -- manufacturing and others
2350: lv_tax_breakup_type := 'MODVAT';
2351: END IF;--(jai_rcv_transactions.organization_type = 'T')
2352:
2353: --Call the following procedure to get the tax amounts by tax types
2354: Get_Tax_Amount_Breakup
2355: ( pn_shipment_line_id => pn_shipment_line_id

Line 2599: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

2595: , pv_supp_vat_inv_date IN VARCHAR2 DEFAULT NULL
2596: , pv_process_downward IN VARCHAR2 DEFAULT NULL
2597: )
2598: IS
2599: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
2600: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
2601:
2602: ln_skip_rcpt_cnt NUMBER := NULL;
2603: lv_profile_setting VARCHAR2(255);

Line 2813: jai_rcv_transactions_rec := Get_Jai_Rcv_Trans_Record(rcv_transactions_rec.transaction_id);

2809: , pn_line_change_id => jai_retro_line_change_rec.line_change_id
2810: )
2811: LOOP
2812: ln_tot_receipt_no := ln_tot_receipt_no +1;
2813: jai_rcv_transactions_rec := Get_Jai_Rcv_Trans_Record(rcv_transactions_rec.transaction_id);
2814: jai_rcv_lines_rec := Get_Jai_Rcv_Lines_Record(rcv_transactions_rec.transaction_id);
2815:
2816: BEGIN
2817: FND_FILE.PUT_LINE(fnd_file.log, ' ');

Line 2823: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);

2819: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2820: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2821: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2822: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2823: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2824: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2825: FND_FILE.PUT_LINE(fnd_file.log, '');
2826: END;
2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL

Line 2824: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);

2820: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2821: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2822: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2823: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2824: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2825: FND_FILE.PUT_LINE(fnd_file.log, '');
2826: END;
2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'

Line 2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL

2823: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2824: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2825: FND_FILE.PUT_LINE(fnd_file.log, '');
2826: END;
2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL

Line 2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'

2824: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2825: FND_FILE.PUT_LINE(fnd_file.log, '');
2826: END;
2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

Line 2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'

2825: FND_FILE.PUT_LINE(fnd_file.log, '');
2826: END;
2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2833: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

Line 2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'

2826: END;
2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2833: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2834: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

Line 2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL

2827: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2833: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2834: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2835: )

Line 2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

2828: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2833: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2834: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2835: )
2836: THEN

Line 2833: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

2829: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2833: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2834: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2835: )
2836: THEN
2837: -- Print a message stating that the Receipt is not claimed and it should be claimed before

Line 2834: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

2830: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2831: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2832: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2833: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2834: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2835: )
2836: THEN
2837: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2838: -- JAI Retroactive price Update is Run

Line 2839: IF( jai_rcv_transactions_rec.process_vat_status IS NULL

2835: )
2836: THEN
2837: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2838: -- JAI Retroactive price Update is Run
2839: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2840: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2841: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2842: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2843: )

Line 2840: OR jai_rcv_transactions_rec.process_vat_status = 'P'

2836: THEN
2837: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2838: -- JAI Retroactive price Update is Run
2839: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2840: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2841: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2842: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2843: )
2844: THEN

Line 2841: OR jai_rcv_transactions_rec.process_vat_status = 'N'

2837: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2838: -- JAI Retroactive price Update is Run
2839: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2840: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2841: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2842: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2843: )
2844: THEN
2845: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

Line 2842: OR jai_rcv_transactions_rec.process_vat_status = 'EE'

2838: -- JAI Retroactive price Update is Run
2839: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2840: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2841: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2842: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2843: )
2844: THEN
2845: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2846: END IF;

Line 2848: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL

2844: THEN
2845: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2846: END IF;
2847:
2848: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2849: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2850: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2851: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2852: )

Line 2849: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

2845: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2846: END IF;
2847:
2848: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2849: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2850: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2851: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2852: )
2853: THEN

Line 2850: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

2846: END IF;
2847:
2848: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2849: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2850: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2851: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2852: )
2853: THEN
2854: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

Line 2851: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

2847:
2848: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2849: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2850: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2851: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2852: )
2853: THEN
2854: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2855: END IF;

Line 3026: , p_line_uom => jai_rcv_transactions_rec.uom_code

3022: ln_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value
3023: ( p_vendor_id => rcv_transactions_rec.vendor_id
3024: , p_vendor_site_id => rcv_transactions_rec.vendor_site_id
3025: , p_inv_item_id => jai_rcv_lines_rec.inventory_item_id
3026: , p_line_uom => jai_rcv_transactions_rec.uom_code
3027: );
3028:
3029: IF (ln_proc_level >= ln_dbg_level)
3030: THEN

Line 3051: , p_uom_code => jai_rcv_transactions_rec.uom_code

3047: ln_vat_assess_value := jai_general_pkg.ja_in_vat_assessable_value
3048: ( p_party_id => rcv_transactions_rec.vendor_id
3049: , p_party_site_id => rcv_transactions_rec.vendor_site_id
3050: , p_inventory_item_id => jai_rcv_lines_rec.inventory_item_id
3051: , p_uom_code => jai_rcv_transactions_rec.uom_code
3052: , p_default_price => jai_retro_line_change_rec.modified_unit_price
3053: , p_ass_value_date => trunc(sysdate)
3054: , p_party_type => 'V'
3055: );

Line 3077: , p_uom_code => jai_rcv_transactions_rec.uom_code

3073: ln_gst_assessable_value := jai_gst_general_pkg.get_gst_assessable_value
3074: ( p_party_id => rcv_transactions_rec.vendor_id
3075: , p_party_site_id => rcv_transactions_rec.vendor_site_id
3076: , p_inventory_item_id => jai_rcv_lines_rec.inventory_item_id
3077: , p_uom_code => jai_rcv_transactions_rec.uom_code
3078: , p_default_price => jai_retro_line_change_rec.modified_unit_price
3079: , p_ass_value_date => trunc(sysdate)
3080: , p_party_type => 'V'
3081: );

Line 3106: , p_line_uom_code => jai_rcv_transactions_rec.uom_code -- Receipt UOM code

3102: , P_line_id => jai_rcv_lines_rec.shipment_line_id -- Receipt Shipment line Id
3103: , p_line_loc_id => -999
3104: , p_line_quantity => rcv_transactions_rec.quantity -- receipt Quantity
3105: , p_price => ln_recv_line_amount -- Receipt line Amount
3106: , p_line_uom_code => jai_rcv_transactions_rec.uom_code -- Receipt UOM code
3107: , p_tax_amount => ln_recv_tax_amount -- Receipt line Amount ( IN Out parameter that gives the total tax amount and takes line amount as Input)
3108: , p_assessable_value => ln_assessable_value -- Excise Assesable value
3109: , p_vat_assess_value => ln_vat_assess_value -- VAT Assessable value
3110: , p_item_id => jai_rcv_lines_rec.inventory_item_id -- Inventory item id

Line 3254: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )

3250: END IF; --(lv_vat_action <> 'UNCLAIMED' AND ln_vat_amount <> 0)
3251:
3252: --Increaset the total processed receipt number;
3253: ln_receipt_processed_no :=ln_receipt_processed_no+1;
3254: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )
3255:
3256: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');
3257: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
3258: FND_FILE.PUT_LINE(fnd_file.log, ' ++');