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_LINES

Line 796: -- Get_Jai_Rcv_Lines_Record Private

792:
793: --==========================================================================
794: -- Function NAME:
795: --
796: -- Get_Jai_Rcv_Lines_Record Private
797: --
798: -- DESCRIPTION:
799: --
800: -- This procedure is used to get the jai_rcv_lines record for a

Line 800: -- This procedure is used to get the jai_rcv_lines record for a

796: -- Get_Jai_Rcv_Lines_Record Private
797: --
798: -- DESCRIPTION:
799: --
800: -- This procedure is used to get the jai_rcv_lines record for a
801: -- given transaction id
802: --
803: --
804: -- PARAMETERS:

Line 814: Function Get_Jai_Rcv_Lines_Record

810: -- CHANGE HISTORY:
811: --
812: -- 14-JAN-2008 Eric Ma created
813: --==========================================================================
814: Function Get_Jai_Rcv_Lines_Record
815: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
816: )
817: RETURN jai_rcv_lines%ROWTYPE
818: IS

Line 817: RETURN jai_rcv_lines%ROWTYPE

813: --==========================================================================
814: Function Get_Jai_Rcv_Lines_Record
815: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
816: )
817: RETURN jai_rcv_lines%ROWTYPE
818: IS
819:
820: CURSOR get_jai_rcv_lines_cur
821: IS

Line 820: CURSOR get_jai_rcv_lines_cur

816: )
817: RETURN jai_rcv_lines%ROWTYPE
818: IS
819:
820: CURSOR get_jai_rcv_lines_cur
821: IS
822: SELECT
823: *
824: FROM

Line 825: jai_rcv_lines

821: IS
822: SELECT
823: *
824: FROM
825: jai_rcv_lines
826: WHERE transaction_id = pn_transaction_id;
827:
828: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
829:

Line 828: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;

824: FROM
825: jai_rcv_lines
826: WHERE transaction_id = pn_transaction_id;
827:
828: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
829:
830: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
831: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
832: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 843: OPEN get_jai_rcv_lines_cur;

839: , 'Enter procedure'
840: );
841: END IF; --l_proc_level>=l_dbg_level
842:
843: OPEN get_jai_rcv_lines_cur;
844: FETCH get_jai_rcv_lines_cur
845: INTO jai_rcv_lines_rec;
846: CLOSE get_jai_rcv_lines_cur;
847:

Line 844: FETCH get_jai_rcv_lines_cur

840: );
841: END IF; --l_proc_level>=l_dbg_level
842:
843: OPEN get_jai_rcv_lines_cur;
844: FETCH get_jai_rcv_lines_cur
845: INTO jai_rcv_lines_rec;
846: CLOSE get_jai_rcv_lines_cur;
847:
848: --logging for debug

Line 845: INTO jai_rcv_lines_rec;

841: END IF; --l_proc_level>=l_dbg_level
842:
843: OPEN get_jai_rcv_lines_cur;
844: FETCH get_jai_rcv_lines_cur
845: INTO jai_rcv_lines_rec;
846: CLOSE get_jai_rcv_lines_cur;
847:
848: --logging for debug
849: IF (ln_proc_level >= ln_dbg_level)

Line 846: CLOSE get_jai_rcv_lines_cur;

842:
843: OPEN get_jai_rcv_lines_cur;
844: FETCH get_jai_rcv_lines_cur
845: INTO jai_rcv_lines_rec;
846: CLOSE get_jai_rcv_lines_cur;
847:
848: --logging for debug
849: IF (ln_proc_level >= ln_dbg_level)
850: THEN

Line 857: RETURN jai_rcv_lines_rec;

853: , 'Exit procedure'
854: );
855: END IF; -- (ln_proc_level>=ln_dbg_level)
856:
857: RETURN jai_rcv_lines_rec;
858: EXCEPTION
859: WHEN OTHERS
860: THEN
861: RAISE;

Line 862: END Get_Jai_Rcv_Lines_Record;

858: EXCEPTION
859: WHEN OTHERS
860: THEN
861: RAISE;
862: END Get_Jai_Rcv_Lines_Record;
863:
864: --==========================================================================
865: -- PROCEDURE NAME:
866: --

Line 1197: FROM jai_rcv_lines

1193:
1194: -- Get the receipt_num
1195: SELECT receipt_num
1196: INTO lv_receipt_num
1197: FROM jai_rcv_lines
1198: WHERE shipment_line_id = ln_shipment_line_id;
1199:
1200: IF (ln_proc_level >= ln_dbg_level)
1201: THEN

Line 1649: Do_Unclaim( pn_organization_id => trx_rec.organization_id -- current organization from rcv_transactions or jai_rcv_lines

1645:
1646: IF (ln_non_rec_amount <> 0)
1647: THEN
1648: --Call the following procedure to do unclaim
1649: Do_Unclaim( pn_organization_id => trx_rec.organization_id -- current organization from rcv_transactions or jai_rcv_lines
1650: , pn_transaction_id => trx_rec.transaction_id -- DELIVER transaction_id
1651: , pn_amount => ln_non_rec_amount -- Amount to be unclaimed
1652: , pn_version_number => pn_version_number
1653: );

Line 1779: lv_receipt_number jai_rcv_lines.receipt_num%TYPE;

1775: lv_reference_25 VARCHAR2 (4000);
1776: lv_reference_26 VARCHAR2 (4000);
1777: lv_process_status VARCHAR2 (4000);
1778: lv_process_message VARCHAR2 (4000);
1779: lv_receipt_number jai_rcv_lines.receipt_num%TYPE;
1780: lv_code_path VARCHAR2 (4000); --TO BE DONE
1781: --lv_receipt_num jai_rcv_lines.receipt_num%TYPE;/*rchandan*/
1782:
1783: CURSOR get_rcv_transactions_cur

Line 1781: --lv_receipt_num jai_rcv_lines.receipt_num%TYPE;/rchandan/

1777: lv_process_status VARCHAR2 (4000);
1778: lv_process_message VARCHAR2 (4000);
1779: lv_receipt_number jai_rcv_lines.receipt_num%TYPE;
1780: lv_code_path VARCHAR2 (4000); --TO BE DONE
1781: --lv_receipt_num jai_rcv_lines.receipt_num%TYPE;/*rchandan*/
1782:
1783: CURSOR get_rcv_transactions_cur
1784: IS
1785: SELECT

Line 1868: , jai_rcv_lines jrl

1864: , jrd.regime_id
1865: FROM
1866: jai_rcv_rgm_lines jrrl
1867: , jai_rgm_definitions jrd
1868: , jai_rcv_lines jrl
1869: WHERE jrrl.rcv_rgm_line_id = pn_rcv_rgm_line_id
1870: AND jrrl.shipment_line_id = jrl.shipment_line_id
1871: AND jrrl.regime_code = jrd.regime_code;
1872:

Line 1897: FROM jai_rcv_lines

1893:
1894: -- Get the receipt_num
1895: SELECT receipt_num
1896: INTO lv_receipt_number
1897: FROM jai_rcv_lines
1898: WHERE shipment_line_id = pn_shipment_line_id;
1899:
1900: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1901: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);

Line 2590: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;

2586: , pv_process_downward IN VARCHAR2 DEFAULT NULL
2587: )
2588: IS
2589: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
2590: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
2591:
2592: ln_skip_rcpt_cnt NUMBER := NULL;
2593: lv_profile_setting VARCHAR2(255);
2594:

Line 2801: jai_rcv_lines_rec := Get_Jai_Rcv_Lines_Record(rcv_transactions_rec.transaction_id);

2797: )
2798: LOOP
2799: ln_tot_receipt_no := ln_tot_receipt_no +1;
2800: jai_rcv_transactions_rec := Get_Jai_Rcv_Trans_Record(rcv_transactions_rec.transaction_id);
2801: jai_rcv_lines_rec := Get_Jai_Rcv_Lines_Record(rcv_transactions_rec.transaction_id);
2802:
2803: BEGIN
2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');

Line 2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);

2803: BEGIN
2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);

Line 2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);

2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');

Line 2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );

2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;

Line 2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )
2831: THEN
2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2833: END IF;
2834:
2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

Line 2841: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )
2840: THEN
2841: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2842: END IF;
2843:
2844: FND_FILE.PUT_LINE(fnd_file.log, ' Please Claim it before running the concurrent JAI Retroactive price Update');
2845: ln_skip_rcpt_cnt := ln_skip_rcpt_cnt + 1;

Line 2868: WHERE doc_header_id = jai_rcv_lines_rec.shipment_header_id

2864: INTO
2865: ln_retro_line_changes_version
2866: FROM
2867: jai_retro_line_changes
2868: WHERE doc_header_id = jai_rcv_lines_rec.shipment_header_id
2869: AND doc_line_id = jai_rcv_lines_rec.shipment_line_id
2870: AND doc_type = 'RECEIPT';
2871:
2872: IF (ln_proc_level >= ln_dbg_level)

Line 2869: AND doc_line_id = jai_rcv_lines_rec.shipment_line_id

2865: ln_retro_line_changes_version
2866: FROM
2867: jai_retro_line_changes
2868: WHERE doc_header_id = jai_rcv_lines_rec.shipment_header_id
2869: AND doc_line_id = jai_rcv_lines_rec.shipment_line_id
2870: AND doc_type = 'RECEIPT';
2871:
2872: IF (ln_proc_level >= ln_dbg_level)
2873: THEN

Line 2912: , jai_rcv_lines_rec.shipment_header_id --=> shipment_header_id from jai_rcv_lines

2908: )
2909: VALUES
2910: ( ln_retro_line_changes_id --=> jai_retro_line_changes_s.nextval
2911: , 'RECEIPT' --=> 'RECEIPT'
2912: , jai_rcv_lines_rec.shipment_header_id --=> shipment_header_id from jai_rcv_lines
2913: , jai_rcv_lines_rec.shipment_line_id --=> shipment_Line_Id from jai_rcv_lines
2914: , NULL --=> NULL
2915: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2916: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment

Line 2913: , jai_rcv_lines_rec.shipment_line_id --=> shipment_Line_Id from jai_rcv_lines

2909: VALUES
2910: ( ln_retro_line_changes_id --=> jai_retro_line_changes_s.nextval
2911: , 'RECEIPT' --=> 'RECEIPT'
2912: , jai_rcv_lines_rec.shipment_header_id --=> shipment_header_id from jai_rcv_lines
2913: , jai_rcv_lines_rec.shipment_line_id --=> shipment_Line_Id from jai_rcv_lines
2914: , NULL --=> NULL
2915: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2916: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment
2917: , SYSDATE --=> Sysdate

Line 2918: , jai_rcv_lines_rec.inventory_item_id --=> inventory_item_id from jai_rcv_lines

2914: , NULL --=> NULL
2915: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2916: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment
2917: , SYSDATE --=> Sysdate
2918: , jai_rcv_lines_rec.inventory_item_id --=> inventory_item_id from jai_rcv_lines
2919: , jai_rcv_lines_rec.organization_id --=> Organization_id from jai_rcv_lines
2920: , jai_retro_line_change_rec.original_unit_price --=> original_unit_price from jai_retro_line_changes of the current Release
2921: , jai_retro_line_change_rec.modified_unit_price --=> Modified_unit_price from jai_retro_line_changes of the current Release
2922: , 'Y' --=> receipt_processed_flag :'Y'

Line 2919: , jai_rcv_lines_rec.organization_id --=> Organization_id from jai_rcv_lines

2915: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2916: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment
2917: , SYSDATE --=> Sysdate
2918: , jai_rcv_lines_rec.inventory_item_id --=> inventory_item_id from jai_rcv_lines
2919: , jai_rcv_lines_rec.organization_id --=> Organization_id from jai_rcv_lines
2920: , jai_retro_line_change_rec.original_unit_price --=> original_unit_price from jai_retro_line_changes of the current Release
2921: , jai_retro_line_change_rec.modified_unit_price --=> Modified_unit_price from jai_retro_line_changes of the current Release
2922: , 'Y' --=> receipt_processed_flag :'Y'
2923: , pv_cenvat_action --=> pv_cenvat_action

Line 2930: , jai_rcv_lines_rec.receipt_num --=> receipt_number from jai_rcv_lines

2926: , pv_vat_action --=> pv_vat_action
2927: , pv_supp_vat_inv_no --=> pv_supp_vat_inv_no
2928: , ld_supp_vat_inv_date --=> pd_supp_vat_inv_date
2929: , fnd_global.conc_request_id --=> fnd_global.conc_request_id
2930: , jai_rcv_lines_rec.receipt_num --=> receipt_number from jai_rcv_lines
2931: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions
2932: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2933: , SYSDATE --=> sysdate
2934: , FND_GLOBAL.USER_ID --=> fnd_global.user_id

Line 3012: , p_inv_item_id => jai_rcv_lines_rec.inventory_item_id

3008: --get_assessable_value
3009: ln_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value
3010: ( p_vendor_id => rcv_transactions_rec.vendor_id
3011: , p_vendor_site_id => rcv_transactions_rec.vendor_site_id
3012: , p_inv_item_id => jai_rcv_lines_rec.inventory_item_id
3013: , p_line_uom => jai_rcv_transactions_rec.uom_code
3014: );
3015:
3016: IF (ln_proc_level >= ln_dbg_level)

Line 3037: , p_inventory_item_id => jai_rcv_lines_rec.inventory_item_id

3033: --get_vat_assessable_value
3034: ln_vat_assess_value := jai_general_pkg.ja_in_vat_assessable_value
3035: ( p_party_id => rcv_transactions_rec.vendor_id
3036: , p_party_site_id => rcv_transactions_rec.vendor_site_id
3037: , p_inventory_item_id => jai_rcv_lines_rec.inventory_item_id
3038: , p_uom_code => jai_rcv_transactions_rec.uom_code
3039: , p_default_price => jai_retro_line_change_rec.modified_unit_price
3040: , p_ass_value_date => trunc(sysdate)
3041: , p_party_type => 'V'

Line 3059: , p_header_id => jai_rcv_lines_rec.shipment_header_id -- Receipt Shipment header Id

3055: END IF; --l_proc_level>=l_dbg_level
3056:
3057: JAI_PO_TAX_PKG.Calculate_Tax
3058: ( p_type => 'RECEIPTS'
3059: , p_header_id => jai_rcv_lines_rec.shipment_header_id -- Receipt Shipment header Id
3060: , P_line_id => jai_rcv_lines_rec.shipment_line_id -- Receipt Shipment line Id
3061: , p_line_loc_id => -999
3062: , p_line_quantity => rcv_transactions_rec.quantity -- receipt Quantity
3063: , p_price => ln_recv_line_amount -- Receipt line Amount

Line 3060: , P_line_id => jai_rcv_lines_rec.shipment_line_id -- Receipt Shipment line Id

3056:
3057: JAI_PO_TAX_PKG.Calculate_Tax
3058: ( p_type => 'RECEIPTS'
3059: , p_header_id => jai_rcv_lines_rec.shipment_header_id -- Receipt Shipment header Id
3060: , P_line_id => jai_rcv_lines_rec.shipment_line_id -- Receipt Shipment line Id
3061: , p_line_loc_id => -999
3062: , p_line_quantity => rcv_transactions_rec.quantity -- receipt Quantity
3063: , p_price => ln_recv_line_amount -- Receipt line Amount
3064: , p_line_uom_code => jai_rcv_transactions_rec.uom_code -- Receipt UOM code

Line 3068: , p_item_id => jai_rcv_lines_rec.inventory_item_id -- Inventory item id

3064: , p_line_uom_code => jai_rcv_transactions_rec.uom_code -- Receipt UOM code
3065: , 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)
3066: , p_assessable_value => ln_assessable_value -- Excise Assesable value
3067: , p_vat_assess_value => ln_vat_assess_value -- VAT Assessable value
3068: , p_item_id => jai_rcv_lines_rec.inventory_item_id -- Inventory item id
3069: , p_conv_rate => rcv_transactions_rec.currency_conversion_rate -- currency conversion rate
3070: , pv_retroprice_changed => 'Y' --CHANGED NEW
3071: , pv_called_from => 'RETROACTIVE' -- New parameter
3072: );

Line 3075: Fnd_File.Put_Line(FND_FILE.LOG,' New total tax amount of the receipt '||jai_rcv_lines_rec.receipt_num||' IS :' ||ln_recv_tax_amount);

3071: , pv_called_from => 'RETROACTIVE' -- New parameter
3072: );
3073:
3074: -- print the new total tax amount of the receipt
3075: Fnd_File.Put_Line(FND_FILE.LOG,' New total tax amount of the receipt '||jai_rcv_lines_rec.receipt_num||' IS :' ||ln_recv_tax_amount);
3076:
3077: -- After recalculating the tax ,updat the modified_tax_amount of jai_retro_tax_changes table
3078: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
3079: LOOP

Line 3086: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id

3082: jai_retro_tax_changes jrtc
3083: SET
3084: modified_tax_amount = ( SELECT tax_amount
3085: FROM jai_rcv_line_taxes jrlt
3086: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id
3087: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3088: AND jrlt.tax_id = jrtc.tax_id
3089: )
3090: WHERE line_change_id = ln_retro_line_changes_id

Line 3087: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id

3083: SET
3084: modified_tax_amount = ( SELECT tax_amount
3085: FROM jai_rcv_line_taxes jrlt
3086: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id
3087: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3088: AND jrlt.tax_id = jrtc.tax_id
3089: )
3090: WHERE line_change_id = ln_retro_line_changes_id
3091: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no

Line 3211: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');

3207: --Increaset the total processed receipt number;
3208: ln_receipt_processed_no :=ln_receipt_processed_no+1;
3209: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )
3210:
3211: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');
3212: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
3213: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
3214: END LOOP; --rcv_transactions_rec IN get_rcv_transactions_cur
3215: