APPS.FRM_DOCUMENTS_PKG dependencies on FRM_DOCUMENTS_B

Line 19: cursor C is select ROWID from FRM_DOCUMENTS_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from FRM_DOCUMENTS_B
20: where DOCUMENT_ID = X_DOCUMENT_ID
21: ;
22: begin
23: insert into FRM_DOCUMENTS_B (

Line 23: insert into FRM_DOCUMENTS_B (

19: cursor C is select ROWID from FRM_DOCUMENTS_B
20: where DOCUMENT_ID = X_DOCUMENT_ID
21: ;
22: begin
23: insert into FRM_DOCUMENTS_B (
24: DOCUMENT_ID,
25: DIRECTORY_ID,
26: SEQUENCE_NUMBER,
27: EXPANDED_FLAG,

Line 106: from FRM_DOCUMENTS_B

102: EXPANDED_FLAG,
103: DS_APP_SHORT_NAME,
104: DATA_SOURCE_CODE,
105: OBJECT_VERSION_NUMBER
106: from FRM_DOCUMENTS_B
107: where DOCUMENT_ID = X_DOCUMENT_ID
108: for update of DOCUMENT_ID nowait;
109: recinfo c%rowtype;
110:

Line 171: update FRM_DOCUMENTS_B set

167: X_LAST_UPDATED_BY in NUMBER,
168: X_LAST_UPDATE_LOGIN in NUMBER
169: ) is
170: begin
171: update FRM_DOCUMENTS_B set
172: DIRECTORY_ID = X_DIRECTORY_ID,
173: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
174: EXPANDED_FLAG = X_EXPANDED_FLAG,
175: DS_APP_SHORT_NAME = X_DS_APP_SHORT_NAME,

Line 212: delete from FRM_DOCUMENTS_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from FRM_DOCUMENTS_B
213: where DOCUMENT_ID = X_DOCUMENT_ID;
214:
215: if (sql%notfound) then
216: raise no_data_found;

Line 226: from FRM_DOCUMENTS_B B

222: begin
223: delete from FRM_DOCUMENTS_TL T
224: where not exists
225: (select NULL
226: from FRM_DOCUMENTS_B B
227: where B.DOCUMENT_ID = T.DOCUMENT_ID
228: );
229:
230: update FRM_DOCUMENTS_TL T set (

Line 321: from FRM_DOCUMENTS_B

317: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
318: begin
319: select LAST_UPDATED_BY, LAST_UPDATE_DATE
320: into db_luby, db_ludate
321: from FRM_DOCUMENTS_B
322: where DOCUMENT_ID = x_document_id;
323:
324: -- Test for customization and version
325: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,