APPS.FEM_APPLICATION_GROUPS_PKG dependencies on FEM_APPLICATION_GROUPS_B

Line 14: cursor C is select ROWID from FEM_APPLICATION_GROUPS_B

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from FEM_APPLICATION_GROUPS_B
15: where APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID
16: ;
17: begin
18: insert into FEM_APPLICATION_GROUPS_B (

Line 18: insert into FEM_APPLICATION_GROUPS_B (

14: cursor C is select ROWID from FEM_APPLICATION_GROUPS_B
15: where APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID
16: ;
17: begin
18: insert into FEM_APPLICATION_GROUPS_B (
19: APPLICATION_GROUP_ID,
20: CREATION_DATE,
21: CREATED_BY,
22: LAST_UPDATE_DATE,

Line 80: from FEM_APPLICATION_GROUPS_B

76: X_APPLICATION_GROUP_NAME in VARCHAR2,
77: X_DESCRIPTION in VARCHAR2
78: ) is
79: cursor c is select APPLICATION_GROUP_ID
80: from FEM_APPLICATION_GROUPS_B
81: where APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID
82: for update of APPLICATION_GROUP_ID nowait;
83: recinfo c%rowtype;
84:

Line 128: update FEM_APPLICATION_GROUPS_B set

124: X_LAST_UPDATED_BY in NUMBER,
125: X_LAST_UPDATE_LOGIN in NUMBER
126: ) is
127: begin
128: update FEM_APPLICATION_GROUPS_B set
129: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
130: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
131: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
132: where APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID;

Line 164: delete from FEM_APPLICATION_GROUPS_B

160: if (sql%notfound) then
161: raise no_data_found;
162: end if;
163:
164: delete from FEM_APPLICATION_GROUPS_B
165: where APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID;
166:
167: if (sql%notfound) then
168: raise no_data_found;

Line 178: from FEM_APPLICATION_GROUPS_B B

174: begin
175: delete from FEM_APPLICATION_GROUPS_TL T
176: where not exists
177: (select NULL
178: from FEM_APPLICATION_GROUPS_B B
179: where B.APPLICATION_GROUP_ID = T.APPLICATION_GROUP_ID
180: );
181:
182: update FEM_APPLICATION_GROUPS_TL T set (