APPS.AR_AGING_BUCKET_LINES_PKG dependencies on AR_AGING_BUCKET_LINES_B

Line 36: cursor C is select ROWID from AR_AGING_BUCKET_LINES_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from AR_AGING_BUCKET_LINES_B
37: where AGING_BUCKET_LINE_ID = X_AGING_BUCKET_LINE_ID
38: ;
39: begin
40: insert into AR_AGING_BUCKET_LINES_B (

Line 40: insert into AR_AGING_BUCKET_LINES_B (

36: cursor C is select ROWID from AR_AGING_BUCKET_LINES_B
37: where AGING_BUCKET_LINE_ID = X_AGING_BUCKET_LINE_ID
38: ;
39: begin
40: insert into AR_AGING_BUCKET_LINES_B (
41: AGING_BUCKET_LINE_ID,
42: AGING_BUCKET_ID,
43: BUCKET_SEQUENCE_NUM,
44: DAYS_START,

Line 186: from AR_AGING_BUCKET_LINES_B

182: ATTRIBUTE12,
183: ATTRIBUTE13,
184: ATTRIBUTE14,
185: ATTRIBUTE15
186: from AR_AGING_BUCKET_LINES_B
187: where AGING_BUCKET_LINE_ID = X_AGING_BUCKET_LINE_ID
188: for update of AGING_BUCKET_LINE_ID nowait;
189: recinfo c%rowtype;
190:

Line 303: update AR_AGING_BUCKET_LINES_B set

299: X_LAST_UPDATED_BY in NUMBER,
300: X_LAST_UPDATE_LOGIN in NUMBER
301: ) is
302: begin
303: update AR_AGING_BUCKET_LINES_B set
304: AGING_BUCKET_ID = X_AGING_BUCKET_ID,
305: BUCKET_SEQUENCE_NUM = X_BUCKET_SEQUENCE_NUM,
306: DAYS_START = X_DAYS_START,
307: DAYS_TO = X_DAYS_TO,

Line 360: delete from AR_AGING_BUCKET_LINES_B

356: if (sql%notfound) then
357: raise no_data_found;
358: end if;
359:
360: delete from AR_AGING_BUCKET_LINES_B
361: where AGING_BUCKET_LINE_ID = X_AGING_BUCKET_LINE_ID;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 374: from AR_AGING_BUCKET_LINES_B B

370: begin
371: delete from AR_AGING_BUCKET_LINES_TL T
372: where not exists
373: (select NULL
374: from AR_AGING_BUCKET_LINES_B B
375: where B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID
376: );
377:
378: update AR_AGING_BUCKET_LINES_TL T set (