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_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_PA_BILLING_PKG

Line 277: WHERE cp_source = jai_pa_billing_pkg.gv_source_projects

273: WHERE jrttv1.regime_code = jai_constants.vat_regime
274: UNION
275: SELECT 'VAT REVERSAL' tax_type FROM DUAL
276: ) jrttv
277: WHERE cp_source = jai_pa_billing_pkg.gv_source_projects
278: AND jpdi.draft_invoice_id = jpdil.draft_invoice_id
279: AND jpdil.draft_invoice_line_id = jcdt.source_doc_line_id
280: AND jcdt.source_doc_id = jpdi.draft_invoice_id
281: AND jcdt.source_doc_type = jai_pa_billing_pkg.gv_source_projects

Line 281: AND jcdt.source_doc_type = jai_pa_billing_pkg.gv_source_projects

277: WHERE cp_source = jai_pa_billing_pkg.gv_source_projects
278: AND jpdi.draft_invoice_id = jpdil.draft_invoice_id
279: AND jpdil.draft_invoice_line_id = jcdt.source_doc_line_id
280: AND jcdt.source_doc_id = jpdi.draft_invoice_id
281: AND jcdt.source_doc_type = jai_pa_billing_pkg.gv_source_projects
282: AND jcdt.tax_type = jrttv.tax_type
283: AND jpdi.draft_invoice_id = p_delivery_id
284: GROUP BY jpdi.draft_invoice_id, jcdt.tax_type, jcdt.tax_id, jcdt.tax_rate;
285: /* end bug# 6012570 (5876390) */

Line 447: , jai_pa_billing_pkg.gv_source_projects /* Bug# 6012570 (5876390) */

443: ******************************************************************************************/
444:
445: IF upper(p_source) in (
446: upper(jai_constants.source_wsh)
447: , jai_pa_billing_pkg.gv_source_projects /* Bug# 6012570 (5876390) */
448: )
449: THEN
450:
451: if jai_pa_billing_pkg.gv_debug then

Line 451: if jai_pa_billing_pkg.gv_debug then

447: , jai_pa_billing_pkg.gv_source_projects /* Bug# 6012570 (5876390) */
448: )
449: THEN
450:
451: if jai_pa_billing_pkg.gv_debug then
452: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 rgm_om_ar_vat_accnt_pkg.process_order_invoice . Psource:'||p_source);
453: end if;
454:
455: /* Start Bug# 6012570 (5876390) */

Line 452: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 rgm_om_ar_vat_accnt_pkg.process_order_invoice . Psource:'||p_source);

448: )
449: THEN
450:
451: if jai_pa_billing_pkg.gv_debug then
452: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 rgm_om_ar_vat_accnt_pkg.process_order_invoice . Psource:'||p_source);
453: end if;
454:
455: /* Start Bug# 6012570 (5876390) */
456: if upper(p_source) = upper(jai_constants.source_wsh) then

Line 463: elsif p_source = jai_pa_billing_pkg.gv_source_projects then

459: lv_source_table_name := jai_constants.tname_dlry_dtl;
460: lv_called_from := jai_constants.vat_repo_call_from_om_ar;
461: lv_attribute_context := jai_constants.contxt_delivery;
462:
463: elsif p_source = jai_pa_billing_pkg.gv_source_projects then
464: record_debug_messages ('6 Projects Draft Invoice PROCESSING');
465: lv_source_trx_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
466: lv_source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- 'JAI_PA_DRAFT_INVOICES';
467: lv_called_from := p_called_from;

Line 465: lv_source_trx_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';

461: lv_attribute_context := jai_constants.contxt_delivery;
462:
463: elsif p_source = jai_pa_billing_pkg.gv_source_projects then
464: record_debug_messages ('6 Projects Draft Invoice PROCESSING');
465: lv_source_trx_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
466: lv_source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- 'JAI_PA_DRAFT_INVOICES';
467: lv_called_from := p_called_from;
468: lv_attribute_context := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE';
469:

Line 466: lv_source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- 'JAI_PA_DRAFT_INVOICES';

462:
463: elsif p_source = jai_pa_billing_pkg.gv_source_projects then
464: record_debug_messages ('6 Projects Draft Invoice PROCESSING');
465: lv_source_trx_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
466: lv_source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- 'JAI_PA_DRAFT_INVOICES';
467: lv_called_from := p_called_from;
468: lv_attribute_context := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE';
469:
470: end if;

Line 468: lv_attribute_context := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE';

464: record_debug_messages ('6 Projects Draft Invoice PROCESSING');
465: lv_source_trx_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
466: lv_source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- 'JAI_PA_DRAFT_INVOICES';
467: lv_called_from := p_called_from;
468: lv_attribute_context := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE';
469:
470: end if;
471: /* End Bug# 6012570 (5876390) */
472:

Line 482: if jai_pa_billing_pkg.gv_debug then

478: /* Bug 5739005 vkantamn --Parameters needed in cur_get_deliveries */
479: FOR rec_cur_get_deliveries IN cur_get_deliveries(p_source, lv_source_trx_type, lv_source_table_name)
480: LOOP
481:
482: if jai_pa_billing_pkg.gv_debug then
483: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '4 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Loop TaxId:'||rec_cur_get_deliveries.tax_id);
484: end if;
485:
486: record_debug_messages (' ************7 PROCESSING Delivery id -> '|| p_delivery_id||'Delivery Details ID -> '||rec_cur_get_deliveries.delivery_detail_id||' ************' );

Line 483: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '4 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Loop TaxId:'||rec_cur_get_deliveries.tax_id);

479: FOR rec_cur_get_deliveries IN cur_get_deliveries(p_source, lv_source_trx_type, lv_source_table_name)
480: LOOP
481:
482: if jai_pa_billing_pkg.gv_debug then
483: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '4 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Loop TaxId:'||rec_cur_get_deliveries.tax_id);
484: end if;
485:
486: record_debug_messages (' ************7 PROCESSING Delivery id -> '|| p_delivery_id||'Delivery Details ID -> '||rec_cur_get_deliveries.delivery_detail_id||' ************' );
487: /*******************************

Line 508: elsif p_source = jai_pa_billing_pkg.gv_source_projects then

504: /* Start Bug# 6012570 (5876390) */
505: if upper(p_source) = upper(jai_constants.source_wsh) then
506: ln_source_id := rec_cur_get_deliveries.delivery_detail_id;
507:
508: elsif p_source = jai_pa_billing_pkg.gv_source_projects then
509: ln_source_id := rec_cur_get_deliveries.delivery_id; /* this is draft_invoice_id */
510:
511: end if;
512: /* End Bug# 6012570 (5876390) */

Line 644: if jai_pa_billing_pkg.gv_debug then

640:
641: record_debug_messages ('11 Before call to jai_cmn_rgm_recording_pkg.insert_vat_repository_entry');
642:
643:
644: if jai_pa_billing_pkg.gv_debug then
645: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '6 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Bef jai_cmn_rgm_recording_pkg.insert_vat_repository_entry');
646: end if;
647:
648: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry (

Line 645: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '6 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Bef jai_cmn_rgm_recording_pkg.insert_vat_repository_entry');

641: record_debug_messages ('11 Before call to jai_cmn_rgm_recording_pkg.insert_vat_repository_entry');
642:
643:
644: if jai_pa_billing_pkg.gv_debug then
645: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '6 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Bef jai_cmn_rgm_recording_pkg.insert_vat_repository_entry');
646: end if;
647:
648: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry (
649: pn_repository_id => ln_repository_id ,

Line 688: if jai_pa_billing_pkg.gv_debug then

684: pv_attribute4 => NULL ,
685: pv_attribute5 => NULL
686: );
687:
688: if jai_pa_billing_pkg.gv_debug then
689: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 rgm_om_ar_vat_accnt_pkg.process_order_invoice. After callto insert_vat_repository_entry'
690: ||', ln_repository_id:'||ln_repository_id
691: ||', lv_process_flag:'||lv_process_flag
692: ||', lv_process_message:'||lv_process_message

Line 689: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 rgm_om_ar_vat_accnt_pkg.process_order_invoice. After callto insert_vat_repository_entry'

685: pv_attribute5 => NULL
686: );
687:
688: if jai_pa_billing_pkg.gv_debug then
689: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 rgm_om_ar_vat_accnt_pkg.process_order_invoice. After callto insert_vat_repository_entry'
690: ||', ln_repository_id:'||ln_repository_id
691: ||', lv_process_flag:'||lv_process_flag
692: ||', lv_process_message:'||lv_process_message
693: );

Line 748: if jai_pa_billing_pkg.gv_debug then

744: ||', p_attribute_context -> ' || jai_constants.contxt_delivery
745: );
746:
747:
748: if jai_pa_billing_pkg.gv_debug then
749: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Before callto jai_cmn_rgm_recording_pkg.do_vat_accounting.');
750: end if;
751:
752: jai_cmn_rgm_recording_pkg.do_vat_accounting (

Line 749: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Before callto jai_cmn_rgm_recording_pkg.do_vat_accounting.');

745: );
746:
747:
748: if jai_pa_billing_pkg.gv_debug then
749: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 rgm_om_ar_vat_accnt_pkg.process_order_invoice. Before callto jai_cmn_rgm_recording_pkg.do_vat_accounting.');
750: end if;
751:
752: jai_cmn_rgm_recording_pkg.do_vat_accounting (
753: pn_regime_id => p_regime_id ,

Line 781: if jai_pa_billing_pkg.gv_debug then

777: pv_reference_name => /*jai_constants.JAI_CMN_TAXES_ALL*/'JA_IN_TAX_CODES' ,
778: pn_reference_id => rec_cur_get_deliveries.tax_id
779: );
780:
781: if jai_pa_billing_pkg.gv_debug then
782: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 rgm_om_ar_vat_accnt_pkg.process_order_invoice. After callto do_vat_accounting.'
783: ||', lv_process_flag:'||lv_process_flag
784: ||', lv_process_message:'||lv_process_message
785: );

Line 782: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 rgm_om_ar_vat_accnt_pkg.process_order_invoice. After callto do_vat_accounting.'

778: pn_reference_id => rec_cur_get_deliveries.tax_id
779: );
780:
781: if jai_pa_billing_pkg.gv_debug then
782: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 rgm_om_ar_vat_accnt_pkg.process_order_invoice. After callto do_vat_accounting.'
783: ||', lv_process_flag:'||lv_process_flag
784: ||', lv_process_message:'||lv_process_message
785: );
786: end if;