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

Line 74: IF (funcmode <> wf_engine.eng_run) THEN

70: BEGIN
71: --
72: -- Return if WF Not Running
73: --
74: IF (funcmode <> wf_engine.eng_run) THEN
75: --
76: resultout := wf_engine.eng_null;
77: RETURN;
78: --

Line 76: resultout := wf_engine.eng_null;

72: -- Return if WF Not Running
73: --
74: IF (funcmode <> wf_engine.eng_run) THEN
75: --
76: resultout := wf_engine.eng_null;
77: RETURN;
78: --
79: END IF;
80: --

Line 82: l_resp_id := wf_engine.GetItemAttrNumber

78: --
79: END IF;
80: --
81:
82: l_resp_id := wf_engine.GetItemAttrNumber
83: (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'RESPONSIBILITY_ID' );
86:

Line 87: l_project_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

83: (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'RESPONSIBILITY_ID' );
86:
87: l_project_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'PROJECT_ID' );
90: l_workflow_started_by_id :=
91: wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 91: wf_engine.GetItemAttrNumber(itemtype => itemtype,

87: l_project_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'PROJECT_ID' );
90: l_workflow_started_by_id :=
91: wf_engine.GetItemAttrNumber(itemtype => itemtype,
92: itemkey => itemkey,
93: aname => 'WORKFLOW_STARTED_BY_ID' );
94:
95: -- Based on the Responsibility, Intialize the Application

Line 123: wf_engine.SetItemAttrNumber

119: ,l_approver_full_name;
120: IF (l_approver_user_csr%FOUND)
121: THEN
122: CLOSE l_approver_user_csr;
123: wf_engine.SetItemAttrNumber
124: (itemtype => itemtype,
125: itemkey => itemkey,
126: aname => 'PROJECT_APPROVER_ID',
127: avalue => l_approver_user_id );

Line 128: wf_engine.SetItemAttrText

124: (itemtype => itemtype,
125: itemkey => itemkey,
126: aname => 'PROJECT_APPROVER_ID',
127: avalue => l_approver_user_id );
128: wf_engine.SetItemAttrText
129: (itemtype => itemtype,
130: itemkey => itemkey,
131: aname => 'PROJECT_APPROVER_NAME',
132: avalue => l_approver_user_name);

Line 133: wf_engine.SetItemAttrText

129: (itemtype => itemtype,
130: itemkey => itemkey,
131: aname => 'PROJECT_APPROVER_NAME',
132: avalue => l_approver_user_name);
133: wf_engine.SetItemAttrText
134: (itemtype => itemtype,
135: itemkey => itemkey,
136: aname => 'PROJECT_APPROVER_FULL_NAME',
137: avalue => l_approver_full_name

Line 150: wf_engine.SetItemAttrText

146: , role_display_name => l_approver_full_name
147: , expiration_date => sysdate+1
148: );
149:
150: wf_engine.SetItemAttrText
151: (itemtype => itemtype,
152: itemkey => itemkey,
153: aname => '#FROM_ROLE',
154: avalue => l_approver_role );

Line 158: resultout := wf_engine.eng_completed||':'||'T';

154: avalue => l_approver_role );
155:
156: --Bug 12678735.Changes ends.
157:
158: resultout := wf_engine.eng_completed||':'||'T';
159: ELSE
160: CLOSE l_approver_user_csr;
161: resultout := wf_engine.eng_completed||':'||'F';
162: END IF;

Line 161: resultout := wf_engine.eng_completed||':'||'F';

157:
158: resultout := wf_engine.eng_completed||':'||'T';
159: ELSE
160: CLOSE l_approver_user_csr;
161: resultout := wf_engine.eng_completed||':'||'F';
162: END IF;
163: ELSE
164: resultout := wf_engine.eng_completed||':'||'F';
165: END IF;

Line 164: resultout := wf_engine.eng_completed||':'||'F';

160: CLOSE l_approver_user_csr;
161: resultout := wf_engine.eng_completed||':'||'F';
162: END IF;
163: ELSE
164: resultout := wf_engine.eng_completed||':'||'F';
165: END IF;
166:
167: EXCEPTION
168:

Line 316: IF (funcmode <> wf_engine.eng_run) THEN

312:
313: --
314: -- Return if WF Not Running
315: --
316: IF (funcmode <> wf_engine.eng_run) THEN
317: --
318: resultout := wf_engine.eng_null;
319: RETURN;
320: END IF;

Line 318: resultout := wf_engine.eng_null;

314: -- Return if WF Not Running
315: --
316: IF (funcmode <> wf_engine.eng_run) THEN
317: --
318: resultout := wf_engine.eng_null;
319: RETURN;
320: END IF;
321:
322: Get_proj_status_attributes (x_item_type => itemtype,

Line 336: resultout := wf_engine.eng_completed||':'||'F';

332: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF (l_err_code > 0)
335: THEN
336: resultout := wf_engine.eng_completed||':'||'F';
337: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
338: PA_WORKFLOW_UTILS.Set_Notification_Messages
339: (p_item_type => itemtype
340: , p_item_key => itemkey

Line 347: l_resp_id := wf_engine.GetItemAttrNumber

343: END IF;
344:
345: /* Bug 2345889 Part 2- Begin */
346:
347: l_resp_id := wf_engine.GetItemAttrNumber
348: (itemtype => itemtype,
349: itemkey => itemkey,
350: aname => 'RESPONSIBILITY_ID' );
351:

Line 352: l_project_approver_id := wf_engine.GetItemAttrNumber

348: (itemtype => itemtype,
349: itemkey => itemkey,
350: aname => 'RESPONSIBILITY_ID' );
351:
352: l_project_approver_id := wf_engine.GetItemAttrNumber
353: (itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'PROJECT_APPROVER_ID');
356:

Line 357: l_proj_stus_code := wf_engine.GetItemAttrText

353: (itemtype => itemtype,
354: itemkey => itemkey,
355: aname => 'PROJECT_APPROVER_ID');
356:
357: l_proj_stus_code := wf_engine.GetItemAttrText
358: ( itemtype => itemtype,
359: itemkey => itemkey,
360: aname => 'PROJECT_STATUS_CODE' );
361:

Line 393: l_project_id := wf_engine.GetItemAttrNumber

389: /* l_success_status_code can be null, so no need of checking cursor NOT FOUND */
390:
391: /* Bug 2345889 Part 2- End*/
392:
393: l_project_id := wf_engine.GetItemAttrNumber
394: ( itemtype => itemtype,
395: itemkey => itemkey,
396: aname => 'PROJECT_ID');
397:

Line 411: resultout := wf_engine.eng_completed||':'||'T';

407: l_wf_enabled_flag := 'N';
408: END IF;
409:
410: IF l_verify_ok_flag = 'Y' THEN
411: resultout := wf_engine.eng_completed||':'||'T';
412: IF l_wf_enabled_flag = 'Y' THEN
413:
414: /* Bug 2345889 Part-3 Begin*/
415: /* Commenting out this code and adding the code below instead*/

Line 474: resultout := wf_engine.eng_completed||':'||'T';

470: p_err_stack => l_err_stack,
471: p_err_stage => l_err_stage,
472: p_err_code => l_err_code );
473: ELSE
474: resultout := wf_engine.eng_completed||':'||'T';
475:
476: /* Bug 2345889 Part-4 Begin*/
477: /* Commenting out this code and adding the code below instead*/
478: /*

Line 569: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,

565: WHERE pps.project_status_code = nvl(c_status_code,' ');
566:
567: BEGIN
568:
569: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
570: itemkey => itemkey,
571: aname => 'NOTE' );
572:
573: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

Line 606: resultout := wf_engine.eng_completed||':'||'F';

602: END;
603: /* End of code for 7299466*/
604:
605: ELSE
606: resultout := wf_engine.eng_completed||':'||'F';
607: Wf_Status_failure (x_project_id => l_project_id,
608: x_failure_status_code => l_failure_status_code,
609: x_item_type => itemtype,
610: x_item_key => itemkey,

Line 652: IF(funcmode <> wf_engine.eng_run) THEN

648: l_project_id NUMBER := 0;
649: BEGIN
650: -- Return if WF Not Running
651: --
652: IF(funcmode <> wf_engine.eng_run) THEN
653: --
654: resultout := wf_engine.eng_null;
655: RETURN;
656: END IF;

Line 654: resultout := wf_engine.eng_null;

650: -- Return if WF Not Running
651: --
652: IF(funcmode <> wf_engine.eng_run) THEN
653: --
654: resultout := wf_engine.eng_null;
655: RETURN;
656: END IF;
657: Get_proj_status_attributes (x_item_type => itemtype,
658: x_item_key => itemkey,

Line 675: l_project_id := wf_engine.GetItemAttrNumber

671:
672: Pa_workflow_utils.Set_Global_Attr (p_item_type => itemtype,
673: p_item_key => itemkey,
674: p_err_code => l_err_code);
675: l_project_id := wf_engine.GetItemAttrNumber
676: ( itemtype => itemtype,
677: itemkey => itemkey,
678: aname => 'PROJECT_ID');
679: -- Call wf status failure.We only need to update the database

Line 689: resultout := wf_engine.eng_completed||':'||'F';

685: x_item_key => itemkey,
686: x_update_db_YN => 'Y',
687: x_populate_msg_yn => 'N',
688: x_err_code => l_err_code );
689: resultout := wf_engine.eng_completed||':'||'F';
690:
691: /* Code Added for bug 7299466*/
692: DECLARE
693: l_rowid VARCHAR2(255);

Line 707: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,

703: WHERE pps.project_status_code = nvl(c_status_code,' ');
704:
705: BEGIN
706:
707: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'NOTE' );
710:
711: l_proj_stus_code := wf_engine.GetItemAttrText( itemtype => itemtype,

Line 711: l_proj_stus_code := wf_engine.GetItemAttrText( itemtype => itemtype,

707: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'NOTE' );
710:
711: l_proj_stus_code := wf_engine.GetItemAttrText( itemtype => itemtype,
712: itemkey => itemkey,
713: aname => 'PROJECT_STATUS_CODE' );
714:
715: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

Line 778: IF(funcmode <> wf_engine.eng_run) THEN

774:
775: BEGIN
776: -- Return if WF Not Running
777: --
778: IF(funcmode <> wf_engine.eng_run) THEN
779: --
780: resultout := wf_engine.eng_null;
781: RETURN;
782: --

Line 780: resultout := wf_engine.eng_null;

776: -- Return if WF Not Running
777: --
778: IF(funcmode <> wf_engine.eng_run) THEN
779: --
780: resultout := wf_engine.eng_null;
781: RETURN;
782: --
783: END IF;
784:

Line 798: resultout := wf_engine.eng_completed||':'||'F';

794: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF (l_err_code > 0)
797: THEN
798: resultout := wf_engine.eng_completed||':'||'F';
799: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
800: PA_WORKFLOW_UTILS.Set_Notification_Messages
801: (p_item_type => itemtype
802: , p_item_key => itemkey

Line 810: l_project_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

806:
807: Pa_workflow_utils.Set_Global_Attr (p_item_type => itemtype,
808: p_item_key => itemkey,
809: p_err_code => l_err_code);
810: l_project_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
811: itemkey => itemkey,
812: aname => 'PROJECT_ID'
813: );
814:

Line 823: resultout := wf_engine.eng_completed||':'||'T';

819: x_wf_enabled_flag => l_wf_enabled_flag,
820: x_verify_ok_flag => l_verify_ok_flag );
821:
822: IF l_verify_ok_flag = 'Y' THEN
823: resultout := wf_engine.eng_completed||':'||'T';
824: ELSE
825: resultout := wf_engine.eng_completed||':'||'F';
826: Wf_Status_failure (x_project_id => l_project_id,
827: x_failure_status_code => l_failure_status_code,

Line 825: resultout := wf_engine.eng_completed||':'||'F';

821:
822: IF l_verify_ok_flag = 'Y' THEN
823: resultout := wf_engine.eng_completed||':'||'T';
824: ELSE
825: resultout := wf_engine.eng_completed||':'||'F';
826: Wf_Status_failure (x_project_id => l_project_id,
827: x_failure_status_code => l_failure_status_code,
828: x_item_type => itemtype,
829: x_item_key => itemkey,

Line 899: l_proj_stus_code := wf_engine.GetItemAttrText

895: BEGIN
896: x_err_code := 0;
897: x_success_proj_stus_code := NULL;
898: x_failure_proj_stus_code := NULL;
899: l_proj_stus_code := wf_engine.GetItemAttrText
900: ( itemtype => x_item_type,
901: itemkey => x_item_key,
902: aname => 'PROJECT_STATUS_CODE' );
903: