[Home] [Help]
PACKAGE: APPS.ARW_CMREQ_COVER
Source
1 PACKAGE arw_cmreq_cover AUTHID CURRENT_USER AS
2 /* $Header: ARWCMRQS.pls 120.11 2011/02/06 09:40:29 manishri ship $ */
3
4
5 /*4556000*/
6 TYPE pq_attribute_rec_type IS RECORD(
7 attribute_category VARCHAR2(30) DEFAULT NULL,
8 attribute1 VARCHAR2(150) DEFAULT NULL,
9 attribute2 VARCHAR2(150) DEFAULT NULL,
10 attribute3 VARCHAR2(150) DEFAULT NULL,
11 attribute4 VARCHAR2(150) DEFAULT NULL,
12 attribute5 VARCHAR2(150) DEFAULT NULL,
13 attribute6 VARCHAR2(150) DEFAULT NULL,
14 attribute7 VARCHAR2(150) DEFAULT NULL,
15 attribute8 VARCHAR2(150) DEFAULT NULL,
16 attribute9 VARCHAR2(150) DEFAULT NULL,
17 attribute10 VARCHAR2(150) DEFAULT NULL,
18 attribute11 VARCHAR2(150) DEFAULT NULL,
19 attribute12 VARCHAR2(150) DEFAULT NULL,
20 attribute13 VARCHAR2(150) DEFAULT NULL,
21 attribute14 VARCHAR2(150) DEFAULT NULL,
22 attribute15 VARCHAR2(150) DEFAULT NULL);
23
24 TYPE pq_interface_rec_type IS RECORD(
25 interface_header_context VARCHAR2(30) DEFAULT NULL,
26 interface_header_attribute1 VARCHAR2(150) DEFAULT NULL,
27 interface_header_attribute2 VARCHAR2(150) DEFAULT NULL,
28 interface_header_attribute3 VARCHAR2(150) DEFAULT NULL,
29 interface_header_attribute4 VARCHAR2(150) DEFAULT NULL,
30 interface_header_attribute5 VARCHAR2(150) DEFAULT NULL,
31 interface_header_attribute6 VARCHAR2(150) DEFAULT NULL,
32 interface_header_attribute7 VARCHAR2(150) DEFAULT NULL,
33 interface_header_attribute8 VARCHAR2(150) DEFAULT NULL,
34 interface_header_attribute9 VARCHAR2(150) DEFAULT NULL,
35 interface_header_attribute10 VARCHAR2(150) DEFAULT NULL,
36 interface_header_attribute11 VARCHAR2(150) DEFAULT NULL,
37 interface_header_attribute12 VARCHAR2(150) DEFAULT NULL,
38 interface_header_attribute13 VARCHAR2(150) DEFAULT NULL,
39 interface_header_attribute14 VARCHAR2(150) DEFAULT NULL,
40 interface_header_attribute15 VARCHAR2(150) DEFAULT NULL);
41
42 TYPE pq_global_attribute_rec_type IS RECORD(
43 global_attribute_category VARCHAR2(30) default null,
44 global_attribute1 VARCHAR2(150) default NULL,
45 global_attribute2 VARCHAR2(150) DEFAULT NULL,
46 global_attribute3 VARCHAR2(150) DEFAULT NULL,
47 global_attribute4 VARCHAR2(150) DEFAULT NULL,
48 global_attribute5 VARCHAR2(150) DEFAULT NULL,
49 global_attribute6 VARCHAR2(150) DEFAULT NULL,
50 global_attribute7 VARCHAR2(150) DEFAULT NULL,
51 global_attribute8 VARCHAR2(150) DEFAULT NULL,
52 global_attribute9 VARCHAR2(150) DEFAULT NULL,
53 global_attribute10 VARCHAR2(150) DEFAULT NULL,
54 global_attribute11 VARCHAR2(150) DEFAULT NULL,
55 global_attribute12 VARCHAR2(150) DEFAULT NULL,
56 global_attribute13 VARCHAR2(150) DEFAULT NULL,
57 global_attribute14 VARCHAR2(150) DEFAULT NULL,
58 global_attribute15 VARCHAR2(150) DEFAULT NULL,
59 global_attribute16 VARCHAR2(150) DEFAULT NULL,
60 global_attribute17 VARCHAR2(150) DEFAULT NULL,
61 global_attribute18 VARCHAR2(150) DEFAULT NULL,
62 global_attribute19 VARCHAR2(150) DEFAULT NULL,
63 global_attribute20 VARCHAR2(150) DEFAULT NULL,
64 global_attribute21 VARCHAR2(150) DEFAULT NULL,
65 global_attribute22 VARCHAR2(150) DEFAULT NULL,
66 global_attribute23 VARCHAR2(150) DEFAULT NULL,
67 global_attribute24 VARCHAR2(150) DEFAULT NULL,
68 global_attribute25 VARCHAR2(150) DEFAULT NULL,
69 global_attribute26 VARCHAR2(150) DEFAULT NULL,
70 global_attribute27 VARCHAR2(150) DEFAULT NULL,
71 global_attribute28 VARCHAR2(150) DEFAULT NULL,
72 global_attribute29 VARCHAR2(150) DEFAULT NULL,
73 global_attribute30 VARCHAR2(150) DEFAULT NULL);
74
75 pq_attribute_rec_const pq_attribute_rec_type;
76 pq_interface_rec_const pq_interface_rec_type;
77 pq_global_attribute_const pq_global_attribute_rec_type;
78
79 /*4556000 additional columns added*/
80 TYPE Cm_Line_Rec_Type_Cover IS RECORD
81 (customer_trx_line_id ra_customer_trx_lines.Customer_trx_line_id%type,
82 extended_amount ra_customer_trx_lines.Extended_amount%type,
83 quantity_credited NUMBER,
84 price NUMBER,
85 ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT NULL,
86 ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
87 ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
88 ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
89 ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
90 ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
91 ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
92 ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
93 ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
94 ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
95 ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
96 ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
97 ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
98 ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
99 ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
100 ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
101 INTERFACE_LINE_CONTEXT VARCHAR2(30) DEFAULT NULL,
102 INTERFACE_LINE_ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
103 INTERFACE_LINE_ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
104 INTERFACE_LINE_ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
105 INTERFACE_LINE_ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
106 INTERFACE_LINE_ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
107 INTERFACE_LINE_ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
108 INTERFACE_LINE_ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
109 INTERFACE_LINE_ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
110 INTERFACE_LINE_ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
111 INTERFACE_LINE_ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
112 INTERFACE_LINE_ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
113 INTERFACE_LINE_ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
114 INTERFACE_LINE_ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
115 INTERFACE_LINE_ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
116 INTERFACE_LINE_ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
117 GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT NULL,
118 GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT NULL,
119 GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT NULL,
120 GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT NULL,
121 GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT NULL,
122 GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT NULL,
123 GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT NULL,
124 GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT NULL,
125 GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT NULL,
126 GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT NULL,
127 GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT NULL,
128 GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT NULL,
129 GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT NULL,
130 GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT NULL,
131 GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT NULL,
132 GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT NULL,
133 GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT NULL,
134 GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT NULL,
135 GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT NULL,
136 GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT NULL,
137 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT NULL);
138
139 TYPE Cm_Line_Tbl_Type_Cover IS TABLE OF Cm_Line_Rec_Type_Cover
140 INDEX BY BINARY_INTEGER;
141
142 FUNCTION ar_request_cm(
143 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
144 p_line_credits_flag IN ra_cm_requests.line_credits_flag%type,
145 p_line_amount IN number,
146 p_tax_amount IN number,
147 p_freight_amount IN number,
148 p_cm_lines_tbl IN Cm_Line_Tbl_Type_Cover,
149 p_cm_reason_code IN varchar2,
150 p_comments IN varchar2,
151 p_url IN ra_cm_requests.url%TYPE default null,
152 p_transaction_url IN ra_cm_requests.transaction_url%TYPE default null,
153 p_trans_act_url IN ra_cm_requests.activities_url%TYPE default null,
154 p_orig_trx_number IN varchar2 default null,
155 p_tax_ex_cert_num IN varchar2 default null,
156 p_skip_workflow_flag IN VARCHAR2 DEFAULT 'N',
157 p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,
158 p_credit_method_installments IN VARCHAR2 DEFAULT NULL,
159 p_credit_method_rules IN VARCHAR2 DEFAULT NULL,
160 p_batch_source_name IN VARCHAR2 DEFAULT NULL,
161 /*4556000*/
162 pq_attribute_rec IN pq_attribute_rec_type DEFAULT pq_attribute_rec_const,
163 pq_interface_attribute_rec IN pq_interface_rec_type DEFAULT pq_interface_rec_const,
164 pq_global_attribute_rec IN pq_global_attribute_rec_type DEFAULT
165 pq_global_attribute_const,
166 p_dispute_date IN DATE DEFAULT NULL, -- Bug 6358930
167 p_internal_comment IN VARCHAR2 DEFAULT NULL, /*7367350 New parameter for handling insertion internal comment*/
168 p_gl_date IN DATE DEFAULT NULL /*Bug 9536019*/
169 ) RETURN varchar2;
170
171 PROCEDURE ar_autocreate_cm(
172 p_request_id IN ra_cm_requests.request_id%type,
173 p_batch_source_name IN ra_batch_sources.name%type,
174 p_credit_method_rules IN varchar2,
175 p_credit_method_installments IN varchar2,
176 p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,
177 p_error_tab OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
178 p_status OUT NOCOPY VARCHAR2,
179 p_passed_gl_date IN DATE DEFAULT NULL /*Bug 9536019*/);
180
181 FUNCTION cancel_cm_request
182 ( p_subscription_guid In RAW
183 , p_event IN OUT NOCOPY WF_EVENT_T
184 )
185 RETURN VARCHAR2;
186
187 END arw_cmreq_cover;