[Home] [Help]
PACKAGE: APPS.XLA_TP_BALANCE_RPT_PKG
Source
1 PACKAGE XLA_TP_BALANCE_RPT_PKG AS
2 -- $Header: xlarptpb.pkh 120.13 2008/01/04 12:09:57 samejain noship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | xlarptpb.pkh |
9 | |
10 | PACKAGE NAME |
11 | xla_tp_balance_rpt_pkg |
12 | |
13 | DESCRIPTION |
14 | Package specification.This provides XML extract for Third Party Balance|
15 | Report |
16 | |
17 | HISTORY |
18 | 07/20/2005 V. Kumar Created |
19 | 12/27/2005 V.Swapna Modified the package to use Data template |
20 | 04/26/2006 A. Wan 5162044 - add 10 custom_parameters 6-15 |
21 | |
22 +===========================================================================*/
23
24 --
25 -- To be used in query as bind variable
26 --
27 P_RESP_APPLICATION_ID NUMBER ;
28 P_LEDGER_ID NUMBER ;
29 P_LEDGER VARCHAR2(300);
30 P_COA_ID NUMBER;
31 P_JE_SOURCE_NAME VARCHAR2(240);
32 P_JE_SOURCE VARCHAR2(300);
33 P_LEGAL_ENTITY_ID NUMBER;
34 P_LEGAL_ENTITY VARCHAR2(300);
35 P_PERIOD_FROM VARCHAR2(30);
36 P_PERIOD_TO VARCHAR2(30);
37 P_GL_DATE_FROM DATE ;
38 P_GL_DATE_TO DATE ;
39 P_INCLUDE_DRAFT_ACTIVITY_FLAG VARCHAR2(1);
40 P_INCLUDE_DRAFT_ACTIVITY VARCHAR2(20);
41 P_BALANCE_SIDE_CODE VARCHAR2(80);
42 P_BALANCE_SIDE VARCHAR2(80);
43 P_BALANCE_AMOUNT_FROM NUMBER;
44 P_BALANCE_AMOUNT_TO NUMBER;
45 P_PARTY_TYPE VARCHAR2(30);
46 P_PARTY_ID NUMBER;
47 P_THIRD_PARTY_NAME VARCHAR2(300);
48 P_DUMMY_PARTY VARCHAR2(300);
49 P_PARTY_SITE_ID NUMBER;
50 P_THIRD_PARTY_SITE VARCHAR2(300);
51 P_PARTY_NUMBER_FROM NUMBER;
52 P_PARTY_NUMBER_TO NUMBER;
53 P_BALANCING_SEGMENT_FROM VARCHAR2(25);
54 P_BALANCING_SEGMENT_TO VARCHAR2(25);
55 P_ACCOUNT_SEGMENT_FROM VARCHAR2(25);
56 P_ACCOUNT_SEGMENT_TO VARCHAR2(25);
57 P_ACCOUNTING_FLEXFIELD_FROM VARCHAR2(780);
58 P_ACCOUNTING_FLEXFIELD_TO VARCHAR2(780);
59 P_INCLUDE_ZERO_AMT_LINES_FLAG VARCHAR2(1);
60 P_INCLUDE_ZERO_AMOUNT_LINES VARCHAR2(20);
61 P_INCLUDE_USER_TRX_ID_FLAG VARCHAR2(1);
62 P_INCLUDE_USER_TRX_IDENTIFIERS VARCHAR2(20);
63 P_INCLUDE_TAX_DETAILS_FLAG VARCHAR2(1);
64 P_INCLUDE_TAX_DETAILS VARCHAR2(20);
65 P_INCLUDE_LE_INFO_FLAG VARCHAR2(30);
66 P_INCLUDE_LEGAL_ENTITY VARCHAR2(30);
67 P_CUSTOM_PARAMETER_1 VARCHAR2(240);
68 P_CUSTOM_PARAMETER_2 VARCHAR2(240);
69 P_CUSTOM_PARAMETER_3 VARCHAR2(240);
70 P_CUSTOM_PARAMETER_4 VARCHAR2(240);
71 P_CUSTOM_PARAMETER_5 VARCHAR2(240);
72 P_CUSTOM_PARAMETER_6 VARCHAR2(240);
73 P_CUSTOM_PARAMETER_7 VARCHAR2(240);
74 P_CUSTOM_PARAMETER_8 VARCHAR2(240);
75 P_CUSTOM_PARAMETER_9 VARCHAR2(240);
76 P_CUSTOM_PARAMETER_10 VARCHAR2(240);
77 P_CUSTOM_PARAMETER_11 VARCHAR2(240);
78 P_CUSTOM_PARAMETER_12 VARCHAR2(240);
79 P_CUSTOM_PARAMETER_13 VARCHAR2(240);
80 P_CUSTOM_PARAMETER_14 VARCHAR2(240);
81 P_CUSTOM_PARAMETER_15 VARCHAR2(240);
82
83 P_LANG VARCHAR2(80);
84 P_START_PERIOD_NUM NUMBER;
85 P_END_PERIOD_NUM NUMBER;
86 P_START_DATE DATE;
87 P_END_DATE DATE;
88
89 p_party_col VARCHAR2(2000):=' ';
90 p_party_tab VARCHAR2(1000):=' ';
91 p_party_join VARCHAR2(1000):=' ';
92 p_legal_ent_col VARCHAR2(2000):=' ';
93 p_legal_ent_from VARCHAR2(1000):=' ';
94 p_legal_ent_join VARCHAR2(1000):=' ';
95 p_qualifier_segment VARCHAR2(4000):=' ';
96 p_seg_desc_from VARCHAR2(1000):=' ';
97 p_seg_desc_join VARCHAR2(1000):=' ';
98 p_other_filter VARCHAR2(2000):=' ';
99 p_trx_identifiers VARCHAR2(32000):=',NULL';
100 p_commercial_query VARCHAR2(32000);
101 p_vat_registration_query VARCHAR2(32000);
102
103 FUNCTION beforeReport RETURN BOOLEAN;
104
105 END XLA_TP_BALANCE_RPT_PKG;