APPS.EAM_DEPT_APPROVERS_PVT dependencies on BOM_EAM_DEPT_APPROVERS

Line 59: CURSOR C IS SELECT rowid FROM BOM_EAM_DEPT_APPROVERS

55: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
56: l_api_version CONSTANT NUMBER := 1.0;
57: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
58:
59: CURSOR C IS SELECT rowid FROM BOM_EAM_DEPT_APPROVERS
60: WHERE DEPT_ID = P_DEPT_ID AND RESPONSIBILITY_ID=P_RESPONSIBILITY_ID;
61:
62: BEGIN
63:

Line 81: INSERT INTO BOM_EAM_DEPT_APPROVERS(

77: -- Initialize API return status to success
78: x_return_status := fnd_api.g_ret_sts_success;
79:
80: -- API body
81: INSERT INTO BOM_EAM_DEPT_APPROVERS(
82: DEPT_ID,
83: ORGANIZATION_ID,
84: LAST_UPDATE_DATE,
85: LAST_UPDATED_BY,

Line 108: FROM BOM_EAM_DEPT_APPROVERS BDA

104: WHERE P_DEPT_ID = P_DEPT_ID
105: AND
106: NOT EXISTS (
107: SELECT null
108: FROM BOM_EAM_DEPT_APPROVERS BDA
109: WHERE BDA.DEPT_ID = P_DEPT_ID And
110: BDA.RESPONSIBILITY_ID = P_RESPONSIBILITY_ID
111: );
112:

Line 176: SELECT * FROM BOM_EAM_DEPT_APPROVERS

172: l_api_version CONSTANT NUMBER := 1.0;
173: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
174:
175: CURSOR C IS
176: SELECT * FROM BOM_EAM_DEPT_APPROVERS
177: WHERE rowid = P_ROWID
178: FOR UPDATE Of RESPONSIBILITY_ID NOWAIT;
179: Recinfo C%ROWTYPE;
180:

Line 297: UPDATE BOM_EAM_DEPT_APPROVERS

293: x_return_status := fnd_api.g_ret_sts_success;
294:
295: -- API body
296:
297: UPDATE BOM_EAM_DEPT_APPROVERS
298: SET
299: DEPT_ID = P_DEPT_ID,
300: ORGANIZATION_ID = P_ORGANIZATION_ID,
301: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 356: delete from BOM_EAM_DEPT_APPROVERS

352: P_RESPONSIBILITY_APPLICATN_ID NUMBER)
353: is
354: begin
355:
356: delete from BOM_EAM_DEPT_APPROVERS
357: where DEPT_ID = P_DEPT_ID
358: and ORGANIZATION_ID = P_ORGANIZATION_ID
359: and RESPONSIBILITY_ID = P_RESPONSIBILITY_ID
360: and RESPONSIBILITY_APPLICATION_ID = P_RESPONSIBILITY_APPLICATN_ID;