PACKAGE: APPS.AR_WL_REW_PKG

Source

1 PACKAGE AR_WL_REW_PKG AUTHID CURRENT_USER AS
2 -- $Header: ARWLREWS.pls 120.0.12010000.1 2008/08/29 20:44:37 tthangav 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 --   ARWLREWS.pls
14 --
15 -- DESCRIPTION
16 -- This script creates the package specification of AR_WL_REW_PKG
17 -- This package is used for Cash Application work load review report.
18 --
19 -- USAGE
20 --   To install        sqlplus <apps_user>/<apps_pwd> @ARWLREWS.pls
21 --   To execute        sqlplus <apps_user>/<apps_pwd> AR_WL_REW_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    25-Jul-2008
35 -- Date the program has been modified for the last time.
36 --
37 -- HISTORY
38 -- =======
39 --
40 -- VERSION DATE        AUTHOR(S)       DESCRIPTION
41 -- ------- ----------- --------------- --------------------------------------
42 --         25-Jul-2008 Thirumalaisamy   Initial Creation
43 +===========================================================================*/
44 
45 /*=========================================
46 Variables to Hold the Parameter Values
47 =========================================*/
48 p_org_id                 VARCHAR2(100);
49 p_cash_appln_owner_from  VARCHAR2(100);
50 p_cash_appln_owner_to    VARCHAR2(100);
51 p_recpt_date_from        DATE;
52 p_recpt_date_to          DATE;
53 p_cust_from              VARCHAR2(100);
54 p_cust_to                VARCHAR2(100);
55 p_work_item_status_from  VARCHAR2(30);
56 p_work_item_status_to    VARCHAR2(30);
57 p_assgn_date_from        DATE;
58 p_assgn_date_to          DATE;
59 p_detail                 VARCHAR2(30);
60 
61 /*========================================
62 Lexical Variables to obtain dynamic values
63 =========================================*/
64 gc_org_id             VARCHAR2(1000) := ' AND 1 = 1 ';
65 gc_cash_appln_owner   VARCHAR2(1000) := ' AND 1 = 1 ';
66 gc_recpt_date         VARCHAR2(1000) := ' AND 1 = 1 ';
67 gc_cust               VARCHAR2(1000) := ' AND 1 = 1 ';
68 gc_work_item_status   VARCHAR2(1000) := ' AND 1 = 1 ';
69 gc_assgn_date         VARCHAR2(1000) := ' AND 1 = 1 ';
70 gc_detail             VARCHAR2(1000) := ' AND 1 = 1 ';
71 /*=========================================
72 Public Functions
73 =========================================*/
74 
75 FUNCTION beforereport RETURN BOOLEAN;
76 
77 END AR_WL_REW_PKG;