[Home] [Help]
PACKAGE: APPS.AP_BAL_PKG
Source
1 PACKAGE AP_BAL_PKG
2 -- $Header: APPREBCPS.pls 120.4.12010000.2 2009/09/23 23:33:11 vinaik ship $
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 AUTHID CURRENT_USER 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);Bug 8923633 */
62 /*SUPPLIER_TO_PARAM VARCHAR2(30);Bug 8923633 */
63 SUPPLIER_FROM_PARAM AP_SUPPLIERS.VENDOR_NAME%TYPE;/*Bug 8923633 */
64 SUPPLIER_TO_PARAM AP_SUPPLIERS.VENDOR_NAME%TYPE;/*Bug 8923633 */
65 PAID_ONLY_PARAM VARCHAR2(30);
66 POSTED_ONLY_PARAM VARCHAR2(30);
67 DUMMY_PARAM NUMBER;
68
69 /*=========================================
70 Variables to obtain dynamic values
71 =========================================*/
72
73 gc_currency VARCHAR2(100);
74 gc_status VARCHAR2(1000);
75 gc_org_where VARCHAR2(100);
76 gc_ledger_name VARCHAR2(40);
77
78 --gc_select_clause VARCHAR2(5000);
79 gc_from_clause VARCHAR2(5000);
80 gc_where_clause VARCHAR2(5000);
81 gc_supplier VARCHAR2(1000);
82 gc_pre_amt_appl VARCHAR2(1000);
83 gc_additional_where VARCHAR2(1000);
84
85 gd_from_date DATE;
86 gd_to_date DATE;
87
88 /*=========================================
89 Public Functions
90 =========================================*/
91
92 FUNCTION beforereport RETURN BOOLEAN;
93 FUNCTION description(p_seg_value IN VARCHAR2,p_seg_type IN VARCHAR2) RETURN VARCHAR2;
94 FUNCTION get_no_of_holds(p_invoice_id IN NUMBER) RETURN NUMBER;
95 FUNCTION get_settlement_date(p_invoice_id IN NUMBER,p_line_number IN NUMBER) RETURN DATE;
96 FUNCTION prepay_amt_applied(p_invoice_id IN NUMBER,p_inv_date IN DATE) RETURN NUMBER;
97
98 END AP_BAL_PKG;