[Home] [Help]
PACKAGE: APPS.ARP_PROCESS_RETURNS
Source
1 PACKAGE ARP_PROCESS_RETURNS AUTHID CURRENT_USER AS
2 /* $Header: ARPRRTNS.pls 120.5 2010/08/01 05:50:04 pnallabo ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE inv_info_type IS RECORD
9 (
10 num_of_cms NUMBER,
11 cc_apps BOOLEAN, --- Has CC apps
12 all_recs_in_doubt BOOLEAN, --- If all receipts are in doubt
13 rid_reason VARCHAR2(2000) -- Correspoding reason for receipt in doubt
14 );
15
16 TYPE app_info_type IS RECORD
17 (
18 rec_proc_option VARCHAR2(30),
19 rec_in_doubt VARCHAR2(1),
20 rec_currency_code ar_cash_receipts.currency_code%type,
21 inv_currency_code ar_cash_receipts.currency_code%type,
22 cross_currency BOOLEAN,
23 rid_reason VARCHAR2(2000),
24 trx_number ra_customer_trx.trx_number%type,
25 customer_trx_id ra_customer_trx.customer_trx_id%type /* bug 9909157 */
26 );
27
28 TYPE amt_app_type IS RECORD
29 (
30 line_applied ar_receivable_applications.amount_applied%type,
31 tax_applied ar_receivable_applications.amount_applied%type,
32 freight_applied ar_receivable_applications.amount_applied%type,
33 charges_applied ar_receivable_applications.amount_applied%type,
34 amount_applied ar_receivable_applications.amount_applied%type
35 );
36
37 TYPE inv_info_table_type IS TABLE OF inv_info_type
38 INDEX BY BINARY_INTEGER;
39
40 TYPE app_table_type IS TABLE OF ar_receivable_applications%rowtype
41 INDEX BY BINARY_INTEGER;
42
43 TYPE app_info_table_type IS TABLE OF app_info_type
44 INDEX BY BINARY_INTEGER;
45 TYPE amt_app_table_type IS TABLE OF amt_app_type
46 INDEX BY BINARY_INTEGER;
47
48 inv_info inv_info_table_type;
49 app_info app_info_table_type;
50 app_tab app_table_type;
51 amt_app_tab amt_app_table_type;
52 /*=======================================================================+
53 | Declare PUBLIC Exceptions
54 +=======================================================================*/
55
56
57 /*========================================================================
58 | Procedure process_invoice_list()
59 |
60 | DESCRIPTION
61 | Process Invoices from the list prepared by the AutoInvoice
62 |
63 | PSEUDO CODE/LOGIC
64 |
65 | PARAMETERS
66 |
67 |
68 | RETURNS
69 | nothing
70 |
71 | KNOWN ISSUES
72 |
73 |
74 |
75 | NOTES
76 |
77 |
78 |
79 | MODIFICATION HISTORY
80 | Date Author Description of Changes
81 | 02-Jul-2003 Ramakant Alat Created
82 |
83 *=======================================================================*/
84 PROCEDURE process_invoice_list ;
85
86 /*========================================================================
87 | Procedure process_application_list()
88 |
89 | DESCRIPTION
90 | Process Applications from the list prepared by the unapply_receipts
91 |
92 | PSEUDO CODE/LOGIC
93 |
94 | PARAMETERS
95 |
96 |
97 | RETURNS
98 | nothing
99 |
100 | KNOWN ISSUES
101 |
102 |
103 |
104 | NOTES
105 |
106 |
107 |
108 | MODIFICATION HISTORY
109 | Date Author Description of Changes
110 | 18-Jul-2003 Ramakant Alat Created
111 |
112 *=======================================================================*/
113 PROCEDURE process_application_list;
114
115 /*========================================================================
116 | Procedure unapply_receipts()
117 |
118 | DESCRIPTION
119 | Unapply all receipt applications for the given invoice
120 | and create the application list. This list will be used to create
121 | special applications and apply remaining amount back to original
122 | invoice
123 |
124 | PSEUDO CODE/LOGIC
125 |
126 | PARAMETERS
127 |
128 | p_inv_customer_trx_id - Invoice customer Trx ID
129 | p_receipt_handling_option IN VARCHAR2
130 | p_rec_in_doubt IN BOOLEAN DEFAULT FALSE
131 | p_rid_reason IN VARCHAR2 DEFAULT NULL
132 |
133 | RETURNS
134 | nothing
135 |
136 | KNOWN ISSUES
137 |
138 |
139 |
140 | NOTES
141 |
142 |
143 |
144 | MODIFICATION HISTORY
145 | Date Author Description of Changes
146 | 17-Jul-2003 Ramakant Alat Created
147 |
148 *=======================================================================*/
149
150 PROCEDURE unapply_receipts (p_inv_customer_trx_id IN NUMBER,
151 p_receipt_handling_option IN VARCHAR2
152 );
153 PROCEDURE add_invoice (p_customer_trx_id IN NUMBER);
154 FUNCTION get_total_cm_amount (p_inv_customer_trx_id IN NUMBER,
155 p_request_id IN NUMBER) RETURN NUMBER;
156 FUNCTION get_total_payment_types (p_inv_customer_trx_id IN NUMBER)
157 RETURN NUMBER;
158
159 FUNCTION get_on_acct_cm_apps(p_customer_trx_id IN NUMBER)
160 RETURN NUMBER;
161
162 FUNCTION get_amount_applied(p_customer_trx_id IN NUMBER,
163 p_line_type IN VARCHAR2)
164 RETURN NUMBER;
165
166 FUNCTION get_neg_inv_apps(p_customer_trx_id IN NUMBER)
167 RETURN NUMBER;
168
169 FUNCTION get_llca_apps(p_customer_trx_id IN NUMBER)
170 RETURN NUMBER;
171
172 END ARP_PROCESS_RETURNS;