[Home] [Help]
Skip to content
PACKAGE: APPS.XLA_MPA_ACCRUAL_RPRTG_PKG
Source
1 PACKAGE xla_mpa_accrual_rprtg_pkg AUTHID CURRENT_USER AS
2 -- $Header: xlarpmpb.pkh 120.1 2006/03/31 10:44:11 vkasina noship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | xlarpmpb.pkh |
9 | |
10 | PACKAGE NAME |
11 | xla_mpa_accrual_rprtg_pkg |
12 | |
13 | DESCRIPTION |
14 | This package is called by the Create Accounting program through |
15 | a concurrent request and generates a report if there are mpa |
16 | entries. The report consists of a list of all those mpa, |
17 | recognition, accrual and accrual reversal entries. |
18 | |
19 | HISTORY |
20 | 26/08/2005 VS Koushik Created |
21 +===========================================================================*/
22
23 p_source_application_id NUMBER;
24 p_source_application gl_je_sources_tl.user_je_source_name%TYPE;
25 p_application_id NUMBER;
26 p_je_source gl_je_sources_tl.user_je_source_name%TYPE;
27 p_dummy VARCHAR2(240);
28 p_ledger_id NUMBER;
29 p_ledger VARCHAR2(30);
30 p_process_category_code VARCHAR2(30);
31 p_process_category_name VARCHAR2(80);
32 p_end_date DATE;
33 p_create_accounting VARCHAR2(30);
34 p_create_accounting_flag VARCHAR2(80);
35 p_dummy_param_1 VARCHAR2(240);
36 p_accounting_mode VARCHAR2(30);
37 p_dummy_param_2 VARCHAR2(240);
38 p_errors_only VARCHAR2(30);
39 p_errors_only_flag VARCHAR2(80);
40 p_dummy_param_3 VARCHAR2(240);
41 p_report VARCHAR2(30);
42 p_report_style VARCHAR2(80);
43 p_transfer_to_gl VARCHAR2(30);
44 p_transfer_to_gl_flag VARCHAR2(80);
45 p_dummy_param_4 VARCHAR2(240);
46 p_post_in_gl VARCHAR2(30);
47 p_post_in_gl_flag VARCHAR2(80);
48 p_gl_batch_name VARCHAR2(50);
49 p_accounting_batch_id NUMBER;
50
51 xah_appl_filter VARCHAR2(2000);
52 xae_appl_filter VARCHAR2(2000);
53 ent_appl_filter VARCHAR2(2000);
54 xal_appl_filter VARCHAR2(2000);
55 acct_batch_filter VARCHAR2(240);
56 C_SUMMARY_QUERY VARCHAR2(4000);
57 C_TRANSFER_QUERY VARCHAR2(4000);
58 C_GENERAL_ERRORS_QUERY VARCHAR2(3000);
59 C_MPA_COLS_QUERY VARCHAR2(8000);
60 C_MPA_FROM_QUERY VARCHAR2(8000);
61 C_MPA_WHR_QUERY VARCHAR2(8000);
62 C_ACCRUAL_RVRSL_COLS_QUERY VARCHAR2(8000);
63 C_ACCRUAL_RVRSL_FROM_QUERY VARCHAR2(8000);
64 C_ACCRUAL_RVRSL_WHR_QUERY VARCHAR2(8000);
65 C_ERRORS_COLS_QUERY VARCHAR2(8000);
66 C_ERRORS_FROM_QUERY VARCHAR2(8000);
67 C_ERRORS_WHR_QUERY VARCHAR2(8000);
68
69 p_trx_identifiers VARCHAR2(32000):= ' ';
70
71 FUNCTION beforeReport RETURN BOOLEAN;
72
73 FUNCTION run_report
74 (p_source_application_id IN NUMBER
75 ,p_application_id IN NUMBER
76 ,p_ledger_id IN NUMBER
77 ,p_process_category IN VARCHAR2
78 ,p_end_date IN DATE
79 ,p_accounting_flag IN VARCHAR2
80 ,p_accounting_mode IN VARCHAR2
81 ,p_errors_only_flag IN VARCHAR2
82 ,p_transfer_flag IN VARCHAR2
83 ,p_gl_posting_flag IN VARCHAR2
84 ,p_gl_batch_name IN VARCHAR2
85 ,p_accounting_batch_id IN NUMBER) RETURN NUMBER;
86
87 END xla_mpa_accrual_rprtg_pkg;