APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_SHIPMENT_HEADERS

Line 7: g_rsh_row rcv_shipment_headers%ROWTYPE;

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;
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;

Line 162: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,

158: /*******/
159: /* RSH */
160: /*******/
161: FUNCTION get_rsh_row_from_num(
162: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
163: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
164: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
165: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
166: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,

Line 163: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,

159: /* RSH */
160: /*******/
161: FUNCTION get_rsh_row_from_num(
162: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
163: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
164: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
165: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
166: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
167: no_data_found_is_error IN BOOLEAN

Line 164: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,

160: /*******/
161: FUNCTION get_rsh_row_from_num(
162: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
163: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
164: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
165: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
166: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
167: no_data_found_is_error IN BOOLEAN
168: )

Line 165: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,

161: FUNCTION get_rsh_row_from_num(
162: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
163: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
164: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
165: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
166: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
167: no_data_found_is_error IN BOOLEAN
168: )
169: RETURN rcv_shipment_headers%ROWTYPE IS

Line 166: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,

162: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
163: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
164: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
165: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
166: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
167: no_data_found_is_error IN BOOLEAN
168: )
169: RETURN rcv_shipment_headers%ROWTYPE IS
170: BEGIN

Line 169: RETURN rcv_shipment_headers%ROWTYPE IS

165: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
166: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
167: no_data_found_is_error IN BOOLEAN
168: )
169: RETURN rcv_shipment_headers%ROWTYPE IS
170: BEGIN
171: IF (p_shipment_num IS NULL) THEN
172: RETURN NULL;
173: END IF;

Line 189: FROM rcv_shipment_headers

185: END IF;
186:
187: SELECT *
188: INTO g_rsh_row
189: FROM rcv_shipment_headers
190: WHERE shipment_num = p_shipment_num
191: AND ( vendor_site_id = NVL(p_vendor_site_id, vendor_site_id)
192: OR vendor_site_id IS NULL)
193: AND ( vendor_id = NVL(p_vendor_id, vendor_id)

Line 215: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE

211: RETURN NULL;
212: END get_rsh_row_from_num;
213:
214: FUNCTION get_rsh_row_from_id(
215: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
216: )
217: RETURN rcv_shipment_headers%ROWTYPE IS
218: BEGIN
219: IF (p_shipment_header_id IS NULL) THEN

Line 217: RETURN rcv_shipment_headers%ROWTYPE IS

213:
214: FUNCTION get_rsh_row_from_id(
215: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
216: )
217: RETURN rcv_shipment_headers%ROWTYPE IS
218: BEGIN
219: IF (p_shipment_header_id IS NULL) THEN
220: RETURN NULL;
221: END IF;

Line 229: FROM rcv_shipment_headers

225: END IF;
226:
227: SELECT *
228: INTO g_rsh_row
229: FROM rcv_shipment_headers
230: WHERE shipment_header_id = p_shipment_header_id;
231:
232: RETURN g_rsh_row;
233: EXCEPTION