APPS.FRM_DELIVERY_FTP_SERVERS_PKG dependencies on FRM_DELIVERY_FTP_SERVERS_B

Line 20: cursor C is select ROWID from FRM_DELIVERY_FTP_SERVERS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from FRM_DELIVERY_FTP_SERVERS_B
21: where SERVER_ID = X_SERVER_ID
22: ;
23: begin
24: insert into FRM_DELIVERY_FTP_SERVERS_B (

Line 24: insert into FRM_DELIVERY_FTP_SERVERS_B (

20: cursor C is select ROWID from FRM_DELIVERY_FTP_SERVERS_B
21: where SERVER_ID = X_SERVER_ID
22: ;
23: begin
24: insert into FRM_DELIVERY_FTP_SERVERS_B (
25: SERVER_ID,
26: HOST,
27: PORT,
28: AUTH_TYPE,

Line 111: from FRM_DELIVERY_FTP_SERVERS_B

107: USERNAME,
108: TYPE,
109: FILE_PERMISSION,
110: OBJECT_VERSION_NUMBER
111: from FRM_DELIVERY_FTP_SERVERS_B
112: where SERVER_ID = X_SERVER_ID
113: for update of SERVER_ID nowait;
114: recinfo c%rowtype;
115:

Line 178: update FRM_DELIVERY_FTP_SERVERS_B set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update FRM_DELIVERY_FTP_SERVERS_B set
179: HOST = X_HOST,
180: PORT = X_PORT,
181: AUTH_TYPE = X_AUTH_TYPE,
182: USERNAME = X_USERNAME,

Line 220: delete from FRM_DELIVERY_FTP_SERVERS_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from FRM_DELIVERY_FTP_SERVERS_B
221: where SERVER_ID = X_SERVER_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 234: from FRM_DELIVERY_FTP_SERVERS_B B

230: begin
231: delete from FRM_DELIVERY_FTP_SERVERS_TL T
232: where not exists
233: (select NULL
234: from FRM_DELIVERY_FTP_SERVERS_B B
235: where B.SERVER_ID = T.SERVER_ID
236: );
237:
238: update FRM_DELIVERY_FTP_SERVERS_TL T set (