APPS.FEM_INTDIV_OPTN_PKG dependencies on FEM_INTDIV_OPTN_B

Line 18: cursor C is select ROWID from FEM_INTDIV_OPTN_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_INTDIV_OPTN_B
19: where INT_DIVIDENDS_OPTION_CODE = X_INT_DIVIDENDS_OPTION_CODE
20: ;
21: begin
22: insert into FEM_INTDIV_OPTN_B (

Line 22: insert into FEM_INTDIV_OPTN_B (

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

Line 100: from FEM_INTDIV_OPTN_B

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

Line 161: update FEM_INTDIV_OPTN_B set

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

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

Line 215: from FEM_INTDIV_OPTN_B B

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