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_RCV_DELIVER_RTR_PKG dependencies on DUAL

Line 36: - Modfied the Main Cursor in DELIVER_RTR_RECO_NONEXCISE procedure not to pass INDIVIDUAL accounting for taxes

32: and proceed further to do either of Costing or Expensing
33:
34: - Uncommented the call to OPM_COSTING to support OPM Receipts Functionality also
35: - INCLUDE_CENVAT_IN_COSTING is modified to include some more checks to return a value to caller
36: - Modfied the Main Cursor in DELIVER_RTR_RECO_NONEXCISE procedure not to pass INDIVIDUAL accounting for taxes
37: related to 'Service Tax India' and 'SERVICE_EDUCATION_CESS' tax types
38: - Modified the procedures expense_accounting, average_costing, standard_costing, opm_costing to include parameters
39: p_process_special_Reason in the signature. this is used to pass a different value for JAI_RCV_JOURNAL_ENTRIES.acct_nature,
40: for accounting_entries identification

Line 213: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;

209: ln_total := 0;
210: ln_opm_total := 0;
211:
212: -- this is to identify the path in SQL TRACE file if any problem occured
213: SELECT 'jai_rcv_deliver_rtr_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
214:
215: FND_FILE.put_line( FND_FILE.log, '~~~~~~ Start of jai_rcv_deliver_rtr_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss'));
216:
217: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.process_transaction', 'START'); /* 1 */

Line 351: /*Step 1 : Call Individual Tax Entries As this should happen in any case if

347: if lv_debug ='Y' then
348: fnd_file.put_line( fnd_file.log, '1.1 ln_apportion_factor ' || ln_apportion_factor );
349: end if;
350:
351: /*Step 1 : Call Individual Tax Entries As this should happen in any case if
352: Recoverable Taxes other than Excise Exist */
353: deliver_rtr_reco_nonexcise
354: (
355: p_transaction_id => r_trx.transaction_id,

Line 446: -- following if condition added to return successfully so that Individual Accounting happens without Costing/Expense Accounting

442:
443: if ln_total = 0 then
444: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath); /* 20 */
445: -- Vijay Shankar for Bug#4071458
446: -- following if condition added to return successfully so that Individual Accounting happens without Costing/Expense Accounting
447: if ln_other_modvat_amount <> 0 then
448: p_process_status := 'Y';
449: else
450:

Line 724: | DELIVER | Individual Tax Amt | | Individual Tax Accounts |

720: | Transaction | | | |
721: | Type | Amount | Credit | Debit |
722: | ==============|====================== |===========================|===========================|
723: | DELIVER | Total | Inv.Receiving | |
724: | DELIVER | Individual Tax Amt | | Individual Tax Accounts |
725: | RTR | Total | | Inv.Receiving |
726: | RTR | Individual Tax Amt | Individual Tax Accounts | |
727: | ============= | ======================|===========================|===========================|
728: ----------------------------------------------------------------------------------------------

Line 726: | RTR | Individual Tax Amt | Individual Tax Accounts | |

722: | ==============|====================== |===========================|===========================|
723: | DELIVER | Total | Inv.Receiving | |
724: | DELIVER | Individual Tax Amt | | Individual Tax Accounts |
725: | RTR | Total | | Inv.Receiving |
726: | RTR | Individual Tax Amt | Individual Tax Accounts | |
727: | ============= | ======================|===========================|===========================|
728: ----------------------------------------------------------------------------------------------
729: */
730:

Line 735: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';

731: /* Character Variable Declarations */
732: lv_reference_10_desc1 VARCHAR2(75);--File.Sql.35 Cbabu := 'India Local Receiving Entry for the Receipt Number ';
733: lv_reference_10_desc2 VARCHAR2(30);--File.Sql.35 Cbabu := ' For the Transaction Type ';
734: lv_reference_10_desc gl_interface.reference10%type;
735: lv_account_nature VARCHAR2(30);--File.Sql.35 Cbabu := 'Individual Tax';
736: lv_reference23 gl_interface.reference23%type;--File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
737: lv_source VARCHAR2(100);--File.Sql.35 Cbabu := 'Purchasing India';
738: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';

Line 742: ln_individual_tax_amount number;--File.Sql.35 Cbabu := 0;

738: lv_category VARCHAR2(100);--File.Sql.35 Cbabu := 'Receiving India';
739: lv_reference24 gl_interface.reference24%type;--File.Sql.35 Cbabu := 'rcv_transactions';
740: lv_reference25 gl_interface.reference25%type;--File.Sql.35 Cbabu := 'transaction_id';
741:
742: ln_individual_tax_amount number;--File.Sql.35 Cbabu := 0;
743: ln_rec_account_tax_amount number;--File.Sql.35 Cbabu := 0;
744: ln_credit_amount number;
745: ln_debit_amount number;
746:

Line 749: lv_account_nature := 'Individual Tax';

745: ln_debit_amount number;
746:
747: BEGIN
748: --File.Sql.35 Cbabu
749: lv_account_nature := 'Individual Tax';
750: lv_reference_10_desc1 := 'India Local Receiving Entry for the Receipt Number ';
751: lv_reference_10_desc2 := ' For the Transaction Type ';
752: lv_reference23 := 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise';
753: lv_source := 'Purchasing India';

Line 757: ln_individual_tax_amount := 0;

753: lv_source := 'Purchasing India';
754: lv_category := 'Receiving India';
755: lv_reference24 := 'rcv_transactions';
756: lv_reference25 := 'transaction_id';
757: ln_individual_tax_amount := 0;
758: ln_rec_account_tax_amount := 0;
759:
760: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_deliver_rtr_pkg.deliver_rtr_reco_nonexcise', 'START'); /* 1 */
761:

Line 819: ln_individual_tax_amount := NVL(tax_rec.tax_amount,0) * nvl(p_apportion_factor,0);

815: p_process_message := 'The Tax Account is not found for this Tax : ';
816: goto exit_from_procedure;
817: end if;
818:
819: ln_individual_tax_amount := NVL(tax_rec.tax_amount,0) * nvl(p_apportion_factor,0);
820: ln_rec_account_tax_amount := nvl(ln_rec_account_tax_amount,0) + nvl(ln_individual_tax_amount,0);
821:
822: if ln_individual_tax_amount <> 0 then
823:

Line 820: ln_rec_account_tax_amount := nvl(ln_rec_account_tax_amount,0) + nvl(ln_individual_tax_amount,0);

816: goto exit_from_procedure;
817: end if;
818:
819: ln_individual_tax_amount := NVL(tax_rec.tax_amount,0) * nvl(p_apportion_factor,0);
820: ln_rec_account_tax_amount := nvl(ln_rec_account_tax_amount,0) + nvl(ln_individual_tax_amount,0);
821:
822: if ln_individual_tax_amount <> 0 then
823:
824: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

Line 822: if ln_individual_tax_amount <> 0 then

818:
819: ln_individual_tax_amount := NVL(tax_rec.tax_amount,0) * nvl(p_apportion_factor,0);
820: ln_rec_account_tax_amount := nvl(ln_rec_account_tax_amount,0) + nvl(ln_individual_tax_amount,0);
821:
822: if ln_individual_tax_amount <> 0 then
823:
824: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
825: if (p_transaction_type ='CORRECT' AND p_parent_transaction_type = 'DELIVER') or
826: p_transaction_type = 'DELIVER' then /* DELIVER scenario */

Line 830: ln_debit_amount := ln_individual_tax_amount;

826: p_transaction_type = 'DELIVER' then /* DELIVER scenario */
827:
828: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
829: ln_credit_amount := NULL;
830: ln_debit_amount := ln_individual_tax_amount;
831:
832: elsif (p_transaction_type ='CORRECT' AND p_parent_transaction_type = 'RETURN TO RECEIVING') or
833: p_transaction_type = 'RETURN TO RECEIVING' then /* RTR scenario */
834:

Line 836: ln_credit_amount := ln_individual_tax_amount;

832: elsif (p_transaction_type ='CORRECT' AND p_parent_transaction_type = 'RETURN TO RECEIVING') or
833: p_transaction_type = 'RETURN TO RECEIVING' then /* RTR scenario */
834:
835: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
836: ln_credit_amount := ln_individual_tax_amount;
837: ln_debit_amount := NULL;
838:
839: end if;
840:

Line 872: end if; --end if for ln_individual_tax_amount <> 0

868: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
869: goto exit_from_procedure;
870: end if;
871:
872: end if; --end if for ln_individual_tax_amount <> 0
873: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
874: end loop; --End Loop for Tax Rec.
875:
876: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */