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 569: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 624: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 696: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 744: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 760: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 821: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 823: x_header_record IN rcv_roi_preprocessor.header_rec_type

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

Line 909: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 946: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1007: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1023: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1025: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1026: x_header_record IN rcv_roi_preprocessor.header_rec_type

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

Line 1719: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1766: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1805: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1819: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

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

Line 1845: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1841: END IF;
1842: END default_processing_info;
1843:
1844: PROCEDURE default_routing_info(
1845: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1846: n IN BINARY_INTEGER
1847: ) IS
1848: x_inspection_required_flag VARCHAR2(1);
1849: l_client_code VARCHAR(40); /* Bug 9169143: LSP Changes */

Line 1911: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1907:
1908: END default_routing_info;
1909:
1910: PROCEDURE default_from_header(
1911: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1912: n IN BINARY_INTEGER,
1913: x_header_record IN rcv_roi_preprocessor.header_rec_type
1914: ) IS
1915: BEGIN

Line 1913: x_header_record IN rcv_roi_preprocessor.header_rec_type

1909:
1910: PROCEDURE default_from_header(
1911: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1912: n IN BINARY_INTEGER,
1913: x_header_record IN rcv_roi_preprocessor.header_rec_type
1914: ) IS
1915: BEGIN
1916: default_customer_header(x_cascaded_table,
1917: n,

Line 1976: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

1972: );
1973: END default_from_header;
1974:
1975: PROCEDURE default_item_info(
1976: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1977: n IN BINARY_INTEGER
1978: ) IS
1979: item_id_record rcv_shipment_line_sv.item_id_record_type;
1980: l_category_set_id mtl_category_sets_b.category_set_id%TYPE;

Line 2049: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2045: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
2046: END default_item_info;
2047:
2048: PROCEDURE default_from_rma(
2049: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2050: n IN BINARY_INTEGER
2051: ) IS
2052: default_rma_record default_rma%ROWTYPE;
2053: BEGIN

Line 2124: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2120: CLOSE default_rma;
2121: END default_from_rma;
2122:
2123: PROCEDURE default_ship_to_info_rma(
2124: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2125: n IN BINARY_INTEGER,
2126: default_rma_record IN default_rma%ROWTYPE
2127: ) IS
2128: BEGIN

Line 2142: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2138: END IF;
2139: END default_ship_to_info_rma;
2140:
2141: PROCEDURE default_customer_header(
2142: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2143: n IN BINARY_INTEGER,
2144: x_header_record IN rcv_roi_preprocessor.header_rec_type
2145: ) IS
2146: BEGIN

Line 2144: x_header_record IN rcv_roi_preprocessor.header_rec_type

2140:
2141: PROCEDURE default_customer_header(
2142: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2143: n IN BINARY_INTEGER,
2144: x_header_record IN rcv_roi_preprocessor.header_rec_type
2145: ) IS
2146: BEGIN
2147: IF ( x_cascaded_table(n).error_status IN('S', 'W')
2148: AND x_cascaded_table(n).customer_id IS NULL) THEN

Line 2170: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2166: END IF;
2167: END default_customer_header;
2168:
2169: PROCEDURE default_customer_site_header(
2170: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2171: n IN BINARY_INTEGER,
2172: x_header_record IN rcv_roi_preprocessor.header_rec_type
2173: ) IS
2174: BEGIN

Line 2172: x_header_record IN rcv_roi_preprocessor.header_rec_type

2168:
2169: PROCEDURE default_customer_site_header(
2170: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2171: n IN BINARY_INTEGER,
2172: x_header_record IN rcv_roi_preprocessor.header_rec_type
2173: ) IS
2174: BEGIN
2175: IF ( x_cascaded_table(n).error_status IN('S', 'W')
2176: AND x_cascaded_table(n).customer_site_id IS NULL) THEN

Line 2198: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2194: END IF;
2195: END default_customer_site_header;
2196:
2197: PROCEDURE default_from_org_header(
2198: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2199: n IN BINARY_INTEGER,
2200: x_header_record IN rcv_roi_preprocessor.header_rec_type
2201: ) IS
2202: BEGIN

Line 2200: x_header_record IN rcv_roi_preprocessor.header_rec_type

2196:
2197: PROCEDURE default_from_org_header(
2198: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2199: n IN BINARY_INTEGER,
2200: x_header_record IN rcv_roi_preprocessor.header_rec_type
2201: ) IS
2202: BEGIN
2203: IF x_cascaded_table(n).from_organization_id IS NULL
2204: AND x_cascaded_table(n).from_organization_code IS NULL THEN

Line 2216: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2212: END IF;
2213: END default_from_org_header;
2214:
2215: PROCEDURE default_ship_to_header(
2216: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2217: n IN BINARY_INTEGER,
2218: x_header_record IN rcv_roi_preprocessor.header_rec_type
2219: ) IS
2220: BEGIN

Line 2218: x_header_record IN rcv_roi_preprocessor.header_rec_type

2214:
2215: PROCEDURE default_ship_to_header(
2216: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2217: n IN BINARY_INTEGER,
2218: x_header_record IN rcv_roi_preprocessor.header_rec_type
2219: ) IS
2220: BEGIN
2221: -- ship_to_org
2222: IF x_cascaded_table(n).to_organization_id IS NULL

Line 2246: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2242: END IF;
2243: END default_ship_to_header;
2244:
2245: PROCEDURE default_currency_info_header(
2246: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2247: n IN BINARY_INTEGER,
2248: x_header_record IN rcv_roi_preprocessor.header_rec_type
2249: ) IS
2250: BEGIN

Line 2248: x_header_record IN rcv_roi_preprocessor.header_rec_type

2244:
2245: PROCEDURE default_currency_info_header(
2246: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2247: n IN BINARY_INTEGER,
2248: x_header_record IN rcv_roi_preprocessor.header_rec_type
2249: ) IS
2250: BEGIN
2251: IF x_cascaded_table(n).currency_code IS NULL
2252: AND x_cascaded_table(n).currency_conversion_type IS NULL

Line 2270: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2266: END IF;
2267: END default_currency_info_header;
2268:
2269: PROCEDURE default_shipment_num_header(
2270: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2271: n IN BINARY_INTEGER,
2272: x_header_record IN rcv_roi_preprocessor.header_rec_type
2273: ) IS
2274: BEGIN

Line 2272: x_header_record IN rcv_roi_preprocessor.header_rec_type

2268:
2269: PROCEDURE default_shipment_num_header(
2270: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2271: n IN BINARY_INTEGER,
2272: x_header_record IN rcv_roi_preprocessor.header_rec_type
2273: ) IS
2274: BEGIN
2275: IF x_cascaded_table(n).shipment_num IS NULL THEN
2276: x_cascaded_table(n).shipment_num := x_header_record.header_record.shipment_num;

Line 2285: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2281: END IF;
2282: END default_shipment_num_header;
2283:
2284: PROCEDURE default_freight_carrier_header(
2285: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2286: n IN BINARY_INTEGER,
2287: x_header_record IN rcv_roi_preprocessor.header_rec_type
2288: ) IS
2289: BEGIN

Line 2287: x_header_record IN rcv_roi_preprocessor.header_rec_type

2283:
2284: PROCEDURE default_freight_carrier_header(
2285: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2286: n IN BINARY_INTEGER,
2287: x_header_record IN rcv_roi_preprocessor.header_rec_type
2288: ) IS
2289: BEGIN
2290: IF x_cascaded_table(n).freight_carrier_code IS NULL THEN
2291: x_cascaded_table(n).freight_carrier_code := x_header_record.header_record.freight_carrier_code;

Line 2300: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2296: END IF;
2297: END default_freight_carrier_header;
2298:
2299: PROCEDURE default_bill_of_lading_header(
2300: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2301: n IN BINARY_INTEGER,
2302: x_header_record IN rcv_roi_preprocessor.header_rec_type
2303: ) IS
2304: BEGIN

Line 2302: x_header_record IN rcv_roi_preprocessor.header_rec_type

2298:
2299: PROCEDURE default_bill_of_lading_header(
2300: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2301: n IN BINARY_INTEGER,
2302: x_header_record IN rcv_roi_preprocessor.header_rec_type
2303: ) IS
2304: BEGIN
2305: IF x_cascaded_table(n).bill_of_lading IS NULL THEN
2306: x_cascaded_table(n).bill_of_lading := x_header_record.header_record.bill_of_lading;

Line 2315: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2311: END IF;
2312: END default_bill_of_lading_header;
2313:
2314: PROCEDURE default_packing_slip_header(
2315: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2316: n IN BINARY_INTEGER,
2317: x_header_record IN rcv_roi_preprocessor.header_rec_type
2318: ) IS
2319: BEGIN

Line 2317: x_header_record IN rcv_roi_preprocessor.header_rec_type

2313:
2314: PROCEDURE default_packing_slip_header(
2315: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2316: n IN BINARY_INTEGER,
2317: x_header_record IN rcv_roi_preprocessor.header_rec_type
2318: ) IS
2319: BEGIN
2320: IF x_cascaded_table(n).packing_slip IS NULL THEN
2321: x_cascaded_table(n).packing_slip := x_header_record.header_record.packing_slip;

Line 2330: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2326: END IF;
2327: END default_packing_slip_header;
2328:
2329: PROCEDURE default_ship_date_header(
2330: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2331: n IN BINARY_INTEGER,
2332: x_header_record IN rcv_roi_preprocessor.header_rec_type
2333: ) IS
2334: BEGIN

Line 2332: x_header_record IN rcv_roi_preprocessor.header_rec_type

2328:
2329: PROCEDURE default_ship_date_header(
2330: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2331: n IN BINARY_INTEGER,
2332: x_header_record IN rcv_roi_preprocessor.header_rec_type
2333: ) IS
2334: BEGIN
2335: IF x_cascaded_table(n).shipped_date IS NULL THEN
2336: x_cascaded_table(n).shipped_date := x_header_record.header_record.shipped_date;

Line 2345: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2341: END IF;
2342: END default_ship_date_header;
2343:
2344: PROCEDURE default_receipt_date_header(
2345: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2346: n IN BINARY_INTEGER,
2347: x_header_record IN rcv_roi_preprocessor.header_rec_type
2348: ) IS
2349: BEGIN

Line 2347: x_header_record IN rcv_roi_preprocessor.header_rec_type

2343:
2344: PROCEDURE default_receipt_date_header(
2345: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2346: n IN BINARY_INTEGER,
2347: x_header_record IN rcv_roi_preprocessor.header_rec_type
2348: ) IS
2349: BEGIN
2350: IF x_cascaded_table(n).expected_receipt_date IS NULL THEN
2351: x_cascaded_table(n).expected_receipt_date := x_header_record.header_record.expected_receipt_date;

Line 2360: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2356: END IF;
2357: END default_receipt_date_header;
2358:
2359: PROCEDURE default_num_containers_header(
2360: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2361: n IN BINARY_INTEGER,
2362: x_header_record IN rcv_roi_preprocessor.header_rec_type
2363: ) IS
2364: BEGIN

Line 2362: x_header_record IN rcv_roi_preprocessor.header_rec_type

2358:
2359: PROCEDURE default_num_containers_header(
2360: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2361: n IN BINARY_INTEGER,
2362: x_header_record IN rcv_roi_preprocessor.header_rec_type
2363: ) IS
2364: BEGIN
2365: IF x_cascaded_table(n).num_of_containers IS NULL THEN
2366: x_cascaded_table(n).num_of_containers := x_header_record.header_record.num_of_containers;

Line 2375: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2371: END IF;
2372: END default_num_containers_header;
2373:
2374: PROCEDURE default_waybill_header(
2375: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2376: n IN BINARY_INTEGER,
2377: x_header_record IN rcv_roi_preprocessor.header_rec_type
2378: ) IS
2379: BEGIN

Line 2377: x_header_record IN rcv_roi_preprocessor.header_rec_type

2373:
2374: PROCEDURE default_waybill_header(
2375: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2376: n IN BINARY_INTEGER,
2377: x_header_record IN rcv_roi_preprocessor.header_rec_type
2378: ) IS
2379: BEGIN
2380: IF x_cascaded_table(n).waybill_airbill_num IS NULL THEN
2381: x_cascaded_table(n).waybill_airbill_num := x_header_record.header_record.waybill_airbill_num;

Line 2390: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2386: END IF;
2387: END default_waybill_header;
2388:
2389: PROCEDURE default_tax_name_header(
2390: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2391: n IN BINARY_INTEGER,
2392: x_header_record IN rcv_roi_preprocessor.header_rec_type
2393: ) IS
2394: BEGIN

Line 2392: x_header_record IN rcv_roi_preprocessor.header_rec_type

2388:
2389: PROCEDURE default_tax_name_header(
2390: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2391: n IN BINARY_INTEGER,
2392: x_header_record IN rcv_roi_preprocessor.header_rec_type
2393: ) IS
2394: BEGIN
2395: IF x_cascaded_table(n).tax_name IS NULL THEN
2396: x_cascaded_table(n).tax_name := x_header_record.header_record.tax_name;

Line 2405: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2401: END IF;
2402: END default_tax_name_header;
2403:
2404: PROCEDURE validate_freight_carrier_info(
2405: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2406: n IN BINARY_INTEGER
2407: ) IS
2408: BEGIN
2409: NULL;

Line 2413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2409: NULL;
2410: END validate_freight_carrier_info;
2411:
2412: PROCEDURE validate_qty_invoiced(
2413: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2414: n IN BINARY_INTEGER
2415: ) IS
2416: BEGIN
2417: NULL;

Line 2421: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2417: NULL;
2418: END validate_qty_invoiced;
2419:
2420: PROCEDURE validate_uom_info(
2421: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2422: n IN BINARY_INTEGER
2423: ) IS
2424: uom_record rcv_shipment_line_sv.quantity_shipped_record_type;
2425: BEGIN

Line 2464: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2460: );
2461: END validate_uom_info;
2462:
2463: PROCEDURE validate_item_info(
2464: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2465: n IN BINARY_INTEGER
2466: ) IS
2467: item_revision_record rcv_shipment_line_sv.item_id_record_type;
2468: item_id_record rcv_shipment_line_sv.item_id_record_type;

Line 2551: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2547: NULL;
2548: END validate_item_info;
2549:
2550: PROCEDURE validate_txn_date(
2551: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2552: n IN BINARY_INTEGER
2553: ) IS
2554: x_sob_id NUMBER;
2555: x_val_open_ok BOOLEAN;

Line 2747: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2743: NULL;
2744: END validate_txn_date;
2745:
2746: PROCEDURE validate_freight_carrier_code(
2747: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2748: n IN BINARY_INTEGER
2749: ) IS
2750: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
2751: BEGIN

Line 2778: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2774: END IF;
2775: END validate_freight_carrier_code;
2776:
2777: PROCEDURE validate_destination_type(
2778: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2779: n IN BINARY_INTEGER
2780: ) IS
2781: po_lookup_code_record rcv_shipment_line_sv.po_lookup_code_record_type;
2782: BEGIN

Line 2809: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2805: );
2806: END validate_destination_type;
2807:
2808: PROCEDURE validate_deliver_to_info(
2809: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2810: n IN BINARY_INTEGER
2811: ) IS
2812: employee_record rcv_shipment_line_sv.employee_record_type;
2813: BEGIN

Line 2842: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2838: );
2839: END validate_deliver_to_info;
2840:
2841: PROCEDURE validate_tax_name(
2842: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2843: n IN BINARY_INTEGER
2844: ) IS
2845: BEGIN
2846: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 2856: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

2852: END IF;
2853: END validate_tax_name;
2854:
2855: PROCEDURE validate_country_of_origin(
2856: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
2857: n IN BINARY_INTEGER
2858: ) IS
2859: country_of_origin_record rcv_shipment_line_sv.country_of_origin_record_type;
2860: BEGIN

Line 3127: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,

3123: END IF;
3124: END validate_item_revision;
3125:
3126: PROCEDURE validate_ref_integrity(
3127: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
3128: n IN BINARY_INTEGER
3129: ) IS
3130: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
3131: x_customer_id rcv_transactions_interface.customer_id%TYPE;