APPS.AR_DUNNING_LETTERS_PKG dependencies on AR_DUNNING_LETTERS_B

Line 33: cursor C is select ROWID from AR_DUNNING_LETTERS_B

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from AR_DUNNING_LETTERS_B
34: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
35: ;
36: begin
37: insert into AR_DUNNING_LETTERS_B (

Line 37: insert into AR_DUNNING_LETTERS_B (

33: cursor C is select ROWID from AR_DUNNING_LETTERS_B
34: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
35: ;
36: begin
37: insert into AR_DUNNING_LETTERS_B (
38: DUNNING_LETTER_ID,
39: STATUS,
40: REVIEW_DATE,
41: ATTRIBUTE_CATEGORY,

Line 171: from AR_DUNNING_LETTERS_B

167: ATTRIBUTE12,
168: ATTRIBUTE13,
169: ATTRIBUTE14,
170: ATTRIBUTE15
171: from AR_DUNNING_LETTERS_B
172: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID
173: for update of DUNNING_LETTER_ID nowait;
174: recinfo c%rowtype;
175:

Line 279: update AR_DUNNING_LETTERS_B set

275: X_LAST_UPDATED_BY in NUMBER,
276: X_LAST_UPDATE_LOGIN in NUMBER
277: ) is
278: begin
279: update AR_DUNNING_LETTERS_B set
280: STATUS = X_STATUS,
281: REVIEW_DATE = X_REVIEW_DATE,
282: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
283: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 333: delete from AR_DUNNING_LETTERS_B

329: if (sql%notfound) then
330: raise no_data_found;
331: end if;
332:
333: delete from AR_DUNNING_LETTERS_B
334: where DUNNING_LETTER_ID = X_DUNNING_LETTER_ID;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 347: from AR_DUNNING_LETTERS_B B

343: begin
344: delete from AR_DUNNING_LETTERS_TL T
345: where not exists
346: (select NULL
347: from AR_DUNNING_LETTERS_B B
348: where B.DUNNING_LETTER_ID = T.DUNNING_LETTER_ID
349: );
350:
351: update AR_DUNNING_LETTERS_TL T set (