[Home] [Help]
PACKAGE: APPS.PSA_MFAR_UTILS
Source
1 PACKAGE PSA_MFAR_UTILS AS
2 /* $Header: PSAMFUTS.pls 120.9 2006/09/15 11:47:40 agovil ship $ */
3
4 TYPE trx_rec IS RECORD (
5 customer_trx_id number,
6 user_id number,
7 status varchar2(240),
8 actual_flag varchar2(240),
9 pst_ctrl_id number,
10 sob_id number,
11 source varchar2(240),
12 cm_cat_name varchar2(240),
13 dm_cat_name varchar2(240),
14 cb_cat_name varchar2(240),
15 inv_cat_name varchar2(240),
16 batch_prefix varchar2(240),
17 summary_flag varchar2(240),
18 pre_ct_line varchar2(240),
19 post_ct_line varchar2(240),
20 class_cb varchar2(240),
21 class_cm varchar2(240),
22 class_dm varchar2(240),
23 class_dep varchar2(240),
24 class_guar varchar2(240),
25 class_inv varchar2(240),
26 nxtval_id number,
27 start_date date,
28 post_thru_date date,
29 last_update_date date
30 );
31
32
33 TYPE adj_rec IS RECORD (
34 adjustment_id number
35 ,user_id number
36 ,status varchar2(240)
37 ,actual_flag varchar2(240)
38 ,pst_ctrl_id number
39 ,sob_id number
40 ,source varchar2(240)
41 ,adj_cat_name varchar2(240)
42 ,batch_prefix varchar2(240)
43 ,summary_flag varchar2(240)
44 ,pre_adjcr_ar varchar2(240)
45 ,pre_adjdr_ar varchar2(240)
46 ,pre_adjdr_adj varchar2(240)
47 ,pre_adjcr_adj varchar2(240)
48 ,pre_adjdr varchar2(240)
49 ,pre_adjcr varchar2(240)
50 ,pre_adj_nrtax varchar2(240)
51 ,pre_adj_finchrg varchar2(240)
52 ,pre_adj_finchrg_nrtax varchar2(240)
53 ,pre_adj_tax varchar2(240)
54 ,pre_adj_deftax varchar2(240)
55 ,class_cb varchar2(240)
56 ,class_cm varchar2(240)
57 ,class_dep varchar2(240)
58 ,class_dm varchar2(240)
59 ,class_guar varchar2(240)
60 ,class_inv varchar2(240)
61 ,post_general varchar2(240)
62 ,nxtval_id number
63 ,start_date date
64 ,post_thru_date date ,
65 last_update_date date
66 );
67
68
69 TYPE rct_rec IS RECORD (
70 ra_receivable_application_id number
71 ,user_id number
72 ,status varchar2(240)
73 ,actual_flag varchar2(240)
74 ,pst_ctrl_id number
75 ,sob_id number
76 ,source varchar2(240)
77 ,trade_cat_name varchar2(240)
78 ,ccurr_cat_name varchar2(240)
79 ,cmapp_cat_name varchar2(240)
80 ,func_curr varchar2(240)
81 ,pre_tradeapp varchar2(240)
82 ,app_onacc varchar2(240)
83 ,app_unapp varchar2(240)
84 ,app_unid varchar2(240)
85 ,app_applied varchar2(240)
86 ,pre_erdisc varchar2(240)
87 ,pre_rec_erdisc_nrtax varchar2(240)
88 ,pre_undisc varchar2(240)
89 ,pre_rec_undisc_nrtax varchar2(240)
90 ,pre_rec_gain varchar2(240)
91 ,pre_rec_loss varchar2(240)
92 ,pre_rec_curr_round varchar2(240)
93 ,pre_rec_tax varchar2(240)
94 ,pre_rec_deftax varchar2(240)
95 ,class_cb varchar2(240)
96 ,class_cm varchar2(240)
97 ,class_dep varchar2(240)
98 ,class_dm varchar2(240)
99 ,class_guar varchar2(240)
100 ,class_inv varchar2(240)
101 ,post_general varchar2(240)
102 ,pre_cmapp varchar2(240)
103 ,pre_cmgain varchar2(240)
104 ,pre_cmloss varchar2(240)
105 ,batch_prefix varchar2(240)
106 ,summary_flag varchar2(240)
107 ,pre_receipt varchar2(240)
108 ,post_receipt varchar2(240)
109 ,nxtval_id number
110 ,start_date date
111 ,post_thru_date date,
112 last_update_date date
113 );
114
115 function get_user_category_name (cat_name in varchar2)
116 return varchar2 ;
117
118
119
120 FUNCTION override_segments
121 (p_primary_ccid IN NUMBER,
122 p_override_ccid IN NUMBER,
123 p_set_of_books_id IN NUMBER,
124 p_trx_type IN VARCHAR2,
125 P_ccid OUT NOCOPY NUMBER)
126 RETURN BOOLEAN;
127
128 PROCEDURE INSERT_DISTRIBUTIONS_LOG (p_error_id IN NUMBER,
129 p_activity IN VARCHAR2,
130 p_customer_trx_id IN NUMBER,
131 p_activity_id IN NUMBER,
132 p_error_message IN VARCHAR2);
133
134 PROCEDURE PSA_MF_ORG_DETAILS (l_org_details OUT NOCOPY psa_implementation_all%rowtype);
135
136 FUNCTION get_ar_sob_id return number;
137
138 FUNCTION get_rec_ccid (p_applied_trx_id in NUMBER, p_trx_id IN NUMBER) return number;
139
140 FUNCTION get_coa (sob_id in number) return number;
141
142 FUNCTION accounting_method RETURN VARCHAR2;
143
144 PROCEDURE insert_ccid (p_ccid IN NUMBER,
145 p_segment_info IN FND_FLEX_EXT.SEGMENTARRAY,
146 p_num_segments IN NUMBER);
147
148 FUNCTION is_ccid_exists(x_ccid IN OUT NOCOPY NUMBER,
149 x_segment_info IN OUT NOCOPY FND_FLEX_EXT.SEGMENTARRAY,
150 x_number_of_segments OUT NOCOPY NUMBER)
151 RETURN BOOLEAN;
152
153 /* Modified this structure for bug 4496742
154 TYPE hold_ccid_info_rec_type IS RECORD
155 (ccid NUMBER(15),
156 SEGMENTS FND_FLEX_EXT.SEGMENTARRAY,
157 NUMBER_OF_SEGMENTS NUMBER);
158 */
159
160 TYPE hold_ccid_info_rec_type IS RECORD
161 (ccid NUMBER(15),
162 segment1 VARCHAR2(200),
163 segment2 VARCHAR2(200),
164 segment3 VARCHAR2(200),
165 segment4 VARCHAR2(200),
166 segment5 VARCHAR2(200),
167 segment6 VARCHAR2(200),
168 segment7 VARCHAR2(200),
169 segment8 VARCHAR2(200),
170 segment9 VARCHAR2(200),
171 segment10 VARCHAR2(200),
172 segment11 VARCHAR2(200),
173 segment12 VARCHAR2(200),
174 segment13 VARCHAR2(200),
175 segment14 VARCHAR2(200),
176 segment15 VARCHAR2(200),
177 segment16 VARCHAR2(200),
178 segment17 VARCHAR2(200),
179 segment18 VARCHAR2(200),
180 segment19 VARCHAR2(200),
181 segment20 VARCHAR2(200),
182 segment21 VARCHAR2(200),
183 segment22 VARCHAR2(200),
184 segment23 VARCHAR2(200),
185 segment24 VARCHAR2(200),
186 segment25 VARCHAR2(200),
187 segment26 VARCHAR2(200),
188 segment27 VARCHAR2(200),
189 segment28 VARCHAR2(200),
190 segment29 VARCHAR2(200),
191 segment30 VARCHAR2(200),
192 NUMBER_OF_SEGMENTS NUMBER);
193
194
195 TYPE hold_ccid_info_tab_type IS TABLE OF hold_ccid_info_rec_type
196 INDEX BY BINARY_INTEGER;
197
198 TYPE combinations_rec IS RECORD
199 (combination VARCHAR2(800),
200 error_message VARCHAR2(2000));
201
202 TYPE combinations_table IS TABLE OF combinations_rec INDEX BY BINARY_INTEGER;
203
204 g_invalid_combinations combinations_table;
205 g_invalid_index BINARY_INTEGER;
206 ccid_info hold_ccid_info_tab_type;
207 g_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
208 g_bal_acct_seg_num NUMBER;
209 g_nat_acct_seg_num NUMBER;
210 g_org_details PSA_IMPLEMENTATION_ALL%ROWTYPE;
211 g_segment_delimiter fnd_id_flex_structures.concatenated_segment_delimiter%TYPE;
212
213 END PSA_MFAR_UTILS;