APPS.FEM_DRDPACCT_TYPES_PKG dependencies on FEM_DRDPACCT_TYPES_B

Line 18: cursor C is select ROWID from FEM_DRDPACCT_TYPES_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_DRDPACCT_TYPES_B
19: where DIR_DEPOS_ACCT_TYPE_CODE = X_DIR_DEPOS_ACCT_TYPE_CODE
20: ;
21: begin
22: insert into FEM_DRDPACCT_TYPES_B (

Line 22: insert into FEM_DRDPACCT_TYPES_B (

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

Line 100: from FEM_DRDPACCT_TYPES_B

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

Line 161: update FEM_DRDPACCT_TYPES_B set

157: X_LAST_UPDATED_BY in NUMBER,
158: X_LAST_UPDATE_LOGIN in NUMBER
159: ) is
160: begin
161: update FEM_DRDPACCT_TYPES_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_DRDPACCT_TYPES_B

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

Line 215: from FEM_DRDPACCT_TYPES_B B

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