DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 16: g_prd_row po_req_distributions_all%ROWTYPE;

12: g_pod_row po_distributions_all%ROWTYPE;
13: g_oeh_row oe_order_headers_all%ROWTYPE;
14: g_oel_row oe_order_lines_all%ROWTYPE;
15: g_prl_row po_requisition_lines_all%ROWTYPE;
16: g_prd_row po_req_distributions_all%ROWTYPE;
17: g_msi_row mtl_system_items%ROWTYPE;
18: g_mic_row mtl_item_categories%ROWTYPE;
19: g_mp_row mtl_parameters%ROWTYPE;
20: g_rp_row rcv_parameters%ROWTYPE;

Line 954: p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE

950: invalid_value(p_requisition_line_id, 'REQUISITION_LINE_ID');
951: END;
952:
953: FUNCTION get_prd_row_from_id(
954: p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE
955: )
956: RETURN po_req_distributions_all%ROWTYPE IS
957: BEGIN
958: IF (p_req_distribution_id IS NULL) THEN

Line 956: RETURN po_req_distributions_all%ROWTYPE IS

952:
953: FUNCTION get_prd_row_from_id(
954: p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE
955: )
956: RETURN po_req_distributions_all%ROWTYPE IS
957: BEGIN
958: IF (p_req_distribution_id IS NULL) THEN
959: RETURN NULL;
960: END IF;

Line 968: FROM po_req_distributions_all

964: END IF;
965:
966: SELECT *
967: INTO g_prd_row
968: FROM po_req_distributions_all
969: WHERE distribution_id = p_req_distribution_id;
970:
971: RETURN g_prd_row;
972: EXCEPTION