APPS.AMS_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 1018: from ozf_funds_all_b

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

Line 1023: from ozf_funds_all_b

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