48: P_ATTRIBUTE15 IN VARCHAR2
49: ) is
50:
51: cursor C is
52: select ROWID from OZF_FUNDS_UTILIZED_ALL_B
53: where UTILIZATION_ID = P_UTILIZATION_ID;
54:
55: begin
56: insert into OZF_FUNDS_UTILIZED_ALL_B (
52: select ROWID from OZF_FUNDS_UTILIZED_ALL_B
53: where UTILIZATION_ID = P_UTILIZATION_ID;
54:
55: begin
56: insert into OZF_FUNDS_UTILIZED_ALL_B (
57: UTILIZATION_ID,
58: LAST_UPDATE_DATE,
59: LAST_UPDATED_BY,
60: LAST_UPDATE_LOGIN,
265: ATTRIBUTE12,
266: ATTRIBUTE13,
267: ATTRIBUTE14,
268: ATTRIBUTE15
269: from OZF_FUNDS_UTILIZED_ALL_B
270: where UTILIZATION_ID = P_UTILIZATION_ID
271: for update of UTILIZATION_ID nowait;
272:
273: recinfo c%rowtype;
430: P_ATTRIBUTE15 IN VARCHAR2
431: ) is
432:
433: begin
434: update OZF_FUNDS_UTILIZED_ALL_B set
435: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
436: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
437: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
438: CREATED_FROM = P_CREATED_FROM,
504: if (sql%notfound) then
505: raise no_data_found;
506: end if;
507:
508: delete from OZF_FUNDS_UTILIZED_ALL_B
509: where UTILIZATION_ID = P_UTILIZATION_ID;
510:
511: if (sql%notfound) then
512: raise no_data_found;
520: begin
521: delete from OZF_FUNDS_UTILIZED_ALL_TL T
522: where not exists
523: (select NULL
524: from OZF_FUNDS_UTILIZED_ALL_B B
525: where B.UTILIZATION_ID = T.UTILIZATION_ID
526: );
527:
528: update OZF_FUNDS_UTILIZED_ALL_TL T
655: l_row_id varchar2(100);
656:
657: cursor c_version is
658: select OBJECT_VERSION_NUMBER
659: from OZF_FUNDS_UTILIZED_ALL_B
660: where UTILIZATION_ID = P_UTILIZATION_ID;
661:
662: cursor c_utilization_exists is
663: select 'x'
660: where UTILIZATION_ID = P_UTILIZATION_ID;
661:
662: cursor c_utilization_exists is
663: select 'x'
664: from OZF_FUNDS_UTILIZED_ALL_B
665: where UTILIZATION_ID = P_UTILIZATION_ID;
666:
667: cursor c_utilization_id is
668: select OZF_FUNDS_UTILIZED_S.nextval