eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_WF_EFF_PKG dependencies on WF_ENGINE

Line 79: wf_engine.CreateProcess(itemtype => ItemType,

75: /*-----------------------------*/
76:
77: l_creator_username := FND_GLOBAL.user_name;
78:
79: wf_engine.CreateProcess(itemtype => ItemType,
80: itemkey => ItemKey,
81: process => 'EFFORT_REPORT_WF');
82:
83: /*Added for bug 7004679 */

Line 84: wf_engine.setitemowner(itemtype => ItemType,

80: itemkey => ItemKey,
81: process => 'EFFORT_REPORT_WF');
82:
83: /*Added for bug 7004679 */
84: wf_engine.setitemowner(itemtype => ItemType,
85: itemkey => ItemKey,
86: owner => l_creator_username);
87:
88: /*----------------------------------------------------------------------------------------*/

Line 102: l_omit_approval_step := wf_engine.GetItemAttrText(itemtype, itemkey, 'OMIT_APPROVAL_STEP');

98: /*9. END_DATE ---/ */
99: /*10. TEMPLATE_ID */
100: /*----------------------------------------------------------------------------------------*/
101:
102: l_omit_approval_step := wf_engine.GetItemAttrText(itemtype, itemkey, 'OMIT_APPROVAL_STEP');
103: IF (l_omit_approval_step = 'Y') THEN
104: wf_engine.SetItemAttrText(itemtype => ItemType,
105: itemkey => ItemKey,
106: aname => 'PROCESS',

Line 104: wf_engine.SetItemAttrText(itemtype => ItemType,

100: /*----------------------------------------------------------------------------------------*/
101:
102: l_omit_approval_step := wf_engine.GetItemAttrText(itemtype, itemkey, 'OMIT_APPROVAL_STEP');
103: IF (l_omit_approval_step = 'Y') THEN
104: wf_engine.SetItemAttrText(itemtype => ItemType,
105: itemkey => ItemKey,
106: aname => 'PROCESS',
107: avalue => 'CERTIFICATION');
108: ELSE

Line 109: wf_engine.SetItemAttrText(itemtype => ItemType,

105: itemkey => ItemKey,
106: aname => 'PROCESS',
107: avalue => 'CERTIFICATION');
108: ELSE
109: wf_engine.SetItemAttrText(itemtype => ItemType,
110: itemkey => ItemKey,
111: aname => 'PROCESS',
112: avalue => 'APPROVAL');
113: END IF;

Line 115: wf_engine.SetItemAttrText(itemtype => ItemType,

111: aname => 'PROCESS',
112: avalue => 'APPROVAL');
113: END IF;
114:
115: wf_engine.SetItemAttrText(itemtype => ItemType,
116: itemkey => ItemKey,
117: aname => 'CREATOR_USERNAME',
118: avalue => l_creator_username);
119:

Line 120: wf_engine.SetItemAttrText(itemtype => ItemType,

116: itemkey => ItemKey,
117: aname => 'CREATOR_USERNAME',
118: avalue => l_creator_username);
119:
120: wf_engine.SetItemAttrText(itemtype => ItemType,
121: itemkey => ItemKey,
122: aname => 'CREATOR_DISPLAY_NAME',
123: avalue => wf_directory.GetRoleDisplayName(l_creator_username));
124:

Line 125: wf_engine.SetItemAttrText(itemtype => ItemType,

121: itemkey => ItemKey,
122: aname => 'CREATOR_DISPLAY_NAME',
123: avalue => wf_directory.GetRoleDisplayName(l_creator_username));
124:
125: wf_engine.SetItemAttrText(itemtype => ItemType,
126: itemkey => ItemKey,
127: aname => 'REPORT_ID',
128: avalue => l_report_id);
129:

Line 134: wf_engine.SetItemAttrText(itemtype => ItemType,

130: OPEN get_period_details_csr;
131: FETCH get_period_details_csr INTO l_begin_date, l_end_date;
132: CLOSE get_period_details_csr;
133:
134: wf_engine.SetItemAttrText(itemtype => ItemType,
135: itemkey => ItemKey,
136: aname => 'BEGIN_DATE',
137: avalue => l_begin_date);
138:

Line 139: wf_engine.SetItemAttrText(itemtype => ItemType,

135: itemkey => ItemKey,
136: aname => 'BEGIN_DATE',
137: avalue => l_begin_date);
138:
139: wf_engine.SetItemAttrText(itemtype => ItemType,
140: itemkey => ItemKey,
141: aname => 'END_DATE',
142: avalue => l_end_date);
143:

Line 160: wf_engine.SetItemAttrText(itemtype => ItemType,

156: FETCH get_emp_display_name INTO l_emp_display_name;
157: CLOSE get_emp_display_name;
158: END IF;
159:
160: wf_engine.SetItemAttrText(itemtype => ItemType,
161: itemkey => ItemKey,
162: aname => 'EMPLOYEE_PERSON_ID',
163: avalue => l_person_id);
164:

Line 165: wf_engine.SetItemAttrText(itemtype => ItemType,

161: itemkey => ItemKey,
162: aname => 'EMPLOYEE_PERSON_ID',
163: avalue => l_person_id);
164:
165: wf_engine.SetItemAttrText(itemtype => ItemType,
166: itemkey => ItemKey,
167: aname => 'EMPLOYEE_USERNAME',
168: avalue => l_emp_username);
169:

Line 170: wf_engine.SetItemAttrText(itemtype => ItemType,

166: itemkey => ItemKey,
167: aname => 'EMPLOYEE_USERNAME',
168: avalue => l_emp_username);
169:
170: wf_engine.SetItemAttrText(itemtype => ItemType,
171: itemkey => ItemKey,
172: aname => 'EMPLOYEE_DISPLAY_NAME',
173: avalue => l_emp_display_name);
174:

Line 175: wf_engine.SetItemAttrText(itemtype => ItemType,

171: itemkey => ItemKey,
172: aname => 'EMPLOYEE_DISPLAY_NAME',
173: avalue => l_emp_display_name);
174:
175: wf_engine.SetItemAttrText(itemtype => ItemType,
176: itemkey => ItemKey,
177: aname => 'TEMPLATE_ID',
178: avalue => a_template_id);
179:

Line 183: wf_engine.startprocess(itemtype => ItemType,

179:
180: /*-----------------------------------------------------*/
181: /*Start the workflow process */
182: /*-----------------------------------------------------*/
183: wf_engine.startprocess(itemtype => ItemType,
184: itemkey => ItemKey);
185: END LOOP;
186: CLOSE get_report_id_csr;
187:

Line 212: l_omit_approval_step := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'OMIT_APPROVAL_STEP');

208: l_omit_approval_step VARCHAR2(1);
209: BEGIN
210:
211: IF (funcmode = 'RUN') THEN
212: l_omit_approval_step := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'OMIT_APPROVAL_STEP');
213: result := 'COMPLETE:'||l_omit_approval_step;
214: END IF;
215:
216: EXCEPTION

Line 239: l_can_employee_approve := wf_engine.GetItemAttrText(itemtype, itemkey, 'CAN_EMPLOYEE_APPROVE');

235: l_can_employee_approve varchar2(1);
236: BEGIN
237:
238: IF (funcmode = 'RUN') THEN
239: l_can_employee_approve := wf_engine.GetItemAttrText(itemtype, itemkey, 'CAN_EMPLOYEE_APPROVE');
240: result := 'COMPLETE:'||l_can_employee_approve;
241: END IF;
242:
243: EXCEPTION

Line 265: l_can_supervisor_certify := wf_engine.GetItemAttrText(itemtype, itemkey, 'CAN_SUPERVISOR_CERTIFY');

261: l_can_supervisor_certify VARCHAR2(1);
262: BEGIN
263:
264: IF (funcmode = 'RUN') THEN
265: l_can_supervisor_certify := wf_engine.GetItemAttrText(itemtype, itemkey, 'CAN_SUPERVISOR_CERTIFY');
266: result := 'COMPLETE:'||l_can_supervisor_certify;
267: END IF;
268:
269: EXCEPTION

Line 294: l_employee_username := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_USERNAME');

290: l_employee_display_name VARCHAR2(240);
291: BEGIN
292:
293: IF (funcmode = 'RUN') THEN
294: l_employee_username := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_USERNAME');
295: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_employee_username);
296: l_employee_display_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_DISPLAY_NAME');
297: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_employee_display_name);
298:

Line 295: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_employee_username);

291: BEGIN
292:
293: IF (funcmode = 'RUN') THEN
294: l_employee_username := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_USERNAME');
295: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_employee_username);
296: l_employee_display_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_DISPLAY_NAME');
297: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_employee_display_name);
298:
299: IF (wf_directory.UserActive(l_employee_username) = TRUE) THEN

Line 296: l_employee_display_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_DISPLAY_NAME');

292:
293: IF (funcmode = 'RUN') THEN
294: l_employee_username := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_USERNAME');
295: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_employee_username);
296: l_employee_display_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_DISPLAY_NAME');
297: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_employee_display_name);
298:
299: IF (wf_directory.UserActive(l_employee_username) = TRUE) THEN
300: result := 'COMPLETE:FOUND';

Line 297: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_employee_display_name);

293: IF (funcmode = 'RUN') THEN
294: l_employee_username := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_USERNAME');
295: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_employee_username);
296: l_employee_display_name := wf_engine.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_DISPLAY_NAME');
297: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_employee_display_name);
298:
299: IF (wf_directory.UserActive(l_employee_username) = TRUE) THEN
300: result := 'COMPLETE:FOUND';
301: ELSE

Line 346: l_employee_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');

342:
343: BEGIN
344:
345: IF (funcmode = 'RUN') THEN ---<>
346: l_employee_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');
347:
348: OPEN get_supervisor_id_csr;
349: FETCH get_supervisor_id_csr INTO l_supervisor_id;
350: IF (get_supervisor_id_csr%NOTFOUND) THEN

Line 365: wf_engine.SetItemAttrText(itemtype => itemtype,

361: ELSE
362: result := 'COMPLETE:NOT_FOUND';
363: END IF;
364:
365: wf_engine.SetItemAttrText(itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'CERTIFIER_USERNAME',
368: avalue => l_certifier_username);
369:

Line 370: wf_engine.SetItemAttrText(itemType => itemtype,

366: itemkey => itemkey,
367: aname => 'CERTIFIER_USERNAME',
368: avalue => l_certifier_username);
369:
370: wf_engine.SetItemAttrText(itemType => itemtype,
371: itemKey => itemkey,
372: aname => 'CERTIFIER_DISPLAY_NAME',
373: avalue => l_certifier_display_name);
374:

Line 542: l_emp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');

538: l_certifier_display_name VARCHAR2(240);
539: BEGIN
540:
541: IF (funcmode = 'RUN') THEN
542: l_emp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');
543: psp_wf_custom.effort_select_certifier(l_emp_id, l_certifier_id);
544: wf_directory.GetUserName('PER', l_certifier_id, l_certifier_username, l_certifier_display_name);
545:
546: IF ((l_certifier_username IS NOT NULL) AND (l_certifier_display_name IS NOT NULL) AND (wf_directory.UserActive(l_certifier_username))) THEN

Line 547: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_certifier_username);

543: psp_wf_custom.effort_select_certifier(l_emp_id, l_certifier_id);
544: wf_directory.GetUserName('PER', l_certifier_id, l_certifier_username, l_certifier_display_name);
545:
546: IF ((l_certifier_username IS NOT NULL) AND (l_certifier_display_name IS NOT NULL) AND (wf_directory.UserActive(l_certifier_username))) THEN
547: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_certifier_username);
548: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_certifier_display_name);
549: result := 'COMPLETE:FOUND';
550: ELSE
551: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', NULL);

Line 548: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_certifier_display_name);

544: wf_directory.GetUserName('PER', l_certifier_id, l_certifier_username, l_certifier_display_name);
545:
546: IF ((l_certifier_username IS NOT NULL) AND (l_certifier_display_name IS NOT NULL) AND (wf_directory.UserActive(l_certifier_username))) THEN
547: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_certifier_username);
548: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_certifier_display_name);
549: result := 'COMPLETE:FOUND';
550: ELSE
551: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', NULL);
552: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', NULL);

Line 551: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', NULL);

547: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_certifier_username);
548: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_certifier_display_name);
549: result := 'COMPLETE:FOUND';
550: ELSE
551: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', NULL);
552: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', NULL);
553: result := 'COMPLETE:NOT_FOUND';
554: END IF;
555: END IF;

Line 552: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', NULL);

548: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_certifier_display_name);
549: result := 'COMPLETE:FOUND';
550: ELSE
551: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', NULL);
552: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', NULL);
553: result := 'COMPLETE:NOT_FOUND';
554: END IF;
555: END IF;
556:

Line 584: l_emp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');

580: l_approver_display_name VARCHAR2(240);
581: BEGIN
582:
583: IF (funcmode = 'RUN') THEN
584: l_emp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');
585: psp_wf_custom.effort_select_approver(l_emp_id, l_approver_id);
586: wf_directory.GetUserName('PER', l_approver_id, l_approver_username, l_approver_display_name);
587:
588: IF ((l_approver_username IS NOT NULL) AND (l_approver_display_name IS NOT NULL) AND (wf_directory.UserActive(l_approver_username))) THEN

Line 589: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_approver_username);

585: psp_wf_custom.effort_select_approver(l_emp_id, l_approver_id);
586: wf_directory.GetUserName('PER', l_approver_id, l_approver_username, l_approver_display_name);
587:
588: IF ((l_approver_username IS NOT NULL) AND (l_approver_display_name IS NOT NULL) AND (wf_directory.UserActive(l_approver_username))) THEN
589: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_approver_username);
590: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_approver_display_name);
591: result := 'COMPLETE:FOUND';
592: ELSE
593: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', NULL);

Line 590: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_approver_display_name);

586: wf_directory.GetUserName('PER', l_approver_id, l_approver_username, l_approver_display_name);
587:
588: IF ((l_approver_username IS NOT NULL) AND (l_approver_display_name IS NOT NULL) AND (wf_directory.UserActive(l_approver_username))) THEN
589: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_approver_username);
590: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_approver_display_name);
591: result := 'COMPLETE:FOUND';
592: ELSE
593: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', NULL);
594: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', NULL);

Line 593: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', NULL);

589: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_approver_username);
590: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_approver_display_name);
591: result := 'COMPLETE:FOUND';
592: ELSE
593: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', NULL);
594: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', NULL);
595: result := 'COMPLETE:NOT_FOUND';
596: END IF;
597: END IF;

Line 594: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', NULL);

590: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_approver_display_name);
591: result := 'COMPLETE:FOUND';
592: ELSE
593: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', NULL);
594: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', NULL);
595: result := 'COMPLETE:NOT_FOUND';
596: END IF;
597: END IF;
598:

Line 639: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_responder_username);

635: CLOSE get_approval_responder_csr;
636:
637: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
638:
639: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_responder_username);
640: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_responder_display_name);
641:
642: result := 'COMPLETE';
643: END IF;

Line 640: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_responder_display_name);

636:
637: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
638:
639: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_responder_username);
640: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_responder_display_name);
641:
642: result := 'COMPLETE';
643: END IF;
644:

Line 685: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_responder_username);

681: CLOSE get_cert_responder_csr;
682:
683: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
684:
685: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_responder_username);
686: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_responder_display_name);
687:
688: result := 'COMPLETE';
689: END IF;

Line 686: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_responder_display_name);

682:
683: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
684:
685: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_USERNAME', l_responder_username);
686: wf_engine.SetItemAttrText(itemtype, itemkey, 'CERTIFIER_DISPLAY_NAME', l_responder_display_name);
687:
688: result := 'COMPLETE';
689: END IF;
690:

Line 737: l_person_id := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');

733:
734:
735: BEGIN
736: IF (funcmode = 'RUN') THEN
737: l_person_id := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMPLOYEE_PERSON_ID');
738:
739: OPEN get_term_employee_csr;
740: FETCH get_term_employee_csr INTO l_current_employee_flag;
741: CLOSE get_term_employee_csr;

Line 744: wf_engine.SetItemAttrText(itemtype => ItemType,

740: FETCH get_term_employee_csr INTO l_current_employee_flag;
741: CLOSE get_term_employee_csr;
742:
743: IF (l_current_employee_flag IS NULL) THEN
744: wf_engine.SetItemAttrText(itemtype => ItemType,
745: itemkey => ItemKey,
746: aname => 'PROCESS',
747: avalue => 'CERTIFICATION');
748: result := 'COMPLETE:Y';