DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_STATUS_B

Line 225: l_status_type GMD_STATUS_B.status_type%TYPE;

221: l_mesg_count NUMBER;
222: l_mesg_data VARCHAR2(2000);
223: l_return_status VARCHAR2(1);
224: l_action_flag VARCHAR2(1) := 'U';
225: l_status_type GMD_STATUS_B.status_type%TYPE;
226:
227: l_item_no VARCHAR2(2000);
228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

Line 306: FROM gmd_status_b

302: concurrent_id = pConcurrent_id;
303:
304: CURSOR Check_version_enabled(vStatus VARCHAR2) IS
305: SELECT version_enabled
306: FROM gmd_status_b
307: WHERE status_type = vStatus;
308:
309: -- Cursor to get formula_id when recipe_id is passed
310: CURSOR get_formula_id(v_recp_id NUMBER) IS