1 PACKAGE AP_BAL_PKG
2 -- $Header: APPREBCPS.pls 120.4.12000000.1 2007/10/25 14:11:21 sgudupat noship $
3 -- ****************************************************************************************
4 -- Copyright (c) 2000 Oracle Solution Services (India) Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- APPREBCPS.pls
10 --
11 -- DESCRIPTION
12 -- This script creates the package specification of AP_PREPAY_BAL_PKG.
13 -- This package is used to generate Prepayment Balance Report.
14 --
15 -- USAGE
16 -- To install How to Install
17 -- To execute How to Execute
18
19 -- DEPENDENCIES
20 -- None.
21 --
22 --PROGRAM LIST
23 --NAME USAGE
24 --
25 -- get_ledger_name Used to obtain the Ledger Name for which the report is running
26 --
27 -- get_no_of_holds Used to obtain the number of holds for a particular Prepayment
28 --
29 -- beforereport Used to initialize the dynamic variable based on the input
30 -- obtained from parameters.
31 --
32 -- CALLED BY
33 -- DataTemplate Extract in Prepayment Balance Report (CZech).
34 --
35 --
36 -- LAST UPDATE DATE 27-Mar-2007
37 -- Date the program has been modified for the last time
38 --
39 -- HISTORY
40 -- =======
41 --
42 -- VERSION DATE AUTHOR(S) DESCRIPTION
43 -- ------- ----------- --------------- ------------------------------------
44 -- 1.00 27-Mar-2007 Sandeep Kumar G. Creation
45 --
46 -- ****************************************************************************************
47 AS
48
49 /*=========================================
50 Variables to Hold the Parameter Values
51 =========================================*/
52 ORG_ID_PARAM NUMBER;
53 COA_ID_PARAM NUMBER;
54 FROM_DATE_PARAM VARCHAR2(30);
55 TO_DATE_PARAM VARCHAR2(30);
56 PERIOD_FROM_PARAM VARCHAR2(30);
57 PERIOD_TO_PARAM VARCHAR2(30);
58 CURR_CODE_PARAM VARCHAR2(30);
59 ACCOUNT_FROM_PARAM NUMBER;
60 ACCOUNT_TO_PARAM NUMBER;
61 SUPPLIER_FROM_PARAM VARCHAR2(30);
62 SUPPLIER_TO_PARAM VARCHAR2(30);
63 PAID_ONLY_PARAM VARCHAR2(30);
64 POSTED_ONLY_PARAM VARCHAR2(30);
65 DUMMY_PARAM NUMBER;
66
67 /*=========================================
68 Variables to obtain dynamic values
69 =========================================*/
70
71 gc_currency VARCHAR2(100);
72 gc_status VARCHAR2(1000);
73 gc_org_where VARCHAR2(100);
74 gc_ledger_name VARCHAR2(40);
75
76 --gc_select_clause VARCHAR2(5000);
77 gc_from_clause VARCHAR2(5000);
78 gc_where_clause VARCHAR2(5000);
79 gc_supplier VARCHAR2(1000);
80 gc_pre_amt_appl VARCHAR2(1000);
81 gc_additional_where VARCHAR2(1000);
82
83 gd_from_date DATE;
84 gd_to_date DATE;
85
86 /*=========================================
87 Public Functions
88 =========================================*/
89
90 FUNCTION beforereport RETURN BOOLEAN;
91 FUNCTION description(p_seg_value IN VARCHAR2,p_seg_type IN VARCHAR2) RETURN VARCHAR2;
92 FUNCTION get_no_of_holds(p_invoice_id IN NUMBER) RETURN NUMBER;
93 FUNCTION get_settlement_date(p_invoice_id IN NUMBER,p_line_number IN NUMBER) RETURN DATE;
94 FUNCTION prepay_amt_applied(p_invoice_id IN NUMBER,p_inv_date IN DATE) RETURN NUMBER;
95
96 END AP_BAL_PKG;