[Home] [Help]
PACKAGE: APPS.XLA_TP_SUMMARY_RPT_PKG
Source
1 PACKAGE XLA_TP_SUMMARY_RPT_PKG
2 -- $Header: XLA_TPSUMRPT_PS.pls 120.3.12000000.1 2007/10/23 12:57:06 sgudupat noship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | XLA_TPSUMRPT_PS.pls |
9 | |
10 | PACKAGE NAME |
11 | XLA_TP_SUMMARY_RPT_PKG |
12 | |
13 | DESCRIPTION |
14 | Package specification.This provides XML extract for Trading Partner |
15 | Summary Report |
16 | |
17 | HISTORY |
18 | 05/06/2007 Rakesh Pulla Created |
19 | 18/09/2007 Rakesh Pulla Modified the code AUTHID CURRENT_USER as it has an impact |
20 | on the new parameter added |
21 | (Third Party type) |
22 | 12/10/2007 Rakesh Pulla Added the functions min_period |
23 | & max_period |
24 | |
25 +===========================================================================*/
26 AS
27
28 P_RESP_APPLICATION_ID NUMBER;
29 P_LEDGER_ID NUMBER;
30 P_LEDGER VARCHAR2(300);
31 P_COA_ID NUMBER(15);
32 P_JE_SOURCE_NAME VARCHAR2(240);
33 P_PERIOD_FROM VARCHAR2(30);
34 P_PERIOD_TO VARCHAR2(30);
35 P_ACCOUNT_DATE_FROM DATE;
36 P_ACCOUNT_DATE_TO DATE;
37 P_THIRD_PARTY_FROM VARCHAR2(300);
38 P_THIRD_PARTY_TO VARCHAR2(300);
39 P_ACCOUNTING_FLEXFIELD_FROM VARCHAR2(285);
40 P_ACCOUNTING_FLEXFIELD_TO VARCHAR2(285);
41 P_PARTY_TYPE VARCHAR2(30);
42 P_PARTY_TYPE_DUMMY VARCHAR2(80);
43 P_THIRD_PARTY_TYPE VARCHAR2(80);
44 P_THIRD_PARTY_TYPE_DUMMY VARCHAR2(80);
45 P_INCLUDE_SUBS_DETAIL VARCHAR2(10);
46 P_INCLUDE_SUBS_DUMMY VARCHAR2(15);
47 P_PERIOD_START_DATE DATE;
48 P_PERIOD_END_DATE DATE;
49 P_LEDGER_CURRENCY VARCHAR2(100);
50 P_BEG_DATE_RANGE VARCHAR2(3000);
51 P_PER_DATE_RANGE VARCHAR2(3000);
52 P_PERIOD_NUM_FROM NUMBER;
53 P_PERIOD_NUM_TO NUMBER;
54
55 /* Commented the variables in order to fix the Bug # 6401736 */
56
57 /* To fetch the actual periods which are present in the xla_control_balances table.
58 P_AC_PERIOD_FROM VARCHAR2(30);
59 P_AC_PERIOD_TO VARCHAR2(30); */
60
61 /* Lexical variables used in the query */
62 p_party_col VARCHAR2(2000);
63 p_party_group VARCHAR2(2000);
64 p_party_tab VARCHAR2(2000);
65 p_party_join VARCHAR2(1000);
66 p_party_name_join VARCHAR2(1000);
67
68
69 FUNCTION beforeReport RETURN BOOLEAN;
70 FUNCTION min_period( p_period_num IN NUMBER) RETURN NUMBER;
71 FUNCTION max_period( p_period_num IN NUMBER) RETURN NUMBER;
72
73 END XLA_TP_SUMMARY_RPT_PKG;