APPS.EAM_DEPT_APPROVERS_PUB dependencies on BOM_EAM_DEPT_APPROVERS

Line 142: from BOM_EAM_DEPT_APPROVERS

138: l_count_rec NUMBER := 0;
139: begin
140: --A DEPARTMENT CAN HAVE ONLY ONE PRIMARY APPROVER
141: select count (*) into l_count_rec
142: from BOM_EAM_DEPT_APPROVERS
143: where dept_id = p_dept_id
144: and responsibility_id = p_responsibility_id;
145:
146: if l_count_rec > 0 then --actually this should be 1

Line 164: FROM BOM_EAM_DEPT_APPROVERS

160: -- Bug # 3518888
161: IF NOT p_create_flag
162: then
163: SELECT COUNT(*) INTO l_count
164: FROM BOM_EAM_DEPT_APPROVERS
165: WHERE DEPT_ID = P_DEPT_ID and
166: ORGANIZATION_ID = P_ORGANIZATION_ID and
167: RESPONSIBILITY_APPLICATION_ID = P_RESP_APP_ID and
168: RESPONSIBILITY_ID = P_RESPONSIBILITY_ID;

Line 177: FROM BOM_EAM_DEPT_APPROVERS

173: end if;
174:
175: ELSIF p_create_flag THEN
176: SELECT COUNT(*) INTO l_count
177: FROM BOM_EAM_DEPT_APPROVERS
178: WHERE DEPT_ID = P_DEPT_ID and
179: ORGANIZATION_ID = P_ORGANIZATION_ID;
180: IF l_count > 0 THEN
181: fnd_message.set_name('EAM', 'EAM_DEPT_REC_EXISTS');

Line 290: INSERT INTO BOM_EAM_DEPT_APPROVERS

286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289:
290: INSERT INTO BOM_EAM_DEPT_APPROVERS
291: (
292: DEPT_ID ,
293: ORGANIZATION_ID ,
294: RESPONSIBILITY_APPLICATION_ID ,

Line 452: UPDATE BOM_EAM_DEPT_APPROVERS

448: p_resp_app_id ,
449: P_RESPONSIBILITY_ID, false );
450:
451: -- Only Approver id can be updated.
452: UPDATE BOM_EAM_DEPT_APPROVERS
453: SET
454: --DEPT_ID = P_DEPT_ID ,
455: --ORGANIZATION_ID = P_ORGANIZATION_ID ,
456: --RESPONSIBILITY_APPLICATION_ID = P_RESP_APP_ID ,