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.4 2010/01/07 19:37:37 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 322: 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$''

318: WHERE apinv.invoice_id = apd.invoice_id
319: AND apinv.invoice_date > $l_end_date$
320: AND apinv.set_of_books_id = $l_ledger_id$
321: AND apinv.legal_entity_id = $l_legal_entity_id$
322: 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$''
323: )';
324:
325: l_update_query_ar := l_update_query_ar ||
326: ' AND zxl.trx_id IN

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

330: WHERE rinv.customer_trx_id = rtd.customer_trx_id
331: AND rinv.trx_date > $l_end_date$
332: AND rinv.set_of_books_id = $l_ledger_id$
333: AND rinv.legal_entity_id = $l_legal_entity_id$
334: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID ,$p_chart_of_account_id$ ,$l_ledger_id$) = ''$p_bsv$''
335: )';
336:
337:
338: END IF; -- p_reporting_level = 'BSV'

Line 372: 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$''

368: WHERE apinv.invoice_id = apd.invoice_id
369: AND apinv.gl_date > $l_end_date$
370: AND apinv.set_of_books_id = $l_ledger_id$
371: AND apinv.legal_entity_id = $l_legal_entity_id$
372: 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$''
373: ) ';
374:
375: l_update_query_ar := l_update_query_ar||
376: ' AND zxl.trx_id IN

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

380: WHERE rinv.customer_trx_id = rtd.customer_trx_id
381: AND rtd.gl_date > $l_end_date$
382: AND rinv.set_of_books_id = $l_ledger_id$
383: AND rinv.legal_entity_id = $l_legal_entity_id$
384: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID ,$p_chart_of_account_id$ ,$l_ledger_id$) = ''$p_bsv$''
385: )';
386:
387: END IF; --p_reporting_level = 'BSV'
388:

Line 427: 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$''

423: ap_invoices_all apinv
424: WHERE apinv.invoice_id = apd.invoice_id
425: AND apinv.set_of_books_id = $l_ledger_id$
426: AND apinv.legal_entity_id = $l_legal_entity_id$
427: 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$''
428: )';
429:
430: l_update_query_ar := l_update_query_ar ||
431: ' AND zxl.trx_id IN

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

434: ra_customer_trx_all rinv
435: WHERE rinv.customer_trx_id = rtd.customer_trx_id
436: AND rinv.set_of_books_id = $l_ledger_id$
437: AND rinv.legal_entity_id = $l_legal_entity_id$
438: AND JG_ZZ_VAT_PRE_REP_PROC_PKG.get_bsv(rtd.CODE_COMBINATION_ID,$p_chart_of_account_id$,$l_ledger_id$) = ''$p_bsv$''
439: )';
440:
441: END IF; --p_reporting_level = 'BSV'
442: END IF;

Line 498: END JG_ZZ_VAT_PRE_REP_PROC_PKG;

494: FND_LOG.STRING(g_level_unexpected, G_MODULE_NAME, g_error_buffer);
495: END IF;
496: retcode := 2;
497: END main;
498: END JG_ZZ_VAT_PRE_REP_PROC_PKG;