41: cursor wf_process is
42: select wf.item_type,
43: wf.name ,
44: wf.display_name
45: from wf_activities_vl wf
46: where wf.item_type like '%BISW%'
47: and type = 'PROCESS'
48: and wf.begin_date <= sysdate
49: and NVL(wf.end_date,sysdate) >= sysdate
96: = FND_API.G_TRUE then
97:
98: select wf.display_name
99: into x_wf_process_name
100: from wf_activities_vl wf
101: where wf.item_type = 'BISKPIWF'
102: and type = 'PROCESS'
103: and wf.name = p_wf_process_short_name
104: and wf.begin_date <= sysdate
138: IS
139:
140: CURSOR val_cur is
141: select 1
142: from wf_activities_vl wf
143: where wf.item_type like '%BISW%'
144: and type = 'PROCESS'
145: and wf.name = p_wf_process_short_name
146: and wf.begin_date <= sysdate
203: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_name)=FND_API.G_TRUE
204: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_name)=FND_API.G_TRUE then
205: select wf.name
206: into x_wf_process_short_name
207: from wf_activities_vl wf
208: where wf.item_type = 'BISKPIWF'
209: and type = 'PROCESS'
210: and wf.display_name = p_wf_process_name
211: and wf.begin_date <= sysdate