eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_RMA_TRANSACTIONS dependencies on RCV_ROI_PREPROCESSOR

Line 42: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

38:
39: -- specs for package level procedures
40: -- helpers for derive_rma_line
41: PROCEDURE derive_order_header_info(
42: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
43: n IN BINARY_INTEGER
44: );
45:
46: PROCEDURE derive_order_line_info(

Line 47: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

43: n IN BINARY_INTEGER
44: );
45:
46: PROCEDURE derive_order_line_info(
47: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
48: n IN BINARY_INTEGER
49: );
50:
51: PROCEDURE derive_document_line_info(

Line 52: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

48: n IN BINARY_INTEGER
49: );
50:
51: PROCEDURE derive_document_line_info(
52: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
53: n IN BINARY_INTEGER
54: );
55:
56: PROCEDURE derive_customer_info(

Line 57: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

53: n IN BINARY_INTEGER
54: );
55:
56: PROCEDURE derive_customer_info(
57: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
58: n IN BINARY_INTEGER
59: );
60:
61: PROCEDURE derive_transit_org_info(

Line 62: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

58: n IN BINARY_INTEGER
59: );
60:
61: PROCEDURE derive_transit_org_info(
62: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
63: n IN BINARY_INTEGER
64: );
65:
66: PROCEDURE derive_uom_info(

Line 67: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

63: n IN BINARY_INTEGER
64: );
65:
66: PROCEDURE derive_uom_info(
67: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
68: n IN BINARY_INTEGER
69: );
70:
71: PROCEDURE derive_org_info(

Line 72: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

68: n IN BINARY_INTEGER
69: );
70:
71: PROCEDURE derive_org_info(
72: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
73: n IN BINARY_INTEGER,
74: x_header_record IN rcv_roi_preprocessor.header_rec_type
75: );
76:

Line 74: x_header_record IN rcv_roi_preprocessor.header_rec_type

70:
71: PROCEDURE derive_org_info(
72: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
73: n IN BINARY_INTEGER,
74: x_header_record IN rcv_roi_preprocessor.header_rec_type
75: );
76:
77: PROCEDURE derive_deliver_to_info(
78: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 78: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

74: x_header_record IN rcv_roi_preprocessor.header_rec_type
75: );
76:
77: PROCEDURE derive_deliver_to_info(
78: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
79: n IN BINARY_INTEGER
80: );
81:
82: PROCEDURE derive_auto_transact_info(

Line 83: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

79: n IN BINARY_INTEGER
80: );
81:
82: PROCEDURE derive_auto_transact_info(
83: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
84: n IN BINARY_INTEGER
85: );
86:
87: PROCEDURE explode_line_quantity(

Line 88: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

84: n IN BINARY_INTEGER
85: );
86:
87: PROCEDURE explode_line_quantity(
88: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
89: n IN OUT NOCOPY BINARY_INTEGER,
90: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
91: x_header_record IN rcv_roi_preprocessor.header_rec_type
92: );

Line 90: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

86:
87: PROCEDURE explode_line_quantity(
88: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
89: n IN OUT NOCOPY BINARY_INTEGER,
90: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
91: x_header_record IN rcv_roi_preprocessor.header_rec_type
92: );
93:
94: -- helpers for default_rma_line

Line 91: x_header_record IN rcv_roi_preprocessor.header_rec_type

87: PROCEDURE explode_line_quantity(
88: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
89: n IN OUT NOCOPY BINARY_INTEGER,
90: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
91: x_header_record IN rcv_roi_preprocessor.header_rec_type
92: );
93:
94: -- helpers for default_rma_line
95: PROCEDURE default_source_info(

Line 96: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

92: );
93:
94: -- helpers for default_rma_line
95: PROCEDURE default_source_info(
96: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
97: n IN BINARY_INTEGER,
98: x_header_id IN rcv_headers_interface.header_interface_id%TYPE
99: );
100:

Line 102: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

98: x_header_id IN rcv_headers_interface.header_interface_id%TYPE
99: );
100:
101: PROCEDURE default_destination_info(
102: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
103: n IN BINARY_INTEGER
104: );
105:
106: PROCEDURE default_item_info(

Line 107: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

103: n IN BINARY_INTEGER
104: );
105:
106: PROCEDURE default_item_info(
107: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
108: n IN BINARY_INTEGER
109: );
110:
111: PROCEDURE default_transaction_info(

Line 112: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

108: n IN BINARY_INTEGER
109: );
110:
111: PROCEDURE default_transaction_info(
112: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
113: n IN BINARY_INTEGER
114: );
115:
116: PROCEDURE default_processing_info(

Line 117: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

113: n IN BINARY_INTEGER
114: );
115:
116: PROCEDURE default_processing_info(
117: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
118: n IN BINARY_INTEGER
119: );
120:
121: PROCEDURE default_from_header(

Line 122: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

118: n IN BINARY_INTEGER
119: );
120:
121: PROCEDURE default_from_header(
122: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
123: n IN BINARY_INTEGER,
124: x_header_record IN rcv_roi_preprocessor.header_rec_type
125: );
126:

Line 124: x_header_record IN rcv_roi_preprocessor.header_rec_type

120:
121: PROCEDURE default_from_header(
122: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
123: n IN BINARY_INTEGER,
124: x_header_record IN rcv_roi_preprocessor.header_rec_type
125: );
126:
127: PROCEDURE default_from_rma(
128: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 128: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

124: x_header_record IN rcv_roi_preprocessor.header_rec_type
125: );
126:
127: PROCEDURE default_from_rma(
128: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
129: n IN BINARY_INTEGER
130: );
131:
132: PROCEDURE default_customer_header(

Line 133: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

129: n IN BINARY_INTEGER
130: );
131:
132: PROCEDURE default_customer_header(
133: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
134: n IN BINARY_INTEGER,
135: x_header_record IN rcv_roi_preprocessor.header_rec_type
136: );
137:

Line 135: x_header_record IN rcv_roi_preprocessor.header_rec_type

131:
132: PROCEDURE default_customer_header(
133: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
134: n IN BINARY_INTEGER,
135: x_header_record IN rcv_roi_preprocessor.header_rec_type
136: );
137:
138: PROCEDURE default_customer_site_header(
139: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 139: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

135: x_header_record IN rcv_roi_preprocessor.header_rec_type
136: );
137:
138: PROCEDURE default_customer_site_header(
139: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
140: n IN BINARY_INTEGER,
141: x_header_record IN rcv_roi_preprocessor.header_rec_type
142: );
143:

Line 141: x_header_record IN rcv_roi_preprocessor.header_rec_type

137:
138: PROCEDURE default_customer_site_header(
139: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
140: n IN BINARY_INTEGER,
141: x_header_record IN rcv_roi_preprocessor.header_rec_type
142: );
143:
144: PROCEDURE default_from_org_header(
145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

141: x_header_record IN rcv_roi_preprocessor.header_rec_type
142: );
143:
144: PROCEDURE default_from_org_header(
145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
146: n IN BINARY_INTEGER,
147: x_header_record IN rcv_roi_preprocessor.header_rec_type
148: );
149:

Line 147: x_header_record IN rcv_roi_preprocessor.header_rec_type

143:
144: PROCEDURE default_from_org_header(
145: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
146: n IN BINARY_INTEGER,
147: x_header_record IN rcv_roi_preprocessor.header_rec_type
148: );
149:
150: PROCEDURE default_ship_to_header(
151: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 151: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

147: x_header_record IN rcv_roi_preprocessor.header_rec_type
148: );
149:
150: PROCEDURE default_ship_to_header(
151: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
152: n IN BINARY_INTEGER,
153: x_header_record IN rcv_roi_preprocessor.header_rec_type
154: );
155:

Line 153: x_header_record IN rcv_roi_preprocessor.header_rec_type

149:
150: PROCEDURE default_ship_to_header(
151: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
152: n IN BINARY_INTEGER,
153: x_header_record IN rcv_roi_preprocessor.header_rec_type
154: );
155:
156: PROCEDURE default_currency_info_header(
157: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 157: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

153: x_header_record IN rcv_roi_preprocessor.header_rec_type
154: );
155:
156: PROCEDURE default_currency_info_header(
157: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
158: n IN BINARY_INTEGER,
159: x_header_record IN rcv_roi_preprocessor.header_rec_type
160: );
161:

Line 159: x_header_record IN rcv_roi_preprocessor.header_rec_type

155:
156: PROCEDURE default_currency_info_header(
157: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
158: n IN BINARY_INTEGER,
159: x_header_record IN rcv_roi_preprocessor.header_rec_type
160: );
161:
162: PROCEDURE default_shipment_num_header(
163: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 163: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

159: x_header_record IN rcv_roi_preprocessor.header_rec_type
160: );
161:
162: PROCEDURE default_shipment_num_header(
163: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
164: n IN BINARY_INTEGER,
165: x_header_record IN rcv_roi_preprocessor.header_rec_type
166: );
167:

Line 165: x_header_record IN rcv_roi_preprocessor.header_rec_type

161:
162: PROCEDURE default_shipment_num_header(
163: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
164: n IN BINARY_INTEGER,
165: x_header_record IN rcv_roi_preprocessor.header_rec_type
166: );
167:
168: PROCEDURE default_freight_carrier_header(
169: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 169: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

165: x_header_record IN rcv_roi_preprocessor.header_rec_type
166: );
167:
168: PROCEDURE default_freight_carrier_header(
169: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
170: n IN BINARY_INTEGER,
171: x_header_record IN rcv_roi_preprocessor.header_rec_type
172: );
173:

Line 171: x_header_record IN rcv_roi_preprocessor.header_rec_type

167:
168: PROCEDURE default_freight_carrier_header(
169: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
170: n IN BINARY_INTEGER,
171: x_header_record IN rcv_roi_preprocessor.header_rec_type
172: );
173:
174: PROCEDURE default_bill_of_lading_header(
175: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 175: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

171: x_header_record IN rcv_roi_preprocessor.header_rec_type
172: );
173:
174: PROCEDURE default_bill_of_lading_header(
175: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
176: n IN BINARY_INTEGER,
177: x_header_record IN rcv_roi_preprocessor.header_rec_type
178: );
179:

Line 177: x_header_record IN rcv_roi_preprocessor.header_rec_type

173:
174: PROCEDURE default_bill_of_lading_header(
175: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
176: n IN BINARY_INTEGER,
177: x_header_record IN rcv_roi_preprocessor.header_rec_type
178: );
179:
180: PROCEDURE default_packing_slip_header(
181: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 181: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

177: x_header_record IN rcv_roi_preprocessor.header_rec_type
178: );
179:
180: PROCEDURE default_packing_slip_header(
181: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
182: n IN BINARY_INTEGER,
183: x_header_record IN rcv_roi_preprocessor.header_rec_type
184: );
185:

Line 183: x_header_record IN rcv_roi_preprocessor.header_rec_type

179:
180: PROCEDURE default_packing_slip_header(
181: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
182: n IN BINARY_INTEGER,
183: x_header_record IN rcv_roi_preprocessor.header_rec_type
184: );
185:
186: PROCEDURE default_ship_date_header(
187: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 187: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

183: x_header_record IN rcv_roi_preprocessor.header_rec_type
184: );
185:
186: PROCEDURE default_ship_date_header(
187: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
188: n IN BINARY_INTEGER,
189: x_header_record IN rcv_roi_preprocessor.header_rec_type
190: );
191:

Line 189: x_header_record IN rcv_roi_preprocessor.header_rec_type

185:
186: PROCEDURE default_ship_date_header(
187: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
188: n IN BINARY_INTEGER,
189: x_header_record IN rcv_roi_preprocessor.header_rec_type
190: );
191:
192: PROCEDURE default_receipt_date_header(
193: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 193: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

189: x_header_record IN rcv_roi_preprocessor.header_rec_type
190: );
191:
192: PROCEDURE default_receipt_date_header(
193: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
194: n IN BINARY_INTEGER,
195: x_header_record IN rcv_roi_preprocessor.header_rec_type
196: );
197:

Line 195: x_header_record IN rcv_roi_preprocessor.header_rec_type

191:
192: PROCEDURE default_receipt_date_header(
193: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
194: n IN BINARY_INTEGER,
195: x_header_record IN rcv_roi_preprocessor.header_rec_type
196: );
197:
198: PROCEDURE default_num_containers_header(
199: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 199: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

195: x_header_record IN rcv_roi_preprocessor.header_rec_type
196: );
197:
198: PROCEDURE default_num_containers_header(
199: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
200: n IN BINARY_INTEGER,
201: x_header_record IN rcv_roi_preprocessor.header_rec_type
202: );
203:

Line 201: x_header_record IN rcv_roi_preprocessor.header_rec_type

197:
198: PROCEDURE default_num_containers_header(
199: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
200: n IN BINARY_INTEGER,
201: x_header_record IN rcv_roi_preprocessor.header_rec_type
202: );
203:
204: PROCEDURE default_waybill_header(
205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

201: x_header_record IN rcv_roi_preprocessor.header_rec_type
202: );
203:
204: PROCEDURE default_waybill_header(
205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
206: n IN BINARY_INTEGER,
207: x_header_record IN rcv_roi_preprocessor.header_rec_type
208: );
209:

Line 207: x_header_record IN rcv_roi_preprocessor.header_rec_type

203:
204: PROCEDURE default_waybill_header(
205: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
206: n IN BINARY_INTEGER,
207: x_header_record IN rcv_roi_preprocessor.header_rec_type
208: );
209:
210: PROCEDURE default_tax_name_header(
211: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 211: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

207: x_header_record IN rcv_roi_preprocessor.header_rec_type
208: );
209:
210: PROCEDURE default_tax_name_header(
211: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
212: n IN BINARY_INTEGER,
213: x_header_record IN rcv_roi_preprocessor.header_rec_type
214: );
215:

Line 213: x_header_record IN rcv_roi_preprocessor.header_rec_type

209:
210: PROCEDURE default_tax_name_header(
211: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
212: n IN BINARY_INTEGER,
213: x_header_record IN rcv_roi_preprocessor.header_rec_type
214: );
215:
216: PROCEDURE default_routing_info(
217: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

Line 217: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

213: x_header_record IN rcv_roi_preprocessor.header_rec_type
214: );
215:
216: PROCEDURE default_routing_info(
217: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
218: n IN BINARY_INTEGER
219: );
220:
221: -- helpers for validate_rma_line

Line 223: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

219: );
220:
221: -- helpers for validate_rma_line
222: PROCEDURE validate_txn_date(
223: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
224: n IN BINARY_INTEGER
225: );
226:
227: PROCEDURE validate_qty_invoiced(

Line 228: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

224: n IN BINARY_INTEGER
225: );
226:
227: PROCEDURE validate_qty_invoiced(
228: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
229: n IN BINARY_INTEGER
230: );
231:
232: PROCEDURE validate_uom_info(

Line 233: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

229: n IN BINARY_INTEGER
230: );
231:
232: PROCEDURE validate_uom_info(
233: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
234: n IN BINARY_INTEGER
235: );
236:
237: PROCEDURE validate_item_info(

Line 238: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

234: n IN BINARY_INTEGER
235: );
236:
237: PROCEDURE validate_item_info(
238: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
239: n IN BINARY_INTEGER
240: );
241:
242: PROCEDURE validate_freight_carrier_info(

Line 243: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

239: n IN BINARY_INTEGER
240: );
241:
242: PROCEDURE validate_freight_carrier_info(
243: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
244: n IN BINARY_INTEGER
245: );
246:
247: PROCEDURE validate_destination_type(

Line 248: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

244: n IN BINARY_INTEGER
245: );
246:
247: PROCEDURE validate_destination_type(
248: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
249: n IN BINARY_INTEGER
250: );
251:
252: PROCEDURE validate_tax_name(

Line 253: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

249: n IN BINARY_INTEGER
250: );
251:
252: PROCEDURE validate_tax_name(
253: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
254: n IN BINARY_INTEGER
255: );
256:
257: PROCEDURE validate_country_of_origin(

Line 258: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

254: n IN BINARY_INTEGER
255: );
256:
257: PROCEDURE validate_country_of_origin(
258: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
259: n IN BINARY_INTEGER
260: );
261:
262: PROCEDURE validate_ref_integrity(

Line 263: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

259: n IN BINARY_INTEGER
260: );
261:
262: PROCEDURE validate_ref_integrity(
263: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
264: n IN BINARY_INTEGER
265: );
266:
267: PROCEDURE validate_uom(

Line 278: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

274: );
275:
276: -- main public procedures
277: PROCEDURE derive_rma_line(
278: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
279: n IN OUT NOCOPY BINARY_INTEGER,
280: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
281: x_header_record IN rcv_roi_preprocessor.header_rec_type
282: ) IS

Line 280: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

276: -- main public procedures
277: PROCEDURE derive_rma_line(
278: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
279: n IN OUT NOCOPY BINARY_INTEGER,
280: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
281: x_header_record IN rcv_roi_preprocessor.header_rec_type
282: ) IS
283: BEGIN
284: IF (g_asn_debug = 'Y') THEN

Line 281: x_header_record IN rcv_roi_preprocessor.header_rec_type

277: PROCEDURE derive_rma_line(
278: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
279: n IN OUT NOCOPY BINARY_INTEGER,
280: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
281: x_header_record IN rcv_roi_preprocessor.header_rec_type
282: ) IS
283: BEGIN
284: IF (g_asn_debug = 'Y') THEN
285: asn_debug.put_line('Enter derive_rma_line');

Line 357: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

353: asn_debug.put_line('RMA derive ' || x_progress || ' error status: ' || NVL(x_cascaded_table(n).error_status, 'NULL'));
354: END derive_rma_line;
355:
356: PROCEDURE derive_rma_trans_del(
357: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
358: n IN OUT NOCOPY BINARY_INTEGER,
359: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
360: x_header_record IN rcv_roi_preprocessor.header_rec_type
361: ) IS

Line 359: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

355:
356: PROCEDURE derive_rma_trans_del(
357: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
358: n IN OUT NOCOPY BINARY_INTEGER,
359: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
360: x_header_record IN rcv_roi_preprocessor.header_rec_type
361: ) IS
362: BEGIN
363: IF (g_asn_debug = 'Y') THEN

Line 360: x_header_record IN rcv_roi_preprocessor.header_rec_type

356: PROCEDURE derive_rma_trans_del(
357: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
358: n IN OUT NOCOPY BINARY_INTEGER,
359: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
360: x_header_record IN rcv_roi_preprocessor.header_rec_type
361: ) IS
362: BEGIN
363: IF (g_asn_debug = 'Y') THEN
364: asn_debug.put_line('enter derive_cust_trans_del ');

Line 413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

409: );
410: END derive_rma_trans_del;
411:
412: PROCEDURE derive_rma_correction_line(
413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
414: n IN OUT NOCOPY BINARY_INTEGER,
415: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
416: x_header_record IN rcv_roi_preprocessor.header_rec_type
417: ) IS

Line 415: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

411:
412: PROCEDURE derive_rma_correction_line(
413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
414: n IN OUT NOCOPY BINARY_INTEGER,
415: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
416: x_header_record IN rcv_roi_preprocessor.header_rec_type
417: ) IS
418: BEGIN
419: IF (g_asn_debug = 'Y') THEN

Line 416: x_header_record IN rcv_roi_preprocessor.header_rec_type

412: PROCEDURE derive_rma_correction_line(
413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
414: n IN OUT NOCOPY BINARY_INTEGER,
415: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
416: x_header_record IN rcv_roi_preprocessor.header_rec_type
417: ) IS
418: BEGIN
419: IF (g_asn_debug = 'Y') THEN
420: asn_debug.put_line('enter derive_correction_line ');

Line 456: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

452: );
453: END derive_rma_correction_line;
454:
455: PROCEDURE default_rma_line(
456: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
457: n IN BINARY_INTEGER,
458: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
459: x_header_record IN rcv_roi_preprocessor.header_rec_type
460: ) IS

Line 459: x_header_record IN rcv_roi_preprocessor.header_rec_type

455: PROCEDURE default_rma_line(
456: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
457: n IN BINARY_INTEGER,
458: x_header_id IN rcv_headers_interface.header_interface_id%TYPE,
459: x_header_record IN rcv_roi_preprocessor.header_rec_type
460: ) IS
461: x_locator_control NUMBER;
462: x_default_subinventory VARCHAR2(10);
463: x_default_locator_id NUMBER;

Line 513: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

509: PROCEDURE NAME: validate_rma_line()
510:
511: ===========================================================================*/
512: PROCEDURE validate_rma_line(
513: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
514: n IN BINARY_INTEGER,
515: x_header_record IN rcv_roi_preprocessor.header_rec_type
516: ) IS
517: BEGIN

Line 515: x_header_record IN rcv_roi_preprocessor.header_rec_type

511: ===========================================================================*/
512: PROCEDURE validate_rma_line(
513: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
514: n IN BINARY_INTEGER,
515: x_header_record IN rcv_roi_preprocessor.header_rec_type
516: ) IS
517: BEGIN
518: IF (g_asn_debug = 'Y') THEN
519: asn_debug.put_line('Enter validate_rma_line');

Line 568: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

564: /**
565: * Helper procedures for derive_rma_lines
566: */
567: PROCEDURE derive_uom_info(
568: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
569: n IN BINARY_INTEGER
570: ) IS
571: BEGIN
572: -- primary uom

Line 623: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

619: END IF;
620: END derive_uom_info;
621:
622: PROCEDURE derive_order_header_info(
623: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
624: n IN BINARY_INTEGER
625: ) IS
626: BEGIN
627: -- bug 3223993 - derive oe_order_num and document num from each other

Line 695: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

691: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
692: END derive_order_header_info;
693:
694: PROCEDURE derive_order_line_info(
695: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
696: n IN BINARY_INTEGER
697: ) IS
698: my_line_id NUMBER;
699: my_item_id NUMBER;

Line 743: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

739: rcv_error_pkg.log_interface_error('OE_ORDER_NUM', FALSE);
740: END derive_order_line_info;
741:
742: PROCEDURE derive_document_line_info(
743: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
744: n IN BINARY_INTEGER
745: ) IS
746: BEGIN
747: IF x_cascaded_table(n).error_status IN('S', 'W')

Line 759: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

755: END IF;
756: END derive_document_line_info;
757:
758: PROCEDURE derive_customer_info(
759: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
760: n IN BINARY_INTEGER
761: ) IS
762: BEGIN
763: -- derive customer_id from customer_account_number

Line 820: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

816: END IF;
817: END derive_customer_info;
818:
819: PROCEDURE derive_org_info(
820: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
821: n IN BINARY_INTEGER,
822: x_header_record IN rcv_roi_preprocessor.header_rec_type
823: ) IS
824: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;

Line 822: x_header_record IN rcv_roi_preprocessor.header_rec_type

818:
819: PROCEDURE derive_org_info(
820: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
821: n IN BINARY_INTEGER,
822: x_header_record IN rcv_roi_preprocessor.header_rec_type
823: ) IS
824: ship_to_org_record rcv_shipment_object_sv.organization_id_record_type;
825: BEGIN
826: -- derive from location_info

Line 908: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

904: END IF;
905: END derive_org_info;
906:
907: PROCEDURE derive_transit_org_info(
908: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
909: n IN BINARY_INTEGER
910: ) IS
911: transit_org_record rcv_shipment_object_sv.organization_id_record_type;
912: BEGIN

Line 945: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

941: END IF;
942: END derive_transit_org_info;
943:
944: PROCEDURE derive_deliver_to_info(
945: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
946: n IN BINARY_INTEGER
947: ) IS
948: employee_id_record rcv_shipment_object_sv.employee_id_record_type;
949: location_id_record rcv_shipment_object_sv.location_id_record_type;

Line 1006: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1002: END IF;
1003: END derive_deliver_to_info;
1004:
1005: PROCEDURE derive_auto_transact_info(
1006: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1007: n IN BINARY_INTEGER
1008: ) IS
1009: BEGIN
1010: IF (x_cascaded_table(n).error_status IN('S', 'W'))

Line 1022: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1018: END IF;
1019: END derive_auto_transact_info;
1020:
1021: PROCEDURE explode_line_quantity(
1022: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1023: n IN OUT NOCOPY BINARY_INTEGER,
1024: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1025: x_header_record IN rcv_roi_preprocessor.header_rec_type
1026: ) IS

Line 1024: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1020:
1021: PROCEDURE explode_line_quantity(
1022: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1023: n IN OUT NOCOPY BINARY_INTEGER,
1024: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1025: x_header_record IN rcv_roi_preprocessor.header_rec_type
1026: ) IS
1027: -- declare the line cursor
1028: /* Bug 4740567

Line 1025: x_header_record IN rcv_roi_preprocessor.header_rec_type

1021: PROCEDURE explode_line_quantity(
1022: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1023: n IN OUT NOCOPY BINARY_INTEGER,
1024: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1025: x_header_record IN rcv_roi_preprocessor.header_rec_type
1026: ) IS
1027: -- declare the line cursor
1028: /* Bug 4740567
1029: * Include oe order line_id also in addition to line_num since

Line 1716: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1712: END IF;
1713: END explode_line_quantity;
1714:
1715: PROCEDURE default_source_info(
1716: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1717: n IN BINARY_INTEGER,
1718: x_header_id IN rcv_headers_interface.header_interface_id%TYPE
1719: ) IS
1720: BEGIN

Line 1763: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1759: /* Bug3593237 - END */
1760: END default_source_info;
1761:
1762: PROCEDURE default_destination_info(
1763: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1764: n IN BINARY_INTEGER
1765: ) IS
1766: BEGIN
1767: IF x_cascaded_table(n).destination_type_code IS NULL

Line 1802: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1798: END IF;
1799: END default_destination_info;
1800:
1801: PROCEDURE default_transaction_info(
1802: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1803: n IN BINARY_INTEGER
1804: ) IS
1805: BEGIN
1806: IF x_cascaded_table(n).transaction_type IS NULL THEN

Line 1816: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1812: END IF;
1813: END default_transaction_info;
1814:
1815: PROCEDURE default_processing_info(
1816: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1817: n IN BINARY_INTEGER
1818: ) IS
1819: BEGIN
1820: IF x_cascaded_table(n).processing_mode_code IS NULL THEN

Line 1842: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1838: END IF;
1839: END default_processing_info;
1840:
1841: PROCEDURE default_routing_info(
1842: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1843: n IN BINARY_INTEGER
1844: ) IS
1845: x_inspection_required_flag VARCHAR2(1);
1846: BEGIN

Line 1877: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1873: END IF;
1874: END default_routing_info;
1875:
1876: PROCEDURE default_from_header(
1877: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1878: n IN BINARY_INTEGER,
1879: x_header_record IN rcv_roi_preprocessor.header_rec_type
1880: ) IS
1881: BEGIN

Line 1879: x_header_record IN rcv_roi_preprocessor.header_rec_type

1875:
1876: PROCEDURE default_from_header(
1877: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1878: n IN BINARY_INTEGER,
1879: x_header_record IN rcv_roi_preprocessor.header_rec_type
1880: ) IS
1881: BEGIN
1882: default_customer_header(x_cascaded_table,
1883: n,

Line 1942: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1938: );
1939: END default_from_header;
1940:
1941: PROCEDURE default_item_info(
1942: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1943: n IN BINARY_INTEGER
1944: ) IS
1945: item_id_record rcv_shipment_line_sv.item_id_record_type;
1946: l_category_set_id mtl_category_sets_b.category_set_id%TYPE;

Line 2015: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2011: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2012: END default_item_info;
2013:
2014: PROCEDURE default_from_rma(
2015: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2016: n IN BINARY_INTEGER
2017: ) IS
2018: default_rma_record default_rma%ROWTYPE;
2019: BEGIN

Line 2090: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2086: CLOSE default_rma;
2087: END default_from_rma;
2088:
2089: PROCEDURE default_ship_to_info_rma(
2090: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2091: n IN BINARY_INTEGER,
2092: default_rma_record IN default_rma%ROWTYPE
2093: ) IS
2094: BEGIN

Line 2108: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2104: END IF;
2105: END default_ship_to_info_rma;
2106:
2107: PROCEDURE default_customer_header(
2108: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2109: n IN BINARY_INTEGER,
2110: x_header_record IN rcv_roi_preprocessor.header_rec_type
2111: ) IS
2112: BEGIN

Line 2110: x_header_record IN rcv_roi_preprocessor.header_rec_type

2106:
2107: PROCEDURE default_customer_header(
2108: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2109: n IN BINARY_INTEGER,
2110: x_header_record IN rcv_roi_preprocessor.header_rec_type
2111: ) IS
2112: BEGIN
2113: IF ( x_cascaded_table(n).error_status IN('S', 'W')
2114: AND x_cascaded_table(n).customer_id IS NULL) THEN

Line 2136: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2132: END IF;
2133: END default_customer_header;
2134:
2135: PROCEDURE default_customer_site_header(
2136: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2137: n IN BINARY_INTEGER,
2138: x_header_record IN rcv_roi_preprocessor.header_rec_type
2139: ) IS
2140: BEGIN

Line 2138: x_header_record IN rcv_roi_preprocessor.header_rec_type

2134:
2135: PROCEDURE default_customer_site_header(
2136: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2137: n IN BINARY_INTEGER,
2138: x_header_record IN rcv_roi_preprocessor.header_rec_type
2139: ) IS
2140: BEGIN
2141: IF ( x_cascaded_table(n).error_status IN('S', 'W')
2142: AND x_cascaded_table(n).customer_site_id IS NULL) THEN

Line 2164: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2160: END IF;
2161: END default_customer_site_header;
2162:
2163: PROCEDURE default_from_org_header(
2164: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2165: n IN BINARY_INTEGER,
2166: x_header_record IN rcv_roi_preprocessor.header_rec_type
2167: ) IS
2168: BEGIN

Line 2166: x_header_record IN rcv_roi_preprocessor.header_rec_type

2162:
2163: PROCEDURE default_from_org_header(
2164: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2165: n IN BINARY_INTEGER,
2166: x_header_record IN rcv_roi_preprocessor.header_rec_type
2167: ) IS
2168: BEGIN
2169: IF x_cascaded_table(n).from_organization_id IS NULL
2170: AND x_cascaded_table(n).from_organization_code IS NULL THEN

Line 2182: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2178: END IF;
2179: END default_from_org_header;
2180:
2181: PROCEDURE default_ship_to_header(
2182: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2183: n IN BINARY_INTEGER,
2184: x_header_record IN rcv_roi_preprocessor.header_rec_type
2185: ) IS
2186: BEGIN

Line 2184: x_header_record IN rcv_roi_preprocessor.header_rec_type

2180:
2181: PROCEDURE default_ship_to_header(
2182: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2183: n IN BINARY_INTEGER,
2184: x_header_record IN rcv_roi_preprocessor.header_rec_type
2185: ) IS
2186: BEGIN
2187: -- ship_to_org
2188: IF x_cascaded_table(n).to_organization_id IS NULL

Line 2212: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2208: END IF;
2209: END default_ship_to_header;
2210:
2211: PROCEDURE default_currency_info_header(
2212: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2213: n IN BINARY_INTEGER,
2214: x_header_record IN rcv_roi_preprocessor.header_rec_type
2215: ) IS
2216: BEGIN

Line 2214: x_header_record IN rcv_roi_preprocessor.header_rec_type

2210:
2211: PROCEDURE default_currency_info_header(
2212: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2213: n IN BINARY_INTEGER,
2214: x_header_record IN rcv_roi_preprocessor.header_rec_type
2215: ) IS
2216: BEGIN
2217: IF x_cascaded_table(n).currency_code IS NULL
2218: AND x_cascaded_table(n).currency_conversion_type IS NULL

Line 2236: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2232: END IF;
2233: END default_currency_info_header;
2234:
2235: PROCEDURE default_shipment_num_header(
2236: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2237: n IN BINARY_INTEGER,
2238: x_header_record IN rcv_roi_preprocessor.header_rec_type
2239: ) IS
2240: BEGIN

Line 2238: x_header_record IN rcv_roi_preprocessor.header_rec_type

2234:
2235: PROCEDURE default_shipment_num_header(
2236: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2237: n IN BINARY_INTEGER,
2238: x_header_record IN rcv_roi_preprocessor.header_rec_type
2239: ) IS
2240: BEGIN
2241: IF x_cascaded_table(n).shipment_num IS NULL THEN
2242: x_cascaded_table(n).shipment_num := x_header_record.header_record.shipment_num;

Line 2251: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2247: END IF;
2248: END default_shipment_num_header;
2249:
2250: PROCEDURE default_freight_carrier_header(
2251: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2252: n IN BINARY_INTEGER,
2253: x_header_record IN rcv_roi_preprocessor.header_rec_type
2254: ) IS
2255: BEGIN

Line 2253: x_header_record IN rcv_roi_preprocessor.header_rec_type

2249:
2250: PROCEDURE default_freight_carrier_header(
2251: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2252: n IN BINARY_INTEGER,
2253: x_header_record IN rcv_roi_preprocessor.header_rec_type
2254: ) IS
2255: BEGIN
2256: IF x_cascaded_table(n).freight_carrier_code IS NULL THEN
2257: x_cascaded_table(n).freight_carrier_code := x_header_record.header_record.freight_carrier_code;

Line 2266: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2262: END IF;
2263: END default_freight_carrier_header;
2264:
2265: PROCEDURE default_bill_of_lading_header(
2266: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2267: n IN BINARY_INTEGER,
2268: x_header_record IN rcv_roi_preprocessor.header_rec_type
2269: ) IS
2270: BEGIN

Line 2268: x_header_record IN rcv_roi_preprocessor.header_rec_type

2264:
2265: PROCEDURE default_bill_of_lading_header(
2266: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2267: n IN BINARY_INTEGER,
2268: x_header_record IN rcv_roi_preprocessor.header_rec_type
2269: ) IS
2270: BEGIN
2271: IF x_cascaded_table(n).bill_of_lading IS NULL THEN
2272: x_cascaded_table(n).bill_of_lading := x_header_record.header_record.bill_of_lading;

Line 2281: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2277: END IF;
2278: END default_bill_of_lading_header;
2279:
2280: PROCEDURE default_packing_slip_header(
2281: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2282: n IN BINARY_INTEGER,
2283: x_header_record IN rcv_roi_preprocessor.header_rec_type
2284: ) IS
2285: BEGIN

Line 2283: x_header_record IN rcv_roi_preprocessor.header_rec_type

2279:
2280: PROCEDURE default_packing_slip_header(
2281: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2282: n IN BINARY_INTEGER,
2283: x_header_record IN rcv_roi_preprocessor.header_rec_type
2284: ) IS
2285: BEGIN
2286: IF x_cascaded_table(n).packing_slip IS NULL THEN
2287: x_cascaded_table(n).packing_slip := x_header_record.header_record.packing_slip;

Line 2296: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2292: END IF;
2293: END default_packing_slip_header;
2294:
2295: PROCEDURE default_ship_date_header(
2296: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2297: n IN BINARY_INTEGER,
2298: x_header_record IN rcv_roi_preprocessor.header_rec_type
2299: ) IS
2300: BEGIN

Line 2298: x_header_record IN rcv_roi_preprocessor.header_rec_type

2294:
2295: PROCEDURE default_ship_date_header(
2296: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2297: n IN BINARY_INTEGER,
2298: x_header_record IN rcv_roi_preprocessor.header_rec_type
2299: ) IS
2300: BEGIN
2301: IF x_cascaded_table(n).shipped_date IS NULL THEN
2302: x_cascaded_table(n).shipped_date := x_header_record.header_record.shipped_date;

Line 2311: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2307: END IF;
2308: END default_ship_date_header;
2309:
2310: PROCEDURE default_receipt_date_header(
2311: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2312: n IN BINARY_INTEGER,
2313: x_header_record IN rcv_roi_preprocessor.header_rec_type
2314: ) IS
2315: BEGIN

Line 2313: x_header_record IN rcv_roi_preprocessor.header_rec_type

2309:
2310: PROCEDURE default_receipt_date_header(
2311: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2312: n IN BINARY_INTEGER,
2313: x_header_record IN rcv_roi_preprocessor.header_rec_type
2314: ) IS
2315: BEGIN
2316: IF x_cascaded_table(n).expected_receipt_date IS NULL THEN
2317: x_cascaded_table(n).expected_receipt_date := x_header_record.header_record.expected_receipt_date;

Line 2326: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2322: END IF;
2323: END default_receipt_date_header;
2324:
2325: PROCEDURE default_num_containers_header(
2326: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2327: n IN BINARY_INTEGER,
2328: x_header_record IN rcv_roi_preprocessor.header_rec_type
2329: ) IS
2330: BEGIN

Line 2328: x_header_record IN rcv_roi_preprocessor.header_rec_type

2324:
2325: PROCEDURE default_num_containers_header(
2326: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2327: n IN BINARY_INTEGER,
2328: x_header_record IN rcv_roi_preprocessor.header_rec_type
2329: ) IS
2330: BEGIN
2331: IF x_cascaded_table(n).num_of_containers IS NULL THEN
2332: x_cascaded_table(n).num_of_containers := x_header_record.header_record.num_of_containers;

Line 2341: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2337: END IF;
2338: END default_num_containers_header;
2339:
2340: PROCEDURE default_waybill_header(
2341: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2342: n IN BINARY_INTEGER,
2343: x_header_record IN rcv_roi_preprocessor.header_rec_type
2344: ) IS
2345: BEGIN

Line 2343: x_header_record IN rcv_roi_preprocessor.header_rec_type

2339:
2340: PROCEDURE default_waybill_header(
2341: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2342: n IN BINARY_INTEGER,
2343: x_header_record IN rcv_roi_preprocessor.header_rec_type
2344: ) IS
2345: BEGIN
2346: IF x_cascaded_table(n).waybill_airbill_num IS NULL THEN
2347: x_cascaded_table(n).waybill_airbill_num := x_header_record.header_record.waybill_airbill_num;

Line 2356: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2352: END IF;
2353: END default_waybill_header;
2354:
2355: PROCEDURE default_tax_name_header(
2356: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2357: n IN BINARY_INTEGER,
2358: x_header_record IN rcv_roi_preprocessor.header_rec_type
2359: ) IS
2360: BEGIN

Line 2358: x_header_record IN rcv_roi_preprocessor.header_rec_type

2354:
2355: PROCEDURE default_tax_name_header(
2356: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2357: n IN BINARY_INTEGER,
2358: x_header_record IN rcv_roi_preprocessor.header_rec_type
2359: ) IS
2360: BEGIN
2361: IF x_cascaded_table(n).tax_name IS NULL THEN
2362: x_cascaded_table(n).tax_name := x_header_record.header_record.tax_name;

Line 2371: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2367: END IF;
2368: END default_tax_name_header;
2369:
2370: PROCEDURE validate_freight_carrier_info(
2371: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2372: n IN BINARY_INTEGER
2373: ) IS
2374: BEGIN
2375: NULL;

Line 2379: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2375: NULL;
2376: END validate_freight_carrier_info;
2377:
2378: PROCEDURE validate_qty_invoiced(
2379: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2380: n IN BINARY_INTEGER
2381: ) IS
2382: BEGIN
2383: NULL;

Line 2387: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2383: NULL;
2384: END validate_qty_invoiced;
2385:
2386: PROCEDURE validate_uom_info(
2387: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2388: n IN BINARY_INTEGER
2389: ) IS
2390: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
2391: BEGIN

Line 2430: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2426: );
2427: END validate_uom_info;
2428:
2429: PROCEDURE validate_item_info(
2430: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2431: n IN BINARY_INTEGER
2432: ) IS
2433: item_revision_record rcv_shipment_line_sv.item_id_record_type;
2434: item_id_record rcv_shipment_line_sv.item_id_record_type;

Line 2517: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2513: NULL;
2514: END validate_item_info;
2515:
2516: PROCEDURE validate_txn_date(
2517: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2518: n IN BINARY_INTEGER
2519: ) IS
2520: x_sob_id NUMBER;
2521: x_val_open_ok BOOLEAN;

Line 2608: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2604: NULL;
2605: END validate_txn_date;
2606:
2607: PROCEDURE validate_freight_carrier_code(
2608: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2609: n IN BINARY_INTEGER
2610: ) IS
2611: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
2612: BEGIN

Line 2639: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2635: END IF;
2636: END validate_freight_carrier_code;
2637:
2638: PROCEDURE validate_destination_type(
2639: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2640: n IN BINARY_INTEGER
2641: ) IS
2642: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
2643: BEGIN

Line 2670: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2666: );
2667: END validate_destination_type;
2668:
2669: PROCEDURE validate_deliver_to_info(
2670: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2671: n IN BINARY_INTEGER
2672: ) IS
2673: employee_record rcv_shipment_line_sv.employee_record_type;
2674: BEGIN

Line 2703: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2699: );
2700: END validate_deliver_to_info;
2701:
2702: PROCEDURE validate_tax_name(
2703: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2704: n IN BINARY_INTEGER
2705: ) IS
2706: BEGIN
2707: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 2717: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2713: END IF;
2714: END validate_tax_name;
2715:
2716: PROCEDURE validate_country_of_origin(
2717: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2718: n IN BINARY_INTEGER
2719: ) IS
2720: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
2721: BEGIN

Line 2987: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2983: END IF;
2984: END validate_item_revision;
2985:
2986: PROCEDURE validate_ref_integrity(
2987: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2988: n IN BINARY_INTEGER
2989: ) IS
2990: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
2991: x_customer_id rcv_transactions_interface.customer_id%TYPE;