[Home] [Help]
75:
76: No dependency.
77:
78: 03-Mar-2005 Vijay Shankar for Bug#4215402, Version:115.3
79: po_distribution_id is populated as null in rcv_Transactions for non inventory items.
80: so to get accrue_on_receipt_flag from PO, we need line_location_id instead of
81: po_distribution_id. So changes are made to pass line_location_id also to
82: jai_rcv_trx_processing_pkg.get_accrue_on_receipt function
83:
333: p_process_message out nocopy varchar2,
334: p_codepath in out nocopy varchar2
335: )is
336:
337: cursor c_ja_in_rcv_transactions(cp_transaction_id in number) is
338: select organization_id,
339: location_id,
340: transaction_type,
341: parent_transaction_type,
343: transaction_date,
344: parent_transaction_id,
345: inventory_item_id,
346: inv_item_flag /* Service */
347: from JAI_RCV_TRANSACTIONS
348: where transaction_id = cp_transaction_id;
349:
350: cursor c_rcv_transactions(cp_transaction_id in number) is
351: select shipment_header_id,
346: inv_item_flag /* Service */
347: from JAI_RCV_TRANSACTIONS
348: where transaction_id = cp_transaction_id;
349:
350: cursor c_rcv_transactions(cp_transaction_id in number) is
351: select shipment_header_id,
352: shipment_line_id,
353: po_distribution_id,
354: po_line_location_id,
358: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. , upper(attribute_category) attribute_category
359: -- , source_document_code
360: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,
361: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
362: from rcv_transactions
363: where transaction_id = cp_transaction_id;
364:
365: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is
366: select from_organization_id,
374: from rcv_shipment_headers
375: where shipment_header_id = cp_shipment_header_id;
376:
377:
378: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
379: r_rcv_transactions c_rcv_transactions%rowtype;
380: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;
381: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;
382:
375: where shipment_header_id = cp_shipment_header_id;
376:
377:
378: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
379: r_rcv_transactions c_rcv_transactions%rowtype;
380: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;
381: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;
382:
383: ln_boe_account_id number;
462: end if;
463:
464: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
465:
466: open c_rcv_transactions(p_transaction_id);
467: fetch c_rcv_transactions into r_rcv_transactions;
468: close c_rcv_transactions;
469:
470: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
463:
464: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
465:
466: open c_rcv_transactions(p_transaction_id);
467: fetch c_rcv_transactions into r_rcv_transactions;
468: close c_rcv_transactions;
469:
470: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
471: open c_ja_in_rcv_transactions(p_transaction_id);
464: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
465:
466: open c_rcv_transactions(p_transaction_id);
467: fetch c_rcv_transactions into r_rcv_transactions;
468: close c_rcv_transactions;
469:
470: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
471: open c_ja_in_rcv_transactions(p_transaction_id);
472: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
467: fetch c_rcv_transactions into r_rcv_transactions;
468: close c_rcv_transactions;
469:
470: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
471: open c_ja_in_rcv_transactions(p_transaction_id);
472: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
473: close c_ja_in_rcv_transactions;
474:
475: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
468: close c_rcv_transactions;
469:
470: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
471: open c_ja_in_rcv_transactions(p_transaction_id);
472: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
473: close c_ja_in_rcv_transactions;
474:
475: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
476: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);
469:
470: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
471: open c_ja_in_rcv_transactions(p_transaction_id);
472: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
473: close c_ja_in_rcv_transactions;
474:
475: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
476: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);
477: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;
472: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
473: close c_ja_in_rcv_transactions;
474:
475: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
476: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);
477: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;
478: close c_rcv_shipment_headers;
479:
480: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
477: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;
478: close c_rcv_shipment_headers;
479:
480: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
481: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
482: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
483: close c_rcv_shipment_lines;
484:
485: if p_debug = 'Y' then
492: /*lv_accounting_method_option :=
493: jai_general_pkg.get_accounting_method
494: (
495: p_org_id => null,
496: p_organization_id => r_ja_in_rcv_transactions.organization_id,
497: p_sob_id => null
498: );*/
499: --commented the above by Sanjikum for Bug#4474501
500:
500:
501: p_codepath := jai_general_pkg.plot_codepath(4.12, p_codepath); /* 4.12 */
502: lv_accrue_on_receipt_flag :=
503: jai_rcv_trx_processing_pkg.get_accrue_on_receipt
504: (p_po_distribution_id => r_rcv_transactions.po_distribution_id,
505: -- added by Vijay Shankar for Bug#4215402
506: p_po_line_location_id => r_rcv_transactions.po_line_location_id
507: );
508:
502: lv_accrue_on_receipt_flag :=
503: jai_rcv_trx_processing_pkg.get_accrue_on_receipt
504: (p_po_distribution_id => r_rcv_transactions.po_distribution_id,
505: -- added by Vijay Shankar for Bug#4215402
506: p_po_line_location_id => r_rcv_transactions.po_line_location_id
507: );
508:
509:
510: p_codepath := jai_general_pkg.plot_codepath(4.13, p_codepath); /* 4.13 */
510: p_codepath := jai_general_pkg.plot_codepath(4.13, p_codepath); /* 4.13 */
511: /*if ( (lv_accrue_on_receipt_flag = 'N')
512: or
513: (lv_accounting_method_option = 'Cash' and
514: nvl(r_ja_in_rcv_transactions.inv_item_flag, 'N') = 'N'
515: )
516: )*/
517: --commented the above and added the below for Bug#4474501
518: if lv_accrue_on_receipt_flag = 'N'
525: lb_account_service_interim := true;
526: end if;
527: /*Bug 5527885 Start*/
528: gn_currency_precision :=
529: jai_general_pkg.get_currency_precision(r_ja_in_rcv_transactions.organization_id);
530: if gn_currency_precision is null then
531: p_process_flag := 'E';
532: p_process_message := 'Currency Precision is null. Organization:'||r_ja_in_rcv_transactions.organization_id;
533: goto exit_from_procedure;
528: gn_currency_precision :=
529: jai_general_pkg.get_currency_precision(r_ja_in_rcv_transactions.organization_id);
530: if gn_currency_precision is null then
531: p_process_flag := 'E';
532: p_process_message := 'Currency Precision is null. Organization:'||r_ja_in_rcv_transactions.organization_id;
533: goto exit_from_procedure;
534: end if;
535: /*Bug 5527885 End*/
536:
536:
537: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
538: get_accounts
539: (
540: p_organization_id => r_ja_in_rcv_transactions.organization_id,
541: p_location_id => r_ja_in_rcv_transactions.location_id,
542: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
543: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
544: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
537: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
538: get_accounts
539: (
540: p_organization_id => r_ja_in_rcv_transactions.organization_id,
541: p_location_id => r_ja_in_rcv_transactions.location_id,
542: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
543: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
544: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
545: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
541: p_location_id => r_ja_in_rcv_transactions.location_id,
542: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
543: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
544: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
545: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
546: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
547: /** OUT parameters **/
548: p_boe_account_id => ln_boe_account_id,
549: p_rtv_expense_account_id => ln_rtv_expense_account_id,
542: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
543: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
544: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
545: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
546: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
547: /** OUT parameters **/
548: p_boe_account_id => ln_boe_account_id,
549: p_rtv_expense_account_id => ln_rtv_expense_account_id,
550: p_excise_expense_account => ln_excise_expense_account,
578: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
579: get_tax_breakup
580: (
581: p_transaction_id => p_transaction_id,
582: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
583: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
584: p_po_vendor_id => r_rcv_transactions.vendor_id,
585: p_all_taxes => ln_all_taxes,
586: p_tds_taxes => ln_tds_taxes ,
579: get_tax_breakup
580: (
581: p_transaction_id => p_transaction_id,
582: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
583: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
584: p_po_vendor_id => r_rcv_transactions.vendor_id,
585: p_all_taxes => ln_all_taxes,
586: p_tds_taxes => ln_tds_taxes ,
587: p_modvat_recovery_taxes => ln_modvat_recovery_taxes,
580: (
581: p_transaction_id => p_transaction_id,
582: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
583: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
584: p_po_vendor_id => r_rcv_transactions.vendor_id,
585: p_all_taxes => ln_all_taxes,
586: p_tds_taxes => ln_tds_taxes ,
587: p_modvat_recovery_taxes => ln_modvat_recovery_taxes,
588: p_cvd_taxes => ln_cvd_taxes,
634: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
635:
636: validate_transaction_tax_accnt
637: (
638: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
639: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
640: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
641: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
642: p_boe_account_id => ln_boe_account_id,
635:
636: validate_transaction_tax_accnt
637: (
638: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
639: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
640: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
641: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
642: p_boe_account_id => ln_boe_account_id,
643: p_rtv_expense_account_id => ln_rtv_expense_account_id,
636: validate_transaction_tax_accnt
637: (
638: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
639: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
640: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
641: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
642: p_boe_account_id => ln_boe_account_id,
643: p_rtv_expense_account_id => ln_rtv_expense_account_id,
644: p_excise_expense_account => ln_excise_expense_account,
677:
678: apply_relieve_boe
679: (
680: p_transaction_id => p_transaction_id,
681: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
682: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
683: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
684: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
685: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
678: apply_relieve_boe
679: (
680: p_transaction_id => p_transaction_id,
681: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
682: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
683: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
684: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
685: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
686: p_organization_id => r_ja_in_rcv_transactions.organization_id,
679: (
680: p_transaction_id => p_transaction_id,
681: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
682: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
683: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
684: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
685: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
686: p_organization_id => r_ja_in_rcv_transactions.organization_id,
687: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
680: p_transaction_id => p_transaction_id,
681: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
682: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
683: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
684: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
685: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
686: p_organization_id => r_ja_in_rcv_transactions.organization_id,
687: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
688: p_cvd_taxes => ln_cvd_taxes,
681: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
682: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
683: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
684: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
685: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
686: p_organization_id => r_ja_in_rcv_transactions.organization_id,
687: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
688: p_cvd_taxes => ln_cvd_taxes,
689: p_add_cvd_taxes => ln_add_cvd_taxes,/*5228046 Additional cvd Enhancement*/
682: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
683: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
684: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
685: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
686: p_organization_id => r_ja_in_rcv_transactions.organization_id,
687: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
688: p_cvd_taxes => ln_cvd_taxes,
689: p_add_cvd_taxes => ln_add_cvd_taxes,/*5228046 Additional cvd Enhancement*/
690: p_customs_taxes => ln_customs_taxes,
683: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
684: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
685: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
686: p_organization_id => r_ja_in_rcv_transactions.organization_id,
687: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
688: p_cvd_taxes => ln_cvd_taxes,
689: p_add_cvd_taxes => ln_add_cvd_taxes,/*5228046 Additional cvd Enhancement*/
690: p_customs_taxes => ln_customs_taxes,
691: p_cvd_edu_cess => ln_cvd_edu_cess, /* Educational Cess */
730: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
731: post_entries
732: (
733: p_transaction_id => p_transaction_id,
734: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
735: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
736: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
737: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
738: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
731: post_entries
732: (
733: p_transaction_id => p_transaction_id,
734: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
735: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
736: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
737: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
738: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
739: p_receipt_num => r_rcv_shipment_headers.receipt_num,
732: (
733: p_transaction_id => p_transaction_id,
734: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
735: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
736: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
737: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
738: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
739: p_receipt_num => r_rcv_shipment_headers.receipt_num,
740: p_receiving_account_id => ln_receiving_account_id,
734: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
735: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
736: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
737: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
738: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
739: p_receipt_num => r_rcv_shipment_headers.receipt_num,
740: p_receiving_account_id => ln_receiving_account_id,
741: p_ap_accrual_account => ln_ap_accrual_account,
742: p_boe_account_id => ln_boe_account_id,
797: /*Bug 5632406 Start*/
798: if (lb_account_service_interim and nvl(ln_service_recoverable, 0) <> 0 )
799: and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER'
800: /* bug#5632406 - bduvarag used the p_receipt_source_code
801: instead of nvl(r_rcv_transactions.attribute_category, 'XX') <> 'INDIA RMA RECEIPT'*/
802: then
803: /*Bug 5632406 End*/
804: p_codepath := jai_general_pkg.plot_codepath(10.1, p_codepath); /* 10.1 */
805:
805:
806: regime_tax_accounting_interim
807: (
808: p_transaction_id => p_transaction_id,
809: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
810: p_organization_id => r_ja_in_rcv_transactions.organization_id,
811: p_location_id => r_ja_in_rcv_transactions.location_id,
812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
806: regime_tax_accounting_interim
807: (
808: p_transaction_id => p_transaction_id,
809: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
810: p_organization_id => r_ja_in_rcv_transactions.organization_id,
811: p_location_id => r_ja_in_rcv_transactions.location_id,
812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
807: (
808: p_transaction_id => p_transaction_id,
809: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
810: p_organization_id => r_ja_in_rcv_transactions.organization_id,
811: p_location_id => r_ja_in_rcv_transactions.location_id,
812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
808: p_transaction_id => p_transaction_id,
809: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
810: p_organization_id => r_ja_in_rcv_transactions.organization_id,
811: p_location_id => r_ja_in_rcv_transactions.location_id,
812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
809: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
810: p_organization_id => r_ja_in_rcv_transactions.organization_id,
811: p_location_id => r_ja_in_rcv_transactions.location_id,
812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
817: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
810: p_organization_id => r_ja_in_rcv_transactions.organization_id,
811: p_location_id => r_ja_in_rcv_transactions.location_id,
812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
817: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
818: p_receipt_num => r_rcv_shipment_headers.receipt_num,
811: p_location_id => r_ja_in_rcv_transactions.location_id,
812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
817: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
818: p_receipt_num => r_rcv_shipment_headers.receipt_num,
819: p_regime_code => jai_constants.service_regime,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
817: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
818: p_receipt_num => r_rcv_shipment_headers.receipt_num,
819: p_regime_code => jai_constants.service_regime,
820: ptr_jv => tr_jv,/*Bug 5632406*/
821: p_simulation => p_simulation,
839: /* VAT interim accounting required as recoverable vat tax exists */
840: regime_tax_accounting_interim
841: (
842: p_transaction_id => p_transaction_id,
843: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
844: p_organization_id => r_ja_in_rcv_transactions.organization_id,
845: p_location_id => r_ja_in_rcv_transactions.location_id,
846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
840: regime_tax_accounting_interim
841: (
842: p_transaction_id => p_transaction_id,
843: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
844: p_organization_id => r_ja_in_rcv_transactions.organization_id,
845: p_location_id => r_ja_in_rcv_transactions.location_id,
846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
841: (
842: p_transaction_id => p_transaction_id,
843: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
844: p_organization_id => r_ja_in_rcv_transactions.organization_id,
845: p_location_id => r_ja_in_rcv_transactions.location_id,
846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
842: p_transaction_id => p_transaction_id,
843: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
844: p_organization_id => r_ja_in_rcv_transactions.organization_id,
845: p_location_id => r_ja_in_rcv_transactions.location_id,
846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
843: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
844: p_organization_id => r_ja_in_rcv_transactions.organization_id,
845: p_location_id => r_ja_in_rcv_transactions.location_id,
846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
851: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
844: p_organization_id => r_ja_in_rcv_transactions.organization_id,
845: p_location_id => r_ja_in_rcv_transactions.location_id,
846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
851: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
852: p_receipt_num => r_rcv_shipment_headers.receipt_num,
845: p_location_id => r_ja_in_rcv_transactions.location_id,
846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
851: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
852: p_receipt_num => r_rcv_shipment_headers.receipt_num,
853: p_regime_code => jai_constants.vat_regime,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
851: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
852: p_receipt_num => r_rcv_shipment_headers.receipt_num,
853: p_regime_code => jai_constants.vat_regime,
854: ptr_jv => tr_jv,/*Bug 5632406*/
855: p_simulation => p_simulation,
866:
867: end if; /* VAT interim accounting */
868:
869: /*Bug 12543504 - When an RMA Receipt is delivered, TCS must be moved from Liability to Interim Liability*/
870: jai_ar_tcs_rep_pkg.receipt_interim_accounting(p_shipment_line_id => r_rcv_transactions.shipment_line_id,
871: p_shipment_header_id=> r_rcv_transactions.shipment_header_id,
872: p_organization_id=>r_ja_in_rcv_transactions.organization_id,
873: p_line_location_id=>r_ja_in_rcv_transactions.location_id,
874: p_currency_conversion_rate=>r_ja_in_rcv_transactions.currency_conversion_rate,
867: end if; /* VAT interim accounting */
868:
869: /*Bug 12543504 - When an RMA Receipt is delivered, TCS must be moved from Liability to Interim Liability*/
870: jai_ar_tcs_rep_pkg.receipt_interim_accounting(p_shipment_line_id => r_rcv_transactions.shipment_line_id,
871: p_shipment_header_id=> r_rcv_transactions.shipment_header_id,
872: p_organization_id=>r_ja_in_rcv_transactions.organization_id,
873: p_line_location_id=>r_ja_in_rcv_transactions.location_id,
874: p_currency_conversion_rate=>r_ja_in_rcv_transactions.currency_conversion_rate,
875: p_transaction_type=> r_ja_in_rcv_transactions.transaction_type,
868:
869: /*Bug 12543504 - When an RMA Receipt is delivered, TCS must be moved from Liability to Interim Liability*/
870: jai_ar_tcs_rep_pkg.receipt_interim_accounting(p_shipment_line_id => r_rcv_transactions.shipment_line_id,
871: p_shipment_header_id=> r_rcv_transactions.shipment_header_id,
872: p_organization_id=>r_ja_in_rcv_transactions.organization_id,
873: p_line_location_id=>r_ja_in_rcv_transactions.location_id,
874: p_currency_conversion_rate=>r_ja_in_rcv_transactions.currency_conversion_rate,
875: p_transaction_type=> r_ja_in_rcv_transactions.transaction_type,
876: p_transaction_id=>p_transaction_id,
869: /*Bug 12543504 - When an RMA Receipt is delivered, TCS must be moved from Liability to Interim Liability*/
870: jai_ar_tcs_rep_pkg.receipt_interim_accounting(p_shipment_line_id => r_rcv_transactions.shipment_line_id,
871: p_shipment_header_id=> r_rcv_transactions.shipment_header_id,
872: p_organization_id=>r_ja_in_rcv_transactions.organization_id,
873: p_line_location_id=>r_ja_in_rcv_transactions.location_id,
874: p_currency_conversion_rate=>r_ja_in_rcv_transactions.currency_conversion_rate,
875: p_transaction_type=> r_ja_in_rcv_transactions.transaction_type,
876: p_transaction_id=>p_transaction_id,
877: v_currency_code=> r_rcv_transactions.currency_code,
870: jai_ar_tcs_rep_pkg.receipt_interim_accounting(p_shipment_line_id => r_rcv_transactions.shipment_line_id,
871: p_shipment_header_id=> r_rcv_transactions.shipment_header_id,
872: p_organization_id=>r_ja_in_rcv_transactions.organization_id,
873: p_line_location_id=>r_ja_in_rcv_transactions.location_id,
874: p_currency_conversion_rate=>r_ja_in_rcv_transactions.currency_conversion_rate,
875: p_transaction_type=> r_ja_in_rcv_transactions.transaction_type,
876: p_transaction_id=>p_transaction_id,
877: v_currency_code=> r_rcv_transactions.currency_code,
878: p_process_flag=>p_process_flag,
871: p_shipment_header_id=> r_rcv_transactions.shipment_header_id,
872: p_organization_id=>r_ja_in_rcv_transactions.organization_id,
873: p_line_location_id=>r_ja_in_rcv_transactions.location_id,
874: p_currency_conversion_rate=>r_ja_in_rcv_transactions.currency_conversion_rate,
875: p_transaction_type=> r_ja_in_rcv_transactions.transaction_type,
876: p_transaction_id=>p_transaction_id,
877: v_currency_code=> r_rcv_transactions.currency_code,
878: p_process_flag=>p_process_flag,
879: p_process_message=>p_process_message);
873: p_line_location_id=>r_ja_in_rcv_transactions.location_id,
874: p_currency_conversion_rate=>r_ja_in_rcv_transactions.currency_conversion_rate,
875: p_transaction_type=> r_ja_in_rcv_transactions.transaction_type,
876: p_transaction_id=>p_transaction_id,
877: v_currency_code=> r_rcv_transactions.currency_code,
878: p_process_flag=>p_process_flag,
879: p_process_message=>p_process_message);
880:
881: /*Bug 5527885 Start*/
1402: ln_tax_apportion_factor number;
1403: ln_tax_amount number;
1404:
1405: --start addiitons by vkaranam for bug#10167393
1406: cursor c_ja_in_rcv_transactions(cp_transaction_id in number) is
1407: select organization_id,
1408: location_id,
1409: transaction_type,
1410: parent_transaction_type,
1412: transaction_date,
1413: parent_transaction_id,
1414: inventory_item_id,
1415: inv_item_flag /* Service */
1416: from JAI_RCV_TRANSACTIONS
1417: where transaction_id = cp_transaction_id;
1418:
1419: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
1420:
1415: inv_item_flag /* Service */
1416: from JAI_RCV_TRANSACTIONS
1417: where transaction_id = cp_transaction_id;
1418:
1419: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
1420:
1421: --end addiitons by vkaranam for bug#10167393
1422:
1423:
1432:
1433: ln_tax_apportion_factor :=
1434: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
1435: --start additions by vkaranam for bug#10167393
1436: open c_ja_in_rcv_transactions(p_transaction_id);
1437: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
1438: close c_ja_in_rcv_transactions;
1439: --end additions by vkaranam for bug#10167393
1440:
1433: ln_tax_apportion_factor :=
1434: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
1435: --start additions by vkaranam for bug#10167393
1436: open c_ja_in_rcv_transactions(p_transaction_id);
1437: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
1438: close c_ja_in_rcv_transactions;
1439: --end additions by vkaranam for bug#10167393
1440:
1441: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1434: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
1435: --start additions by vkaranam for bug#10167393
1436: open c_ja_in_rcv_transactions(p_transaction_id);
1437: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
1438: close c_ja_in_rcv_transactions;
1439: --end additions by vkaranam for bug#10167393
1440:
1441: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1442: p_all_taxes := 0;
1498: -- end additions for POT 11936596
1499:
1500: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
1501: --start additions by vkaranam for bug#10167393
1502: if nvl(cur_rec.adhoc_flag,'N')='Y' and nvl(cur_rec.vat_flag,'N')<>'Q' and cur_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and r_ja_in_rcv_transactions.transaction_type='CORRECT'
1503: then
1504: ln_tax_amount := 0;
1505: else
1506: ln_tax_amount := ln_tax_amount; -- * ln_tax_apportion_factor; --Commented for bug #13494816
2185: /* If apply relieve BOE has been done successfully, update the boe_applied_flag in ja_in_rcv_transaction */
2186: if p_process_flag = 'Y' and nvl(p_simulation , 'Y') <> 'Y' then
2187:
2188: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
2189: update JAI_RCV_TRANSACTIONS
2190: set boe_applied_flag = 'Y'
2191: where transaction_id = p_transaction_id;
2192:
2193: end if;
2572: lv_acct_type varchar2(15); /* Regular or Reversal*/
2573:
2574: lv_reference_10 varchar2(240);
2575: lv_reference_23 varchar2(240); -- := 'jai_rcv_rcv_rtv_pkg.post_entries';
2576: lv_reference_24 varchar2(240); -- := 'rcv_transactions';
2577: lv_reference_25 varchar2(240); -- := 'transaction_id';
2578: lv_reference_26 varchar2(240);
2579: /* End of File.Sql.35 by Brathod */
2580:
2689: lv_source_name := 'Purchasing India';
2690: lv_category_name := 'Receiving India';
2691: lv_acct_nature := 'Receiving';
2692: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.post_entries';
2693: lv_reference_24 := 'rcv_transactions';
2694: lv_reference_25 := 'transaction_id';
2695: /* End of File.Sql.35 by Brathod*/
2696:
2697: if p_debug = 'Y' then
3061: ------------------------------------------------------------------
3062: select organization_id,
3063: location_id
3064: into ln_organization_id,ln_location_id
3065: from JAI_RCV_TRANSACTIONS
3066: where transaction_id = p_transaction_id;
3067:
3068:
3069:
3821: lv_acct_type varchar2(15); /* Regular or Reversal*/
3822:
3823: lv_reference_10 varchar2(240);
3824: lv_reference_23 varchar2(240);-- := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
3825: lv_reference_24 varchar2(240);-- := 'rcv_transactions';
3826: lv_reference_25 varchar2(240);-- := 'transaction_id';
3827: /* End of File.Sql.35 by Brathod */
3828:
3829: lv_reference_26 varchar2(240);
3925: lv_source_name := 'Purchasing India';
3926: lv_category_name := 'Receiving India';
3927: lv_acct_nature := 'Receiving';
3928: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
3929: lv_reference_24 := 'rcv_transactions';
3930: lv_reference_25 := 'transaction_id';
3931: /* End of File.Sql.35 by Brathod */
3932:
3933: