APPS.AMS_FUND_UTILIZED_ALL_PKG dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 52: select ROWID from OZF_FUNDS_UTILIZED_ALL_B

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 (

Line 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,

Line 269: from OZF_FUNDS_UTILIZED_ALL_B

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;

Line 434: update OZF_FUNDS_UTILIZED_ALL_B set

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,

Line 508: delete from OZF_FUNDS_UTILIZED_ALL_B

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;

Line 524: from OZF_FUNDS_UTILIZED_ALL_B B

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

Line 657: from OZF_FUNDS_UTILIZED_ALL_B

653: l_row_id varchar2(100);
654:
655: cursor c_version is
656: select OBJECT_VERSION_NUMBER
657: from OZF_FUNDS_UTILIZED_ALL_B
658: where UTILIZATION_ID = P_UTILIZATION_ID;
659:
660: cursor c_utilization_exists is
661: select 'x'

Line 662: from OZF_FUNDS_UTILIZED_ALL_B

658: where UTILIZATION_ID = P_UTILIZATION_ID;
659:
660: cursor c_utilization_exists is
661: select 'x'
662: from OZF_FUNDS_UTILIZED_ALL_B
663: where UTILIZATION_ID = P_UTILIZATION_ID;
664:
665: cursor c_utilization_id is
666: select OZF_FUNDS_UTILIZED_S.nextval