1 PACKAGE AP_CHECK_PAYMT_SUPP_RPT_PKG
2 -- $Header: AP_CHECKPAYMTSUPPS.pls 120.1.12000000.1 2007/10/24 18:03:57 sgudupat noship $
3 --*************************************************************************
4 -- Copyright (c) 2000 Oracle Product Development
5 -- All rights reserved
6 --*************************************************************************
7 --
8 -- HEADER
9 -- Source control header
10 --
11 -- PROGRAM NAME
12 -- AP_CHECK_PAYMT_SUPP_RPT_PKG
13 --
14 -- DESCRIPTION
15 -- This script creates the package specification of AP_CHECK_PAYMT_SUPP_RPT_PKG
16 -- This package is used to report on AP Check payments to Suppliers.
17 --
18 -- USAGE
19 -- To install sqlplus <apps_user>/<apps_pwd> @AP_CHECKPAYMTSUPPS.pls
20 -- To execute sqlplus <apps_user>/<apps_pwd> AP_CHECK_PAYMT_SUPP_RPT_PKG.
21 --
22 -- PROGRAM LIST DESCRIPTION
23 -- beforereport This function is used to dynamically get the
24 -- WHERE clause in SELECT statement.
25 -- DEPENDENCIES
26 -- None
27 --
28 -- CALLED BY
29 -- AP Check Payments to Suppliers Report.
30 --
31 -- LAST UPDATE DATE 08-Feb-2007
32 -- Date the program has been modified for the last time.
33 --
34 -- HISTORY
35 -- =======
36 --
37 -- VERSION DATE AUTHOR(S) DESCRIPTION
38 -- ------- ----------- --------------- --------------------------------------
39 -- Draft1A 08-Feb-2007 Rakesh Pulla Initial Creation
40 -- Draft1B 16-Feb-2007 Rakesh Pulla Updated as per the Ref # 23464
41 -- Draft1C 12-Jul-2007 Rakesh Pulla Incorporated the product team review comments.
42 -- Draft1D 12-Jul-2007 Rakesh Pulla Replaced CHCK with CHECK as suggested by the product team.
43 --************************************************************************
44 AS
45
46 P_VNDR_NUMBER_FROM NUMBER(15);
47 P_VNDR_NUMBER_TO NUMBER(15);
48 P_CHECK_DATE_FROM DATE;
49 P_CHECK_DATE_TO DATE;
50 P_CHECK_DUE_DATE_FROM DATE;
51 P_CHECK_DUE_DATE_TO DATE;
52 P_CURRENCY VARCHAR2(15);
53 P_CHECK_STAT VARCHAR2(80);
54 GC_WHERE VARCHAR2(1000):='1=1';
55 GC_ATTRIBUTE_COL VARCHAR2(80);
56 GC_ATTRIBUTE VARCHAR2(50);
57
58 FUNCTION beforereport RETURN BOOLEAN;
59
60 END AP_CHECK_PAYMT_SUPP_RPT_PKG;