DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on RCV_TRANSACTIONS

Line 79: po_distribution_id is populated as null in rcv_Transactions for non inventory items.

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:

Line 262: cursor c_ja_in_rcv_transactions(cp_transaction_id in number) is

258: p_process_message out nocopy varchar2,
259: p_codepath in out nocopy varchar2
260: )is
261:
262: cursor c_ja_in_rcv_transactions(cp_transaction_id in number) is
263: select organization_id,
264: location_id,
265: transaction_type,
266: parent_transaction_type,

Line 272: from JAI_RCV_TRANSACTIONS

268: transaction_date,
269: parent_transaction_id,
270: inventory_item_id,
271: inv_item_flag /* Service */
272: from JAI_RCV_TRANSACTIONS
273: where transaction_id = cp_transaction_id;
274:
275: cursor c_rcv_transactions(cp_transaction_id in number) is
276: select shipment_header_id,

Line 275: cursor c_rcv_transactions(cp_transaction_id in number) is

271: inv_item_flag /* Service */
272: from JAI_RCV_TRANSACTIONS
273: where transaction_id = cp_transaction_id;
274:
275: cursor c_rcv_transactions(cp_transaction_id in number) is
276: select shipment_header_id,
277: shipment_line_id,
278: po_distribution_id,
279: po_line_location_id,

Line 286: from rcv_transactions

282: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. , upper(attribute_category) attribute_category
283: -- , source_document_code
284: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,
285: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
286: from rcv_transactions
287: where transaction_id = cp_transaction_id;
288:
289: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is
290: select from_organization_id,

Line 302: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;

298: from rcv_shipment_headers
299: where shipment_header_id = cp_shipment_header_id;
300:
301:
302: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
303: r_rcv_transactions c_rcv_transactions%rowtype;
304: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;
305: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;
306:

Line 303: r_rcv_transactions c_rcv_transactions%rowtype;

299: where shipment_header_id = cp_shipment_header_id;
300:
301:
302: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
303: r_rcv_transactions c_rcv_transactions%rowtype;
304: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;
305: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;
306:
307: ln_boe_account_id number;

Line 377: open c_rcv_transactions(p_transaction_id);

373: end if;
374:
375: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
376:
377: open c_rcv_transactions(p_transaction_id);
378: fetch c_rcv_transactions into r_rcv_transactions;
379: close c_rcv_transactions;
380:
381: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */

Line 378: fetch c_rcv_transactions into r_rcv_transactions;

374:
375: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
376:
377: open c_rcv_transactions(p_transaction_id);
378: fetch c_rcv_transactions into r_rcv_transactions;
379: close c_rcv_transactions;
380:
381: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
382: open c_ja_in_rcv_transactions(p_transaction_id);

Line 379: close c_rcv_transactions;

375: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
376:
377: open c_rcv_transactions(p_transaction_id);
378: fetch c_rcv_transactions into r_rcv_transactions;
379: close c_rcv_transactions;
380:
381: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
382: open c_ja_in_rcv_transactions(p_transaction_id);
383: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;

Line 382: open c_ja_in_rcv_transactions(p_transaction_id);

378: fetch c_rcv_transactions into r_rcv_transactions;
379: close c_rcv_transactions;
380:
381: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
382: open c_ja_in_rcv_transactions(p_transaction_id);
383: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
384: close c_ja_in_rcv_transactions;
385:
386: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */

Line 383: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;

379: close c_rcv_transactions;
380:
381: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
382: open c_ja_in_rcv_transactions(p_transaction_id);
383: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
384: close c_ja_in_rcv_transactions;
385:
386: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
387: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);

Line 384: close c_ja_in_rcv_transactions;

380:
381: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
382: open c_ja_in_rcv_transactions(p_transaction_id);
383: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
384: close c_ja_in_rcv_transactions;
385:
386: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
387: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);
388: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;

Line 387: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);

383: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
384: close c_ja_in_rcv_transactions;
385:
386: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
387: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);
388: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;
389: close c_rcv_shipment_headers;
390:
391: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */

Line 392: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);

388: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;
389: close c_rcv_shipment_headers;
390:
391: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
392: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
393: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
394: close c_rcv_shipment_lines;
395:
396: if p_debug = 'Y' then

Line 407: p_organization_id => r_ja_in_rcv_transactions.organization_id,

403: /*lv_accounting_method_option :=
404: jai_general_pkg.get_accounting_method
405: (
406: p_org_id => null,
407: p_organization_id => r_ja_in_rcv_transactions.organization_id,
408: p_sob_id => null
409: );*/
410: --commented the above by Sanjikum for Bug#4474501
411:

Line 415: (p_po_distribution_id => r_rcv_transactions.po_distribution_id,

411:
412: p_codepath := jai_general_pkg.plot_codepath(4.12, p_codepath); /* 4.12 */
413: lv_accrue_on_receipt_flag :=
414: jai_rcv_trx_processing_pkg.get_accrue_on_receipt
415: (p_po_distribution_id => r_rcv_transactions.po_distribution_id,
416: -- added by Vijay Shankar for Bug#4215402
417: p_po_line_location_id => r_rcv_transactions.po_line_location_id
418: );
419:

Line 417: p_po_line_location_id => r_rcv_transactions.po_line_location_id

413: lv_accrue_on_receipt_flag :=
414: jai_rcv_trx_processing_pkg.get_accrue_on_receipt
415: (p_po_distribution_id => r_rcv_transactions.po_distribution_id,
416: -- added by Vijay Shankar for Bug#4215402
417: p_po_line_location_id => r_rcv_transactions.po_line_location_id
418: );
419:
420:
421: p_codepath := jai_general_pkg.plot_codepath(4.13, p_codepath); /* 4.13 */

Line 425: nvl(r_ja_in_rcv_transactions.inv_item_flag, 'N') = 'N'

421: p_codepath := jai_general_pkg.plot_codepath(4.13, p_codepath); /* 4.13 */
422: /*if ( (lv_accrue_on_receipt_flag = 'N')
423: or
424: (lv_accounting_method_option = 'Cash' and
425: nvl(r_ja_in_rcv_transactions.inv_item_flag, 'N') = 'N'
426: )
427: )*/
428: --commented the above and added the below for Bug#4474501
429: if lv_accrue_on_receipt_flag = 'N'

Line 440: jai_general_pkg.get_currency_precision(r_ja_in_rcv_transactions.organization_id);

436: lb_account_service_interim := true;
437: end if;
438: /*Bug 5527885 Start*/
439: gn_currency_precision :=
440: jai_general_pkg.get_currency_precision(r_ja_in_rcv_transactions.organization_id);
441: if gn_currency_precision is null then
442: p_process_flag := 'E';
443: p_process_message := 'Currency Precision is null. Organization:'||r_ja_in_rcv_transactions.organization_id;
444: goto exit_from_procedure;

Line 443: p_process_message := 'Currency Precision is null. Organization:'||r_ja_in_rcv_transactions.organization_id;

439: gn_currency_precision :=
440: jai_general_pkg.get_currency_precision(r_ja_in_rcv_transactions.organization_id);
441: if gn_currency_precision is null then
442: p_process_flag := 'E';
443: p_process_message := 'Currency Precision is null. Organization:'||r_ja_in_rcv_transactions.organization_id;
444: goto exit_from_procedure;
445: end if;
446: /*Bug 5527885 End*/
447:

Line 451: p_organization_id => r_ja_in_rcv_transactions.organization_id,

447:
448: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
449: get_accounts
450: (
451: p_organization_id => r_ja_in_rcv_transactions.organization_id,
452: p_location_id => r_ja_in_rcv_transactions.location_id,
453: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
454: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
455: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,

Line 452: p_location_id => r_ja_in_rcv_transactions.location_id,

448: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
449: get_accounts
450: (
451: p_organization_id => r_ja_in_rcv_transactions.organization_id,
452: p_location_id => r_ja_in_rcv_transactions.location_id,
453: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
454: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
455: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
456: p_po_distribution_id => r_rcv_transactions.po_distribution_id,

Line 456: p_po_distribution_id => r_rcv_transactions.po_distribution_id,

452: p_location_id => r_ja_in_rcv_transactions.location_id,
453: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
454: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
455: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
456: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
457: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
458: /** OUT parameters **/
459: p_boe_account_id => ln_boe_account_id,
460: p_rtv_expense_account_id => ln_rtv_expense_account_id,

Line 457: p_po_line_location_id => r_rcv_transactions.po_line_location_id,

453: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
454: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
455: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
456: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
457: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
458: /** OUT parameters **/
459: p_boe_account_id => ln_boe_account_id,
460: p_rtv_expense_account_id => ln_rtv_expense_account_id,
461: p_excise_expense_account => ln_excise_expense_account,

Line 493: p_shipment_line_id => r_rcv_transactions.shipment_line_id,

489: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
490: get_tax_breakup
491: (
492: p_transaction_id => p_transaction_id,
493: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
494: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
495: p_po_vendor_id => r_rcv_transactions.vendor_id,
496: p_all_taxes => ln_all_taxes,
497: p_tds_taxes => ln_tds_taxes ,

Line 494: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,

490: get_tax_breakup
491: (
492: p_transaction_id => p_transaction_id,
493: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
494: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
495: p_po_vendor_id => r_rcv_transactions.vendor_id,
496: p_all_taxes => ln_all_taxes,
497: p_tds_taxes => ln_tds_taxes ,
498: p_modvat_recovery_taxes => ln_modvat_recovery_taxes,

Line 495: p_po_vendor_id => r_rcv_transactions.vendor_id,

491: (
492: p_transaction_id => p_transaction_id,
493: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
494: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
495: p_po_vendor_id => r_rcv_transactions.vendor_id,
496: p_all_taxes => ln_all_taxes,
497: p_tds_taxes => ln_tds_taxes ,
498: p_modvat_recovery_taxes => ln_modvat_recovery_taxes,
499: p_cvd_taxes => ln_cvd_taxes,

Line 535: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,

531: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
532:
533: validate_transaction_tax_accnt
534: (
535: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
536: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
537: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
538: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
539: p_boe_account_id => ln_boe_account_id,

Line 536: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,

532:
533: validate_transaction_tax_accnt
534: (
535: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
536: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
537: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
538: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
539: p_boe_account_id => ln_boe_account_id,
540: p_rtv_expense_account_id => ln_rtv_expense_account_id,

Line 537: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,

533: validate_transaction_tax_accnt
534: (
535: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
536: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
537: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
538: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
539: p_boe_account_id => ln_boe_account_id,
540: p_rtv_expense_account_id => ln_rtv_expense_account_id,
541: p_excise_expense_account => ln_excise_expense_account,

Line 578: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,

574:
575: apply_relieve_boe
576: (
577: p_transaction_id => p_transaction_id,
578: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
579: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,

Line 579: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,

575: apply_relieve_boe
576: (
577: p_transaction_id => p_transaction_id,
578: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
579: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
583: p_organization_id => r_ja_in_rcv_transactions.organization_id,

Line 580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,

576: (
577: p_transaction_id => p_transaction_id,
578: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
579: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
583: p_organization_id => r_ja_in_rcv_transactions.organization_id,
584: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,

Line 581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,

577: p_transaction_id => p_transaction_id,
578: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
579: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
583: p_organization_id => r_ja_in_rcv_transactions.organization_id,
584: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
585: p_cvd_taxes => ln_cvd_taxes,

Line 582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,

578: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
579: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
583: p_organization_id => r_ja_in_rcv_transactions.organization_id,
584: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
585: p_cvd_taxes => ln_cvd_taxes,
586: p_add_cvd_taxes => ln_add_cvd_taxes,/*5228046 Additional cvd Enhancement*/

Line 583: p_organization_id => r_ja_in_rcv_transactions.organization_id,

579: p_parent_transaction_id => r_ja_in_rcv_transactions.parent_transaction_id,
580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
583: p_organization_id => r_ja_in_rcv_transactions.organization_id,
584: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
585: p_cvd_taxes => ln_cvd_taxes,
586: p_add_cvd_taxes => ln_add_cvd_taxes,/*5228046 Additional cvd Enhancement*/
587: p_customs_taxes => ln_customs_taxes,

Line 584: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,

580: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
581: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
582: p_shipment_header_id => r_rcv_transactions.shipment_header_id,
583: p_organization_id => r_ja_in_rcv_transactions.organization_id,
584: p_inventory_item_id => r_ja_in_rcv_transactions.inventory_item_id,
585: p_cvd_taxes => ln_cvd_taxes,
586: p_add_cvd_taxes => ln_add_cvd_taxes,/*5228046 Additional cvd Enhancement*/
587: p_customs_taxes => ln_customs_taxes,
588: p_cvd_edu_cess => ln_cvd_edu_cess, /* Educational Cess */

Line 620: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,

616: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
617: post_entries
618: (
619: p_transaction_id => p_transaction_id,
620: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
621: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
622: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
623: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
624: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,

Line 621: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,

617: post_entries
618: (
619: p_transaction_id => p_transaction_id,
620: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
621: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
622: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
623: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
624: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
625: p_receipt_num => r_rcv_shipment_headers.receipt_num,

Line 622: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,

618: (
619: p_transaction_id => p_transaction_id,
620: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
621: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
622: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
623: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
624: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
625: p_receipt_num => r_rcv_shipment_headers.receipt_num,
626: p_receiving_account_id => ln_receiving_account_id,

Line 624: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,

620: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
621: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
622: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
623: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
624: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
625: p_receipt_num => r_rcv_shipment_headers.receipt_num,
626: p_receiving_account_id => ln_receiving_account_id,
627: p_ap_accrual_account => ln_ap_accrual_account,
628: p_boe_account_id => ln_boe_account_id,

Line 672: instead of nvl(r_rcv_transactions.attribute_category, 'XX') <> 'INDIA RMA RECEIPT'*/

668: /*Bug 5632406 Start*/
669: if (lb_account_service_interim and nvl(ln_service_recoverable, 0) <> 0 )
670: and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER'
671: /* bug#5632406 - bduvarag used the p_receipt_source_code
672: instead of nvl(r_rcv_transactions.attribute_category, 'XX') <> 'INDIA RMA RECEIPT'*/
673: then
674: /*Bug 5632406 End*/
675: p_codepath := jai_general_pkg.plot_codepath(10.1, p_codepath); /* 10.1 */
676:

Line 680: p_shipment_line_id => r_rcv_transactions.shipment_line_id,

676:
677: regime_tax_accounting_interim
678: (
679: p_transaction_id => p_transaction_id,
680: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
681: p_organization_id => r_ja_in_rcv_transactions.organization_id,
682: p_location_id => r_ja_in_rcv_transactions.location_id,
683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,

Line 681: p_organization_id => r_ja_in_rcv_transactions.organization_id,

677: regime_tax_accounting_interim
678: (
679: p_transaction_id => p_transaction_id,
680: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
681: p_organization_id => r_ja_in_rcv_transactions.organization_id,
682: p_location_id => r_ja_in_rcv_transactions.location_id,
683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,

Line 682: p_location_id => r_ja_in_rcv_transactions.location_id,

678: (
679: p_transaction_id => p_transaction_id,
680: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
681: p_organization_id => r_ja_in_rcv_transactions.organization_id,
682: p_location_id => r_ja_in_rcv_transactions.location_id,
683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,

Line 683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,

679: p_transaction_id => p_transaction_id,
680: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
681: p_organization_id => r_ja_in_rcv_transactions.organization_id,
682: p_location_id => r_ja_in_rcv_transactions.location_id,
683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

Line 684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,

680: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
681: p_organization_id => r_ja_in_rcv_transactions.organization_id,
682: p_location_id => r_ja_in_rcv_transactions.location_id,
683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,

Line 685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,

681: p_organization_id => r_ja_in_rcv_transactions.organization_id,
682: p_location_id => r_ja_in_rcv_transactions.location_id,
683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
689: p_receipt_num => r_rcv_shipment_headers.receipt_num,

Line 686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,

682: p_location_id => r_ja_in_rcv_transactions.location_id,
683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
689: p_receipt_num => r_rcv_shipment_headers.receipt_num,
690: p_regime_code => jai_constants.service_regime,

Line 688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,

684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
689: p_receipt_num => r_rcv_shipment_headers.receipt_num,
690: p_regime_code => jai_constants.service_regime,
691: ptr_jv => tr_jv,/*Bug 5632406*/
692: p_simulation => p_simulation,

Line 713: p_shipment_line_id => r_rcv_transactions.shipment_line_id,

709: /* VAT interim accounting required as recoverable vat tax exists */
710: regime_tax_accounting_interim
711: (
712: p_transaction_id => p_transaction_id,
713: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
714: p_organization_id => r_ja_in_rcv_transactions.organization_id,
715: p_location_id => r_ja_in_rcv_transactions.location_id,
716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,

Line 714: p_organization_id => r_ja_in_rcv_transactions.organization_id,

710: regime_tax_accounting_interim
711: (
712: p_transaction_id => p_transaction_id,
713: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
714: p_organization_id => r_ja_in_rcv_transactions.organization_id,
715: p_location_id => r_ja_in_rcv_transactions.location_id,
716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,

Line 715: p_location_id => r_ja_in_rcv_transactions.location_id,

711: (
712: p_transaction_id => p_transaction_id,
713: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
714: p_organization_id => r_ja_in_rcv_transactions.organization_id,
715: p_location_id => r_ja_in_rcv_transactions.location_id,
716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,

Line 716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,

712: p_transaction_id => p_transaction_id,
713: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
714: p_organization_id => r_ja_in_rcv_transactions.organization_id,
715: p_location_id => r_ja_in_rcv_transactions.location_id,
716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

Line 717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,

713: p_shipment_line_id => r_rcv_transactions.shipment_line_id,
714: p_organization_id => r_ja_in_rcv_transactions.organization_id,
715: p_location_id => r_ja_in_rcv_transactions.location_id,
716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,

Line 718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,

714: p_organization_id => r_ja_in_rcv_transactions.organization_id,
715: p_location_id => r_ja_in_rcv_transactions.location_id,
716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
722: p_receipt_num => r_rcv_shipment_headers.receipt_num,

Line 719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,

715: p_location_id => r_ja_in_rcv_transactions.location_id,
716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
722: p_receipt_num => r_rcv_shipment_headers.receipt_num,
723: p_regime_code => jai_constants.vat_regime,

Line 721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,

717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
722: p_receipt_num => r_rcv_shipment_headers.receipt_num,
723: p_regime_code => jai_constants.vat_regime,
724: ptr_jv => tr_jv,/*Bug 5632406*/
725: p_simulation => p_simulation,

Line 1861: update JAI_RCV_TRANSACTIONS

1857: /* If apply relieve BOE has been done successfully, update the boe_applied_flag in ja_in_rcv_transaction */
1858: if p_process_flag = 'Y' and nvl(p_simulation , 'Y') <> 'Y' then
1859:
1860: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1861: update JAI_RCV_TRANSACTIONS
1862: set boe_applied_flag = 'Y'
1863: where transaction_id = p_transaction_id;
1864:
1865: end if;

Line 2233: lv_reference_24 varchar2(240); -- := 'rcv_transactions';

2229: lv_acct_type varchar2(15); /* Regular or Reversal*/
2230:
2231: lv_reference_10 varchar2(240);
2232: lv_reference_23 varchar2(240); -- := 'jai_rcv_rcv_rtv_pkg.post_entries';
2233: lv_reference_24 varchar2(240); -- := 'rcv_transactions';
2234: lv_reference_25 varchar2(240); -- := 'transaction_id';
2235: lv_reference_26 varchar2(240);
2236: /* End of File.Sql.35 by Brathod */
2237:

Line 2348: lv_reference_24 := 'rcv_transactions';

2344: lv_source_name := 'Purchasing India';
2345: lv_category_name := 'Receiving India';
2346: lv_acct_nature := 'Receiving';
2347: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.post_entries';
2348: lv_reference_24 := 'rcv_transactions';
2349: lv_reference_25 := 'transaction_id';
2350: /* End of File.Sql.35 by Brathod*/
2351:
2352: if p_debug = 'Y' then

Line 2894: lv_reference_24 varchar2(240);-- := 'rcv_transactions';

2890: lv_acct_type varchar2(15); /* Regular or Reversal*/
2891:
2892: lv_reference_10 varchar2(240);
2893: lv_reference_23 varchar2(240);-- := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
2894: lv_reference_24 varchar2(240);-- := 'rcv_transactions';
2895: lv_reference_25 varchar2(240);-- := 'transaction_id';
2896: /* End of File.Sql.35 by Brathod */
2897:
2898: lv_reference_26 varchar2(240);

Line 2993: lv_reference_24 := 'rcv_transactions';

2989: lv_source_name := 'Purchasing India';
2990: lv_category_name := 'Receiving India';
2991: lv_acct_nature := 'Receiving';
2992: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
2993: lv_reference_24 := 'rcv_transactions';
2994: lv_reference_25 := 'transaction_id';
2995: /* End of File.Sql.35 by Brathod */
2996:
2997: