APPS.FEM_APP_ANALYSTS_PKG dependencies on FEM_APP_ANALYSTS_B

Line 18: cursor C is select ROWID from FEM_APP_ANALYSTS_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from FEM_APP_ANALYSTS_B
19: where APPL_ANALYST_CODE = X_APPL_ANALYST_CODE
20: ;
21: begin
22: insert into FEM_APP_ANALYSTS_B (

Line 22: insert into FEM_APP_ANALYSTS_B (

18: cursor C is select ROWID from FEM_APP_ANALYSTS_B
19: where APPL_ANALYST_CODE = X_APPL_ANALYST_CODE
20: ;
21: begin
22: insert into FEM_APP_ANALYSTS_B (
23: APPL_ANALYST_CODE,
24: ENABLED_FLAG,
25: PERSONAL_FLAG,
26: READ_ONLY_FLAG,

Line 100: from FEM_APP_ANALYSTS_B

96: ENABLED_FLAG,
97: PERSONAL_FLAG,
98: READ_ONLY_FLAG,
99: OBJECT_VERSION_NUMBER
100: from FEM_APP_ANALYSTS_B
101: where APPL_ANALYST_CODE = X_APPL_ANALYST_CODE
102: for update of APPL_ANALYST_CODE nowait;
103: recinfo c%rowtype;
104:

Line 161: update FEM_APP_ANALYSTS_B set

157: X_LAST_UPDATED_BY in NUMBER,
158: X_LAST_UPDATE_LOGIN in NUMBER
159: ) is
160: begin
161: update FEM_APP_ANALYSTS_B set
162: ENABLED_FLAG = X_ENABLED_FLAG,
163: PERSONAL_FLAG = X_PERSONAL_FLAG,
164: READ_ONLY_FLAG = X_READ_ONLY_FLAG,
165: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 201: delete from FEM_APP_ANALYSTS_B

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: delete from FEM_APP_ANALYSTS_B
202: where APPL_ANALYST_CODE = X_APPL_ANALYST_CODE;
203:
204: if (sql%notfound) then
205: raise no_data_found;

Line 215: from FEM_APP_ANALYSTS_B B

211: begin
212: delete from FEM_APP_ANALYSTS_TL T
213: where not exists
214: (select NULL
215: from FEM_APP_ANALYSTS_B B
216: where B.APPL_ANALYST_CODE = T.APPL_ANALYST_CODE
217: );
218:
219: update FEM_APP_ANALYSTS_TL T set (