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

Line 57: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');

53:
54: l_api_name CONSTANT VARCHAR2(30) := 'Select_Approver' ;
55: l_return_status VARCHAR2(1);
56: l_INSTRUCTOR_ID IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE;
57: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');
58: rec_c_set_requestor C_SET_REQUESTOR%ROWTYPE;
59: rec_c_get_lead_instructor C_GET_LEAD_INSTRUCTOR%ROWTYPE;
60:
61: BEGIN

Line 69: OPEN c_set_requestor (wf_engine.getItemAttrText(itemtype, itemkey,'FROM_USER_ID'));

65: IF ( funcmode = 'RUN' ) THEN
66:
67: /******************************** Validation 1 - Set value for the Workflow Attribute REQUESTER_USER_NAME *****************************/
68:
69: OPEN c_set_requestor (wf_engine.getItemAttrText(itemtype, itemkey,'FROM_USER_ID'));
70: FETCH c_set_requestor INTO rec_c_set_requestor;
71: CLOSE c_set_requestor;
72: wf_engine.setItemAttrText(itemtype, itemkey,'FROM_USER',rec_c_set_requestor.user_name);
73:

Line 72: wf_engine.setItemAttrText(itemtype, itemkey,'FROM_USER',rec_c_set_requestor.user_name);

68:
69: OPEN c_set_requestor (wf_engine.getItemAttrText(itemtype, itemkey,'FROM_USER_ID'));
70: FETCH c_set_requestor INTO rec_c_set_requestor;
71: CLOSE c_set_requestor;
72: wf_engine.setItemAttrText(itemtype, itemkey,'FROM_USER',rec_c_set_requestor.user_name);
73:
74: /******************************** Validation 2 - Set the Value For The Workflow Attributes TO_USER_ID ,TO_USER****************************/
75:
76: OPEN c_get_lead_instructor(wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID'));

Line 76: OPEN c_get_lead_instructor(wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID'));

72: wf_engine.setItemAttrText(itemtype, itemkey,'FROM_USER',rec_c_set_requestor.user_name);
73:
74: /******************************** Validation 2 - Set the Value For The Workflow Attributes TO_USER_ID ,TO_USER****************************/
75:
76: OPEN c_get_lead_instructor(wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID'));
77: FETCH c_get_lead_instructor INTO rec_c_get_lead_instructor;
78:
79: IF c_get_lead_instructor%NOTFOUND THEN
80: /* If Lead Instructor not found then return failure */

Line 87: wf_engine.setItemAttrText(itemtype, itemkey, 'TO_USER_ID', rec_c_get_lead_instructor.instructor_id);

83: RETURN;
84: ELSE
85:
86: /* Finding Lead Instructor and corresponding User Name */
87: wf_engine.setItemAttrText(itemtype, itemkey, 'TO_USER_ID', rec_c_get_lead_instructor.instructor_id);
88: wf_engine.setItemAttrText(itemtype, itemkey, 'TO_USER' , rec_c_get_lead_instructor.user_name );
89: END IF;
90:
91: CLOSE c_get_lead_instructor;

Line 88: wf_engine.setItemAttrText(itemtype, itemkey, 'TO_USER' , rec_c_get_lead_instructor.user_name );

84: ELSE
85:
86: /* Finding Lead Instructor and corresponding User Name */
87: wf_engine.setItemAttrText(itemtype, itemkey, 'TO_USER_ID', rec_c_get_lead_instructor.instructor_id);
88: wf_engine.setItemAttrText(itemtype, itemkey, 'TO_USER' , rec_c_get_lead_instructor.user_name );
89: END IF;
90:
91: CLOSE c_get_lead_instructor;
92: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 141: l_PERSON_ID NUMBER(15) := wf_engine.getItemAttrText(itemtype, itemkey,'PERSON_ID');

137: IS
138:
139: l_api_name CONSTANT VARCHAR2(30) := 'Repeat_Process' ;
140: l_return_status VARCHAR2(1);
141: l_PERSON_ID NUMBER(15) := wf_engine.getItemAttrText(itemtype, itemkey,'PERSON_ID');
142: l_UNIT_CD VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'UNIT_CD');
143: l_COURSE_CD VARCHAR2(6) := wf_engine.getItemAttrText(itemtype, itemkey,'COURSE_CD');
144: l_TEACH_CAL_TYPE VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CAL_TYPE');
145: l_TEACH_CI_SEQUENCE_NUMBER NUMBER(6) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CI_SEQUENCE_NUMBER');

Line 142: l_UNIT_CD VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'UNIT_CD');

138:
139: l_api_name CONSTANT VARCHAR2(30) := 'Repeat_Process' ;
140: l_return_status VARCHAR2(1);
141: l_PERSON_ID NUMBER(15) := wf_engine.getItemAttrText(itemtype, itemkey,'PERSON_ID');
142: l_UNIT_CD VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'UNIT_CD');
143: l_COURSE_CD VARCHAR2(6) := wf_engine.getItemAttrText(itemtype, itemkey,'COURSE_CD');
144: l_TEACH_CAL_TYPE VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CAL_TYPE');
145: l_TEACH_CI_SEQUENCE_NUMBER NUMBER(6) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CI_SEQUENCE_NUMBER');
146: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');

Line 143: l_COURSE_CD VARCHAR2(6) := wf_engine.getItemAttrText(itemtype, itemkey,'COURSE_CD');

139: l_api_name CONSTANT VARCHAR2(30) := 'Repeat_Process' ;
140: l_return_status VARCHAR2(1);
141: l_PERSON_ID NUMBER(15) := wf_engine.getItemAttrText(itemtype, itemkey,'PERSON_ID');
142: l_UNIT_CD VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'UNIT_CD');
143: l_COURSE_CD VARCHAR2(6) := wf_engine.getItemAttrText(itemtype, itemkey,'COURSE_CD');
144: l_TEACH_CAL_TYPE VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CAL_TYPE');
145: l_TEACH_CI_SEQUENCE_NUMBER NUMBER(6) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CI_SEQUENCE_NUMBER');
146: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');
147: BEGIN

Line 144: l_TEACH_CAL_TYPE VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CAL_TYPE');

140: l_return_status VARCHAR2(1);
141: l_PERSON_ID NUMBER(15) := wf_engine.getItemAttrText(itemtype, itemkey,'PERSON_ID');
142: l_UNIT_CD VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'UNIT_CD');
143: l_COURSE_CD VARCHAR2(6) := wf_engine.getItemAttrText(itemtype, itemkey,'COURSE_CD');
144: l_TEACH_CAL_TYPE VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CAL_TYPE');
145: l_TEACH_CI_SEQUENCE_NUMBER NUMBER(6) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CI_SEQUENCE_NUMBER');
146: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');
147: BEGIN
148:

Line 145: l_TEACH_CI_SEQUENCE_NUMBER NUMBER(6) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CI_SEQUENCE_NUMBER');

141: l_PERSON_ID NUMBER(15) := wf_engine.getItemAttrText(itemtype, itemkey,'PERSON_ID');
142: l_UNIT_CD VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'UNIT_CD');
143: l_COURSE_CD VARCHAR2(6) := wf_engine.getItemAttrText(itemtype, itemkey,'COURSE_CD');
144: l_TEACH_CAL_TYPE VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CAL_TYPE');
145: l_TEACH_CI_SEQUENCE_NUMBER NUMBER(6) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CI_SEQUENCE_NUMBER');
146: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');
147: BEGIN
148:
149: SAVEPOINT Repeat_Process;

Line 146: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');

142: l_UNIT_CD VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'UNIT_CD');
143: l_COURSE_CD VARCHAR2(6) := wf_engine.getItemAttrText(itemtype, itemkey,'COURSE_CD');
144: l_TEACH_CAL_TYPE VARCHAR2(10) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CAL_TYPE');
145: l_TEACH_CI_SEQUENCE_NUMBER NUMBER(6) := wf_engine.getItemAttrText(itemtype, itemkey,'TEACH_CI_SEQUENCE_NUMBER');
146: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');
147: BEGIN
148:
149: SAVEPOINT Repeat_Process;
150: