1: package body AMS_FUNDS_ALL_PKG as
2: /* $Header: amslfunb.pls 115.1 2002/07/15 22:11:55 mpande noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_FUND_ID in NUMBER,
1044: fetch c_fund_id into l_fund_id;
1045: close c_fund_id;
1046: end if;
1047: l_version := 1;
1048: AMS_FUNDS_ALL_PKG.INSERT_ROW(
1049: X_ROWID =>l_row_id
1050: ,X_FUND_ID =>l_fund_id
1051: ,X_CREATED_FROM =>X_CREATED_FROM
1052: ,X_REQUEST_ID =>X_REQUEST_ID
1133: close c_fund_exists;
1134: open c_version;
1135: fetch c_version into l_version;
1136: close c_version;
1137: AMS_FUNDS_ALL_PKG.UPDATE_ROW(
1138: X_FUND_ID =>l_fund_id
1139: ,X_CREATED_FROM =>X_CREATED_FROM
1140: ,X_REQUEST_ID =>X_REQUEST_ID
1141: ,X_FUND_NUMBER =>X_FUND_NUMBER
1218: end if;
1219: END LOAD_ROW;
1220:
1221:
1222: end AMS_FUNDS_ALL_PKG;