APPS.GHR_WF dependencies on WF_ENGINE

Line 86: wf_engine.CreateProcess ('GHR',l_get_seq,'NOTIFYUSER');

82:
83: l_get_seq :='NFC'||l_get_seq;
84:
85:
86: wf_engine.CreateProcess ('GHR',l_get_seq,'NOTIFYUSER');
87:
88:
89: wf_engine.SetItemAttrText (
90: itemType => 'GHR',

Line 89: wf_engine.SetItemAttrText (

85:
86: wf_engine.CreateProcess ('GHR',l_get_seq,'NOTIFYUSER');
87:
88:
89: wf_engine.SetItemAttrText (
90: itemType => 'GHR',
91: itemKey => l_get_seq,
92: aname => 'USER_ROLE',
93: avalue => p_role);--l_get_role_name.name );

Line 95: l_attr:= wf_engine.GetItemAttrText(

91: itemKey => l_get_seq,
92: aname => 'USER_ROLE',
93: avalue => p_role);--l_get_role_name.name );
94:
95: l_attr:= wf_engine.GetItemAttrText(
96: itemtype => 'GHR',
97: itemkey =>l_get_seq,
98: aname =>'NOTIF_TYPE',
99: ignore_notfound =>l_ignore);

Line 102: wf_engine.setItemAttrText (

98: aname =>'NOTIF_TYPE',
99: ignore_notfound =>l_ignore);
100: --
101: IF l_attr='EVERY_TIME' THEN
102: wf_engine.setItemAttrText (
103: itemType => 'GHR',
104: itemKey => l_get_seq,
105: aname => 'ERROR_WARN',
106: avalue => ben_ext_thread.g_err_cnt );

Line 108: wf_engine.setItemAttrText (

104: itemKey => l_get_seq,
105: aname => 'ERROR_WARN',
106: avalue => ben_ext_thread.g_err_cnt );
107: IF ben_ext_thread.g_err_cnt > 0 THEN
108: wf_engine.setItemAttrText (
109: itemType => 'GHR',
110: itemKey => l_get_seq,
111: aname => 'STATUS',
112: avalue => ' with Errors' );

Line 115: wf_engine.setItemAttrText (

111: aname => 'STATUS',
112: avalue => ' with Errors' );
113:
114: END IF;
115: wf_engine.setItemAttrText (
116: itemType => 'GHR',
117: itemKey => l_get_seq,
118: aname => 'TOTALEXTRACT',
119: avalue => l_get_rec_cnt.rec_cnt );

Line 121: wf_engine.setItemAttrText (

117: itemKey => l_get_seq,
118: aname => 'TOTALEXTRACT',
119: avalue => l_get_rec_cnt.rec_cnt );
120:
121: wf_engine.setItemAttrText (
122: itemType => 'GHR',
123: itemKey => l_get_seq,
124: aname => 'REQUEST_ID',
125: avalue => p_request_id );

Line 128: wf_engine.setItemAttrText (

124: aname => 'REQUEST_ID',
125: avalue => p_request_id );
126:
127: IF INSTR(l_dfn.name,'Position') > 0 THEN
128: wf_engine.setItemAttrText (
129: itemType => 'GHR',
130: itemKey => l_get_seq,
131: aname => 'FILETYPE',
132: avalue => 'Position' );

Line 135: wf_engine.setItemAttrText (

131: aname => 'FILETYPE',
132: avalue => 'Position' );
133:
134: ELSIF INSTR(l_dfn.name,'Personnel') > 0 THEN
135: wf_engine.setItemAttrText (
136: itemType => 'GHR',
137: itemKey => l_get_seq,
138: aname => 'FILETYPE',
139: avalue => 'Personnel Action' );

Line 143: wf_engine.StartProcess ('GHR',l_get_seq);

139: avalue => 'Personnel Action' );
140:
141: END IF;
142:
143: wf_engine.StartProcess ('GHR',l_get_seq);
144: ELSIF l_attr='ONLY_ERROR' THEN
145: IF l_get_rslt.tot_err_num>0 THEN
146: wf_engine.setItemAttrText (
147: itemType => 'GHR',

Line 146: wf_engine.setItemAttrText (

142:
143: wf_engine.StartProcess ('GHR',l_get_seq);
144: ELSIF l_attr='ONLY_ERROR' THEN
145: IF l_get_rslt.tot_err_num>0 THEN
146: wf_engine.setItemAttrText (
147: itemType => 'GHR',
148: itemKey => l_get_seq,
149: aname => 'ERROR_WARN',
150: avalue => ben_ext_thread.g_err_cnt );

Line 152: wf_engine.setItemAttrText (

148: itemKey => l_get_seq,
149: aname => 'ERROR_WARN',
150: avalue => ben_ext_thread.g_err_cnt );
151:
152: wf_engine.setItemAttrText (
153: itemType => 'GHR',
154: itemKey => l_get_seq,
155: aname => 'STATUS',
156: avalue => ' with Errors' );

Line 158: wf_engine.setItemAttrText (

154: itemKey => l_get_seq,
155: aname => 'STATUS',
156: avalue => ' with Errors' );
157:
158: wf_engine.setItemAttrText (
159: itemType => 'GHR',
160: itemKey => l_get_seq,
161: aname => 'TOTALEXTRACT',
162: avalue => l_get_rslt.TOT_REC_NUM );

Line 164: wf_engine.setItemAttrNumber (

160: itemKey => l_get_seq,
161: aname => 'TOTALEXTRACT',
162: avalue => l_get_rslt.TOT_REC_NUM );
163:
164: wf_engine.setItemAttrNumber (
165: itemType => 'GHR',
166: itemKey => l_get_seq,
167: aname => 'REQUEST_ID',
168: avalue => p_request_id );

Line 171: wf_engine.setItemAttrText (

167: aname => 'REQUEST_ID',
168: avalue => p_request_id );
169:
170: IF INSTR(l_dfn.name,'Position') > 0 THEN
171: wf_engine.setItemAttrText (
172: itemType => 'GHR',
173: itemKey => l_get_seq,
174: aname => 'FILETYPE',
175: avalue => 'Position' );

Line 178: wf_engine.setItemAttrText (

174: aname => 'FILETYPE',
175: avalue => 'Position' );
176:
177: ELSIF INSTR(l_dfn.name,'Personnel') > 0 THEN
178: wf_engine.setItemAttrText (
179: itemType => 'GHR',
180: itemKey => l_get_seq,
181: aname => 'FILETYPE',
182: avalue => 'Personnel Action' );

Line 185: wf_engine.StartProcess ('GHR',l_get_seq);

181: aname => 'FILETYPE',
182: avalue => 'Personnel Action' );
183:
184: END IF;
185: wf_engine.StartProcess ('GHR',l_get_seq);
186: END IF;
187:
188: END IF;
189: END;

Line 209: l_attr:= wf_engine.GetItemAttrText(

205: FROM WF_USER_ROLE_ASSIGNMENTS_V wur
206: WHERE wur.role_name =cp_role;
207: l_count NUMBER;
208: BEGIN
209: l_attr:= wf_engine.GetItemAttrText(
210: itemtype => itemtype,
211: itemkey =>itemkey,
212: aname =>'USER_ROLE',
213: ignore_notfound =>l_ignore);