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 801: -- Get_Jai_Rcv_Lines_Record Private

797:
798: --==========================================================================
799: -- Function NAME:
800: --
801: -- Get_Jai_Rcv_Lines_Record Private
802: --
803: -- DESCRIPTION:
804: --
805: -- This procedure is used to get the jai_rcv_lines record for a

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

801: -- Get_Jai_Rcv_Lines_Record Private
802: --
803: -- DESCRIPTION:
804: --
805: -- This procedure is used to get the jai_rcv_lines record for a
806: -- given transaction id
807: --
808: --
809: -- PARAMETERS:

Line 819: Function Get_Jai_Rcv_Lines_Record

815: -- CHANGE HISTORY:
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

Line 822: RETURN jai_rcv_lines%ROWTYPE

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:
825: CURSOR get_jai_rcv_lines_cur
826: IS

Line 825: CURSOR get_jai_rcv_lines_cur

821: )
822: RETURN jai_rcv_lines%ROWTYPE
823: IS
824:
825: CURSOR get_jai_rcv_lines_cur
826: IS
827: SELECT
828: *
829: FROM

Line 830: jai_rcv_lines

826: IS
827: SELECT
828: *
829: FROM
830: jai_rcv_lines
831: WHERE transaction_id = pn_transaction_id;
832:
833: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
834:

Line 833: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;

829: FROM
830: jai_rcv_lines
831: WHERE transaction_id = pn_transaction_id;
832:
833: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
834:
835: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
836: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
837: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 848: OPEN get_jai_rcv_lines_cur;

844: , 'Enter procedure'
845: );
846: END IF; --l_proc_level>=l_dbg_level
847:
848: OPEN get_jai_rcv_lines_cur;
849: FETCH get_jai_rcv_lines_cur
850: INTO jai_rcv_lines_rec;
851: CLOSE get_jai_rcv_lines_cur;
852:

Line 849: FETCH get_jai_rcv_lines_cur

845: );
846: END IF; --l_proc_level>=l_dbg_level
847:
848: OPEN get_jai_rcv_lines_cur;
849: FETCH get_jai_rcv_lines_cur
850: INTO jai_rcv_lines_rec;
851: CLOSE get_jai_rcv_lines_cur;
852:
853: --logging for debug

Line 850: INTO jai_rcv_lines_rec;

846: END IF; --l_proc_level>=l_dbg_level
847:
848: OPEN get_jai_rcv_lines_cur;
849: FETCH get_jai_rcv_lines_cur
850: INTO jai_rcv_lines_rec;
851: CLOSE get_jai_rcv_lines_cur;
852:
853: --logging for debug
854: IF (ln_proc_level >= ln_dbg_level)

Line 851: CLOSE get_jai_rcv_lines_cur;

847:
848: OPEN get_jai_rcv_lines_cur;
849: FETCH get_jai_rcv_lines_cur
850: INTO jai_rcv_lines_rec;
851: CLOSE get_jai_rcv_lines_cur;
852:
853: --logging for debug
854: IF (ln_proc_level >= ln_dbg_level)
855: THEN

Line 862: RETURN jai_rcv_lines_rec;

858: , 'Exit procedure'
859: );
860: END IF; -- (ln_proc_level>=ln_dbg_level)
861:
862: RETURN jai_rcv_lines_rec;
863: EXCEPTION
864: WHEN OTHERS
865: THEN
866: RAISE;

Line 867: END Get_Jai_Rcv_Lines_Record;

863: EXCEPTION
864: WHEN OTHERS
865: THEN
866: RAISE;
867: END Get_Jai_Rcv_Lines_Record;
868:
869: --==========================================================================
870: -- PROCEDURE NAME:
871: --

Line 1202: FROM jai_rcv_lines

1198:
1199: -- Get the receipt_num
1200: SELECT receipt_num
1201: INTO lv_receipt_num
1202: FROM jai_rcv_lines
1203: WHERE shipment_line_id = ln_shipment_line_id;
1204:
1205: IF (ln_proc_level >= ln_dbg_level)
1206: THEN

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

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

Line 1784: lv_receipt_number jai_rcv_lines.receipt_num%TYPE;

1780: lv_reference_25 VARCHAR2 (4000);
1781: lv_reference_26 VARCHAR2 (4000);
1782: lv_process_status VARCHAR2 (4000);
1783: lv_process_message VARCHAR2 (4000);
1784: lv_receipt_number jai_rcv_lines.receipt_num%TYPE;
1785: lv_code_path VARCHAR2 (4000); --TO BE DONE
1786: --lv_receipt_num jai_rcv_lines.receipt_num%TYPE;/*rchandan*/
1787:
1788: CURSOR get_rcv_transactions_cur

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

1782: lv_process_status VARCHAR2 (4000);
1783: lv_process_message VARCHAR2 (4000);
1784: lv_receipt_number jai_rcv_lines.receipt_num%TYPE;
1785: lv_code_path VARCHAR2 (4000); --TO BE DONE
1786: --lv_receipt_num jai_rcv_lines.receipt_num%TYPE;/*rchandan*/
1787:
1788: CURSOR get_rcv_transactions_cur
1789: IS
1790: SELECT

Line 1873: , jai_rcv_lines jrl

1869: , jrd.regime_id
1870: FROM
1871: jai_rcv_rgm_lines jrrl
1872: , jai_rgm_definitions jrd
1873: , jai_rcv_lines jrl
1874: WHERE jrrl.rcv_rgm_line_id = pn_rcv_rgm_line_id
1875: AND jrrl.shipment_line_id = jrl.shipment_line_id
1876: AND jrrl.regime_code = jrd.regime_code;
1877:

Line 1902: FROM jai_rcv_lines

1898:
1899: -- Get the receipt_num
1900: SELECT receipt_num
1901: INTO lv_receipt_number
1902: FROM jai_rcv_lines
1903: WHERE shipment_line_id = pn_shipment_line_id;
1904:
1905: --Get the record from jai_rcv_rgm_lines for the current shipment_line_id ( ln_rcv_rgm_line_id )
1906: OPEN jai_rcv_rgm_lines_cur (pn_shipment_line_id => pn_shipment_line_id);

Line 2600: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;

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);
2604:

Line 2814: jai_rcv_lines_rec := Get_Jai_Rcv_Lines_Record(rcv_transactions_rec.transaction_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, ' ');
2818: FND_FILE.PUT_LINE(fnd_file.log, ' ++');

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

2816: BEGIN
2817: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2818: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
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);

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

2817: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2818: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
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, '');

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

2818: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
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;

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

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;
2847:
2848: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2849: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

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

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;
2856:
2857: FND_FILE.PUT_LINE(fnd_file.log, ' Please Claim it before running the concurrent JAI Retroactive price Update');
2858: ln_skip_rcpt_cnt := ln_skip_rcpt_cnt + 1;

Line 2881: WHERE doc_header_id = jai_rcv_lines_rec.shipment_header_id

2877: INTO
2878: ln_retro_line_changes_version
2879: FROM
2880: jai_retro_line_changes
2881: WHERE doc_header_id = jai_rcv_lines_rec.shipment_header_id
2882: AND doc_line_id = jai_rcv_lines_rec.shipment_line_id
2883: AND doc_type = 'RECEIPT';
2884:
2885: IF (ln_proc_level >= ln_dbg_level)

Line 2882: AND doc_line_id = jai_rcv_lines_rec.shipment_line_id

2878: ln_retro_line_changes_version
2879: FROM
2880: jai_retro_line_changes
2881: WHERE doc_header_id = jai_rcv_lines_rec.shipment_header_id
2882: AND doc_line_id = jai_rcv_lines_rec.shipment_line_id
2883: AND doc_type = 'RECEIPT';
2884:
2885: IF (ln_proc_level >= ln_dbg_level)
2886: THEN

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

2921: )
2922: VALUES
2923: ( ln_retro_line_changes_id --=> jai_retro_line_changes_s.nextval
2924: , 'RECEIPT' --=> 'RECEIPT'
2925: , jai_rcv_lines_rec.shipment_header_id --=> shipment_header_id from jai_rcv_lines
2926: , jai_rcv_lines_rec.shipment_line_id --=> shipment_Line_Id from jai_rcv_lines
2927: , NULL --=> NULL
2928: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2929: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment

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

2922: VALUES
2923: ( ln_retro_line_changes_id --=> jai_retro_line_changes_s.nextval
2924: , 'RECEIPT' --=> 'RECEIPT'
2925: , jai_rcv_lines_rec.shipment_header_id --=> shipment_header_id from jai_rcv_lines
2926: , jai_rcv_lines_rec.shipment_line_id --=> shipment_Line_Id from jai_rcv_lines
2927: , NULL --=> NULL
2928: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2929: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment
2930: , SYSDATE --=> Sysdate

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

2927: , NULL --=> NULL
2928: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2929: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment
2930: , SYSDATE --=> Sysdate
2931: , jai_rcv_lines_rec.inventory_item_id --=> inventory_item_id from jai_rcv_lines
2932: , jai_rcv_lines_rec.organization_id --=> Organization_id from jai_rcv_lines
2933: , jai_retro_line_change_rec.original_unit_price --=> original_unit_price from jai_retro_line_changes of the current Release
2934: , jai_retro_line_change_rec.modified_unit_price --=> Modified_unit_price from jai_retro_line_changes of the current Release
2935: , 'Y' --=> receipt_processed_flag :'Y'

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

2928: , ln_retro_line_changes_version --=> Increment previous version number of this receipt,issue??
2929: , jai_retro_line_change_rec.line_change_id --=> source_line_change_id ,The line_change_id of latest shipment
2930: , SYSDATE --=> Sysdate
2931: , jai_rcv_lines_rec.inventory_item_id --=> inventory_item_id from jai_rcv_lines
2932: , jai_rcv_lines_rec.organization_id --=> Organization_id from jai_rcv_lines
2933: , jai_retro_line_change_rec.original_unit_price --=> original_unit_price from jai_retro_line_changes of the current Release
2934: , jai_retro_line_change_rec.modified_unit_price --=> Modified_unit_price from jai_retro_line_changes of the current Release
2935: , 'Y' --=> receipt_processed_flag :'Y'
2936: , pv_cenvat_action --=> pv_cenvat_action

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

2939: , pv_vat_action --=> pv_vat_action
2940: , pv_supp_vat_inv_no --=> pv_supp_vat_inv_no
2941: , ld_supp_vat_inv_date --=> pd_supp_vat_inv_date
2942: , fnd_global.conc_request_id --=> fnd_global.conc_request_id
2943: , jai_rcv_lines_rec.receipt_num --=> receipt_number from jai_rcv_lines
2944: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions
2945: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2946: , SYSDATE --=> sysdate
2947: , FND_GLOBAL.USER_ID --=> fnd_global.user_id

Line 3025: , p_inv_item_id => jai_rcv_lines_rec.inventory_item_id

3021: --get_assessable_value
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)

Line 3050: , p_inventory_item_id => jai_rcv_lines_rec.inventory_item_id

3046: --get_vat_assessable_value
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'

Line 3076: , p_inventory_item_id => jai_rcv_lines_rec.inventory_item_id

3072: /* for bug 16013918 by anupgupt
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'

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

3097:
3098:
3099: JAI_PO_TAX_PKG.Calculate_Tax
3100: ( p_type => 'RECEIPTS'
3101: , p_header_id => jai_rcv_lines_rec.shipment_header_id -- Receipt Shipment header Id
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

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

3098:
3099: JAI_PO_TAX_PKG.Calculate_Tax
3100: ( p_type => 'RECEIPTS'
3101: , p_header_id => jai_rcv_lines_rec.shipment_header_id -- Receipt Shipment header Id
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

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

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
3111: , p_conv_rate => rcv_transactions_rec.currency_conversion_rate -- currency conversion rate
3112: , pv_retroprice_changed => 'Y' --CHANGED NEW
3113: , pv_called_from => 'RETROACTIVE' -- New parameter
3114: /* for bug 16013918 by anupgupt

Line 3120: 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);

3116: */
3117: );
3118:
3119: -- print the new total tax amount of the receipt
3120: 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);
3121:
3122: -- After recalculating the tax ,updat the modified_tax_amount of jai_retro_tax_changes table
3123: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
3124: LOOP

Line 3131: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id

3127: jai_retro_tax_changes jrtc
3128: SET
3129: modified_tax_amount = ( SELECT tax_amount
3130: FROM jai_rcv_line_taxes jrlt
3131: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id
3132: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3133: AND jrlt.tax_id = jrtc.tax_id
3134: )
3135: WHERE line_change_id = ln_retro_line_changes_id

Line 3132: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id

3128: SET
3129: modified_tax_amount = ( SELECT tax_amount
3130: FROM jai_rcv_line_taxes jrlt
3131: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id
3132: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3133: AND jrlt.tax_id = jrtc.tax_id
3134: )
3135: WHERE line_change_id = ln_retro_line_changes_id
3136: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no

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

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, ' ++');
3259: END LOOP; --rcv_transactions_rec IN get_rcv_transactions_cur
3260: