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