APPS.RA_TERMS_TABLE_HANDLER dependencies on RA_TERMS_B

Line 41: cursor C is select ROWID from RA_TERMS_B

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from RA_TERMS_B
42: where TERM_ID = X_TERM_ID
43: ;
44: begin
45: insert into RA_TERMS_B (

Line 45: insert into RA_TERMS_B (

41: cursor C is select ROWID from RA_TERMS_B
42: where TERM_ID = X_TERM_ID
43: ;
44: begin
45: insert into RA_TERMS_B (
46: TERM_ID,
47: CREDIT_CHECK_FLAG,
48: PREPAYMENT_FLAG,
49: BILLING_CYCLE_ID,

Line 216: from RA_TERMS_B

212: ATTRIBUTE12,
213: ATTRIBUTE13,
214: ATTRIBUTE14,
215: ATTRIBUTE15
216: from RA_TERMS_B
217: where TERM_ID = X_TERM_ID
218: for update of TERM_ID nowait;
219: recinfo c%rowtype;
220:

Line 345: update RA_TERMS_B set

341: X_LAST_UPDATED_BY in NUMBER,
342: X_LAST_UPDATE_LOGIN in NUMBER
343: ) is
344: begin
345: update RA_TERMS_B set
346: CREDIT_CHECK_FLAG = X_CREDIT_CHECK_FLAG,
347: PREPAYMENT_FLAG = X_PREPAYMENT_FLAG,
348: BILLING_CYCLE_ID = X_BILLING_CYCLE_ID,
349: PRINTING_LEAD_DAYS = X_PRINTING_LEAD_DAYS,

Line 408: delete from RA_TERMS_B

404: if (sql%notfound) then
405: raise no_data_found;
406: end if;
407:
408: delete from RA_TERMS_B
409: where TERM_ID = X_TERM_ID;
410:
411: if (sql%notfound) then
412: raise no_data_found;

Line 422: from RA_TERMS_B B

418: begin
419: delete from RA_TERMS_TL T
420: where not exists
421: (select NULL
422: from RA_TERMS_B B
423: where B.TERM_ID = T.TERM_ID
424: );
425:
426: update RA_TERMS_TL T set (