APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_HEADERS_INTERFACE

Line 4: g_rhi_row rcv_headers_interface%ROWTYPE;

1: PACKAGE BODY rcv_table_functions AS
2: /* $Header: RCVTBFNB.pls 120.4.12010000.3 2008/12/26 07:28:26 ksivasa ship $*/
3: g_debug_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
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;

Line 54: p_header_interface_id IN rcv_headers_interface.header_interface_id%TYPE

50: /*******/
51: /* RHI */
52: /*******/
53: FUNCTION get_rhi_row_from_id(
54: p_header_interface_id IN rcv_headers_interface.header_interface_id%TYPE
55: )
56: RETURN rcv_headers_interface%ROWTYPE IS
57: BEGIN
58: IF (p_header_interface_id IS NULL) THEN

Line 56: RETURN rcv_headers_interface%ROWTYPE IS

52: /*******/
53: FUNCTION get_rhi_row_from_id(
54: p_header_interface_id IN rcv_headers_interface.header_interface_id%TYPE
55: )
56: RETURN rcv_headers_interface%ROWTYPE IS
57: BEGIN
58: IF (p_header_interface_id IS NULL) THEN
59: RETURN NULL;
60: END IF;

Line 68: FROM rcv_headers_interface

64: END IF;
65:
66: SELECT *
67: INTO g_rhi_row
68: FROM rcv_headers_interface
69: WHERE header_interface_id = p_header_interface_id;
70:
71: RETURN g_rhi_row;
72: EXCEPTION

Line 78: p_rhi_row IN rcv_headers_interface%ROWTYPE

74: invalid_value(p_header_interface_id, 'HEADER_INTERFACE_ID');
75: END get_rhi_row_from_id;
76:
77: PROCEDURE update_rhi_row(
78: p_rhi_row IN rcv_headers_interface%ROWTYPE
79: ) IS
80: BEGIN
81: asn_debug.put_line('Updating RHI HEADER_INTERFACE_ID=' || p_rhi_row.header_interface_id);
82:

Line 83: UPDATE rcv_headers_interface

79: ) IS
80: BEGIN
81: asn_debug.put_line('Updating RHI HEADER_INTERFACE_ID=' || p_rhi_row.header_interface_id);
82:
83: UPDATE rcv_headers_interface
84: SET ROW = p_rhi_row
85: WHERE header_interface_id = p_rhi_row.header_interface_id;
86:
87: g_rhi_row := p_rhi_row;