PACKAGE: APPS.AP_TURNOVER_RPT_PKG

Source

1 PACKAGE AP_TURNOVER_RPT_PKG AS
2 -- $Header: APTURNOVERRPTPS.pls 120.1 2008/05/27 14:43:52 rapulla noship $
3 -- ****************************************************************************************
4 -- Copyright (c)  2000  Oracle Corporation    Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- APTURNOVERRPTPS.pls
10 --
11 -- DESCRIPTION
12 --  This script creates the package specification of AP_TURNOVER_RPT_PKG.
13 --  This package is used to generate AP Turnover Report.
14 --
15 -- USAGE
16 --   To install        How to Install
17 --   To execute        How to Execute
18 --
19 -- DEPENDENCIES
20 --   None.
21 --
22 --  beforereport        It is a public function used to intialize global variables
23 --                                which will be used to build the quries in the Data Template Dynamically
24 --
25 -- LAST UPDATE DATE   21-FEB-2007
26 --   Date the program has been modified for the last time
27 --
28 -- HISTORY
29 -- =======
30 --
31 -- VERSION DATE        AUTHOR(S)         DESCRIPTION
32 -- ------- ----------- ---------------   ------------------------------------
33 -- 1.0    21-FEB-2007 Praveen Gollu Creation
34 --
35 --****************************************************************************************
36 
37 /*=========================================
38 Variables to Hold the Parameter Values
39 =========================================*/
40 LEDGER_ID_PARAM          NUMBER;
41 LEDGER_NAME_PARAM        VARCHAR2(30);
42 COA_ID_PARAM             NUMBER;
43 COA_ID_SUMRY_MASK_PARAM  NUMBER;
44 REPORT_TYPE_PARAM        NUMBER;
45 DUMMY_REPORT_TYPE_PARAM  VARCHAR2(240);
46 OU_FROM_PARAM            VARCHAR2(240);
47 OU_TO_PARAM              VARCHAR2(240);
48 PERIOD_START_DATE_PARAM  DATE;
49 PERIOD_END_DATE_PARAM    DATE;
50 SUPPLIER_FROM_PARAM      VARCHAR2(240);
51 SUPPLIER_TO_PARAM        VARCHAR2(240);
52 ACCT_FROM_PARAM          VARCHAR2(200);
53 ACCT_TO_PARAM            VARCHAR2(200);
54 CURRENCY_PARAM           VARCHAR2(15);
55 SHOW_OP_CURRENCY_PARAM   VARCHAR2(5);
56 REPORT_LEVEL_PARAM       NUMBER;
57 DUMMY_REPORT_LEVEL_PARAM VARCHAR2(240);
58 PRPMT_PROCESSING_PARAM   VARCHAR2(50);
59 SUMMARY_MASK_PARAM       VARCHAR2(50);
60 
61 /*=========================================
62 Global Variables
63 =========================================*/
64 gc_supplier_where        VARCHAR2(500) := ' AND 1 = 1 ';
65 gc_currency_where        VARCHAR2(500) := ' AND 1 = 1 ';
66 gc_operunit_where        VARCHAR2(800) := ' AND 1 = 1 ';
67 gc_ledger_name           VARCHAR2(50);
68 
69 gc_prepay_invoice_from   VARCHAR2(1000);
70 gc_prepay_invoice_select VARCHAR2(1000);
71 gc_prepay_invoice_where  VARCHAR2(1000);
72 gc_prepay_where          VARCHAR2(1000);
73 gn_open_payment_balance  NUMBER(20) := 0;
74 gn_open_invoice_balance  NUMBER(20) := 0;
75 g_open_balance           NUMBER(20) := 0;
76 gc_orderby               VARCHAR2(30);
77 
78 /*=========================================
79 Public Functions
80 =========================================*/
81 
82 FUNCTION beforeReport  RETURN BOOLEAN;
83 FUNCTION get_summary_mask_account(Acct_num IN VARCHAR2) RETURN VARCHAR2;
84 FUNCTION opening_balance(p_in_sup_id       IN NUMBER
85                         ,p_in_sup_site_id  IN NUMBER
86                         ,p_in_curr         IN VARCHAR2
87                         ,p_in_code_comb_id IN NUMBER
88                         ,p_in_orgs_id      IN NUMBER) RETURN NUMBER;
89 END AP_TURNOVER_RPT_PKG;