1 package gl_info AUTHID CURRENT_USER as
2 /* $Header: gluplifs.pls 120.4 2005/05/05 01:42:03 kvora ship $ */
3 procedure gl_get_period_dates (tledger_id IN NUMBER,
4 tperiod_name IN VARCHAR2,
5 tstart_date OUT NOCOPY DATE,
6 tend_date OUT NOCOPY DATE,
7 errbuf OUT NOCOPY VARCHAR2);
8
9 -- NAME
10 -- gl_get_ledger_info
11 -- DESCRIPTION
12 -- Gets the chart of accounts id and the name of the
13 -- ledger provided.
14 -- PARAMETERS
15 -- ledid - holds the ledger id
16 -- coaid - holds the returned chart of accounts id
17 -- ledname - holds the returned ledger name
18 -- func_curr - holds the returned functional currency
19 -- errbuf - holds the returned error message, if there is one
20 procedure gl_get_ledger_info ( ledid IN NUMBER,
21 coaid OUT NOCOPY NUMBER,
22 ledname OUT NOCOPY VARCHAR2,
23 func_curr OUT NOCOPY VARCHAR2,
24 errbuf OUT NOCOPY VARCHAR2);
25
26 -- NAME
27 -- gl_get_bud_or_enc_name
28 -- DESCRIPTION
29 -- This routine takes the actual type (Actual, Budget,
30 -- or Encumbrance) and the budget version id or the
31 -- encumbrance type id. It returns null, for an
32 -- actual type of Actual, the name of the budget, for
33 -- Budget, or the encumbrance type, for Encumbrance.
34 -- PARAMETERS
35 -- actual_type - A (Actual), B (Budget), or
36 -- E (Encumbrance)
37 -- type_id - the budget version ID of the budget or
38 -- the encumbrance type ID for the
39 -- encumbrance
40 -- name - holds the returned value: null, for actuals; the budget
41 -- name, for budgets; and the
42 -- encumbrance type, for
43 -- encumbrances.
44 -- errbuf - holds the returned error message, if there is one
45 procedure gl_get_bud_or_enc_name ( actual_type IN VARCHAR2,
46 type_id IN NUMBER,
47 name OUT NOCOPY VARCHAR2,
48 errbuf OUT NOCOPY VARCHAR2);
49
50 -- NAME
51 -- gl_get_lookup_value
52 -- DESCRIPTION
53 -- This function gets the meaning or description of a
54 -- lookup code for a particular lookup type
55 -- PARAMETERS
56 -- lmode - M (Meaning) or D (Description)
57 -- code - the lookup code
58 -- type - the lookup type
59 -- errbuf - holds the returned error message, if there is one
60 procedure gl_get_lookup_value ( lmode VARCHAR2,
61 code VARCHAR2,
62 type VARCHAR2,
63 value OUT NOCOPY VARCHAR2,
64 errbuf OUT NOCOPY VARCHAR2);
65
66 -- NAME
67 -- gl_get_first_period
68 -- DESCRIPTION
69 -- This function gets the first period of the year
70 -- for a particular period_name
71 -- PARAMETERS
72 -- tledger_id - valid ledger_id (IN)
73 -- tperiod_name - valid period_name (IN)
74 -- tfirst_period - first period of the year
75 -- errbuf - holds the returned error message, if there is one
76 procedure gl_get_first_period(tledger_id IN NUMBER,
77 tperiod_name IN VARCHAR2,
78 tfirst_period OUT NOCOPY VARCHAR2,
79 errbuf OUT NOCOPY VARCHAR2);
80
81 -- Kai Pigg 7/6/1993. New procedure
82 -- NAME
83 -- gl_get_first_period_of_quarter
84 -- DESCRIPTION
85 -- This function gets the first period of the quarter
86 -- for a particular period_name
87 -- PARAMETERS
88 -- tledger_id - valid ledger_id (IN)
89 -- tperiod_name - valid period_name (IN)
90 -- tfirst_period - first period of the quarter
91 -- errbuf - holds the returned error message, if there is one
92 procedure gl_get_first_period_of_quarter(tledger_id IN NUMBER,
93 tperiod_name IN VARCHAR2,
94 tfirst_period OUT NOCOPY VARCHAR2,
95 errbuf OUT NOCOPY VARCHAR2);
96
97 -- NAME
98 -- gl_get_consolidation_info
99 -- PURPOSE
100 -- Gets various information about a consolidation
101 -- PARAMETERS
102 -- cons_id - the id of the consolidation
103 -- cons_name - the name of the consolidation
104 -- method - the method of consolidation (this is a code use
105 -- gl_lookups to get the method name)
106 -- curr_code - the consolidation currency code
107 -- from_ledid - the id of the child ledger.
108 -- to_ledid - the id of the parentledgers.
109 -- description - the description of the consolidation
110 -- start_date - the start date for the consolidation
111 -- end_date - the end date for the consolidation
112 -- errbuf - holds any returned error messages
113 procedure gl_get_consolidation_info(
114 cons_id NUMBER, cons_name OUT NOCOPY VARCHAR2,
115 method OUT NOCOPY VARCHAR2, curr_code OUT NOCOPY VARCHAR2,
116 from_ledid OUT NOCOPY NUMBER, to_ledid OUT NOCOPY NUMBER,
117 description OUT NOCOPY VARCHAR2,
118 errbuf OUT NOCOPY VARCHAR2);
119 end gl_info;
120