123: FUNCTION get_pvs_row_from_id( p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE )
124: RETURN po_vendor_sites_all%ROWTYPE;
125:
126: FUNCTION get_oeh_row_from_num(
127: p_order_number oe_order_headers_all.order_number%TYPE,
128: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
129: p_version_number oe_order_headers_all.version_number%TYPE,
130: p_org_id oe_order_headers_all.org_id%TYPE
131: )
124: RETURN po_vendor_sites_all%ROWTYPE;
125:
126: FUNCTION get_oeh_row_from_num(
127: p_order_number oe_order_headers_all.order_number%TYPE,
128: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
129: p_version_number oe_order_headers_all.version_number%TYPE,
130: p_org_id oe_order_headers_all.org_id%TYPE
131: )
132: RETURN oe_order_headers_all%ROWTYPE;
125:
126: FUNCTION get_oeh_row_from_num(
127: p_order_number oe_order_headers_all.order_number%TYPE,
128: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
129: p_version_number oe_order_headers_all.version_number%TYPE,
130: p_org_id oe_order_headers_all.org_id%TYPE
131: )
132: RETURN oe_order_headers_all%ROWTYPE;
133:
126: FUNCTION get_oeh_row_from_num(
127: p_order_number oe_order_headers_all.order_number%TYPE,
128: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
129: p_version_number oe_order_headers_all.version_number%TYPE,
130: p_org_id oe_order_headers_all.org_id%TYPE
131: )
132: RETURN oe_order_headers_all%ROWTYPE;
133:
134: FUNCTION get_oeh_row_from_id(
128: p_order_type_id oe_order_headers_all.order_type_id%TYPE,
129: p_version_number oe_order_headers_all.version_number%TYPE,
130: p_org_id oe_order_headers_all.org_id%TYPE
131: )
132: RETURN oe_order_headers_all%ROWTYPE;
133:
134: FUNCTION get_oeh_row_from_id(
135: p_header_id IN oe_order_headers_all.header_id%TYPE
136: )
131: )
132: RETURN oe_order_headers_all%ROWTYPE;
133:
134: FUNCTION get_oeh_row_from_id(
135: p_header_id IN oe_order_headers_all.header_id%TYPE
136: )
137: RETURN oe_order_headers_all%ROWTYPE;
138:
139: FUNCTION get_oel_row_from_num(
133:
134: FUNCTION get_oeh_row_from_id(
135: p_header_id IN oe_order_headers_all.header_id%TYPE
136: )
137: RETURN oe_order_headers_all%ROWTYPE;
138:
139: FUNCTION get_oel_row_from_num(
140: p_line_number oe_order_lines_all.line_number%TYPE,
141: p_header_id oe_order_lines_all.header_id%TYPE