PACKAGE: APPS.AP_TP_STMT_PKG

Source

1 PACKAGE AP_TP_STMT_PKG AUTHID CURRENT_USER AS
2 -- $Header: APTPSTMTPS.pls 120.0 2008/03/06 11:41:25 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 --   ARTPSTMTPS.pls
14 --
15 -- DESCRIPTION
16 -- This script creates the package specification of AP_TP_STMT_PKG
17 -- This package is used for Supplier/Customer Statement Reports.
18 --
19 -- USAGE
20 --   To install        sqlplus <apps_user>/<apps_pwd> @APTPSTMTPS.pls
21 --   To execute        sqlplus <apps_user>/<apps_pwd> AP_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_SUPP_NAME        VARCHAR2(100);
56 P_TO_SUPP_NAME          VARCHAR2(100);
57 P_CURRENCY              VARCHAR2(100);
58 P_PAY_GROUP             VARCHAR2(100);
59 P_VEND_TYPE             VARCHAR2(100);
60 P_UNVALIDATED_TRX       VARCHAR2(100);
61 P_UNAPPROVED_TRX        VARCHAR2(100);
62 P_ACCOUNTED             VARCHAR2(100);
63 
64 /*========================================
65 Lexical Variables to obtain dynamic values
66 =========================================*/
67 gc_org_id           VARCHAR2(1000) := ' AND 1 = 1 ';
68 gc_reporting_entity VARCHAR2(1000) := ' AND 1 = 1 ';
69 gc_pmt_org_id       VARCHAR2(1000) := ' AND 1 = 1 ';
70 gc_currency         VARCHAR2(1000) := ' AND 1 = 1 ';
71 gc_pmt_currency     VARCHAR2(1000) := ' AND 1 = 1 ';
72 gc_supplier_name    VARCHAR2(1000) := ' AND 1 = 1 ';
73 gc_pay_group        VARCHAR2(1000) := ' AND 1 = 1 ';
74 gc_vend_type        VARCHAR2(1000) := ' AND 1 = 1 ';
75 gc_pmt_accounted    VARCHAR2(1000) := ' AND 1 = 1 ';
76 gc_unapproved_trx   VARCHAR2(1000) := ' AND 1 = 1 ';
77 gc_validate_inv     VARCHAR2(3000) := ' AND 1 = 1 ';
78 /*=========================================
79 Public Functions
80 =========================================*/
81 
82 FUNCTION beforereport RETURN BOOLEAN;
83 FUNCTION invoice_validate_status (p_in_inv_id IN NUMBER) RETURN VARCHAR2;
84 FUNCTION balance_brought_forward (p_in_vendor_id      IN NUMBER
85                                  ,p_in_vendor_site_id IN NUMBER
86                                  ,p_in_org_id         IN NUMBER)
87 RETURN NUMBER;
88 END AP_TP_STMT_PKG;