APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_SHIPMENT_LINES

Line 8: g_rsl_row rcv_shipment_lines%ROWTYPE;

4: g_rhi_row rcv_headers_interface%ROWTYPE;
5: g_rti_row rcv_transactions_interface%ROWTYPE;
6: g_rt_row rcv_transactions%ROWTYPE;
7: g_rsh_row rcv_shipment_headers%ROWTYPE;
8: g_rsl_row rcv_shipment_lines%ROWTYPE;
9: g_poh_row po_headers_all%ROWTYPE;
10: g_pol_row po_lines_all%ROWTYPE;
11: g_pll_row po_line_locations_all%ROWTYPE;
12: g_pod_row po_distributions_all%ROWTYPE;

Line 245: p_line_num rcv_shipment_lines.line_num%TYPE,

241: /*******/
242: /* RSL */
243: /*******/
244: FUNCTION get_rsl_row_from_num(
245: p_line_num rcv_shipment_lines.line_num%TYPE,
246: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
247: )
248: RETURN rcv_shipment_lines%ROWTYPE IS
249: BEGIN

Line 246: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE

242: /* RSL */
243: /*******/
244: FUNCTION get_rsl_row_from_num(
245: p_line_num rcv_shipment_lines.line_num%TYPE,
246: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
247: )
248: RETURN rcv_shipment_lines%ROWTYPE IS
249: BEGIN
250: IF ( p_line_num IS NULL

Line 248: RETURN rcv_shipment_lines%ROWTYPE IS

244: FUNCTION get_rsl_row_from_num(
245: p_line_num rcv_shipment_lines.line_num%TYPE,
246: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE
247: )
248: RETURN rcv_shipment_lines%ROWTYPE IS
249: BEGIN
250: IF ( p_line_num IS NULL
251: OR p_shipment_header_id IS NULL) THEN
252: RETURN NULL;

Line 262: FROM rcv_shipment_lines

258: END IF;
259:
260: SELECT *
261: INTO g_rsl_row
262: FROM rcv_shipment_lines
263: WHERE line_num = p_line_num
264: AND shipment_header_id = p_shipment_header_id;
265:
266: RETURN g_rsl_row;

Line 279: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE

275: RETURN NULL;
276: END get_rsl_row_from_num;
277:
278: FUNCTION get_rsl_row_from_id(
279: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
280: )
281: RETURN rcv_shipment_lines%ROWTYPE IS
282: BEGIN
283: IF (p_shipment_line_id IS NULL) THEN

Line 281: RETURN rcv_shipment_lines%ROWTYPE IS

277:
278: FUNCTION get_rsl_row_from_id(
279: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
280: )
281: RETURN rcv_shipment_lines%ROWTYPE IS
282: BEGIN
283: IF (p_shipment_line_id IS NULL) THEN
284: RETURN NULL;
285: END IF;

Line 293: FROM rcv_shipment_lines

289: END IF;
290:
291: SELECT *
292: INTO g_rsl_row
293: FROM rcv_shipment_lines
294: WHERE shipment_line_id = p_shipment_line_id;
295:
296: RETURN g_rsl_row;
297: EXCEPTION

Line 303: p_rsl_row IN rcv_shipment_lines%ROWTYPE

299: invalid_value(p_shipment_line_id, 'SHIPMENT_LINE_ID');
300: END get_rsl_row_from_id;
301:
302: PROCEDURE update_rsl_row(
303: p_rsl_row IN rcv_shipment_lines%ROWTYPE
304: ) IS
305: BEGIN
306: asn_debug.put_line('Updating RSL SHIPMENT_LINE_ID=' || p_rsl_row.shipment_line_id);
307:

Line 308: UPDATE rcv_shipment_lines

304: ) IS
305: BEGIN
306: asn_debug.put_line('Updating RSL SHIPMENT_LINE_ID=' || p_rsl_row.shipment_line_id);
307:
308: UPDATE rcv_shipment_lines
309: SET ROW = p_rsl_row
310: WHERE shipment_line_id = p_rsl_row.shipment_line_id;
311:
312: g_rsl_row := p_rsl_row;