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 930: p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE

926: invalid_value(p_line_id, 'OE_ORDER_LINE_ID');
927: END get_oel_row_from_id;
928:
929: FUNCTION get_prl_row_from_id(
930: p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE
931: )
932: RETURN po_requisition_lines_all%ROWTYPE IS
933: BEGIN
934: IF (p_requisition_line_id IS NULL) THEN

Line 932: RETURN po_requisition_lines_all%ROWTYPE IS

928:
929: FUNCTION get_prl_row_from_id(
930: p_requisition_line_id IN po_requisition_lines_all.requisition_line_id%TYPE
931: )
932: RETURN po_requisition_lines_all%ROWTYPE IS
933: BEGIN
934: IF (p_requisition_line_id IS NULL) THEN
935: RETURN NULL;
936: END IF;

Line 944: FROM po_requisition_lines_all

940: END IF;
941:
942: SELECT *
943: INTO g_prl_row
944: FROM po_requisition_lines_all
945: WHERE requisition_line_id = p_requisition_line_id;
946:
947: RETURN g_prl_row;
948: EXCEPTION