[Home] [Help]
PACKAGE: APPS.AR_INVOICE_SQL_FUNC_PUB
Source
1 PACKAGE AR_INVOICE_SQL_FUNC_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARTPSQS.pls 115.6 99/10/11 16:15:56 porting sh $ */
3 /*===========================================================================+
4 | FUNCTION get_description |
5 | |
6 | DESCRIPTION |
7 | |
8 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
9 | |
10 | ARGUMENTS : IN: |
11 | |
12 | OUT: |
13 | RETURNS : |
14 | |
15 | NOTES : Function implemented is populate_mls_lexicals |
16 | |
17 | MODIFICATION HISTORY |
18 | 01-MAY-97 Ashim K Dey Created |
19 +===========================================================================*/
20
21 FUNCTION get_description(p_customer_trx_line_id IN NUMBER)
22 RETURN VARCHAR2;
23
24
25
26 /*===========================================================================+
27 | FUNCTION get_inv_tax_code_name
28 | |
29 | DESCRIPTION |
30 | This function is used for getting inv_tax_code_name
31 | |
32 | SCOPE - PUBLIC |
33 | |
34 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
35 | |
36 | ARGUMENTS : IN: p_bill_to_site_use_id
37 | p_bill_to_customer_id
38 | p_tax_printing_option
39 | p_printed_tax_name
40 | p_tax_code
41 | OUT: |
42 | RETURNS : |
43 | |
44 | NOTES |
45 | |
46 | MODIFICATION HISTORY |
47 | 02-MAY-97 Ashim K Dey Created |
48 +===========================================================================*/
49
50 FUNCTION get_inv_tax_code_name(
51 p_bill_to_site_use_id IN NUMBER,
52 p_bill_to_customer_id IN NUMBER,
53 p_tax_printing_option IN VARCHAR2,
54 p_printed_tax_name IN VARCHAR2,
55 p_tax_code IN VARCHAR2)
56 RETURN VARCHAR2;
57
58
59 /*=============================================================================
60 || PRIVATE FUNCTION get_com_total_activity
61 ||
62 || DESCRIPTION Returns the commitment total activity
63 ||
64 || ARGUMENTS p_customer_trx_id
65 || p_commit_parent_type
66 p_init_cust_trx_id
67 ||
68 || RETURN
69 ||
70 || NOTE
71 || This function simulates the report local function
72 || commitments in RAXINV.rdf
73 ||
74 || MODIFICATION HISTORY
75 || 22-MAY-97 Ashim K Dey Created
76 =============================================================================*/
77
78 FUNCTION get_com_total_activity(
79 p_customer_trx_id IN NUMBER,
80 p_trx_type IN VARCHAR2,
81 p_init_cust_trx_id IN NUMBER)
82 return NUMBER ;
83
84
85 /*=============================================================================
86 || PRIVATE FUNCTION get_com_amt_uninvoiced
87 ||
88 || DESCRIPTION Returns the commitment uninvoiced amount
89 ||
90 || ARGUMENTS p_init_cust_trx_id
91 ||
92 || RETURN returns 0 if no data found; otherwise total uninvoiced amount
93 || for the transaction.
94 ||
95 || NOTE
96 || This function simulates the cursor in report local function
97 || "commitments" in RAXINV.rdf.
98 || Here It is not checked whether Order entry is installed, becase
99 || the table so_lines will always be present.
100 ||
101 || MODIFICATION HISTORY
102 || 22-MAY-97 Ashim K Dey Created
103 =============================================================================*/
104
105 FUNCTION get_com_amt_uninvoiced( p_init_cust_trx_id IN NUMBER)
106 RETURN number ;
107
108
109
110 FUNCTION get_com_balance(
111 p_original_amount IN NUMBER,
112 p_trx_type IN VARCHAR2,
113 p_init_cust_trx_id IN NUMBER)
114 RETURN NUMBER ;
115
116
117 /*=============================================================================
118 || PRIVATE FUNCTION get_commit_this_invoice
119 ||
120 || DESCRIPTION
121 ||
122 || ARGUMENTS p_customer_trx_id
123 ||
124 || RETURN commit_this_invoice
125 ||
126 || NOTE
127 || This function simulates the query Q_Commitment_Adjustment in RAXINV.rdf.
128 ||
129 || MODIFICATION HISTORY
130 || 23-MAY-97 Ashim K Dey Created
131 =============================================================================*/
132 FUNCTION get_commit_this_invoice(p_customer_trx_id IN NUMBER)
133 RETURN number ;
134
135
136 /*=============================================================================
137 || PRIVATE PROCEDURE update_customer_trx
138 ||
139 || DESCRIPTION This procedure updates the ra_customer_trx table
140 || and sets the printing information.
141 ||
142 || ARGUMENTS
143 || IN: p_choice
144 || p_customer_trx_id
145 || p_trx_type
146 || p_term_count
147 || p_term_sequence_number
148 || p_printing_count
149 || p_printing_original_date
150 ||
151 || OUT:
152 ||
153 || FUNCTION CALL
154 ||
155 || RETURN
156 ||
157 || NOTE This is a update procedure. So pragma restriction should not be
158 || imposed in its declaration.
159 ||
160 || MODIFICATION HISTORY
161 || 29-MAY-97 Ashim K Dey Created
162 =============================================================================*/
163
164 PROCEDURE update_customer_trx (
165 p_choice IN VARCHAR2,
166 p_customer_trx_id IN NUMBER,
167 p_trx_type IN VARCHAR2,
168 p_term_count IN NUMBER,
169 p_term_sequence_number IN NUMBER,
170 p_printing_count IN NUMBER,
171 p_printing_original_date IN DATE) ;
172
173 /*=============================================================================
174 || PRIVATE PROCEDURE get_taxyn
175 ||
176 || DESCRIPTION
177 ||
178 || ARGUMENTS
179 || IN: p_customer_trx_line_id
180 ||
181 || OUT:
182 ||
183 || FUNCTION CALL
184 ||
185 || RETURN
186 ||
187 || NOTE For ease of translation ar_lookup table is referred for
188 || getting 'Yes' or 'No'
189 ||
190 || MODIFICATION HISTORY
191 || 29-MAY-97 Ashim K Dey Created
192 =============================================================================*/
193
194 FUNCTION get_taxyn ( p_customer_trx_line_id IN NUMBER)
195 return VARCHAR2 ;
196
197
198 /*=============================================================================
199 || PRIVATE FUNCTION get_remit_to_given_bill_to
200 ||
201 || DESCRIPTION
202 ||
203 ||
204 || ARGUMENTS
205 ||
206 || FUNCTION CALL
207 ||
208 || RETURN
209 ||
210 || NOTE
211 ||
212 || MODIFICATION HISTORY
213 || 29-MAY-97 Ashim K Dey Created
214 =============================================================================*/
215
216 FUNCTION get_remit_to_given_bill_to( p_bill_to_site_use_id in number )
217 return number ;
218
219
220 /*=============================================================================
221 || PRIVATE FUNCTION get_remit_address_id
222 ||
223 || DESCRIPTION This function gets the remit_address_id
224 ||
225 ||
226 || ARGUMENTS
227 ||
228 || FUNCTION CALL
229 ||
230 || RETURN
231 ||
232 || NOTE
233 ||
234 || MODIFICATION HISTORY
235 || 29-MAY-97 Ashim K Dey Created
236 =============================================================================*/
237
238 FUNCTION get_remit_address_id(
239 p_remit_to_address_id IN NUMBER,
240 p_previous_customer_trx_id IN NUMBER,
241 p_trx_type IN VARCHAR2,
242 p_bill_to_site_use_id IN NUMBER)
243 return varchar2 ;
244
245
246 END AR_INVOICE_SQL_FUNC_PUB ;