APPS.FEM_MAP_RULE_TYPES_PKG dependencies on FEM_MAP_RULE_TYPES_B

Line 16: cursor C is select ROWID from FEM_MAP_RULE_TYPES_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from FEM_MAP_RULE_TYPES_B
17: where MAP_RULE_TYPE_CODE = X_MAP_RULE_TYPE_CODE
18: ;
19: begin
20: insert into FEM_MAP_RULE_TYPES_B (

Line 20: insert into FEM_MAP_RULE_TYPES_B (

16: cursor C is select ROWID from FEM_MAP_RULE_TYPES_B
17: where MAP_RULE_TYPE_CODE = X_MAP_RULE_TYPE_CODE
18: ;
19: begin
20: insert into FEM_MAP_RULE_TYPES_B (
21: MAP_RULE_TYPE_CODE,
22: ENABLED_FLAG,
23: OBJECT_VERSION_NUMBER,
24: CREATION_DATE,

Line 90: from FEM_MAP_RULE_TYPES_B

86: ) is
87: cursor c is select
88: ENABLED_FLAG,
89: OBJECT_VERSION_NUMBER
90: from FEM_MAP_RULE_TYPES_B
91: where MAP_RULE_TYPE_CODE = X_MAP_RULE_TYPE_CODE
92: for update of MAP_RULE_TYPE_CODE nowait;
93: recinfo c%rowtype;
94:

Line 148: update FEM_MAP_RULE_TYPES_B set

144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_LOGIN in NUMBER
146: ) is
147: begin
148: update FEM_MAP_RULE_TYPES_B set
149: ENABLED_FLAG = X_ENABLED_FLAG,
150: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
151: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
152: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 186: delete from FEM_MAP_RULE_TYPES_B

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: delete from FEM_MAP_RULE_TYPES_B
187: where MAP_RULE_TYPE_CODE = X_MAP_RULE_TYPE_CODE;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 200: from FEM_MAP_RULE_TYPES_B B

196: begin
197: delete from FEM_MAP_RULE_TYPES_TL T
198: where not exists
199: (select NULL
200: from FEM_MAP_RULE_TYPES_B B
201: where B.MAP_RULE_TYPE_CODE = T.MAP_RULE_TYPE_CODE
202: );
203:
204: update FEM_MAP_RULE_TYPES_TL T set (