eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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) := asn_debug.is_debug_on; -- Bug 9152790
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: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,

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: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
168: no_data_found_is_error IN BOOLEAN

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: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
168: no_data_found_is_error IN BOOLEAN
169: )

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: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
168: no_data_found_is_error IN BOOLEAN
169: )
170: RETURN rcv_shipment_headers%ROWTYPE IS

Line 167: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%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: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
168: no_data_found_is_error IN BOOLEAN
169: )
170: RETURN rcv_shipment_headers%ROWTYPE IS
171: BEGIN

Line 170: RETURN rcv_shipment_headers%ROWTYPE IS

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

Line 191: FROM rcv_shipment_headers

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

Line 218: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE

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

Line 220: RETURN rcv_shipment_headers%ROWTYPE IS

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

Line 232: FROM rcv_shipment_headers

228: END IF;
229:
230: SELECT *
231: INTO g_rsh_row
232: FROM rcv_shipment_headers
233: WHERE shipment_header_id = p_shipment_header_id;
234:
235: RETURN g_rsh_row;
236: EXCEPTION