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 72: IF (funcmode <> wf_engine.eng_run) THEN

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

Line 74: resultout := wf_engine.eng_null;

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

Line 80: l_resp_id := wf_engine.GetItemAttrNumber

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

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

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

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

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

Line 121: wf_engine.SetItemAttrNumber

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

Line 126: wf_engine.SetItemAttrText

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

Line 131: wf_engine.SetItemAttrText

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

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

133: itemkey => itemkey,
134: aname => 'PROJECT_APPROVER_FULL_NAME',
135: avalue => l_approver_full_name
136: );
137: resultout := wf_engine.eng_completed||':'||'T';
138: ELSE
139: CLOSE l_approver_user_csr;
140: resultout := wf_engine.eng_completed||':'||'F';
141: END IF;

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

136: );
137: resultout := wf_engine.eng_completed||':'||'T';
138: ELSE
139: CLOSE l_approver_user_csr;
140: resultout := wf_engine.eng_completed||':'||'F';
141: END IF;
142: ELSE
143: resultout := wf_engine.eng_completed||':'||'F';
144: END IF;

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

139: CLOSE l_approver_user_csr;
140: resultout := wf_engine.eng_completed||':'||'F';
141: END IF;
142: ELSE
143: resultout := wf_engine.eng_completed||':'||'F';
144: END IF;
145:
146: EXCEPTION
147:

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

291:
292: --
293: -- Return if WF Not Running
294: --
295: IF (funcmode <> wf_engine.eng_run) THEN
296: --
297: resultout := wf_engine.eng_null;
298: RETURN;
299: END IF;

Line 297: resultout := wf_engine.eng_null;

293: -- Return if WF Not Running
294: --
295: IF (funcmode <> wf_engine.eng_run) THEN
296: --
297: resultout := wf_engine.eng_null;
298: RETURN;
299: END IF;
300:
301: Get_proj_status_attributes (x_item_type => itemtype,

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

311: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF (l_err_code > 0)
314: THEN
315: resultout := wf_engine.eng_completed||':'||'F';
316: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
317: PA_WORKFLOW_UTILS.Set_Notification_Messages
318: (p_item_type => itemtype
319: , p_item_key => itemkey

Line 326: l_resp_id := wf_engine.GetItemAttrNumber

322: END IF;
323:
324: /* Bug 2345889 Part 2- Begin */
325:
326: l_resp_id := wf_engine.GetItemAttrNumber
327: (itemtype => itemtype,
328: itemkey => itemkey,
329: aname => 'RESPONSIBILITY_ID' );
330:

Line 331: l_project_approver_id := wf_engine.GetItemAttrNumber

327: (itemtype => itemtype,
328: itemkey => itemkey,
329: aname => 'RESPONSIBILITY_ID' );
330:
331: l_project_approver_id := wf_engine.GetItemAttrNumber
332: (itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'PROJECT_APPROVER_ID');
335:

Line 336: l_proj_stus_code := wf_engine.GetItemAttrText

332: (itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'PROJECT_APPROVER_ID');
335:
336: l_proj_stus_code := wf_engine.GetItemAttrText
337: ( itemtype => itemtype,
338: itemkey => itemkey,
339: aname => 'PROJECT_STATUS_CODE' );
340:

Line 372: l_project_id := wf_engine.GetItemAttrNumber

368: /* l_success_status_code can be null, so no need of checking cursor NOT FOUND */
369:
370: /* Bug 2345889 Part 2- End*/
371:
372: l_project_id := wf_engine.GetItemAttrNumber
373: ( itemtype => itemtype,
374: itemkey => itemkey,
375: aname => 'PROJECT_ID');
376:

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

386: l_wf_enabled_flag := 'N';
387: END IF;
388:
389: IF l_verify_ok_flag = 'Y' THEN
390: resultout := wf_engine.eng_completed||':'||'T';
391: IF l_wf_enabled_flag = 'Y' THEN
392:
393: /* Bug 2345889 Part-3 Begin*/
394: /* Commenting out this code and adding the code below instead*/

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

449: p_err_stack => l_err_stack,
450: p_err_stage => l_err_stage,
451: p_err_code => l_err_code );
452: ELSE
453: resultout := wf_engine.eng_completed||':'||'T';
454:
455: /* Bug 2345889 Part-4 Begin*/
456: /* Commenting out this code and adding the code below instead*/
457: /*

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

543: WHERE pps.project_status_code = nvl(c_status_code,' ');
544:
545: BEGIN
546:
547: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
548: itemkey => itemkey,
549: aname => 'NOTE' );
550:
551: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

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

580: END;
581: /* End of code for 7299466*/
582:
583: ELSE
584: resultout := wf_engine.eng_completed||':'||'F';
585: Wf_Status_failure (x_project_id => l_project_id,
586: x_failure_status_code => l_failure_status_code,
587: x_item_type => itemtype,
588: x_item_key => itemkey,

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

626: l_project_id NUMBER := 0;
627: BEGIN
628: -- Return if WF Not Running
629: --
630: IF(funcmode <> wf_engine.eng_run) THEN
631: --
632: resultout := wf_engine.eng_null;
633: RETURN;
634: END IF;

Line 632: resultout := wf_engine.eng_null;

628: -- Return if WF Not Running
629: --
630: IF(funcmode <> wf_engine.eng_run) THEN
631: --
632: resultout := wf_engine.eng_null;
633: RETURN;
634: END IF;
635: Get_proj_status_attributes (x_item_type => itemtype,
636: x_item_key => itemkey,

Line 653: l_project_id := wf_engine.GetItemAttrNumber

649:
650: Pa_workflow_utils.Set_Global_Attr (p_item_type => itemtype,
651: p_item_key => itemkey,
652: p_err_code => l_err_code);
653: l_project_id := wf_engine.GetItemAttrNumber
654: ( itemtype => itemtype,
655: itemkey => itemkey,
656: aname => 'PROJECT_ID');
657: -- Call wf status failure.We only need to update the database

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

663: x_item_key => itemkey,
664: x_update_db_YN => 'Y',
665: x_populate_msg_yn => 'N',
666: x_err_code => l_err_code );
667: resultout := wf_engine.eng_completed||':'||'F';
668:
669: /* Code Added for bug 7299466*/
670: DECLARE
671: l_rowid VARCHAR2(255);

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

681: WHERE pps.project_status_code = nvl(c_status_code,' ');
682:
683: BEGIN
684:
685: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
686: itemkey => itemkey,
687: aname => 'NOTE' );
688:
689: l_proj_stus_code := wf_engine.GetItemAttrText( itemtype => itemtype,

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

685: l_note := wf_engine.GetItemAttrText( itemtype => itemtype,
686: itemkey => itemkey,
687: aname => 'NOTE' );
688:
689: l_proj_stus_code := wf_engine.GetItemAttrText( itemtype => itemtype,
690: itemkey => itemkey,
691: aname => 'PROJECT_STATUS_CODE' );
692:
693: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id

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

752:
753: BEGIN
754: -- Return if WF Not Running
755: --
756: IF(funcmode <> wf_engine.eng_run) THEN
757: --
758: resultout := wf_engine.eng_null;
759: RETURN;
760: --

Line 758: resultout := wf_engine.eng_null;

754: -- Return if WF Not Running
755: --
756: IF(funcmode <> wf_engine.eng_run) THEN
757: --
758: resultout := wf_engine.eng_null;
759: RETURN;
760: --
761: END IF;
762:

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

772: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
773: RAISE FND_API.G_EXC_ERROR;
774: ELSIF (l_err_code > 0)
775: THEN
776: resultout := wf_engine.eng_completed||':'||'F';
777: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
778: PA_WORKFLOW_UTILS.Set_Notification_Messages
779: (p_item_type => itemtype
780: , p_item_key => itemkey

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

784:
785: Pa_workflow_utils.Set_Global_Attr (p_item_type => itemtype,
786: p_item_key => itemkey,
787: p_err_code => l_err_code);
788: l_project_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
789: itemkey => itemkey,
790: aname => 'PROJECT_ID'
791: );
792:

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

797: x_wf_enabled_flag => l_wf_enabled_flag,
798: x_verify_ok_flag => l_verify_ok_flag );
799:
800: IF l_verify_ok_flag = 'Y' THEN
801: resultout := wf_engine.eng_completed||':'||'T';
802: ELSE
803: resultout := wf_engine.eng_completed||':'||'F';
804: Wf_Status_failure (x_project_id => l_project_id,
805: x_failure_status_code => l_failure_status_code,

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

799:
800: IF l_verify_ok_flag = 'Y' THEN
801: resultout := wf_engine.eng_completed||':'||'T';
802: ELSE
803: resultout := wf_engine.eng_completed||':'||'F';
804: Wf_Status_failure (x_project_id => l_project_id,
805: x_failure_status_code => l_failure_status_code,
806: x_item_type => itemtype,
807: x_item_key => itemkey,

Line 874: l_proj_stus_code := wf_engine.GetItemAttrText

870: BEGIN
871: x_err_code := 0;
872: x_success_proj_stus_code := NULL;
873: x_failure_proj_stus_code := NULL;
874: l_proj_stus_code := wf_engine.GetItemAttrText
875: ( itemtype => x_item_type,
876: itemkey => x_item_key,
877: aname => 'PROJECT_STATUS_CODE' );
878: