APPS.OZF_FUNDS_ALL_PKG dependencies on OZF_FUNDS_ALL_B

Line 87: cursor C is select ROWID from OZF_FUNDS_ALL_B

83: X_PLAN_ID in NUMBER,
84: X_LIABLE_ACCNT_SEGMENTS in VARCHAR2,
85: X_ADJUSTMENT_ACCNT_SEGMENTS in VARCHAR2
86: ) is
87: cursor C is select ROWID from OZF_FUNDS_ALL_B
88: where FUND_ID = X_FUND_ID
89: ;
90: begin
91: insert into OZF_FUNDS_ALL_B (

Line 91: insert into OZF_FUNDS_ALL_B (

87: cursor C is select ROWID from OZF_FUNDS_ALL_B
88: where FUND_ID = X_FUND_ID
89: ;
90: begin
91: insert into OZF_FUNDS_ALL_B (
92: FUND_ID,
93: CREATED_FROM,
94: REQUEST_ID,
95: FUND_NUMBER,

Line 449: from OZF_FUNDS_ALL_B

445: PLAN_TYPE,
446: PLAN_ID,
447: LIABLE_ACCNT_SEGMENTS,
448: ADJUSTMENT_ACCNT_SEGMENTS
449: from OZF_FUNDS_ALL_B
450: where FUND_ID = X_FUND_ID
451: for update of FUND_ID nowait;
452: recinfo c%rowtype;
453:

Line 717: update OZF_FUNDS_ALL_B set

713: X_LIABLE_ACCNT_SEGMENTS in VARCHAR2,
714: X_ADJUSTMENT_ACCNT_SEGMENTS in VARCHAR2
715: ) is
716: begin
717: update OZF_FUNDS_ALL_B set
718: CREATED_FROM = X_CREATED_FROM,
719: REQUEST_ID = X_REQUEST_ID,
720: FUND_NUMBER = X_FUND_NUMBER,
721: PARENT_FUND_ID = X_PARENT_FUND_ID,

Line 826: delete from OZF_FUNDS_ALL_B

822: if (sql%notfound) then
823: raise no_data_found;
824: end if;
825:
826: delete from OZF_FUNDS_ALL_B
827: where FUND_ID = X_FUND_ID;
828:
829: if (sql%notfound) then
830: raise no_data_found;

Line 840: from OZF_FUNDS_ALL_B B

836: begin
837: delete from OZF_FUNDS_ALL_TL T
838: where not exists
839: (select NULL
840: from OZF_FUNDS_ALL_B B
841: where B.FUND_ID = T.FUND_ID
842: );
843:
844: update OZF_FUNDS_ALL_TL T set (

Line 1020: from ozf_funds_all_b

1016: l_row_id varchar2(100);
1017:
1018: cursor c_version is
1019: select object_version_number
1020: from ozf_funds_all_b
1021: where fund_id = X_FUND_ID;
1022:
1023: cursor c_fund_exists is
1024: select 'x'

Line 1025: from ozf_funds_all_b

1021: where fund_id = X_FUND_ID;
1022:
1023: cursor c_fund_exists is
1024: select 'x'
1025: from ozf_funds_all_b
1026: where fund_id = X_FUND_ID;
1027:
1028: cursor c_fund_id is
1029: select OZF_FUNDS_S.nextval