APPS.FRM_DIRECTORY_PKG dependencies on FRM_DIRECTORY_B

Line 16: cursor C is select ROWID from FRM_DIRECTORY_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 FRM_DIRECTORY_B
17: where DIRECTORY_ID = X_DIRECTORY_ID
18: ;
19: begin
20: insert into FRM_DIRECTORY_B (

Line 20: insert into FRM_DIRECTORY_B (

16: cursor C is select ROWID from FRM_DIRECTORY_B
17: where DIRECTORY_ID = X_DIRECTORY_ID
18: ;
19: begin
20: insert into FRM_DIRECTORY_B (
21: DIRECTORY_ID,
22: PARENT_ID,
23: SEQUENCE_NUMBER,
24: OBJECT_VERSION_NUMBER,

Line 91: from FRM_DIRECTORY_B

87: cursor c is select
88: PARENT_ID,
89: SEQUENCE_NUMBER,
90: OBJECT_VERSION_NUMBER
91: from FRM_DIRECTORY_B
92: where DIRECTORY_ID = X_DIRECTORY_ID
93: for update of DIRECTORY_ID nowait;
94: recinfo c%rowtype;
95:

Line 148: update FRM_DIRECTORY_B set

144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_LOGIN in NUMBER
146: ) is
147: begin
148: update FRM_DIRECTORY_B set
149: PARENT_ID = X_PARENT_ID,
150: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
151: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
152: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 186: delete from FRM_DIRECTORY_B

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

Line 200: from FRM_DIRECTORY_B B

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

Line 292: from FRM_DIRECTORY_B

288: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
289: begin
290: select LAST_UPDATED_BY, LAST_UPDATE_DATE
291: into db_luby, db_ludate
292: from FRM_DIRECTORY_B
293: where DIRECTORY_ID = x_directory_id;
294:
295: -- Test for customization and version
296: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,