1 package jg_info AUTHID CURRENT_USER as
2 /* $Header: jgzzinfs.pls 115.1 2002/11/15 17:07:28 arimai ship $ */
3
4 -- NAME
5 -- jg_get_set_of_books_info
6 -- DESCRIPTION
7 -- Gets the chart of accounts id and the name of the
8 -- set of books provided.
9 -- PARAMETERS
10 -- sobid - holds the set of books id
11 -- coaid - holds the returned chart of accounts id
12 -- sobname - holds the returned set of books name
13 -- func_curr - holds the returned functional currency
14 -- errbuf - holds the returned error message, if there is one
15 procedure jg_get_set_of_books_info ( sobid IN NUMBER,
16 coaid OUT NOCOPY NUMBER,
17 sobname OUT NOCOPY VARCHAR2,
18 func_curr OUT NOCOPY VARCHAR2,
19 errbuf OUT NOCOPY VARCHAR2);
20 -- NAME
21 -- jg_get_bud_or_enc_name
22 -- DESCRIPTION
23 -- This routine takes the actual type (Actual, Budget,
24 -- or Encumbrance) and the budget version id or the
25 -- encumbrance type id. It returns null, for an
26 -- actual type of Actual, the name of the budget, for
27 -- Budget, or the encumbrance type, for Encumbrance.
28 -- PARAMETERS
29 -- actual_type - A (Actual), B (Budget), or
30 -- E (Encumbrance)
31 -- type_id - the budget version ID of the budget or
32 -- the encumbrance type ID for the
33 -- encumbrance
34 -- name - holds the returned value: null, for actuals; the budget
35 -- name, for budgets; and the
36 -- encumbrance type, for
37 -- encumbrances.
38 -- errbuf - holds the returned error message, if there is one
39 procedure jg_get_bud_or_enc_name ( actual_type IN VARCHAR2,
40 type_id IN NUMBER,
41 name OUT NOCOPY VARCHAR2,
42 errbuf OUT NOCOPY VARCHAR2);
43 -- NAME
44 -- jg_get_lookup_value
45 -- DESCRIPTION
46 -- This function gets the meaning or description of a
47 -- lookup code for a particular lookup type
48 -- PARAMETERS
49 -- lmode - M (Meaning) or D (Description)
50 -- code - the lookup code
51 -- type - the lookup type
52 -- errbuf - holds the returned error message, if there is one
53 procedure jg_get_lookup_value ( lmode VARCHAR2,
54 code VARCHAR2,
55 type VARCHAR2,
56 value OUT NOCOPY VARCHAR2,
57 errbuf OUT NOCOPY VARCHAR2);
58 -- NAME
59 -- jg_get_first_period
60 -- DESCRIPTION
61 -- This function gets the first period of the year
62 -- for a particular period_name
63 -- PARAMETERS
64 -- tset_of_books_id - valid set_of_books_id (IN)
65 -- tperiod_name - valid period_name (IN)
66 -- tfirst_period - first period of the year
67 -- errbuf - holds the returned error message, if there is one
68 procedure jg_get_first_period(app_id IN NUMBER,
69 tset_of_books_id IN NUMBER,
70 tperiod_name IN VARCHAR2,
71 tfirst_period OUT NOCOPY VARCHAR2,
72 errbuf OUT NOCOPY VARCHAR2);
73 -- Kai Pigg 7/6/1993. New procedure
74 -- NAME
75 -- jg_get_first_period_of_quarter
76 -- DESCRIPTION
77 -- This function gets the first period of the quarter
78 -- for a particular period_name
79 -- PARAMETERS
80 -- tset_of_books_id - valid set_of_books_id (IN)
81 -- tperiod_name - valid period_name (IN)
82 -- tfirst_period - first period of the quarter
83 -- errbuf - holds the returned error message, if there is one
84 procedure jg_get_first_period_of_quarter(app_id IN NUMBER,
85 tset_of_books_id IN NUMBER,
86 tperiod_name IN VARCHAR2,
87 tfirst_period OUT NOCOPY VARCHAR2,
88 errbuf OUT NOCOPY VARCHAR2);
89 function jg_format_curr_amt(in_precision NUMBER,
90 in_amount_disp VARCHAR2) return VARCHAR2;
91 end jg_info;