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 (
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,
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:
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,
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;
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 (