PACKAGE: APPS.JA_JP_TP_BAL_CTRL_RPT_PKG

Source

1 PACKAGE JA_JP_TP_BAL_CTRL_RPT_PKG AUTHID CURRENT_USER AS
2 -- $Header: jajptpbcs.pls 120.2 2010/12/23 06:23:39 spasupun noship $
3 --
4 -- To be used in query as bind variable
5 --
6 
7 P_RESP_APPLICATION_ID            NUMBER ;
8 P_LEDGER_ID                      NUMBER ;
9 P_LEDGER                         VARCHAR2(300);
10 P_COA_ID                         NUMBER;
11 P_JE_SOURCE_NAME                 VARCHAR2(240);
12 P_JE_SOURCE                      VARCHAR2(300);
13 P_LEGAL_ENTITY_ID                NUMBER;
14 P_LEGAL_ENTITY                   VARCHAR2(300);
15 P_PERIOD_FROM                    VARCHAR2(30);
16 P_PERIOD_TO                      VARCHAR2(30);
17 P_GL_DATE_FROM                   DATE ;
18 P_GL_DATE_TO                     DATE ;
19 P_INCLUDE_DRAFT_ACTIVITY_FLAG    VARCHAR2(1);
20 P_INCLUDE_DRAFT_ACTIVITY         VARCHAR2(20);
21 P_PARTY_TYPE                     VARCHAR2(30);
22 P_THIRD_PARTY_NAME_FROM                VARCHAR2(300);
23 P_THIRD_PARTY_NAME_TO                  VARCHAR2(300);
24 P_THIRD_PARTY_NUMBER_FROM              VARCHAR2(30);
25 P_THIRD_PARTY_NUMBER_TO                VARCHAR2(30);
26 P_THIRD_PARTY_SITE_NAME_FROM           VARCHAR2(240);
27 P_THIRD_PARTY_SITE_NAME_TO           VARCHAR2(240);
28 P_ACCOUNTING_FLEXFIELD_FROM      VARCHAR2(780);
29 P_ACCOUNTING_FLEXFIELD_TO        VARCHAR2(780);
30 P_INCLUDE_LE_INFO_FLAG           VARCHAR2(30);
31 P_INCLUDE_LEGAL_ENTITY           VARCHAR2(30);
32 P_GL_TRANSFER_VALUE              VARCHAR2(30);
33 P_GL_TRANSFER_STATUS             VARCHAR2(80);
34 P_DOCUMENT_SEQUENCE_NAME         VARCHAR2(300);
35 P_DOCUMENT_SEQUENCE_VALUE        VARCHAR2(300);
36 P_DOC_SEQUENCE_NUMBER_FROM       NUMBER;
37 P_DOC_SEQUENCE_NUMBER_TO         NUMBER;
38 P_DIST_ACCT_FLEXFIELD_FROM    VARCHAR2(780);
39 P_DIST_ACCT_FLEXFIELD_TO      VARCHAR2(780);
40 P_DIST_DR_CR                     VARCHAR2(80);
41 P_DIST_AMT_FROM                  NUMBER;
42 P_DIST_AMT_TO                    NUMBER;
43 
44 P_LANG                           VARCHAR2(80);
45 P_START_PERIOD_NUM               NUMBER;
46 P_END_PERIOD_NUM                 NUMBER;
47 P_START_DATE                     DATE;
48 P_END_DATE                       DATE;
49 
50 P_DIST_ACCOUNT_FF_RANGE_FILTER   VARCHAR2(32000);
51 P_ALIAS_BALANCING_SEGMENT        VARCHAR2(80);
52 P_ALIAS_ACCOUNT_SEGMENT          VARCHAR2(80);
53 
54 p_party_col                      VARCHAR2(2000) :='';
55 p_party_tab                      VARCHAR2(1000) :='';
56 p_party_join                     VARCHAR2(1000) :='';
57 p_legal_ent_col                  VARCHAR2(2000) :='';
58 p_legal_ent_from                 VARCHAR2(1000) :='';
59 p_legal_ent_join                 VARCHAR2(1000) :='';
60 p_qualifier_segment              VARCHAR2(4000) :='';
61 p_seg_desc_from                  VARCHAR2(1000) :='';
62 p_seg_desc_join                  VARCHAR2(1000) :='';
63 p_other_filter                   VARCHAR2(2000) :='';
64 p_commercial_query               VARCHAR2(32000);
65 p_vat_registration_query         VARCHAR2(32000);
66 p_trx_identifiers                VARCHAR2(32000):= '';
67 
68 G_POSTING_FLAG                   VARCHAR2(50);
69 
70 FUNCTION beforeReport RETURN BOOLEAN;
71 
72 END JA_JP_TP_BAL_CTRL_RPT_PKG;