DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_STATUS_B

Line 360: l_status_type GMD_STATUS_B.status_type%TYPE;

356: l_mesg_count NUMBER;
357: l_mesg_data VARCHAR2(2000);
358: l_return_status VARCHAR2(1);
359: l_action_flag VARCHAR2(1) := 'U';
360: l_status_type GMD_STATUS_B.status_type%TYPE;
361:
362: l_item_no VARCHAR2(2000);
363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

Line 459: FROM gmd_status_b

455: concurrent_id = pConcurrent_id;
456:
457: CURSOR Check_version_enabled(vStatus VARCHAR2) IS
458: SELECT version_enabled
459: FROM gmd_status_b
460: WHERE status_type = vStatus;
461:
462: -- Cursor to get formula_id when recipe_id is passed
463: CURSOR get_formula_id(v_recp_id NUMBER) IS