DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on JG_ZZ_COMMON_PKG

Line 506: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount

502: ,NULL import_document_date
503: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
504: ,jzvtd.posted_flag
505: -- Bug 7683525 ,SUM(Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION) + DECODE(tax_recoverable_flag,'N',Round(nvl(jzvtd.taxable_amt_funcl_curr,jzvtd.taxable_amt),G_PRECISION),0)) invoice_amount
506: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
507: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,'VAT-A',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) s_vat_on_fixed_assets
508: ,0 p_vat_on_fixed_assets
509: ,0 i_vat_on_fixed_assets
510: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,'VAT-S',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) s_vat_on_other_trx

Line 550: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount

546: ,NULL import_document_date
547: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
548: ,jzvtd.posted_flag
549: -- Bug 7683525 ,SUM(Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION) + DECODE(tax_recoverable_flag,'N',Round(nvl(jzvtd.taxable_amt_funcl_curr,jzvtd.taxable_amt),G_PRECISION),0)) invoice_amount
550: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
551: ,0 s_vat_on_fixed_assets
552: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,'VAT-KA',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) p_vat_on_fixed_assets
553: ,0 i_vat_on_fixed_assets
554: ,0 s_vat_on_other_trx

Line 602: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount

598: ,apinvl.GLOBAL_ATTRIBUTE13 import_document_date
599: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
600: ,jzvtd.posted_flag
601: -- Bug 7683525 ,SUM(Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION) + DECODE(tax_recoverable_flag,'N',Round(nvl(jzvtd.taxable_amt_funcl_curr,jzvtd.taxable_amt),G_PRECISION),0)) invoice_amount
602: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
603: ,0 s_vat_on_fixed_assets
604: ,0 p_vat_on_fixed_assets
605: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,'VAT-RA',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) i_vat_on_fixed_assets
606: ,0 s_vat_on_other_trx

Line 653: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;

649: BEGIN
650:
651: p_where_clause := ' AND 1 = 1 ';
652:
653: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;
654: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code
655: ,l_rep_entity_name
656: ,l_legal_entity_id
657: ,l_taxpayer_id

Line 654: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code

650:
651: p_where_clause := ' AND 1 = 1 ';
652:
653: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;
654: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code
655: ,l_rep_entity_name
656: ,l_legal_entity_id
657: ,l_taxpayer_id
658: ,P_VAT_REPORTING_ENTITY_ID

Line 661: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;

657: ,l_taxpayer_id
658: ,P_VAT_REPORTING_ENTITY_ID
659: , pv_period_name => p_tax_calendar_period /* UT TEST addition */
660: );
661: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;
662: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name
663: ,x_registration_number =>l_registration_number
664: ,x_country => l_country
665: ,x_address1 => l_address1

Line 662: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name

658: ,P_VAT_REPORTING_ENTITY_ID
659: , pv_period_name => p_tax_calendar_period /* UT TEST addition */
660: );
661: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;
662: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name
663: ,x_registration_number =>l_registration_number
664: ,x_country => l_country
665: ,x_address1 => l_address1
666: ,x_address2 => l_address2

Line 679: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;

675: ,x_vat_reg_num => l_vat_reg_num
676: ,pn_legal_entity_id => l_legal_entity_id
677: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
678:
679: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;
680: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
681: ,x_period_start_date => l_period_start_date
682: ,x_period_end_date => l_period_end_date
683: ,x_status => l_reporting_status

Line 680: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num

676: ,pn_legal_entity_id => l_legal_entity_id
677: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
678:
679: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;
680: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
681: ,x_period_start_date => l_period_start_date
682: ,x_period_end_date => l_period_end_date
683: ,x_status => l_reporting_status
684: ,pn_vat_rep_entity_id => p_vat_reporting_entity_id