19: WHERE organization_id = p_organization_id
20: AND formula_id = p_formula_id;
21: BEGIN
22:
23: DELETE FROM gmd_formula_security_temp;
24:
25: COMMIT;
26:
27: x_resp_id := fnd_global.resp_id;
35: -- fnd_global.apps_initialize (2060, v_resp_id , 552);
36: l_organization_id := p_organization_id;
37: l_formula_id := p_formula_id;
38:
39: INSERT INTO gmd_formula_security_temp( assign_method_ind,
40: activated_ind,
41: access_type_ind,
42: organization_id,
43: user_id,
66:
67: FOR l_users IN c_manual_formulas
68: LOOP
69: IF l_users.other_organization_id IS NULL THEN
70: UPDATE GMD_formula_security_temp
71: SET activated_ind = 'A'
72: WHERE user_id = l_users.user_id
73: AND organization_id = p_organization_id
74: AND other_organization_id IS NULL;
72: WHERE user_id = l_users.user_id
73: AND organization_id = p_organization_id
74: AND other_organization_id IS NULL;
75:
76: UPDATE GMD_formula_security_temp
77: SET activated_ind = 'A'
78: WHERE responsibility_id = l_users.responsibility_id
79: AND organization_id = p_organization_id
80: AND other_organization_id IS NULL;
78: WHERE responsibility_id = l_users.responsibility_id
79: AND organization_id = p_organization_id
80: AND other_organization_id IS NULL;
81: ELSE
82: UPDATE GMD_formula_security_temp
83: SET activated_ind = 'A'
84: WHERE user_id = l_users.user_id
85: AND organization_id = p_organization_id
86: AND other_organization_id = l_users.other_organization_id;
84: WHERE user_id = l_users.user_id
85: AND organization_id = p_organization_id
86: AND other_organization_id = l_users.other_organization_id;
87:
88: UPDATE GMD_formula_security_temp
89: SET activated_ind = 'A'
90: WHERE responsibility_id = l_users.responsibility_id
91: AND organization_id = p_organization_id
92: AND other_organization_id = l_users.other_organization_id;
93:
94: END IF;
95: END LOOP;
96:
97: INSERT INTO gmd_formula_security_temp( formula_id,
98: assign_method_ind,
99: activated_ind,
100: access_type_ind,
101: organization_id,