[Home] [Help]
PACKAGE: APPS.ARP_TRX_UTIL
Source
1 PACKAGE ARP_TRX_UTIL AS
2 /* $Header: ARTUTILS.pls 120.4.12010000.2 2008/11/13 15:45:44 rmanikan ship $ */
3
4 PROCEDURE delete_transaction(p_form_name IN varchar2,
5 p_form_version IN number,
6 p_customer_trx_id IN NUMBER);
7
8 PROCEDURE lock_transaction(p_customer_trx_id IN NUMBER);
9
10 PROCEDURE set_term_in_use_flag(p_form_name IN varchar2,
11 p_form_version IN number,
12 p_term_id IN number,
13 p_term_in_use_flag IN varchar2);
14
15 PROCEDURE set_posted_flag(p_customer_trx_id IN NUMBER,
16 p_posted_flag OUT NOCOPY BOOLEAN);
17
18
19 FUNCTION boolean_to_varchar2(p_boolean IN boolean) RETURN varchar2;
20
21 FUNCTION detect_freight_only_rules_case( p_customer_trx_id IN
22 ra_customer_trx.customer_trx_id%type )
23 RETURN BOOLEAN;
24
25 /*===========================================================================+
26 | PROCEDURE |
27 | transaction_balance |
28 | |
29 | DESCRIPTION |
30 | Determines the balances for a transaction |
31 | |
32 | SCOPE - PUBLIC |
33 | |
34 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
35 | arp_util.debug |
36 | |
37 | ARGUMENTS : IN: |
38 | p_customer_trx_id - identifies the transaction |
39 | p_open_receivables_flag |
40 | p_exchange_rate |
41 | p_mode - Can be 'ALL' or 'SUMMARY' |
42 | - All balances are returned in ALL |
43 | mode. Only the Txn. original and |
44 | remaining balances are returned |
45 | in SUMMARY mode. |
46 | |
47 | p_currency_mode - Can be 'E'(ntered) or 'A'(ll) |
48 | - The base currency amounts are only |
49 | calculated and returned in 'A' mode.|
50 | OUT: |
51 | < entered currency balances > |
52 | < base currency balances > |
53 | |
54 | NOTES |
55 | Rounding errors for the base amounts are corrected in this procedure |
56 | by putting the rounding error on the line balances. This may not be |
57 | the same as how the rounding errors are corrected on the actual |
58 | transaction. Therefore, the base line, tax and freight balances may |
59 | not be accurate. The totals are always accurate, however. |
60 | |
61 | MODIFICATION HISTORY |
62 | 31-AUG-95 Charlie Tomberg Created |
63 | |
64 +===========================================================================*/
65
66 PROCEDURE transaction_balances(p_customer_trx_id IN
67 ra_customer_trx.customer_trx_id%type,
68 p_open_receivables_flag IN
69 ra_cust_trx_types.accounting_affect_flag%type,
70 p_exchange_rate IN
71 ra_customer_trx.exchange_rate%type,
72 p_mode IN VARCHAR2,
73 p_currency_mode IN VARCHAR2,
74 p_line_original OUT NOCOPY NUMBER,
75 p_line_remaining OUT NOCOPY NUMBER,
76 p_tax_original OUT NOCOPY NUMBER,
77 p_tax_remaining OUT NOCOPY NUMBER,
78 p_freight_original OUT NOCOPY NUMBER,
79 p_freight_remaining OUT NOCOPY NUMBER,
80 p_charges_original OUT NOCOPY NUMBER,
81 p_charges_remaining OUT NOCOPY NUMBER,
82 p_line_discount OUT NOCOPY NUMBER,
83 p_tax_discount OUT NOCOPY NUMBER,
84 p_freight_discount OUT NOCOPY NUMBER,
85 p_charges_discount OUT NOCOPY NUMBER,
86 p_total_discount OUT NOCOPY NUMBER,
87 p_total_original OUT NOCOPY NUMBER,
88 p_total_remaining OUT NOCOPY NUMBER,
89 p_line_receipts OUT NOCOPY NUMBER,
90 p_tax_receipts OUT NOCOPY NUMBER,
91 p_freight_receipts OUT NOCOPY NUMBER,
92 p_charges_receipts OUT NOCOPY NUMBER,
93 p_total_receipts OUT NOCOPY NUMBER,
94 p_line_credits OUT NOCOPY NUMBER,
95 p_tax_credits OUT NOCOPY NUMBER,
96 p_freight_credits OUT NOCOPY NUMBER,
97 p_total_credits OUT NOCOPY NUMBER,
98 p_line_adjustments OUT NOCOPY NUMBER,
99 p_tax_adjustments OUT NOCOPY NUMBER,
100 p_freight_adjustments OUT NOCOPY NUMBER,
101 p_charges_adjustments OUT NOCOPY NUMBER,
102 p_total_adjustments OUT NOCOPY NUMBER,
103 p_aline_adjustments OUT NOCOPY NUMBER,
104 p_atax_adjustments OUT NOCOPY NUMBER,
105 p_afreight_adjustments OUT NOCOPY NUMBER,
106 p_acharges_adjustments OUT NOCOPY NUMBER,
107 p_atotal_adjustments OUT NOCOPY NUMBER,
108 p_base_line_original OUT NOCOPY NUMBER,
109 p_base_line_remaining OUT NOCOPY NUMBER,
110 p_base_tax_original OUT NOCOPY NUMBER,
111 p_base_tax_remaining OUT NOCOPY NUMBER,
112 p_base_freight_original OUT NOCOPY NUMBER,
113 p_base_freight_remaining OUT NOCOPY NUMBER,
114 p_base_charges_original OUT NOCOPY NUMBER,
115 p_base_charges_remaining OUT NOCOPY NUMBER,
116 p_base_line_discount OUT NOCOPY NUMBER,
117 p_base_tax_discount OUT NOCOPY NUMBER,
118 p_base_freight_discount OUT NOCOPY NUMBER,
119 p_base_total_discount OUT NOCOPY NUMBER,
120 p_base_total_original OUT NOCOPY NUMBER,
121 p_base_total_remaining OUT NOCOPY NUMBER,
122 p_base_line_receipts OUT NOCOPY NUMBER,
123 p_base_tax_receipts OUT NOCOPY NUMBER,
124 p_base_freight_receipts OUT NOCOPY NUMBER,
125 p_base_charges_receipts OUT NOCOPY NUMBER,
126 p_base_total_receipts OUT NOCOPY NUMBER,
127 p_base_line_credits OUT NOCOPY NUMBER,
128 p_base_tax_credits OUT NOCOPY NUMBER,
129 p_base_freight_credits OUT NOCOPY NUMBER,
130 p_base_total_credits OUT NOCOPY NUMBER,
131 p_base_line_adjustments OUT NOCOPY NUMBER,
132 p_base_tax_adjustments OUT NOCOPY NUMBER,
133 p_base_freight_adjustments OUT NOCOPY NUMBER,
134 p_base_charges_adjustments OUT NOCOPY NUMBER,
135 p_base_total_adjustments OUT NOCOPY NUMBER,
136 p_base_aline_adjustments OUT NOCOPY NUMBER,
137 p_base_atax_adjustments OUT NOCOPY NUMBER,
138 p_base_afreight_adjustments OUT NOCOPY NUMBER,
139 p_base_acharges_adjustments OUT NOCOPY NUMBER,
140 p_base_atotal_adjustments OUT NOCOPY NUMBER
141 );
142
143 PROCEDURE get_summary_trx_balances( p_customer_trx_id IN
144 ra_customer_trx.customer_trx_id%type,
145 p_open_receivables_flag IN
146 ra_cust_trx_types.accounting_affect_flag%type,
147 p_line_original OUT NOCOPY NUMBER,
148 p_line_remaining OUT NOCOPY NUMBER,
149 p_tax_original OUT NOCOPY NUMBER,
150 p_tax_remaining OUT NOCOPY NUMBER,
151 p_freight_original OUT NOCOPY NUMBER,
152 p_freight_remaining OUT NOCOPY NUMBER,
153 p_charges_original OUT NOCOPY NUMBER,
154 p_charges_remaining OUT NOCOPY NUMBER,
155 p_total_original OUT NOCOPY NUMBER,
156 p_total_remaining OUT NOCOPY NUMBER );
157
158 /*===========================================================================+
159 | FUNTION |
160 | IS_FV_ENABLED |
161 | |
162 | DESCRIPTION |
163 | Checks whether the Federal is enabled or not using |
164 | Federal Financial api fv_install.enabled. |
165 | |
166 | SCOPE - PRIVATE |
167 | |
168 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
169 | arp_standard.debug |
170 | |
171 | ARGUMENTS : IN: |
172 | |
173 | OUT: |
174 | |
175 | RETURNS : T - True, F - False |
176 | |
177 | NOTES |
178 | |
179 | MODIFICATION HISTORY |
180 | 23-Jun-08 Thirumalaisamy Created |
181 +===========================================================================*/
182 FUNCTION IS_FV_ENABLED RETURN VARCHAR2;
183
184 /*===========================================================================+
185 | FUNTION |
186 | IS_CCR_SUPPLIER |
187 | |
188 | DESCRIPTION |
189 | Checks the given party/site is CCR supplier/Site |
190 | |
191 | SCOPE - PRIVATE |
192 | |
193 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
194 | arp_standard.debug |
195 | |
196 | ARGUMENTS : IN: |
197 | p_object_type - CUST - Customer, ADDR - Address |
198 | OUT: |
199 | |
200 | RETURNS : T - True, F - False |
201 | |
202 | NOTES |
203 | |
204 | MODIFICATION HISTORY |
205 | 23-Jun-08 Thirumalaisamy Created |
206 +===========================================================================*/
207
208 FUNCTION IS_CCR_SUPPLIER(
209 p_object_type IN VARCHAR2 ,
210 p_object_id IN NUMBER
211 )RETURN VARCHAR2;
212
213
214 PROCEDURE init;
215
216 END ARP_TRX_UTIL;