191: || adhawan 23-feb-02' made the UNIQUE key incasesensitive by adding the UPPER clause
192: || (reverse chronological order - newest change first)
193: */
194:
195: l_org_id igf_aw_fund_type_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
196: CURSOR cur_rowid IS
197: SELECT rowid
198: FROM igf_aw_fund_type
199: WHERE fund_type = x_fund_type
322: x_last_update_date DATE;
323: x_last_updated_by NUMBER;
324: x_last_update_login NUMBER;
325:
326: l_org_id igf_aw_fund_type_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
327:
328: BEGIN
329:
330: x_last_update_date := SYSDATE;