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 927: p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE

923: invalid_value(p_requisition_line_id, 'REQUISITION_LINE_ID');
924: END;
925:
926: FUNCTION get_prd_row_from_id(
927: p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE
928: )
929: RETURN po_req_distributions_all%ROWTYPE IS
930: BEGIN
931: IF (p_req_distribution_id IS NULL) THEN

Line 929: RETURN po_req_distributions_all%ROWTYPE IS

925:
926: FUNCTION get_prd_row_from_id(
927: p_req_distribution_id IN po_req_distributions_all.distribution_id%TYPE
928: )
929: RETURN po_req_distributions_all%ROWTYPE IS
930: BEGIN
931: IF (p_req_distribution_id IS NULL) THEN
932: RETURN NULL;
933: END IF;

Line 941: FROM po_req_distributions_all

937: END IF;
938:
939: SELECT *
940: INTO g_prd_row
941: FROM po_req_distributions_all
942: WHERE distribution_id = p_req_distribution_id;
943:
944: RETURN g_prd_row;
945: EXCEPTION