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 242: p_line_num rcv_shipment_lines.line_num%TYPE,

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

Line 243: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE

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

Line 245: RETURN rcv_shipment_lines%ROWTYPE IS

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

Line 259: FROM rcv_shipment_lines

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

Line 276: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE

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

Line 278: RETURN rcv_shipment_lines%ROWTYPE IS

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

Line 290: FROM rcv_shipment_lines

286: END IF;
287:
288: SELECT *
289: INTO g_rsl_row
290: FROM rcv_shipment_lines
291: WHERE shipment_line_id = p_shipment_line_id;
292:
293: RETURN g_rsl_row;
294: EXCEPTION

Line 300: p_rsl_row IN rcv_shipment_lines%ROWTYPE

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

Line 305: UPDATE rcv_shipment_lines

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