1 PACKAGE FV_UTILITY AUTHID CURRENT_USER AS
2 --$Header: FVXUTL1S.pls 120.10.12000000.2 2007/05/15 17:25:41 sasukuma ship $
3
4 PROCEDURE log_mesg(p_level IN NUMBER,
5 p_module IN VARCHAR2,
6 p_message IN VARCHAR2);
7
8 PROCEDURE log_mesg(p_message IN VARCHAR2,
9 p_module IN VARCHAR2 DEFAULT NULL,
10 p_level IN NUMBER DEFAULT NULL);
11
12 PROCEDURE debug_mesg(p_message IN VARCHAR2,
13 p_module IN VARCHAR2 DEFAULT NULL,
14 p_level IN NUMBER DEFAULT NULL);
15
16 PROCEDURE message(p_level IN NUMBER DEFAULT NULL,
17 p_module IN VARCHAR2 DEFAULT NULL,
18 p_pop IN BOOLEAN DEFAULT FALSE);
19 PROCEDURE message(p_module IN VARCHAR2 DEFAULT NULL,
20 p_level IN NUMBER DEFAULT NULL,
21 p_pop IN BOOLEAN DEFAULT FALSE);
22 PROCEDURE debug_mesg(p_level IN NUMBER,
23 p_module IN VARCHAR2,
24 p_message IN VARCHAR2);
25
26 PROCEDURE GET_LEDGER_INFO (p_org_id in number ,
27 p_ledger_id out nocopy varchar2,
28 p_coa_id out nocopy varchar2,
29 p_currency out nocopy varchar2,
30 p_status out nocopy varchar2);
31
32 -- Time stamp function
33 function TIME_STAMP return varchar2;
34
35 -- Procedure used to retrieve FV context variable values.
36 -- User_id is current fnd_global.userid
37 -- resp_id is the current fnd_global.resp_id (responsibility_id)
38 -- Variable value should be
39 -- CHART_OF_ACCOUNTS_ID to obtain chart_of_accounts_id context variable,
40 -- ACCT_SEGMENT to obtain acct_segment name context variable,
41 -- BALANCE_SEGMENT to obtain balance_segment name context variable
42 -- Returned is the value for the context variable specified above.
43 -- Returned variable values are all varchar2.
44 -- Error_code is a boolean which will be FALSE if NO errors are found and
45 -- TRUE if errors are raised during processing. Error_message will only
46 -- contain an error message if error_code is TRUE.
47 --
48 PROCEDURE get_context(user_id IN number,
49 resp_id IN number,
50 variable_type IN varchar2,
51 variable_value OUT NOCOPY varchar2,
52 error_code OUT NOCOPY boolean,
53 error_message OUT NOCOPY varchar2);
54 -- package specs
55
56 --Procedure for getting report information when running report in application
57 PROCEDURE GET_REPORT_INFO(p_request_id IN NUMBER,
58 p_report_id OUT NOCOPY NUMBER,
59 p_report_set OUT NOCOPY VARCHAR2,
60 p_responsibility OUT NOCOPY VARCHAR2,
61 p_application OUT NOCOPY VARCHAR2,
62 p_request_time OUT NOCOPY DATE,
63 p_resub_interval OUT NOCOPY VARCHAR2,
64 p_run_time OUT NOCOPY DATE,
65 p_printer OUT NOCOPY VARCHAR2,
66 p_copies OUT NOCOPY NUMBER,
67 p_save_output OUT NOCOPY VARCHAR2);
68
69 --
70 -- This procedure should be called to determine the Organization Name for a
71 -- NON-Multiorg Database only. If an error occurs error_code will be TRUE
72 -- and error_message will contain the error message. Please check in
73 -- the calling process.
74 --
75 PROCEDURE GET_ORG_INFO(v_set_of_books_id IN NUMBER,
76 v_organization_name OUT NOCOPY VARCHAR2,
77 error_code OUT NOCOPY BOOLEAN,
78 error_message OUT NOCOPY VARCHAR2);
79 -- NAME
80 -- gl_get_first_period
81 -- DESCRIPTION
82 -- This function gets the first period of the year
83 -- for a particular period_name
84 -- PARAMETERS
85 -- tset_of_books_id - valid set_of_books_id (IN)
86 -- tperiod_name - valid period_name (IN)
87 -- tfirst_period - first period of the year
88 -- errbuf - holds the returned error message, if there is one
89 procedure gl_get_first_period(tset_of_books_id IN NUMBER,
90 tperiod_name IN VARCHAR2,
91 tfirst_period OUT NOCOPY VARCHAR2,
92 errbuf OUT NOCOPY VARCHAR2);
93
94 -----------------------------------------------------------------------------
95 -- NAME
96 -- get_segment_col_names
97 -- DESCRIPTION
98 -- This procedure gets the ACCOUNTING_SEGMENT and BALANCING_SEGMENT,
99 -- for the user's sets of books
100 -- PARAMETERS
101 -- ledger_id - valid ledger_id (IN)
102 -- chart_of_accounts_id - valid chart_of_accounts_id (IN)
103 -- acct_seg_name - accounting segment
104 -- balance_seg_name - balancing segment
105 -- error_code - TRUE if errors are raised during processing.
106 -- error_message - holds the returned error message, if there is one
107 -- error_message will only contain an error message if error_code is TRUE.
108 PROCEDURE get_segment_col_names(chart_of_accounts_id IN NUMBER,
109 acct_seg_name OUT NOCOPY VARCHAR2,
110 balance_seg_name OUT NOCOPY VARCHAR2,
111 error_code OUT NOCOPY BOOLEAN,
112 error_message OUT NOCOPY VARCHAR2);
113 -----------------------------------------------------------------------------
114 -- NAME
115 -- calc_child_flex_value
116 -- DESCRIPTION
117 -- This procedure gets the gets the chile flex value for a parent account
118 -- PARAMETERS
119 -- p_flex_value_set_id - valid flex valueset id (IN)
120 -- p_parent_flex_value - valid parent flex value (IN)
121
122 PROCEDURE calc_child_flex_value(p_flex_value_set_id IN NUMBER,
123 p_parent_flex_value IN VARCHAR2);
124
125 -----------------------------------------------------------------------------
126 -- NAME
127 -- calc_concat_accts
128 -- This function returns the concatenated child accounts for a parent account
129 -- PARAMETERS
130 -- p_flex_value_set_id - valid flex valueset id (IN)
131 -- p_parent_flex_value - valid parent flex value (IN)
132
133
134 FUNCTION calc_concat_accts(p_flex_value IN VARCHAR2,
135 p_coa_id IN NUMBER)
136 RETURN VARCHAR2;
137
138 ---------------------------------------------
139
140
141 PROCEDURE Get_Period_Year(period_from VARCHAR2,
142 period_to VARCHAR2,
143 sob_id NUMBER,
144 period_start_date OUT NOCOPY DATE,
145 period_end_date OUT NOCOPY DATE,
146 period_year OUT NOCOPY NUMBER,
147 errbuf OUT NOCOPY VARCHAR2,
148 retcode OUT NOCOPY NUMBER);
149
150 ---------------------------------------------------
151 FUNCTION tin
152 (
153 p_vendor_type_lookup_code IN VARCHAR2,
154 p_org_type_lookup_code IN VARCHAR2,
155 p_num_1099 IN VARCHAR2,
156 p_individual_1099 IN VARCHAR2,
157 p_employee_id IN NUMBER
158 )
159 RETURN VARCHAR2;
160 ---------------------------------------------------
161 END; --package specs