DBA Data[Home] [Help]

APPS.GMD_FORMULA_HEADER_PVT dependencies on GMD_FORMULA_SECURITY

Line 128: INSERT INTO GMD_FORMULA_SECURITY

124: FETCH Cur_user_access
125: INTO l_sec_cnt, l_other_orgn_id;
126: IF (Cur_user_access%FOUND) THEN
127: IF l_sec_cnt = 1 THEN
128: INSERT INTO GMD_FORMULA_SECURITY
129: (formula_security_id,
130: formula_id,
131: access_type_ind,
132: organization_id,

Line 142: (gmd_formula_security_id_s.NEXTVAL,

138: last_update_date,
139: last_updated_by,
140: last_update_login)
141: VALUES
142: (gmd_formula_security_id_s.NEXTVAL,
143: p_formula_header_rec.formula_id,
144: 'U',
145: p_formula_header_rec.owner_organization_id,
146: p_formula_header_rec.created_by,

Line 167: INSERT INTO GMD_FORMULA_SECURITY

163: FETCH Cur_resp_access
164: INTO l_sec_cnt, l_other_orgn_id;
165: IF (Cur_resp_access%FOUND) THEN
166: IF l_sec_cnt = 1 THEN
167: INSERT INTO GMD_FORMULA_SECURITY
168: (formula_security_id,
169: formula_id,
170: access_type_ind,
171: organization_id,

Line 181: (gmd_formula_security_id_s.NEXTVAL,

177: last_update_date,
178: last_updated_by,
179: last_update_login)
180: VALUES
181: (gmd_formula_security_id_s.NEXTVAL,
182: p_formula_header_rec.formula_id,
183: 'U',
184: p_formula_header_rec.owner_organization_id,
185: NULL,