APPS.FEM_CCTR_ORG_TYPES_PKG dependencies on FEM_CCTR_ORG_TYPES_B

Line 18: cursor C is select ROWID from FEM_CCTR_ORG_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_CCTR_ORG_TYPES_B
19: where CCTR_ORG_TYPE_CODE = X_CCTR_ORG_TYPE_CODE
20: ;
21: begin
22: insert into FEM_CCTR_ORG_TYPES_B (

Line 22: insert into FEM_CCTR_ORG_TYPES_B (

18: cursor C is select ROWID from FEM_CCTR_ORG_TYPES_B
19: where CCTR_ORG_TYPE_CODE = X_CCTR_ORG_TYPE_CODE
20: ;
21: begin
22: insert into FEM_CCTR_ORG_TYPES_B (
23: OBJECT_VERSION_NUMBER,
24: CCTR_ORG_TYPE_CODE,
25: ENABLED_FLAG,
26: READ_ONLY_FLAG,

Line 100: from FEM_CCTR_ORG_TYPES_B

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

Line 162: update FEM_CCTR_ORG_TYPES_B set

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

Line 202: delete from FEM_CCTR_ORG_TYPES_B

198: if (sql%notfound) then
199: raise no_data_found;
200: end if;
201:
202: delete from FEM_CCTR_ORG_TYPES_B
203: where CCTR_ORG_TYPE_CODE = X_CCTR_ORG_TYPE_CODE;
204:
205: if (sql%notfound) then
206: raise no_data_found;

Line 216: from FEM_CCTR_ORG_TYPES_B B

212: begin
213: delete from FEM_CCTR_ORG_TYPES_TL T
214: where not exists
215: (select NULL
216: from FEM_CCTR_ORG_TYPES_B B
217: where B.CCTR_ORG_TYPE_CODE = T.CCTR_ORG_TYPE_CODE
218: );
219:
220: update FEM_CCTR_ORG_TYPES_TL T set (