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.JG_ZZ_SUMMARY_AP_PKG dependencies on JG_ZZ_COMMON_PKG

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

705: ,NULL import_document_number
706: ,NULL import_document_date
707: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
708: ,jzvtd.posted_flag
709: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
710: ,sum(DECODE(tax_recoverable_flag,'Y',
711: (CASE
712: WHEN jzvtd.reporting_code IN ('VAT-A') THEN nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt)
713: ELSE 0

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

769: ,NVL(apinvl.GLOBAL_ATTRIBUTE14,apinv.invoice_num) import_document_number
770: ,apinvl.GLOBAL_ATTRIBUTE13 import_document_date
771: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
772: ,jzvtd.posted_flag
773: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
774: ,SUM(DECODE(jzvtd.reporting_code,'VAT-RA',DECODE(tax_recoverable_flag,'Y',nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),0),0)) vat_on_fixed_assets
775: ,SUM(DECODE(jzvtd.reporting_code,'VAT-RS',DECODE(tax_recoverable_flag,'Y',nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),0),0)) vat_on_other_trxs
776: , 'R' class
777: ,0 mark_trx_flag

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

820: ,NULL import_document_number
821: ,NULL import_document_date
822: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
823: ,jzvtd.posted_flag
824: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
825: ,sum(DECODE(jzvtd.reporting_code,'VAT-KA',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_fixed_assets
826: ,sum(DECODE(jzvtd.reporting_code,'VAT-KS',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_other_trxs
827: ,'K' class
828: ,0 mark_trx_flag

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

862: ,NULL import_document_number
863: ,NULL import_document_date
864: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
865: ,jzvtd.posted_flag
866: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
867: ,sum(DECODE(jzvtd.reporting_code,'VAT-KA',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_fixed_assets
868: ,sum(DECODE(jzvtd.reporting_code,'VAT-KS',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_other_trxs
869: ,'K' class
870: ,1 mark_trx_flag

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

908: ,NULL import_document_date
909: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
910: ,jzvtd.posted_flag
911: -- 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
912: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
913: ,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
914: ,0 p_vat_on_fixed_assets
915: ,0 i_vat_on_fixed_assets
916: ,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 956: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount

952: ,NULL import_document_date
953: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
954: ,jzvtd.posted_flag
955: -- 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
956: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
957: ,0 s_vat_on_fixed_assets
958: ,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
959: ,0 i_vat_on_fixed_assets
960: ,0 s_vat_on_other_trx

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

1003: ,apinvl.GLOBAL_ATTRIBUTE13 import_document_date
1004: ,DECODE(nvl2(apinv.cancelled_date,'Y','N'),'Y','CANCELLED',jzvtd.trx_line_class) trx_line_class
1005: ,jzvtd.posted_flag
1006: -- 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
1007: ,JG_ZZ_COMMON_PKG.get_amt_tot(jzvtd.trx_id,l_ledger_id,G_PRECISION) invoice_amount
1008: ,0 s_vat_on_fixed_assets
1009: ,0 p_vat_on_fixed_assets
1010: ,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
1011: ,0 s_vat_on_other_trx

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

1053: BEGIN
1054:
1055: p_where_clause := ' AND 1 = 1 ';
1056:
1057: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;
1058: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code
1059: ,l_rep_entity_name
1060: ,l_legal_entity_id
1061: ,l_taxpayer_id

Line 1058: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code

1054:
1055: p_where_clause := ' AND 1 = 1 ';
1056:
1057: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;
1058: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code
1059: ,l_rep_entity_name
1060: ,l_legal_entity_id
1061: ,l_taxpayer_id
1062: ,P_VAT_REPORTING_ENTITY_ID

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

1061: ,l_taxpayer_id
1062: ,P_VAT_REPORTING_ENTITY_ID
1063: , pv_period_name => p_tax_calendar_period /* UT TEST addition */
1064: );
1065: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;
1066: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name
1067: ,x_registration_number =>l_registration_number
1068: ,x_country => l_country
1069: ,x_address1 => l_address1

Line 1066: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name

1062: ,P_VAT_REPORTING_ENTITY_ID
1063: , pv_period_name => p_tax_calendar_period /* UT TEST addition */
1064: );
1065: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;
1066: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name
1067: ,x_registration_number =>l_registration_number
1068: ,x_country => l_country
1069: ,x_address1 => l_address1
1070: ,x_address2 => l_address2

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

1079: ,x_vat_reg_num => l_vat_reg_num
1080: ,pn_legal_entity_id => l_legal_entity_id
1081: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
1082:
1083: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;
1084: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
1085: ,x_period_start_date => l_period_start_date
1086: ,x_period_end_date => l_period_end_date
1087: ,x_status => l_reporting_status

Line 1084: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num

1080: ,pn_legal_entity_id => l_legal_entity_id
1081: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
1082:
1083: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;
1084: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
1085: ,x_period_start_date => l_period_start_date
1086: ,x_period_end_date => l_period_end_date
1087: ,x_status => l_reporting_status
1088: ,pn_vat_rep_entity_id => p_vat_reporting_entity_id