94: FROM rcv_transactions_interface rti
95: WHERE interface_transaction_id = v_parent_inter_trx_id;
96:
97: PROCEDURE derive_return_line (
98: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
99: n IN OUT NOCOPY BINARY_INTEGER,
100: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
101: x_header_record IN rcv_roi_preprocessor.header_rec_type
102: );
96:
97: PROCEDURE derive_return_line (
98: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
99: n IN OUT NOCOPY BINARY_INTEGER,
100: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
101: x_header_record IN rcv_roi_preprocessor.header_rec_type
102: );
103:
104: PROCEDURE default_return_line (
97: PROCEDURE derive_return_line (
98: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
99: n IN OUT NOCOPY BINARY_INTEGER,
100: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
101: x_header_record IN rcv_roi_preprocessor.header_rec_type
102: );
103:
104: PROCEDURE default_return_line (
105: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
101: x_header_record IN rcv_roi_preprocessor.header_rec_type
102: );
103:
104: PROCEDURE default_return_line (
105: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
106: n IN BINARY_INTEGER
107: );
108:
109: PROCEDURE derive_return_line_qty (
106: n IN BINARY_INTEGER
107: );
108:
109: PROCEDURE derive_return_line_qty (
110: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
111: n IN OUT NOCOPY BINARY_INTEGER,
112: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
113: );
114:
108:
109: PROCEDURE derive_return_line_qty (
110: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
111: n IN OUT NOCOPY BINARY_INTEGER,
112: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
113: );
114:
115: PROCEDURE derive_reason_info (
116: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
112: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type
113: );
114:
115: PROCEDURE derive_reason_info (
116: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
117: n IN OUT NOCOPY BINARY_INTEGER
118: );
119:
120: PROCEDURE derive_ship_to_org_info (
117: n IN OUT NOCOPY BINARY_INTEGER
118: );
119:
120: PROCEDURE derive_ship_to_org_info (
121: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
122: n IN OUT NOCOPY BINARY_INTEGER,
123: x_header_record IN rcv_roi_preprocessor.header_rec_type
124: );
125:
119:
120: PROCEDURE derive_ship_to_org_info (
121: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
122: n IN OUT NOCOPY BINARY_INTEGER,
123: x_header_record IN rcv_roi_preprocessor.header_rec_type
124: );
125:
126: PROCEDURE default_common_lines (
127: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
123: x_header_record IN rcv_roi_preprocessor.header_rec_type
124: );
125:
126: PROCEDURE default_common_lines (
127: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
128: n IN BINARY_INTEGER
129: );
130:
131: PROCEDURE default_po_info (
128: n IN BINARY_INTEGER
129: );
130:
131: PROCEDURE default_po_info (
132: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
133: n IN BINARY_INTEGER,
134: default_return_rec IN default_return%ROWTYPE
135: );
136:
134: default_return_rec IN default_return%ROWTYPE
135: );
136:
137: PROCEDURE default_shipment_info (
138: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
139: n IN BINARY_INTEGER,
140: default_return_rec IN default_return%ROWTYPE
141: );
142:
140: default_return_rec IN default_return%ROWTYPE
141: );
142:
143: PROCEDURE default_wip_info (
144: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
145: n IN BINARY_INTEGER,
146: default_return_rec IN default_return%ROWTYPE
147: );
148:
146: default_return_rec IN default_return%ROWTYPE
147: );
148:
149: PROCEDURE default_oe_info (
150: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
151: n IN BINARY_INTEGER,
152: default_return_rec IN default_return%ROWTYPE
153: );
154:
152: default_return_rec IN default_return%ROWTYPE
153: );
154:
155: PROCEDURE default_currency_info (
156: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
157: n IN BINARY_INTEGER,
158: default_return_rec IN default_return%ROWTYPE
159: );
160:
158: default_return_rec IN default_return%ROWTYPE
159: );
160:
161: PROCEDURE default_vendor_info (
162: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
163: n IN BINARY_INTEGER,
164: default_return_rec IN default_return%ROWTYPE
165: );
166:
164: default_return_rec IN default_return%ROWTYPE
165: );
166:
167: PROCEDURE default_customer_info (
168: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
169: n IN BINARY_INTEGER,
170: default_return_rec IN default_return%ROWTYPE
171: );
172:
170: default_return_rec IN default_return%ROWTYPE
171: );
172:
173: PROCEDURE default_deliver_to_info (
174: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
175: n IN BINARY_INTEGER,
176: default_return_rec IN default_return%ROWTYPE
177: );
178:
176: default_return_rec IN default_return%ROWTYPE
177: );
178:
179: PROCEDURE default_source_info (
180: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
181: n IN BINARY_INTEGER,
182: default_return_rec IN default_return%ROWTYPE
183: );
184:
182: default_return_rec IN default_return%ROWTYPE
183: );
184:
185: PROCEDURE default_item_info (
186: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
187: n IN BINARY_INTEGER,
188: default_return_rec IN default_return%ROWTYPE
189: );
190:
188: default_return_rec IN default_return%ROWTYPE
189: );
190:
191: PROCEDURE default_destination_info (
192: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
193: n IN BINARY_INTEGER,
194: default_return_rec IN default_return%ROWTYPE
195: );
196:
194: default_return_rec IN default_return%ROWTYPE
195: );
196:
197: PROCEDURE default_location_info (
198: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
199: n IN BINARY_INTEGER,
200: default_return_rec IN default_return%ROWTYPE
201: );
202:
200: default_return_rec IN default_return%ROWTYPE
201: );
202:
203: PROCEDURE default_movement_id (
204: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
205: n IN BINARY_INTEGER,
206: default_return_rec IN default_return%ROWTYPE
207: );
208:
206: default_return_rec IN default_return%ROWTYPE
207: );
208:
209: PROCEDURE default_bom_resource_id (
210: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
211: n IN BINARY_INTEGER,
212: default_return_rec IN default_return%ROWTYPE
213: );
214:
212: default_return_rec IN default_return%ROWTYPE
213: );
214:
215: PROCEDURE derive_inv_qty (
216: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
217: n IN BINARY_INTEGER
218: );
219:
220: PROCEDURE derive_inv_qty_1(