[Home] [Help]
PACKAGE: APPS.AR_TP_STMT_PKG
Source
1 PACKAGE AR_TP_STMT_PKG 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;