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_VAT_PRE_REP_PROC_PKG dependencies on JG_ZZ_VAT_PRE_REP_PROC_PKG

Line 1: PACKAGE BODY JG_ZZ_VAT_PRE_REP_PROC_PKG AS

1: PACKAGE BODY JG_ZZ_VAT_PRE_REP_PROC_PKG AS
2: /* $Header: jgzzprpb.pls 120.0.12010000.2 2008/12/02 05:53:58 spasupun noship $ */
3: -----------------------------------------
4: --Public Variable Declarations
5: -----------------------------------------

Line 15: g_pkg_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_PRE_REP_PROC_PKG';

11: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_buffer VARCHAR2(100);
14: g_debug_flag VARCHAR2(1);
15: g_pkg_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_PRE_REP_PROC_PKG';
16: g_module_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_PRE_REP_PROC_PKG';
17:
18: /*
19: REM +======================================================================+

Line 16: g_module_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_PRE_REP_PROC_PKG';

12: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_buffer VARCHAR2(100);
14: g_debug_flag VARCHAR2(1);
15: g_pkg_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_PRE_REP_PROC_PKG';
16: g_module_name CONSTANT VARCHAR2(30) := 'JG_ZZ_VAT_PRE_REP_PROC_PKG';
17:
18: /*
19: REM +======================================================================+
20: REM Name: get_bsv

Line 301: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(apd.dist_code_combination_id ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$

297: WHERE apinv.invoice_id = apd.invoice_id
298: AND apinv.invoice_date > $l_end_date$
299: AND apinv.set_of_books_id = $l_ledger_id$
300: AND apinv.legal_entity_id = $l_legal_entity_id$
301: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(apd.dist_code_combination_id ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$
302: )';
303:
304: l_update_query_ar := l_update_query_ar ||
305: ' AND zxl.trx_id IN

Line 313: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$

309: WHERE rinv.customer_trx_id = rtd.customer_trx_id
310: AND rinv.trx_date > $l_end_date$
311: AND rinv.set_of_books_id = $l_ledger_id$
312: AND rinv.legal_entity_id = $l_legal_entity_id$
313: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$
314: )';
315:
316:
317: END IF; -- p_reporting_level = 'BSV'

Line 351: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(apd.dist_code_combination_id ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$

347: WHERE apinv.invoice_id = apd.invoice_id
348: AND apinv.gl_date > $l_end_date$
349: AND apinv.set_of_books_id = $l_ledger_id$
350: AND apinv.legal_entity_id = $l_legal_entity_id$
351: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(apd.dist_code_combination_id ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$
352: ) ';
353:
354: l_update_query_ar := l_update_query_ar||
355: ' AND zxl.trx_id IN

Line 363: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$

359: WHERE rinv.customer_trx_id = rtd.customer_trx_id
360: AND rtd.gl_date > $l_end_date$
361: AND rinv.set_of_books_id = $l_ledger_id$
362: AND rinv.legal_entity_id = $l_legal_entity_id$
363: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$
364: )';
365:
366: END IF; --p_reporting_level = 'BSV'
367:

Line 406: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(apd.dist_code_combination_id ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$

402: ap_invoices_all apinv
403: WHERE apinv.invoice_id = apd.invoice_id
404: AND apinv.set_of_books_id = $l_ledger_id$
405: AND apinv.legal_entity_id = $l_legal_entity_id$
406: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(apd.dist_code_combination_id ,$p_chart_of_account_id$ ,$l_ledger_id$) = $p_bsv$
407: )';
408:
409: l_update_query_ar := l_update_query_ar ||
410: ' AND zxl.trx_id IN

Line 417: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID,$p_chart_of_account_id$,$l_ledger_id$) = $p_bsv$

413: ra_customer_trx_all rinv
414: WHERE rinv.customer_trx_id = rtd.customer_trx_id
415: AND rinv.set_of_books_id = $l_ledger_id$
416: AND rinv.legal_entity_id = $l_legal_entity_id$
417: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID,$p_chart_of_account_id$,$l_ledger_id$) = $p_bsv$
418: )';
419:
420: END IF; --p_reporting_level = 'BSV'
421: END IF;

Line 477: END JG_ZZ_VAT_PRE_REP_PROC_PKG;

473: FND_LOG.STRING(g_level_unexpected, G_MODULE_NAME, g_error_buffer);
474: END IF;
475: retcode := 2;
476: END main;
477: END JG_ZZ_VAT_PRE_REP_PROC_PKG;