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