26: P_update VARCHAR2,
27: X_active_ind OUT NOCOPY NUMBER) IS
28: CURSOR Cur_check_formula IS
29: SELECT 1
30: FROM sys.dual
31: WHERE EXISTS (SELECT 1
32: FROM fm_form_mst_b
33: WHERE orgn_code = P_orgn_code);
34:
33: WHERE orgn_code = P_orgn_code);
34:
35: CURSOR Cur_check_recipe IS
36: SELECT 1
37: FROM sys.dual
38: WHERE EXISTS (SELECT 1
39: FROM gmd_recipes_b
40: WHERE owner_orgn_code = P_orgn_code);
41:
40: WHERE owner_orgn_code = P_orgn_code);
41:
42: CURSOR Cur_check_validity IS
43: SELECT 1
44: FROM sys.dual
45: WHERE EXISTS (SELECT 1
46: FROM gmd_recipe_validity_rules
47: WHERE orgn_code = P_orgn_code);
48:
47: WHERE orgn_code = P_orgn_code);
48:
49: CURSOR Cur_check_tech_param IS
50: SELECT 1
51: FROM sys.dual
52: WHERE EXISTS (SELECT 1
53: FROM lm_tech_hdr
54: WHERE orgn_code = P_orgn_code);
55:
54: WHERE orgn_code = P_orgn_code);
55:
56: CURSOR Cur_check_batch IS
57: SELECT 1
58: FROM sys.dual
59: WHERE EXISTS (SELECT 1
60: FROM pm_btch_hdr
61: WHERE plant_code = P_orgn_code);
62:
61: WHERE plant_code = P_orgn_code);
62:
63: CURSOR Cur_check_item_cost IS
64: SELECT 1
65: FROM sys.dual
66: WHERE EXISTS (SELECT 1
67: FROM gl_item_cst
68: WHERE orgn_code = P_orgn_code);
69: