7: dummy number;
8: target_lname VARCHAR2(30);
9: CURSOR unique_name(target_lname VARCHAR2) IS
10: SELECT 1
11: FROM DUAL
12: WHERE EXISTS
13: (SELECT primary_ledger_id
14: FROM gl_ledger_relationships
15: WHERE target_ledger_name = target_lname);
29: -1,substrb(tcurr_code,1,
30: (27-lengthb(to_char(ldg_id))))||
31: ')',tcurr_code||')')
32: INTO target_lname
33: FROM DUAL;
34: END IF;
35:
36: RETURN target_lname;
37:
44: dummy number;
45: target_lshort_name VARCHAR2(30);
46: CURSOR unique_name(target_lshort_name VARCHAR2) IS
47: SELECT 1
48: FROM DUAL
49: WHERE EXISTS
50: (SELECT primary_ledger_id
51: FROM gl_ledger_relationships
52: WHERE target_ledger_short_name = target_lshort_name);
65: decode(sign(17-lengthb(to_char(ldg_id))-lengthb(tcurr_code)),
66: -1,substrb(tcurr_code,1,(17-lengthb(to_char(ldg_id))))||
67: ')',tcurr_code||')')
68: INTO target_lshort_name
69: FROM DUAL;
70: END IF;
71:
72: RETURN target_lshort_name;
73: