DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on RCV_SHIPMENT_HEADERS

Line 45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,

41: )
42: RETURN rcv_transactions%ROWTYPE;
43: --Bug 9005670 Added input parameter receipt_source_code.
44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,

Line 46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,

42: RETURN rcv_transactions%ROWTYPE;
43: --Bug 9005670 Added input parameter receipt_source_code.
44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,

Line 47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,

43: --Bug 9005670 Added input parameter receipt_source_code.
44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
51: no_data_found_is_error IN BOOLEAN

Line 48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,

44: FUNCTION get_rsh_row_from_num(
45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
51: no_data_found_is_error IN BOOLEAN
52: )

Line 49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,

45: p_shipment_num IN rcv_shipment_headers.shipment_num%TYPE,
46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
51: no_data_found_is_error IN BOOLEAN
52: )
53: RETURN rcv_shipment_headers%ROWTYPE;

Line 50: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,

46: p_vendor_id IN rcv_shipment_headers.vendor_id%TYPE,
47: p_vendor_site_id IN rcv_shipment_headers.vendor_site_id%TYPE,
48: p_ship_to_org_id IN rcv_shipment_headers.ship_to_org_id%TYPE,
49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
51: no_data_found_is_error IN BOOLEAN
52: )
53: RETURN rcv_shipment_headers%ROWTYPE;
54:

Line 53: RETURN rcv_shipment_headers%ROWTYPE;

49: p_shipped_date IN rcv_shipment_headers.shipped_date%TYPE,
50: p_receipt_source_code IN rcv_shipment_headers.receipt_source_code%TYPE,
51: no_data_found_is_error IN BOOLEAN
52: )
53: RETURN rcv_shipment_headers%ROWTYPE;
54:
55: FUNCTION get_rsh_row_from_id(
56: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
57: )

Line 56: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE

52: )
53: RETURN rcv_shipment_headers%ROWTYPE;
54:
55: FUNCTION get_rsh_row_from_id(
56: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
57: )
58: RETURN rcv_shipment_headers%ROWTYPE;
59:
60: FUNCTION get_rsl_row_from_num(

Line 58: RETURN rcv_shipment_headers%ROWTYPE;

54:
55: FUNCTION get_rsh_row_from_id(
56: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
57: )
58: RETURN rcv_shipment_headers%ROWTYPE;
59:
60: FUNCTION get_rsl_row_from_num(
61: p_line_num rcv_shipment_lines.line_num%TYPE,
62: p_shipment_header_id rcv_shipment_lines.shipment_header_id%TYPE