24: colon := instr(username, ':');
25: if (colon = 0) then
26: select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
27: into uorig_system, uorig_system_id
28: from WF_ROLES WR
29: where WR.NAME = username
30: and WR.ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
31: 'HZ_GROUP','CUST_CONT');
32:
32:
33: else
34: select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
35: into uorig_system, uorig_system_id
36: from WF_ROLES WR
37: where WR.ORIG_SYSTEM = substr(username, 1, colon-1)
38: and WR.ORIG_SYSTEM_ID = substr(username, colon+1)
39: and WR.NAME = username;
40: end if;
96: colon := instr(username, ':');
97: if (colon = 0) then
98: select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
99: into uorig_system, uorig_system_id
100: from WF_ROLES WR
101: where WR.NAME = username
102: and WR.ORIG_SYSTEM NOT IN ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
103: 'HZ_GROUP','CUST_CONT');
104:
104:
105: else
106: select WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID
107: into uorig_system, uorig_system_id
108: from WF_ROLES WR
109: where WR.ORIG_SYSTEM = substr(username, 1, colon-1)
110: and WR.ORIG_SYSTEM_ID = substr(username, colon+1)
111: and WR.NAME = username;
112: end if;