PACKAGE: APPS.AR_TP_STMT_PKG

Source

1 PACKAGE AR_TP_STMT_PKG AUTHID CURRENT_USER AS
2 -- $Header: ARSTMTRPTPS.pls 120.0 2008/02/12 15:56:26 sgudupat noship $
3 /*===========================================================================+
4 --*************************************************************************
5 -- Copyright (c)  2000    Oracle                 Product Development
6 -- All rights reserved
7 --*************************************************************************
8 --
9 -- HEADER
10 --  Source control header
11 --
12 -- PROGRAM NAME
13 --   ARSTMTRPTPS.pls
14 --
15 -- DESCRIPTION
16 -- This script creates the package specification of AR_TP_STMT_PKG
17 -- This package is used for Supplier/Customer Statement Reports.
18 --
19 -- USAGE
20 --   To install        sqlplus <apps_user>/<apps_pwd> @ARSTMTRPTPS.pls
21 --   To execute        sqlplus <apps_user>/<apps_pwd> AR_TP_STMT_PKG.
22 --
23 -- PROGRAM LIST        DESCRIPTION
24 --
25 -- BEFOREREPORT        This function is used to dynamically get the
26 --                     WHERE clause in SELECT statement.
27 --
28 -- DEPENDENCIES
29 -- None
30 --
31 -- CALLED BY
32 --
33 --
34 -- LAST UPDATE DATE    03-Sep-2007
35 -- Date the program has been modified for the last time.
36 --
37 -- HISTORY
38 -- =======
39 --
40 -- VERSION DATE        AUTHOR(S)       DESCRIPTION
41 -- ------- ----------- --------------- --------------------------------------
42 -- Draft1A 03-Sep-2007 Sandeep Kumar G Initial Creation
43 +===========================================================================*/
44 
45 /*=========================================
46 Variables to Hold the Parameter Values
47 =========================================*/
48 P_REPORTING_LEVEL       VARCHAR2(30);
49 P_REPORTING_ENTITY_ID   NUMBER;
50 P_REPORTING_ENTITY_NAME VARCHAR2(100);
51 P_FROM_DOC_DATE         VARCHAR2(30);
52 P_TO_DOC_DATE           VARCHAR2(30);
53 P_FROM_GL_DATE          VARCHAR2(30);
54 P_TO_GL_DATE            VARCHAR2(30);
55 P_FROM_CUST_NAME        VARCHAR2(100);
56 P_TO_CUST_NAME          VARCHAR2(100);
57 P_CURRENCY              VARCHAR2(100);
58 P_CUST_CATEGORY         VARCHAR2(100);
59 P_CUST_CLASS            VARCHAR2(100);
60 P_INCOMPLETE_TRX        VARCHAR2(100);
61 P_ACCOUNTED             VARCHAR2(100);
62 
63 /*========================================
64 Lexical Variables to obtain dynamic values
65 =========================================*/
66 gc_org_id         VARCHAR2(1000) := ' AND 1 = 1 ';
67 gc_rcpt_org_id    VARCHAR2(1000) := ' AND 1 = 1 ';
68 gc_cust_class     VARCHAR2(1000) := ' AND 1 = 1 ';
69 gc_cust_category  VARCHAR2(1000) := ' AND 1 = 1 ';
70 gc_currency       VARCHAR2(1000) := ' AND 1 = 1 ';
71 gc_rcpt_currency  VARCHAR2(1000) := ' AND 1 = 1 ';
72 gc_accounted      VARCHAR2(1000) := ' AND 1 = 1 ';
73 gc_rcpt_accounted VARCHAR2(1000) := ' AND 1 = 1 ';
74 gc_adj_accounted  VARCHAR2(1000) := ' AND 1 = 1 ';
75 gc_incomplete_trx VARCHAR2(1000) := ' AND 1 = 1 ';
76 gc_customer_name  VARCHAR2(1000) := ' AND 1 = 1 ';
77 gc_app_accounted  VARCHAR2(1000) := ' AND 1 = 1 ';
78 gc_reporting_entity VARCHAR2(1000) := ' AND 1 = 1 ';
79 /*=========================================
80 Public Functions
81 =========================================*/
82 
83 FUNCTION beforereport RETURN BOOLEAN;
84 FUNCTION balance_brought_forward (p_in_cust_account_id IN NUMBER
85                                  ,p_in_site_use_id     IN NUMBER
86                                  ,p_in_org_id          IN NUMBER)
87 RETURN NUMBER;
88 FUNCTION contact_details(p_owner_table_id IN NUMBER
89                         ,p_contact_type IN VARCHAR2)
90 RETURN VARCHAR2;
91 
92 END AR_TP_STMT_PKG;