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 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 901: CURSOR rcv_transactions_cur IS

897: , pn_amount IN NUMBER
898: , pn_version_number IN NUMBER
899: )
900: IS
901: CURSOR rcv_transactions_cur IS
902: SELECT
903: destination_type_code
904: , shipment_line_id
905: FROM rcv_transactions

Line 905: FROM rcv_transactions

901: CURSOR rcv_transactions_cur IS
902: SELECT
903: destination_type_code
904: , shipment_line_id
905: FROM rcv_transactions
906: WHERE transaction_id = pn_transaction_id;
907:
908:
909: CURSOR get_mtl_parameters_cur IS

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 989: OPEN rcv_transactions_cur;

985: FND_FILE.PUT_LINE(fnd_file.log,'ln_retroprice_adj_account_id '|| ln_retroprice_adj_account_id);
986: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);
987: END IF; --l_proc_level>=l_dbg_level
988:
989: OPEN rcv_transactions_cur;
990: FETCH rcv_transactions_cur
991: INTO
992: lv_destination_type_code
993: , ln_shipment_line_id;

Line 990: FETCH rcv_transactions_cur

986: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);
987: END IF; --l_proc_level>=l_dbg_level
988:
989: OPEN rcv_transactions_cur;
990: FETCH rcv_transactions_cur
991: INTO
992: lv_destination_type_code
993: , ln_shipment_line_id;
994: CLOSE rcv_transactions_cur;

Line 994: CLOSE rcv_transactions_cur;

990: FETCH rcv_transactions_cur
991: INTO
992: lv_destination_type_code
993: , ln_shipment_line_id;
994: CLOSE rcv_transactions_cur;
995:
996: IF (ln_proc_level >= ln_dbg_level)
997: THEN
998: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 3');

Line 1020: , p_reference_24 => 'rcv_transactions'

1016: , p_currency_code => 'INR'
1017: , p_accounting_date => SYSDATE
1018: , p_reference_10 => NULL
1019: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1020: , p_reference_24 => 'rcv_transactions'
1021: , p_reference_25 => 'transaction_id'
1022: , p_reference_26 => to_char(pn_transaction_id)
1023: , p_destination => 'G'
1024: , p_simulate_flag => 'N'

Line 1057: , p_reference_24 => 'rcv_transactions'

1053: , p_currency_code => 'INR'
1054: , p_accounting_date => SYSDATE
1055: , p_reference_10 => NULL
1056: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1057: , p_reference_24 => 'rcv_transactions'
1058: , p_reference_25 => 'transaction_id'
1059: , p_reference_26 => to_char(pn_transaction_id)
1060: , p_destination => 'G'
1061: , p_simulate_flag => 'N'

Line 1101: , p_reference_24 => 'rcv_transactions'

1097: , p_currency_code => 'INR'
1098: , p_accounting_date => SYSDATE
1099: , p_reference_10 => NULL
1100: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1101: , p_reference_24 => 'rcv_transactions'
1102: , p_reference_25 => 'transaction_id'
1103: , p_reference_26 => to_char(pn_transaction_id)
1104: , p_destination => 'S'
1105: , p_simulate_flag => 'N'

Line 1137: , p_reference_24 => 'rcv_transactions'

1133: , p_currency_code => 'INR'
1134: , p_accounting_date => SYSDATE
1135: , p_reference_10 => NULL
1136: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1137: , p_reference_24 => 'rcv_transactions'
1138: , p_reference_25 => 'transaction_id'
1139: , p_reference_26 => to_char(pn_transaction_id)
1140: , p_destination => 'S'
1141: , p_simulate_flag => 'N'

Line 1229: , p_reference_24 => 'rcv_transactions'

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

Line 1305: , p_reference_24 => 'rcv_transactions'

1301: , p_currency_conversion_type => NULL
1302: , p_currency_conversion_rate => NULL
1303: , p_reference_10 => 'India Localization.....'
1304: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1305: , p_reference_24 => 'rcv_transactions'
1306: , p_reference_25 => 'transaction_id'
1307: , p_reference_26 => to_char(pn_transaction_id)
1308: , p_process_message => lv_process_message
1309: , p_process_status => lv_process_status

Line 1429: Rcv_Transactions

1425: SELECT
1426: transaction_id
1427: , organization_id
1428: FROM
1429: Rcv_Transactions
1430: WHERE shipment_line_id = pn_shipment_line_id
1431: AND transaction_type = 'DELIVER';
1432:
1433: ln_tax_diff_tot NUMBER;

Line 1435: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;

1431: AND transaction_type = 'DELIVER';
1432:
1433: ln_tax_diff_tot NUMBER;
1434: lv_currency Jai_Retro_Tax_Changes.Currency_Code%TYPE;
1435: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;
1436: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;
1437: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;
1438: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;
1439: ln_non_rec_amount NUMBER;

Line 1436: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;

1432:
1433: ln_tax_diff_tot NUMBER;
1434: lv_currency Jai_Retro_Tax_Changes.Currency_Code%TYPE;
1435: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;
1436: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;
1437: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;
1438: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;
1439: ln_non_rec_amount NUMBER;
1440: lv_include_cenvat_in_costing VARCHAR2(10);

Line 1469: Rcv_Transactions

1465: INTO
1466: ln_curr_conv_rate
1467: , ln_organization_id
1468: FROM
1469: Rcv_Transactions
1470: WHERE shipment_line_id = pn_shipment_line_id
1471: AND transaction_type = 'RECEIVE';
1472:
1473: IF (ln_proc_level >= ln_dbg_level)

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

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

Line 1539: , p_reference_24 => 'rcv_transactions'

1535: , p_currency_code => 'INR'
1536: , p_accounting_date => SYSDATE
1537: , p_reference_10 => NULL
1538: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1539: , p_reference_24 => 'rcv_transactions'
1540: , p_reference_25 => 'transaction_id'
1541: , p_reference_26 => to_char(pn_transaction_id)
1542: , p_destination => 'G' --G indicates GL Interface Entries,
1543: , p_simulate_flag => 'N'

Line 1591: , p_reference_24 => 'rcv_transactions'

1587: , p_currency_code => 'INR'
1588: , p_accounting_date => SYSDATE
1589: , p_reference_10 => NULL
1590: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1591: , p_reference_24 => 'rcv_transactions'
1592: , p_reference_25 => 'transaction_id'
1593: , p_reference_26 => to_char(pn_transaction_id)
1594: , p_destination => 'G' --GL Interface Entries
1595: , p_simulate_flag => 'N'

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

1612: END IF; --l_proc_level>=l_dbg_level
1613:
1614: ln_non_rec_amount := pn_non_rec_amount;
1615:
1616: --LOOP through the DELIVER transactions for the shipment_line_id from rcv_transactions
1617: FOR trx_rec IN Rcv_Trx_Cur
1618: LOOP
1619: IF pn_cenvat_amount <> 0 --if the recoverable cenvat amount is not zero
1620: 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 1760: rcv_transactions_rec rcv_transactions%ROWTYPE;

1756: --This procedure is used to CLAIm or UNCLAIM VAT to the extent it got modified
1757: --It does the corresponding accounting as well
1758:
1759: jai_rcv_rgm_lines_rec jai_rcv_rgm_lines%ROWTYPE;
1760: rcv_transactions_rec rcv_transactions%ROWTYPE;
1761: ln_tot_clm_instl_amt NUMBER;
1762: ln_tot_instl_amt NUMBER;
1763: ln_installment_cnt NUMBER;
1764: ln_new_re_tax_amt NUMBER;

Line 1788: CURSOR get_rcv_transactions_cur

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
1791: *
1792: FROM

Line 1793: rcv_transactions

1789: IS
1790: SELECT
1791: *
1792: FROM
1793: rcv_transactions
1794: WHERE
1795: transaction_id = pn_transaction_id;
1796:
1797: CURSOR jai_rcv_rgm_lines_cur (pn_shipment_line_id NUMBER)

Line 1893: OPEN get_rcv_transactions_cur;

1889: );
1890: END IF; --l_proc_level>=l_dbg_level
1891: --Get the primary_cost_method from mtl_parameters for the organization
1892:
1893: OPEN get_rcv_transactions_cur;
1894: FETCH get_rcv_transactions_cur
1895: INTO
1896: rcv_transactions_rec ;
1897: CLOSE get_rcv_transactions_cur;

Line 1894: FETCH get_rcv_transactions_cur

1890: END IF; --l_proc_level>=l_dbg_level
1891: --Get the primary_cost_method from mtl_parameters for the organization
1892:
1893: OPEN get_rcv_transactions_cur;
1894: FETCH get_rcv_transactions_cur
1895: INTO
1896: rcv_transactions_rec ;
1897: CLOSE get_rcv_transactions_cur;
1898:

Line 1896: rcv_transactions_rec ;

1892:
1893: OPEN get_rcv_transactions_cur;
1894: FETCH get_rcv_transactions_cur
1895: INTO
1896: rcv_transactions_rec ;
1897: CLOSE get_rcv_transactions_cur;
1898:
1899: -- Get the receipt_num
1900: SELECT receipt_num

Line 1897: CLOSE get_rcv_transactions_cur;

1893: OPEN get_rcv_transactions_cur;
1894: FETCH get_rcv_transactions_cur
1895: INTO
1896: rcv_transactions_rec ;
1897: CLOSE get_rcv_transactions_cur;
1898:
1899: -- Get the receipt_num
1900: SELECT receipt_num
1901: INTO lv_receipt_number

Line 2070: pv_source_table_name => 'RCV_TRANSACTIONS',

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

Line 2122: p_currency_code => rcv_transactions_rec.currency_code,

2118: p_category_name => 'Receiving India',
2119: p_code_combination_id => ln_code_combination_id,
2120: p_entered_dr => claim_schedule_rec.claim_amount,
2121: p_entered_cr => NULL,
2122: p_currency_code => rcv_transactions_rec.currency_code,
2123: p_accounting_date => SYSDATE,
2124: p_reference_10 => lv_reference_10,
2125: p_reference_23 => lv_reference_23,
2126: p_reference_24 => lv_reference_24,

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 2357: , pn_curr_conv_rate => jai_transaction_rec.currency_conversion_rate -- from rcv_transactions

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
2356: , pn_transaction_id => pn_transaction_id
2357: , pn_curr_conv_rate => jai_transaction_rec.currency_conversion_rate -- from rcv_transactions
2358: , pr_tax => xt_tax_breakup_rec -- OUT parameter
2359: , pv_breakup_type => lv_tax_breakup_type
2360: , pn_line_change_id => pn_line_change_id
2361: );

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 2636: CURSOR get_rcv_transactions_cur

2632: ln_org_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2633: ln_modif_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2634: ln_diff_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2635:
2636: CURSOR get_rcv_transactions_cur
2637: ( pn_line_location_id rcv_transactions.po_line_location_id%TYPE
2638: , pn_line_change_id jai_retro_line_changes.line_change_id%TYPE
2639: )
2640: IS

Line 2637: ( pn_line_location_id rcv_transactions.po_line_location_id%TYPE

2633: ln_modif_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2634: ln_diff_nonre_tax_amount NUMBER; --added by eric on Apr 10,2008 for bug 6957519/6958938/6968839
2635:
2636: CURSOR get_rcv_transactions_cur
2637: ( pn_line_location_id rcv_transactions.po_line_location_id%TYPE
2638: , pn_line_change_id jai_retro_line_changes.line_change_id%TYPE
2639: )
2640: IS
2641: SELECT

Line 2644: rcv_transactions rt

2640: IS
2641: SELECT
2642: *
2643: FROM
2644: rcv_transactions rt
2645: WHERE rt.transaction_type = 'RECEIVE'
2646: AND rt.po_line_location_id =pn_line_location_id
2647: AND creation_date >= NVL(ld_from_eff_date,creation_date)-- eric changed according to review comment #36
2648: AND NOT EXISTS ( SELECT

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

2804: ln_receipt_processed_no :=0 ;--Initial vaiable for counting receipt processed number for a shipment
2805: ln_tot_receipt_no :=0; --Initial vaiable for counting total receipts number for a shipment
2806:
2807: --LOOP through the RECEIVE transactions performed against the current Shipment
2808: FOR rcv_transactions_rec IN get_rcv_transactions_cur ( pn_line_location_id => jai_retro_line_change_rec.line_location_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;

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

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

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 2944: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions

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

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

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

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

2955: THEN
2956: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_line_changes inserted ');
2957: END IF; --l_proc_level>=l_dbg_level
2958:
2959: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
2960: LOOP
2961: -- Insert into jai_retro_tax_changes
2962: INSERT INTO jai_retro_tax_changes
2963: ( tax_change_id

Line 3011: * rcv_transactions_rec.quantity;

3007: END IF; --l_proc_level>=l_dbg_level
3008:
3009: --calc_new_line_amount
3010: ln_recv_line_amount := jai_retro_line_change_rec.modified_unit_price
3011: * rcv_transactions_rec.quantity;
3012:
3013: ln_recv_tax_amount := ln_recv_line_amount;
3014:
3015: IF (ln_proc_level >= ln_dbg_level)

Line 3023: ( p_vendor_id => rcv_transactions_rec.vendor_id

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

Line 3024: , p_vendor_site_id => rcv_transactions_rec.vendor_site_id

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

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 3038: ln_assessable_value := ln_assessable_value * rcv_transactions_rec.quantity;

3034: IF NVL( ln_assessable_value, 0 ) <= 0
3035: THEN
3036: ln_assessable_value := ln_recv_line_amount;
3037: ELSE
3038: ln_assessable_value := ln_assessable_value * rcv_transactions_rec.quantity;
3039: END IF;
3040:
3041: IF (ln_proc_level >= ln_dbg_level)
3042: THEN

Line 3048: ( p_party_id => rcv_transactions_rec.vendor_id

3044: END IF; --l_proc_level>=l_dbg_level
3045:
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

Line 3049: , p_party_site_id => rcv_transactions_rec.vendor_site_id

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

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 3063: ln_vat_assess_value := ln_vat_assess_value * rcv_transactions_rec.quantity;

3059: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value : '|| ln_vat_assess_value);
3060: END IF; --l_proc_level>=l_dbg_level
3061:
3062:
3063: ln_vat_assess_value := ln_vat_assess_value * rcv_transactions_rec.quantity;
3064:
3065: IF (ln_proc_level >= ln_dbg_level)
3066: THEN
3067: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value :=ln_vat_assess_value*quantity : '|| ln_vat_assess_value);

Line 3074: ( p_party_id => rcv_transactions_rec.vendor_id

3070: -- Added by Jia for GST Bug#10043656 on 2010/09/10, Begin
3071: -------------------------------------------------------------------------------------------
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

Line 3075: , p_party_site_id => rcv_transactions_rec.vendor_site_id

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

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 3088: ln_gst_assessable_value := ln_gst_assessable_value * rcv_transactions_rec.quantity;

3084: THEN
3085: FND_FILE.PUT_LINE(fnd_file.log, ' ln_gst_assessable_value : '|| ln_gst_assessable_value);
3086: END IF; --l_proc_level>=l_dbg_level
3087:
3088: ln_gst_assessable_value := ln_gst_assessable_value * rcv_transactions_rec.quantity;
3089:
3090: IF (ln_proc_level >= ln_dbg_level)
3091: THEN
3092: FND_FILE.PUT_LINE(fnd_file.log, ' ln_gst_assessable_value :=ln_gst_assessable_value*quantity : '|| ln_gst_assessable_value);

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

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

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 3111: , p_conv_rate => rcv_transactions_rec.currency_conversion_rate -- currency conversion rate

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
3115: , pn_gst_assessable_value => ln_gst_assessable_value -- Added by Jia for GST Bug#10043656

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

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
3125: -- Update the new tax amount in modified_tax_amount column of jai_retro_tax_changes
3126: UPDATE
3127: jai_retro_tax_changes jrtc

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

3178: -- xv_cenvat_action/xv_vat_action are IN OUT parameters. Even if the user decides
3179: -- to claim cenvat, depending on set up we may chose to unclaim. This parameter returns the action taken
3180: -- and takes the pv_cenvat_action as input
3181: Do_Accounting
3182: ( pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3183: , pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions for the current RECEIVE transaction,
3184: , pn_cenvat_amount => ln_diff_re_cenvat_amount -- Cenvat amount difference from above
3185: , xv_cenvat_action => lv_cenvat_action
3186: , pn_vat_amount => ln_diff_re_vat_amount -- recoverable VAT difference from above

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

3179: -- to claim cenvat, depending on set up we may chose to unclaim. This parameter returns the action taken
3180: -- and takes the pv_cenvat_action as input
3181: Do_Accounting
3182: ( pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3183: , pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions for the current RECEIVE transaction,
3184: , pn_cenvat_amount => ln_diff_re_cenvat_amount -- Cenvat amount difference from above
3185: , xv_cenvat_action => lv_cenvat_action
3186: , pn_vat_amount => ln_diff_re_vat_amount -- recoverable VAT difference from above
3187: , xv_vat_action => lv_vat_action

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

3204: -- if its UNCLAIMED then amount is already uncalimed during DELIVER in do_accounting
3205: IF (NVL(lv_cenvat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_cenvat_amount <> 0 )
3206: THEN
3207: Do_Cenvat_Claim
3208: ( pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions
3209: , pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3210: --, pn_cenvat_amount => ln_diff_re_cenvat_amount ,delete the useless parameter by eric on Jan 24,2008
3211: , pv_supp_exc_inv_no => pv_supp_exc_inv_no
3212: , pd_supp_exc_inv_date => ld_supp_exc_inv_date

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

3205: IF (NVL(lv_cenvat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_cenvat_amount <> 0 )
3206: THEN
3207: Do_Cenvat_Claim
3208: ( pn_transaction_id => rcv_transactions_rec.transaction_id -- from rcv_transactions
3209: , pn_shipment_line_id => rcv_transactions_rec.shipment_line_id -- from rcv_transactions
3210: --, pn_cenvat_amount => ln_diff_re_cenvat_amount ,delete the useless parameter by eric on Jan 24,2008
3211: , pv_supp_exc_inv_no => pv_supp_exc_inv_no
3212: , pd_supp_exc_inv_date => ld_supp_exc_inv_date
3213: , pn_version_number => ln_retro_line_changes_version -- current version of the receipt

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

3228:
3229: IF (NVL(lv_vat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_vat_amount <> 0)
3230: THEN --if VAT is unclaimed in do_accounting then we should not claim or unclaim
3231: Do_Vat_Claim
3232: ( pn_transaction_id => rcv_transactions_rec.transaction_id, -- from rcv_transactions
3233: pn_shipment_line_id => rcv_transactions_rec.shipment_line_id, -- from rcv_transactions
3234: pn_vat_amount => ln_diff_re_vat_amount,
3235: pv_supp_vat_inv_no => pv_supp_vat_inv_no,
3236: pd_supp_vat_inv_date => ld_supp_vat_inv_date,

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

3229: IF (NVL(lv_vat_action,'$') <> 'UNCLAIMED' AND ln_diff_re_vat_amount <> 0)
3230: THEN --if VAT is unclaimed in do_accounting then we should not claim or unclaim
3231: Do_Vat_Claim
3232: ( pn_transaction_id => rcv_transactions_rec.transaction_id, -- from rcv_transactions
3233: pn_shipment_line_id => rcv_transactions_rec.shipment_line_id, -- from rcv_transactions
3234: pn_vat_amount => ln_diff_re_vat_amount,
3235: pv_supp_vat_inv_no => pv_supp_vat_inv_no,
3236: pd_supp_vat_inv_date => ld_supp_vat_inv_date,
3237: pn_version_number => ln_retro_line_changes_version -- current version of the receipt

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, ' ++');

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

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

Line 3259: END LOOP; --rcv_transactions_rec IN get_rcv_transactions_cur

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:
3261: IF (ln_skip_rcpt_cnt =0)
3262: THEN
3263: UPDATE