APPS.RCV_TABLE_FUNCTIONS dependencies on MTL_ITEM_CATEGORIES

Line 18: g_mic_row mtl_item_categories%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;
21: g_fc_row fnd_currencies%ROWTYPE;
22: g_sob_row gl_sets_of_books%ROWTYPE;

Line 1004: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE

1000: invalid_value('(' || p_item_id || ', ' || p_org_id || ')', '(ITEM_ID,TO_ORGANIZATION_ID)');
1001: END get_msi_row_from_num;
1002:
1003: FUNCTION get_mic_row_from_num
1004: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
1005: , p_org_id IN mtl_item_categories.organization_id%TYPE
1006: )
1007: RETURN mtl_item_categories%ROWTYPE IS
1008: BEGIN

Line 1005: , p_org_id IN mtl_item_categories.organization_id%TYPE

1001: END get_msi_row_from_num;
1002:
1003: FUNCTION get_mic_row_from_num
1004: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
1005: , p_org_id IN mtl_item_categories.organization_id%TYPE
1006: )
1007: RETURN mtl_item_categories%ROWTYPE IS
1008: BEGIN
1009: IF ( p_item_id IS NULL OR p_org_id IS NULL ) THEN

Line 1007: RETURN mtl_item_categories%ROWTYPE IS

1003: FUNCTION get_mic_row_from_num
1004: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
1005: , p_org_id IN mtl_item_categories.organization_id%TYPE
1006: )
1007: RETURN mtl_item_categories%ROWTYPE IS
1008: BEGIN
1009: IF ( p_item_id IS NULL OR p_org_id IS NULL ) THEN
1010: RETURN NULL;
1011: END IF;

Line 1019: FROM mtl_item_categories

1015: END IF;
1016:
1017: SELECT *
1018: INTO g_mic_row
1019: FROM mtl_item_categories
1020: WHERE inventory_item_id = p_item_id
1021: AND organization_id = p_org_id;
1022:
1023: RETURN g_mic_row;