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.PN_AM_WF dependencies on WF_ENGINE

Line 122: wf_engine.getitemattrtext (itemtype => itemtype,

118: IF (funcmode = 'RUN')
119: THEN
120: -- Get OAM parameter values from Approvals WF
121: l_trx_type :=
122: wf_engine.getitemattrtext (itemtype => itemtype,
123: itemkey => itemkey,
124: aname => 'TRX_TYPE_ID'
125: );
126: l_app_id :=

Line 127: wf_engine.getitemattrtext (itemtype => itemtype,

123: itemkey => itemkey,
124: aname => 'TRX_TYPE_ID'
125: );
126: l_app_id :=
127: wf_engine.getitemattrtext (itemtype => itemtype,
128: itemkey => itemkey,
129: aname => 'APPLICATION_ID'
130: );
131: l_transaction_id :=

Line 132: wf_engine.getitemattrtext (itemtype => itemtype,

128: itemkey => itemkey,
129: aname => 'APPLICATION_ID'
130: );
131: l_transaction_id :=
132: wf_engine.getitemattrtext (itemtype => itemtype,
133: itemkey => itemkey,
134: aname => 'TRANSACTION_ID'
135: );
136: -- Call OAM api to get approval details

Line 155: wf_engine.setitemattrtext (itemtype => itemtype,

151: p_user_id => l_user_id,
152: x_name => l_approver,
153: x_description => l_name
154: );
155: wf_engine.setitemattrtext (itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'APPROVER',
158: avalue => l_approver
159: );

Line 160: wf_engine.setitemattrtext (itemtype => itemtype,

156: itemkey => itemkey,
157: aname => 'APPROVER',
158: avalue => l_approver
159: );
160: wf_engine.setitemattrtext (itemtype => itemtype,
161: itemkey => itemkey,
162: aname => 'FIRST_NAME',
163: avalue => l_approver_rec.first_name
164: );

Line 165: wf_engine.setitemattrtext (itemtype => itemtype,

161: itemkey => itemkey,
162: aname => 'FIRST_NAME',
163: avalue => l_approver_rec.first_name
164: );
165: wf_engine.setitemattrtext (itemtype => itemtype,
166: itemkey => itemkey,
167: aname => 'LAST_NAME',
168: avalue => l_approver_rec.last_name
169: );

Line 170: wf_engine.setitemattrnumber (itemtype => itemtype,

166: itemkey => itemkey,
167: aname => 'LAST_NAME',
168: avalue => l_approver_rec.last_name
169: );
170: wf_engine.setitemattrnumber (itemtype => itemtype,
171: itemkey => itemkey,
172: aname => 'USER_ID',
173: avalue => l_approver_rec.user_id
174: );

Line 175: wf_engine.setitemattrnumber (itemtype => itemtype,

171: itemkey => itemkey,
172: aname => 'USER_ID',
173: avalue => l_approver_rec.user_id
174: );
175: wf_engine.setitemattrnumber (itemtype => itemtype,
176: itemkey => itemkey,
177: aname => 'PERSON_ID',
178: avalue => l_approver_rec.person_id
179: );

Line 180: wf_engine.setitemattrtext (itemtype => itemtype,

176: itemkey => itemkey,
177: aname => 'PERSON_ID',
178: avalue => l_approver_rec.person_id
179: );
180: wf_engine.setitemattrtext (itemtype => itemtype,
181: itemkey => itemkey,
182: aname => 'API_INSERTION',
183: avalue => l_approver_rec.api_insertion
184: );

Line 185: wf_engine.setitemattrtext (itemtype => itemtype,

181: itemkey => itemkey,
182: aname => 'API_INSERTION',
183: avalue => l_approver_rec.api_insertion
184: );
185: wf_engine.setitemattrtext (itemtype => itemtype,
186: itemkey => itemkey,
187: aname => 'AUTHORITY',
188: avalue => l_approver_rec.authority
189: );

Line 193: wf_engine.getitemattrtext (itemtype => itemtype,

189: );
190: resultout := 'COMPLETE:FOUND';
191: ELSE
192: l_result :=
193: wf_engine.getitemattrtext (itemtype => itemtype,
194: itemkey => itemkey,
195: aname => 'RESULT'
196: );
197: wf_debug ('RESULT' || l_result);

Line 202: wf_engine.setitemattrtext (itemtype => itemtype,

198:
199: IF l_result IS NULL
200: THEN
201: -- There were no appovers, set RESULT to APPROVE
202: wf_engine.setitemattrtext (itemtype => itemtype,
203: itemkey => itemkey,
204: aname => 'RESULT',
205: avalue => 'APPROVED'
206: );

Line 279: wf_engine.getitemattrtext (itemtype => itemtype,

275: BEGIN
276: IF (funcmode = 'RUN')
277: THEN
278: l_result :=
279: wf_engine.getitemattrtext (itemtype => itemtype,
280: itemkey => itemkey,
281: aname => 'RESULT'
282: );
283: wf_debug ('RESULT' || l_result);

Line 285: wf_engine.getitemattrtext (itemtype => itemtype,

281: aname => 'RESULT'
282: );
283: wf_debug ('RESULT' || l_result);
284: l_transaction_id :=
285: wf_engine.getitemattrtext (itemtype => itemtype,
286: itemkey => itemkey,
287: aname => 'TRANSACTION_ID'
288: );
289: wf_debug ('TRANSACTION_ID' || l_transaction_id);

Line 445: wf_engine.createprocess (itemtype => l_itemtype,

441:
442: CLOSE get_app_id_csr;
443:
444: l_key := l_itemtype || l_seq;
445: wf_engine.createprocess (itemtype => l_itemtype,
446: itemkey => l_key,
447: process => l_process
448: );
449: wf_engine.setitemattrtext (itemtype => l_itemtype,

Line 449: wf_engine.setitemattrtext (itemtype => l_itemtype,

445: wf_engine.createprocess (itemtype => l_itemtype,
446: itemkey => l_key,
447: process => l_process
448: );
449: wf_engine.setitemattrtext (itemtype => l_itemtype,
450: itemkey => l_key,
451: aname => 'REQUESTOR',
452: avalue => l_requester
453: );

Line 454: wf_engine.setitemattrtext (itemtype => l_itemtype,

450: itemkey => l_key,
451: aname => 'REQUESTOR',
452: avalue => l_requester
453: );
454: wf_engine.setitemattrtext (itemtype => l_itemtype,
455: itemkey => l_key,
456: aname => 'LEASE_NUMBER',
457: avalue => l_lease_number
458: );

Line 459: wf_engine.setitemattrtext (itemtype => l_itemtype,

455: itemkey => l_key,
456: aname => 'LEASE_NUMBER',
457: avalue => l_lease_number
458: );
459: wf_engine.setitemattrtext (itemtype => l_itemtype,
460: itemkey => l_key,
461: aname => 'TRANSACTION_ID',
462: avalue => p_transaction_id
463: );

Line 464: wf_engine.setitemattrtext (itemtype => l_itemtype,

460: itemkey => l_key,
461: aname => 'TRANSACTION_ID',
462: avalue => p_transaction_id
463: );
464: wf_engine.setitemattrtext (itemtype => l_itemtype,
465: itemkey => l_key,
466: aname => 'APPLICATION_ID',
467: avalue => l_app_id
468: );

Line 469: wf_engine.setitemattrtext (itemtype => l_itemtype,

465: itemkey => l_key,
466: aname => 'APPLICATION_ID',
467: avalue => l_app_id
468: );
469: wf_engine.setitemattrtext (itemtype => l_itemtype,
470: itemkey => l_key,
471: aname => 'LEASE_COMMENCEMENT_DATE',
472: avalue => l_commencement_date
473: );

Line 474: wf_engine.setitemattrtext (itemtype => l_itemtype,

470: itemkey => l_key,
471: aname => 'LEASE_COMMENCEMENT_DATE',
472: avalue => l_commencement_date
473: );
474: wf_engine.setitemattrtext (itemtype => l_itemtype,
475: itemkey => l_key,
476: aname => 'LEASE_TERMINATION_DATE',
477: avalue => l_termination_date
478: );

Line 480: wf_engine.getitemattrtext (itemtype => l_itemtype,

476: aname => 'LEASE_TERMINATION_DATE',
477: avalue => l_termination_date
478: );
479: l_org_id :=
480: wf_engine.getitemattrtext (itemtype => l_itemtype,
481: itemkey => l_key,
482: aname => 'ORG_ID'
483: );
484: wf_debug ('Value of ORG_ID' || l_org_id);

Line 485: wf_engine.setitemattrtext (itemtype => l_itemtype,

481: itemkey => l_key,
482: aname => 'ORG_ID'
483: );
484: wf_debug ('Value of ORG_ID' || l_org_id);
485: wf_engine.setitemattrtext (itemtype => l_itemtype,
486: itemkey => l_key,
487: aname => 'ORG_ID',
488: avalue => l_org_id
489: );

Line 490: wf_engine.setitemattrtext (itemtype => l_itemtype,

486: itemkey => l_key,
487: aname => 'ORG_ID',
488: avalue => l_org_id
489: );
490: wf_engine.setitemattrtext (itemtype => l_itemtype,
491: itemkey => l_key,
492: aname => 'TRX_TYPE_ID',
493: avalue => l_trx_type
494: );

Line 495: wf_engine.startprocess (itemtype => l_itemtype, itemkey => l_key);

491: itemkey => l_key,
492: aname => 'TRX_TYPE_ID',
493: avalue => l_trx_type
494: );
495: wf_engine.startprocess (itemtype => l_itemtype, itemkey => l_key);
496: EXCEPTION
497: WHEN OTHERS
498: THEN
499: IF pn_key_csr%ISOPEN

Line 538: wf_engine.getitemattrtext (itemtype => itemtype,

534: IF (funcmode = 'RUN')
535: THEN
536: -- Get current approval status
537: l_approved_yn :=
538: wf_engine.getitemattrtext (itemtype => itemtype,
539: itemkey => itemkey,
540: aname => 'RESULT'
541: );
542: wf_debug ('RESULT' || l_approved_yn);

Line 553: wf_engine.getitemattrtext (itemtype => itemtype,

549: END IF;
550:
551: -- All OAM attributes
552: l_transaction_id :=
553: wf_engine.getitemattrtext (itemtype => itemtype,
554: itemkey => itemkey,
555: aname => 'TRANSACTION_ID'
556: );
557: l_trx_type :=

Line 558: wf_engine.getitemattrtext (itemtype => itemtype,

554: itemkey => itemkey,
555: aname => 'TRANSACTION_ID'
556: );
557: l_trx_type :=
558: wf_engine.getitemattrtext (itemtype => itemtype,
559: itemkey => itemkey,
560: aname => 'TRX_TYPE_ID'
561: );
562: wf_debug ('TRANSACTION TYPE ID' || l_trx_type);

Line 564: wf_engine.getitemattrnumber (itemtype => itemtype,

560: aname => 'TRX_TYPE_ID'
561: );
562: wf_debug ('TRANSACTION TYPE ID' || l_trx_type);
563: l_app_id :=
564: wf_engine.getitemattrnumber (itemtype => itemtype,
565: itemkey => itemkey,
566: aname => 'APPLICATION_ID'
567: );
568: l_approver_rec.last_name :=

Line 569: wf_engine.getitemattrtext (itemtype => itemtype,

565: itemkey => itemkey,
566: aname => 'APPLICATION_ID'
567: );
568: l_approver_rec.last_name :=
569: wf_engine.getitemattrtext (itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'LAST_NAME'
572: );
573: l_approver_rec.first_name :=

Line 574: wf_engine.getitemattrtext (itemtype => itemtype,

570: itemkey => itemkey,
571: aname => 'LAST_NAME'
572: );
573: l_approver_rec.first_name :=
574: wf_engine.getitemattrtext (itemtype => itemtype,
575: itemkey => itemkey,
576: aname => 'FIRST_NAME'
577: );
578: l_user_id :=

Line 579: wf_engine.getitemattrnumber (itemtype => itemtype,

575: itemkey => itemkey,
576: aname => 'FIRST_NAME'
577: );
578: l_user_id :=
579: wf_engine.getitemattrnumber (itemtype => itemtype,
580: itemkey => itemkey,
581: aname => 'USER_ID'
582: );
583:

Line 592: wf_engine.getitemattrnumber (itemtype => itemtype,

588: l_approver_rec.user_id := l_user_id;
589: END IF;
590:
591: l_approver_rec.person_id :=
592: wf_engine.getitemattrnumber (itemtype => itemtype,
593: itemkey => itemkey,
594: aname => 'PERSON_ID'
595: );
596: l_approver_rec.api_insertion :=

Line 597: wf_engine.getitemattrtext (itemtype => itemtype,

593: itemkey => itemkey,
594: aname => 'PERSON_ID'
595: );
596: l_approver_rec.api_insertion :=
597: wf_engine.getitemattrtext (itemtype => itemtype,
598: itemkey => itemkey,
599: aname => 'API_INSERTION'
600: );
601: l_approver_rec.authority :=

Line 602: wf_engine.getitemattrtext (itemtype => itemtype,

598: itemkey => itemkey,
599: aname => 'API_INSERTION'
600: );
601: l_approver_rec.authority :=
602: wf_engine.getitemattrtext (itemtype => itemtype,
603: itemkey => itemkey,
604: aname => 'AUTHORITY'
605: );
606: ame_api.updateapprovalstatus (applicationidin => l_app_id,

Line 673: wf_engine.setitemattrtext (itemtype => itemtype,

669: SAVEPOINT set_atts;
670:
671: IF (funcmode = 'RUN')
672: THEN
673: wf_engine.setitemattrtext (itemtype => itemtype,
674: itemkey => itemkey,
675: aname => 'RESULT',
676: avalue => 'REJECT'
677: );

Line 868: wf_engine.getitemattrtext (itemtype => itemtype,

864: BEGIN
865: IF (funcmode = 'RUN')
866: THEN
867: l_trx_type :=
868: wf_engine.getitemattrtext (itemtype => itemtype,
869: itemkey => itemkey,
870: aname => 'TRX_TYPE_ID'
871: );
872: l_app_id :=

Line 873: wf_engine.getitemattrtext (itemtype => itemtype,

869: itemkey => itemkey,
870: aname => 'TRX_TYPE_ID'
871: );
872: l_app_id :=
873: wf_engine.getitemattrtext (itemtype => itemtype,
874: itemkey => itemkey,
875: aname => 'APPLICATION_ID'
876: );
877: