DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on PO_REQUISITION_LINES_ALL

Line 15: g_prl_row po_requisition_lines_all%ROWTYPE;

11: g_pll_row po_line_locations_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;

Line 903: p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE

899: invalid_value(p_line_id, 'OE_ORDER_LINE_ID');
900: END get_oel_row_from_id;
901:
902: FUNCTION get_prl_row_from_id(
903: p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE
904: )
905: RETURN po_requisition_lines_all%ROWTYPE IS
906: BEGIN
907: IF (p_requisition_line_id IS NULL) THEN

Line 905: RETURN po_requisition_lines_all%ROWTYPE IS

901:
902: FUNCTION get_prl_row_from_id(
903: p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE
904: )
905: RETURN po_requisition_lines_all%ROWTYPE IS
906: BEGIN
907: IF (p_requisition_line_id IS NULL) THEN
908: RETURN NULL;
909: END IF;

Line 917: FROM po_requisition_lines_all

913: END IF;
914:
915: SELECT *
916: INTO g_prl_row
917: FROM po_requisition_lines_all
918: WHERE requisition_line_id = p_requisition_line_id;
919:
920: RETURN g_prl_row;
921: EXCEPTION