APPS.FRM_DELIVERY_MAILERS_PKG dependencies on FRM_DELIVERY_MAILERS_B

Line 19: cursor C is select ROWID from FRM_DELIVERY_MAILERS_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_DELIVERY_MAILERS_B
20: where MAILER_ID = X_MAILER_ID
21: ;
22: begin
23: insert into FRM_DELIVERY_MAILERS_B (

Line 23: insert into FRM_DELIVERY_MAILERS_B (

19: cursor C is select ROWID from FRM_DELIVERY_MAILERS_B
20: where MAILER_ID = X_MAILER_ID
21: ;
22: begin
23: insert into FRM_DELIVERY_MAILERS_B (
24: MAILER_ID,
25: HOST,
26: PORT,
27: FROM_ADDRESS,

Line 106: from FRM_DELIVERY_MAILERS_B

102: FROM_ADDRESS,
103: USERNAME,
104: SSL_ENABLED,
105: OBJECT_VERSION_NUMBER
106: from FRM_DELIVERY_MAILERS_B
107: where MAILER_ID = X_MAILER_ID
108: for update of MAILER_ID nowait;
109: recinfo c%rowtype;
110:

Line 170: update FRM_DELIVERY_MAILERS_B set

166: X_LAST_UPDATED_BY in NUMBER,
167: X_LAST_UPDATE_LOGIN in NUMBER
168: ) is
169: begin
170: update FRM_DELIVERY_MAILERS_B set
171: HOST = X_HOST,
172: PORT = X_PORT,
173: FROM_ADDRESS = X_FROM_ADDRESS,
174: USERNAME = X_USERNAME,

Line 211: delete from FRM_DELIVERY_MAILERS_B

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: delete from FRM_DELIVERY_MAILERS_B
212: where MAILER_ID = X_MAILER_ID;
213:
214: if (sql%notfound) then
215: raise no_data_found;

Line 225: from FRM_DELIVERY_MAILERS_B B

221: begin
222: delete from FRM_DELIVERY_MAILERS_TL T
223: where not exists
224: (select NULL
225: from FRM_DELIVERY_MAILERS_B B
226: where B.MAILER_ID = T.MAILER_ID
227: );
228:
229: update FRM_DELIVERY_MAILERS_TL T set (