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 RCV_TRANSACTIONS

Line 738: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE

734: --
735: -- 14-JAN-2008 Eric Ma created
736: --==========================================================================
737: Function Get_Jai_Rcv_Trans_Record
738: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
739: )
740: RETURN jai_rcv_transactions%ROWTYPE
741: IS
742:

Line 740: RETURN jai_rcv_transactions%ROWTYPE

736: --==========================================================================
737: Function Get_Jai_Rcv_Trans_Record
738: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
739: )
740: RETURN jai_rcv_transactions%ROWTYPE
741: IS
742:
743: CURSOR get_jai_rcv_transactions_cur
744: IS

Line 743: CURSOR get_jai_rcv_transactions_cur

739: )
740: RETURN jai_rcv_transactions%ROWTYPE
741: IS
742:
743: CURSOR get_jai_rcv_transactions_cur
744: IS
745: SELECT
746: *
747: FROM

Line 748: jai_rcv_transactions

744: IS
745: SELECT
746: *
747: FROM
748: jai_rcv_transactions
749: WHERE transaction_id = pn_transaction_id;
750:
751:
752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

Line 752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

748: jai_rcv_transactions
749: WHERE transaction_id = pn_transaction_id;
750:
751:
752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
753:
754: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
755: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
756: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 768: OPEN get_jai_rcv_transactions_cur;

764: , 'Enter procedure'
765: );
766: END IF; --l_proc_level>=l_dbg_level
767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:

Line 769: FETCH get_jai_rcv_transactions_cur

765: );
766: END IF; --l_proc_level>=l_dbg_level
767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:
773: --logging for debug

Line 770: INTO jai_rcv_transactions_rec;

766: END IF; --l_proc_level>=l_dbg_level
767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:
773: --logging for debug
774: IF (ln_proc_level >= ln_dbg_level)

Line 771: CLOSE get_jai_rcv_transactions_cur;

767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:
773: --logging for debug
774: IF (ln_proc_level >= ln_dbg_level)
775: THEN

Line 781: RETURN jai_rcv_transactions_rec;

777: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
778: , 'Exit procedure'
779: );
780: END IF; -- (ln_proc_level>=ln_dbg_level)
781: RETURN jai_rcv_transactions_rec;
782: EXCEPTION
783: WHEN OTHERS THEN
784: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
785: THEN

Line 815: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE

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
819:

Line 896: CURSOR rcv_transactions_cur IS

892: , pn_amount IN NUMBER
893: , pn_version_number IN NUMBER
894: )
895: IS
896: CURSOR rcv_transactions_cur IS
897: SELECT
898: destination_type_code
899: , shipment_line_id
900: FROM rcv_transactions

Line 900: FROM rcv_transactions

896: CURSOR rcv_transactions_cur IS
897: SELECT
898: destination_type_code
899: , shipment_line_id
900: FROM rcv_transactions
901: WHERE transaction_id = pn_transaction_id;
902:
903:
904: CURSOR get_mtl_parameters_cur IS

Line 925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;

921: WHERE
922: organization_id = pn_organization_id;
923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%TYPE;
929: lv_process_message VARCHAR2(500);

Line 926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;

922: organization_id = pn_organization_id;
923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%TYPE;
929: lv_process_message VARCHAR2(500);
930: lv_process_status VARCHAR2(500);

Line 927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;

923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%TYPE;
929: lv_process_message VARCHAR2(500);
930: lv_process_status VARCHAR2(500);
931: lv_code_path VARCHAR2(500);

Line 984: OPEN rcv_transactions_cur;

980: FND_FILE.PUT_LINE(fnd_file.log,'ln_retroprice_adj_account_id '|| ln_retroprice_adj_account_id);
981: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);
982: END IF; --l_proc_level>=l_dbg_level
983:
984: OPEN rcv_transactions_cur;
985: FETCH rcv_transactions_cur
986: INTO
987: lv_destination_type_code
988: , ln_shipment_line_id;

Line 985: FETCH rcv_transactions_cur

981: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);
982: END IF; --l_proc_level>=l_dbg_level
983:
984: OPEN rcv_transactions_cur;
985: FETCH rcv_transactions_cur
986: INTO
987: lv_destination_type_code
988: , ln_shipment_line_id;
989: CLOSE rcv_transactions_cur;

Line 989: CLOSE rcv_transactions_cur;

985: FETCH rcv_transactions_cur
986: INTO
987: lv_destination_type_code
988: , ln_shipment_line_id;
989: CLOSE rcv_transactions_cur;
990:
991: IF (ln_proc_level >= ln_dbg_level)
992: THEN
993: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 3');

Line 1015: , p_reference_24 => 'rcv_transactions'

1011: , p_currency_code => 'INR'
1012: , p_accounting_date => SYSDATE
1013: , p_reference_10 => NULL
1014: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1015: , p_reference_24 => 'rcv_transactions'
1016: , p_reference_25 => 'transaction_id'
1017: , p_reference_26 => to_char(pn_transaction_id)
1018: , p_destination => 'G'
1019: , p_simulate_flag => 'N'

Line 1052: , p_reference_24 => 'rcv_transactions'

1048: , p_currency_code => 'INR'
1049: , p_accounting_date => SYSDATE
1050: , p_reference_10 => NULL
1051: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1052: , p_reference_24 => 'rcv_transactions'
1053: , p_reference_25 => 'transaction_id'
1054: , p_reference_26 => to_char(pn_transaction_id)
1055: , p_destination => 'G'
1056: , p_simulate_flag => 'N'

Line 1096: , p_reference_24 => 'rcv_transactions'

1092: , p_currency_code => 'INR'
1093: , p_accounting_date => SYSDATE
1094: , p_reference_10 => NULL
1095: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1096: , p_reference_24 => 'rcv_transactions'
1097: , p_reference_25 => 'transaction_id'
1098: , p_reference_26 => to_char(pn_transaction_id)
1099: , p_destination => 'S'
1100: , p_simulate_flag => 'N'

Line 1132: , p_reference_24 => 'rcv_transactions'

1128: , p_currency_code => 'INR'
1129: , p_accounting_date => SYSDATE
1130: , p_reference_10 => NULL
1131: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1132: , p_reference_24 => 'rcv_transactions'
1133: , p_reference_25 => 'transaction_id'
1134: , p_reference_26 => to_char(pn_transaction_id)
1135: , p_destination => 'S'
1136: , p_simulate_flag => 'N'

Line 1224: , p_reference_24 => 'rcv_transactions'

1220: , p_currency_conversion_type => NULL
1221: , p_currency_conversion_rate => NULL
1222: , p_reference_10 => 'JAI Retropricing Unclaim Entry for the Receipt Number '||lv_receipt_num ||' for the Organization code '||lv_organization_code
1223: , p_reference_23 => 'JAI_RETRO_PRC_PKG.Do_Accounting'
1224: , p_reference_24 => 'rcv_transactions'
1225: , p_reference_25 => 'transaction_id'
1226: , p_reference_26 => to_char(pn_transaction_id)
1227: , p_process_message => lv_process_message
1228: , p_process_status => lv_process_status

Line 1300: , p_reference_24 => 'rcv_transactions'

1296: , p_currency_conversion_type => NULL
1297: , p_currency_conversion_rate => NULL
1298: , p_reference_10 => 'India Localization.....'
1299: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1300: , p_reference_24 => 'rcv_transactions'
1301: , p_reference_25 => 'transaction_id'
1302: , p_reference_26 => to_char(pn_transaction_id)
1303: , p_process_message => lv_process_message
1304: , p_process_status => lv_process_status

Line 1424: Rcv_Transactions

1420: SELECT
1421: transaction_id
1422: , organization_id
1423: FROM
1424: Rcv_Transactions
1425: WHERE shipment_line_id = pn_shipment_line_id
1426: AND transaction_type = 'DELIVER';
1427:
1428: ln_tax_diff_tot NUMBER;

Line 1430: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;

1426: AND transaction_type = 'DELIVER';
1427:
1428: ln_tax_diff_tot NUMBER;
1429: lv_currency Jai_Retro_Tax_Changes.Currency_Code%TYPE;
1430: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;
1431: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;
1432: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;
1433: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;
1434: ln_non_rec_amount NUMBER;

Line 1431: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;

1427:
1428: ln_tax_diff_tot NUMBER;
1429: lv_currency Jai_Retro_Tax_Changes.Currency_Code%TYPE;
1430: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;
1431: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;
1432: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;
1433: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;
1434: ln_non_rec_amount NUMBER;
1435: lv_include_cenvat_in_costing VARCHAR2(10);

Line 1464: Rcv_Transactions

1460: INTO
1461: ln_curr_conv_rate
1462: , ln_organization_id
1463: FROM
1464: Rcv_Transactions
1465: WHERE shipment_line_id = pn_shipment_line_id
1466: AND transaction_type = 'RECEIVE';
1467:
1468: IF (ln_proc_level >= ln_dbg_level)

Line 1476: -- Get the difference in INR. Multiply with currency_conversion_rate of rcv_transactions

1472: FND_FILE.PUT_LINE(fnd_file.log,'ln_organization_id '|| ln_organization_id);
1473: END IF; --l_proc_level>=l_dbg_level
1474:
1475: --Get the total tax difference from jai_retro_tax_changes for the shipment_line_id
1476: -- Get the difference in INR. Multiply with currency_conversion_rate of rcv_transactions
1477: -- if the tax is in Non INR currency
1478: SELECT
1479: SUM((modified_tax_amount - original_tax_amount) * DECODE(currency_code,'INR',1, ln_curr_conv_rate)) tax_diff_tot
1480: INTO

Line 1534: , p_reference_24 => 'rcv_transactions'

1530: , p_currency_code => 'INR'
1531: , p_accounting_date => SYSDATE
1532: , p_reference_10 => NULL
1533: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1534: , p_reference_24 => 'rcv_transactions'
1535: , p_reference_25 => 'transaction_id'
1536: , p_reference_26 => to_char(pn_transaction_id)
1537: , p_destination => 'G' --G indicates GL Interface Entries,
1538: , p_simulate_flag => 'N'

Line 1586: , p_reference_24 => 'rcv_transactions'

1582: , p_currency_code => 'INR'
1583: , p_accounting_date => SYSDATE
1584: , p_reference_10 => NULL
1585: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1586: , p_reference_24 => 'rcv_transactions'
1587: , p_reference_25 => 'transaction_id'
1588: , p_reference_26 => to_char(pn_transaction_id)
1589: , p_destination => 'G' --GL Interface Entries
1590: , p_simulate_flag => 'N'

Line 1611: --LOOP through the DELIVER transactions for the shipment_line_id from rcv_transactions

1607: END IF; --l_proc_level>=l_dbg_level
1608:
1609: ln_non_rec_amount := pn_non_rec_amount;
1610:
1611: --LOOP through the DELIVER transactions for the shipment_line_id from rcv_transactions
1612: FOR trx_rec IN Rcv_Trx_Cur
1613: LOOP
1614: IF pn_cenvat_amount <> 0 --if the recoverable cenvat amount is not zero
1615: 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 1755: rcv_transactions_rec rcv_transactions%ROWTYPE;

1751: --This procedure is used to CLAIm or UNCLAIM VAT to the extent it got modified
1752: --It does the corresponding accounting as well
1753:
1754: jai_rcv_rgm_lines_rec jai_rcv_rgm_lines%ROWTYPE;
1755: rcv_transactions_rec rcv_transactions%ROWTYPE;
1756: ln_tot_clm_instl_amt NUMBER;
1757: ln_tot_instl_amt NUMBER;
1758: ln_installment_cnt NUMBER;
1759: ln_new_re_tax_amt NUMBER;

Line 1783: CURSOR get_rcv_transactions_cur

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
1786: *
1787: FROM

Line 1788: rcv_transactions

1784: IS
1785: SELECT
1786: *
1787: FROM
1788: rcv_transactions
1789: WHERE
1790: transaction_id = pn_transaction_id;
1791:
1792: CURSOR jai_rcv_rgm_lines_cur (pn_shipment_line_id NUMBER)

Line 1888: OPEN get_rcv_transactions_cur;

1884: );
1885: END IF; --l_proc_level>=l_dbg_level
1886: --Get the primary_cost_method from mtl_parameters for the organization
1887:
1888: OPEN get_rcv_transactions_cur;
1889: FETCH get_rcv_transactions_cur
1890: INTO
1891: rcv_transactions_rec ;
1892: CLOSE get_rcv_transactions_cur;

Line 1889: FETCH get_rcv_transactions_cur

1885: END IF; --l_proc_level>=l_dbg_level
1886: --Get the primary_cost_method from mtl_parameters for the organization
1887:
1888: OPEN get_rcv_transactions_cur;
1889: FETCH get_rcv_transactions_cur
1890: INTO
1891: rcv_transactions_rec ;
1892: CLOSE get_rcv_transactions_cur;
1893:

Line 1891: rcv_transactions_rec ;

1887:
1888: OPEN get_rcv_transactions_cur;
1889: FETCH get_rcv_transactions_cur
1890: INTO
1891: rcv_transactions_rec ;
1892: CLOSE get_rcv_transactions_cur;
1893:
1894: -- Get the receipt_num
1895: SELECT receipt_num

Line 1892: CLOSE get_rcv_transactions_cur;

1888: OPEN get_rcv_transactions_cur;
1889: FETCH get_rcv_transactions_cur
1890: INTO
1891: rcv_transactions_rec ;
1892: CLOSE get_rcv_transactions_cur;
1893:
1894: -- Get the receipt_num
1895: SELECT receipt_num
1896: INTO lv_receipt_number

Line 2065: pv_source_table_name => 'RCV_TRANSACTIONS',

2061: pn_organization_id => ln_organization_id, -- fetched above
2062: pn_location_id => ln_location_id, -- fetched above
2063: pv_source => jai_constants.source_rcv,
2064: pv_source_trx_type => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),
2065: pv_source_table_name => 'RCV_TRANSACTIONS',
2066: pn_source_id => pn_transaction_id,
2067: pd_transaction_date => trunc(sysdate),
2068: pv_account_name => jai_constants.recovery,
2069: pn_charge_account_id => ln_code_combination_id,

Line 2113: p_currency_code => rcv_transactions_rec.currency_code,

2109: p_category_name => 'Receiving India',
2110: p_code_combination_id => ln_code_combination_id,
2111: p_entered_dr => claim_schedule_rec.claim_amount,
2112: p_entered_cr => NULL,
2113: p_currency_code => rcv_transactions_rec.currency_code,
2114: p_accounting_date => SYSDATE,
2115: p_reference_10 => lv_reference_10,
2116: p_reference_23 => lv_reference_23,
2117: p_reference_24 => lv_reference_24,

Line 2254: jai_rcv_transactions

2250: IS
2251: SELECT
2252: *
2253: FROM
2254: jai_rcv_transactions
2255: WHERE
2256: transaction_id = pn_transaction_id;
2257:
2258: CURSOR get_rcv_cenvat_claim_cur

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

2320: RETURN;
2321: END IF;
2322:
2323:
2324: --Get the record from jai_rcv_transactions for the current transaction_id
2325: OPEN get_jai_transaction_cur;
2326: FETCH get_jai_transaction_cur
2327: INTO jai_transaction_rec;
2328: CLOSE get_jai_transaction_cur;

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

2338: THEN --Trading
2339: lv_tax_breakup_type := 'RG23D';
2340: ELSE -- manufacturing and others
2341: lv_tax_breakup_type := 'MODVAT';
2342: END IF;--(jai_rcv_transactions.organization_type = 'T')
2343:
2344: --Call the following procedure to get the tax amounts by tax types
2345: Get_Tax_Amount_Breakup
2346: ( pn_shipment_line_id => pn_shipment_line_id

Line 2348: , pn_curr_conv_rate => jai_transaction_rec.currency_conversion_rate -- from rcv_transactions

2344: --Call the following procedure to get the tax amounts by tax types
2345: Get_Tax_Amount_Breakup
2346: ( pn_shipment_line_id => pn_shipment_line_id
2347: , pn_transaction_id => pn_transaction_id
2348: , pn_curr_conv_rate => jai_transaction_rec.currency_conversion_rate -- from rcv_transactions
2349: , pr_tax => xt_tax_breakup_rec -- OUT parameter
2350: , pv_breakup_type => lv_tax_breakup_type
2351: , pn_line_change_id => pn_line_change_id
2352: );

Line 2589: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

2585: , pv_supp_vat_inv_date IN VARCHAR2 DEFAULT NULL
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);

Line 2623: CURSOR get_rcv_transactions_cur

2619: ln_org_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2620: ln_modif_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2621: ln_diff_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2622:
2623: CURSOR get_rcv_transactions_cur
2624: ( pn_line_location_id rcv_transactions.po_line_location_id%TYPE
2625: , pn_line_change_id jai_retro_line_changes.line_change_id%TYPE
2626: )
2627: IS

Line 2624: ( pn_line_location_id rcv_transactions.po_line_location_id%TYPE

2620: ln_modif_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2621: ln_diff_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2622:
2623: CURSOR get_rcv_transactions_cur
2624: ( pn_line_location_id rcv_transactions.po_line_location_id%TYPE
2625: , pn_line_change_id jai_retro_line_changes.line_change_id%TYPE
2626: )
2627: IS
2628: SELECT

Line 2631: rcv_transactions rt

2627: IS
2628: SELECT
2629: *
2630: FROM
2631: rcv_transactions rt
2632: WHERE rt.transaction_type = 'RECEIVE'
2633: AND rt.po_line_location_id =pn_line_location_id
2634: AND creation_date >= NVL(ld_from_eff_date,creation_date)-- eric changed according to review comment #36
2635: AND NOT EXISTS ( SELECT

Line 2795: FOR rcv_transactions_rec IN get_rcv_transactions_cur ( pn_line_location_id => jai_retro_line_change_rec.line_location_id

2791: ln_receipt_processed_no :=0 ;--Initial vaiable for counting receipt processed number for a shipment
2792: ln_tot_receipt_no :=0; --Initial vaiable for counting total receipts number for a shipment
2793:
2794: --LOOP through the RECEIVE transactions performed against the current Shipment
2795: FOR rcv_transactions_rec IN get_rcv_transactions_cur ( pn_line_location_id => jai_retro_line_change_rec.line_location_id
2796: , pn_line_change_id => jai_retro_line_change_rec.line_change_id
2797: )
2798: LOOP
2799: ln_tot_receipt_no := ln_tot_receipt_no +1;

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

2796: , pn_line_change_id => jai_retro_line_change_rec.line_change_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, ' ');

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 2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);

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

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

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;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL

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

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;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'

Line 2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL

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;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL

Line 2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'

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;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

Line 2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'

2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

Line 2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'

2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

Line 2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL

2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )

Line 2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )
2823: THEN

Line 2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )
2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before

Line 2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )
2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run

Line 2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL

2822: )
2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )

Line 2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'

2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )
2831: THEN

Line 2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'

2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
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.');

Line 2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'

2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
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;

Line 2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL

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'
2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )

Line 2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

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'
2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )
2840: THEN

Line 2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

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'
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.');

Line 2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

2834:
2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
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;

Line 2931: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions

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
2935: , SYSDATE --=> sysdate

Line 2932: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions

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
2935: , SYSDATE --=> sysdate
2936: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id

Line 2946: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)

2942: THEN
2943: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_line_changes inserted ');
2944: END IF; --l_proc_level>=l_dbg_level
2945:
2946: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
2947: LOOP
2948: -- Insert into jai_retro_tax_changes
2949: INSERT INTO jai_retro_tax_changes
2950: ( tax_change_id

Line 2998: * rcv_transactions_rec.quantity;

2994: END IF; --l_proc_level>=l_dbg_level
2995:
2996: --calc_new_line_amount
2997: ln_recv_line_amount := jai_retro_line_change_rec.modified_unit_price
2998: * rcv_transactions_rec.quantity;
2999:
3000: ln_recv_tax_amount := ln_recv_line_amount;
3001:
3002: IF (ln_proc_level >= ln_dbg_level)

Line 3010: ( p_vendor_id => rcv_transactions_rec.vendor_id

3006: END IF; --l_proc_level>=l_dbg_level
3007:
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: );

Line 3011: , p_vendor_site_id => rcv_transactions_rec.vendor_site_id

3007:
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:

Line 3013: , p_line_uom => jai_rcv_transactions_rec.uom_code

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)
3017: THEN

Line 3025: ln_assessable_value := ln_assessable_value * rcv_transactions_rec.quantity;

3021: IF NVL( ln_assessable_value, 0 ) <= 0
3022: THEN
3023: ln_assessable_value := ln_recv_line_amount;
3024: ELSE
3025: ln_assessable_value := ln_assessable_value * rcv_transactions_rec.quantity;
3026: END IF;
3027:
3028: IF (ln_proc_level >= ln_dbg_level)
3029: THEN

Line 3035: ( p_party_id => rcv_transactions_rec.vendor_id

3031: END IF; --l_proc_level>=l_dbg_level
3032:
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

Line 3036: , p_party_site_id => rcv_transactions_rec.vendor_site_id

3032:
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)

Line 3038: , p_uom_code => jai_rcv_transactions_rec.uom_code

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'
3042: );

Line 3050: ln_vat_assess_value := ln_vat_assess_value * rcv_transactions_rec.quantity;

3046: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value : '|| ln_vat_assess_value);
3047: END IF; --l_proc_level>=l_dbg_level
3048:
3049:
3050: ln_vat_assess_value := ln_vat_assess_value * rcv_transactions_rec.quantity;
3051:
3052: IF (ln_proc_level >= ln_dbg_level)
3053: THEN
3054: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value :=ln_vat_assess_value*quantity : '|| ln_vat_assess_value);

Line 3062: , p_line_quantity => rcv_transactions_rec.quantity -- receipt Quantity

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
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

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

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
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

Line 3069: , p_conv_rate => rcv_transactions_rec.currency_conversion_rate -- currency conversion rate

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

Line 3078: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)

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
3080: -- Update the new tax amount in modified_tax_amount column of jai_retro_tax_changes
3081: UPDATE
3082: jai_retro_tax_changes jrtc

Line 3137: ( pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions

3133: -- xv_cenvat_action/xv_vat_action are IN OUT parameters. Even if the user decides
3134: -- to claim cenvat, depending on set up we may chose to unclaim. This parameter returns the action taken
3135: -- and takes the pv_cenvat_action as input
3136: Do_Accounting
3137: ( pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3138: , pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions for the current RECEIVE transaction,
3139: , pn_cenvat_amount => ln_diff_re_cenvat_amount -- Cenvat amount difference from above
3140: , xv_cenvat_action => lv_cenvat_action
3141: , pn_vat_amount => ln_diff_re_vat_amount -- recoverable VAT difference from above

Line 3138: , pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions for the current RECEIVE transaction,

3134: -- to claim cenvat, depending on set up we may chose to unclaim. This parameter returns the action taken
3135: -- and takes the pv_cenvat_action as input
3136: Do_Accounting
3137: ( pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3138: , pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions for the current RECEIVE transaction,
3139: , pn_cenvat_amount => ln_diff_re_cenvat_amount -- Cenvat amount difference from above
3140: , xv_cenvat_action => lv_cenvat_action
3141: , pn_vat_amount => ln_diff_re_vat_amount -- recoverable VAT difference from above
3142: , xv_vat_action => lv_vat_action

Line 3163: ( pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions

3159: -- if its UNCLAIMED then amount is already uncalimed during DELIVER in do_accounting
3160: IF (NVL(lv_cenvat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_cenvat_amount <> 0 )
3161: THEN
3162: Do_Cenvat_Claim
3163: ( pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions
3164: , pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3165: --, pn_cenvat_amount => ln_diff_re_cenvat_amount ,delete the useless parameter by eric on Jan 24,2008
3166: , pv_supp_exc_inv_no => pv_supp_exc_inv_no
3167: , pd_supp_exc_inv_date => ld_supp_exc_inv_date

Line 3164: , pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions

3160: IF (NVL(lv_cenvat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_cenvat_amount <> 0 )
3161: THEN
3162: Do_Cenvat_Claim
3163: ( pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions
3164: , pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3165: --, pn_cenvat_amount => ln_diff_re_cenvat_amount ,delete the useless parameter by eric on Jan 24,2008
3166: , pv_supp_exc_inv_no => pv_supp_exc_inv_no
3167: , pd_supp_exc_inv_date => ld_supp_exc_inv_date
3168: , pn_version_number => ln_retro_line_changes_version -- current version of the receipt

Line 3187: ( pn_transaction_id => rcv_transactions_rec.transaction_id, -- from rcv_transactions

3183:
3184: IF (NVL(lv_vat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_vat_amount <> 0)
3185: THEN --if VAT is unclaimed in do_accounting then we should not claim or unclaim
3186: Do_Vat_Claim
3187: ( pn_transaction_id => rcv_transactions_rec.transaction_id, -- from rcv_transactions
3188: pn_shipment_line_id => rcv_transactions_rec.shipment_line_id, -- from rcv_transactions
3189: pn_vat_amount => ln_diff_re_vat_amount,
3190: pv_supp_vat_inv_no => pv_supp_vat_inv_no,
3191: pd_supp_vat_inv_date => ld_supp_vat_inv_date,

Line 3188: pn_shipment_line_id => rcv_transactions_rec.shipment_line_id, -- from rcv_transactions

3184: IF (NVL(lv_vat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_vat_amount <> 0)
3185: THEN --if VAT is unclaimed in do_accounting then we should not claim or unclaim
3186: Do_Vat_Claim
3187: ( pn_transaction_id => rcv_transactions_rec.transaction_id, -- from rcv_transactions
3188: pn_shipment_line_id => rcv_transactions_rec.shipment_line_id, -- from rcv_transactions
3189: pn_vat_amount => ln_diff_re_vat_amount,
3190: pv_supp_vat_inv_no => pv_supp_vat_inv_no,
3191: pd_supp_vat_inv_date => ld_supp_vat_inv_date,
3192: pn_version_number => ln_retro_line_changes_version -- current version of the receipt

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

3205: END IF; --(lv_vat_action <> 'UNCLAIMED' AND ln_vat_amount <> 0)
3206:
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, ' ++');

Line 3212: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);

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:
3216: IF (ln_skip_rcpt_cnt =0)

Line 3214: END LOOP; --rcv_transactions_rec IN get_rcv_transactions_cur

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:
3216: IF (ln_skip_rcpt_cnt =0)
3217: THEN
3218: UPDATE