DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on WF_ENGINE

Line 124: wf_engine.SetItemAttrText(p_item_type, p_item_key,

120: FETCH getStructureVerInfo INTO l_structure_ver_num, l_structure_ver_name, l_project_id, l_locked_by_person_id, l_record_version_num, l_structure_ver_desc;
121: CLOSE getStructureVerInfo;
122:
123: --set structure_ver_name
124: wf_engine.SetItemAttrText(p_item_type, p_item_key,
125: 'STRUCTURE_VER_NAME',l_structure_ver_name);
126:
127: --set structure_ver_number
128: wf_engine.SetItemAttrText(p_item_type, p_item_key,

Line 128: wf_engine.SetItemAttrText(p_item_type, p_item_key,

124: wf_engine.SetItemAttrText(p_item_type, p_item_key,
125: 'STRUCTURE_VER_NAME',l_structure_ver_name);
126:
127: --set structure_ver_number
128: wf_engine.SetItemAttrText(p_item_type, p_item_key,
129: 'STRUCTURE_VER_NUM', to_char(l_structure_ver_num));
130:
131: --set structure_ver_id
132: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,

Line 132: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,

128: wf_engine.SetItemAttrText(p_item_type, p_item_key,
129: 'STRUCTURE_VER_NUM', to_char(l_structure_ver_num));
130:
131: --set structure_ver_id
132: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,
133: 'STRUCTURE_VER_ID',p_structure_version_id);
134: wf_engine.SetItemAttrText(p_item_type, p_item_key,
135: 'STRUCTURE_VER_ID_T',to_char(p_structure_version_id));
136:

Line 134: wf_engine.SetItemAttrText(p_item_type, p_item_key,

130:
131: --set structure_ver_id
132: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,
133: 'STRUCTURE_VER_ID',p_structure_version_id);
134: wf_engine.SetItemAttrText(p_item_type, p_item_key,
135: 'STRUCTURE_VER_ID_T',to_char(p_structure_version_id));
136:
137: --set structure_ver_name
138: wf_engine.SetItemAttrText(p_item_type, p_item_key,

Line 138: wf_engine.SetItemAttrText(p_item_type, p_item_key,

134: wf_engine.SetItemAttrText(p_item_type, p_item_key,
135: 'STRUCTURE_VER_ID_T',to_char(p_structure_version_id));
136:
137: --set structure_ver_name
138: wf_engine.SetItemAttrText(p_item_type, p_item_key,
139: 'STRUCTURE_VER_DESC',l_structure_ver_desc);
140:
141: --set record_version_number
142: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,

Line 142: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,

138: wf_engine.SetItemAttrText(p_item_type, p_item_key,
139: 'STRUCTURE_VER_DESC',l_structure_ver_desc);
140:
141: --set record_version_number
142: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,
143: 'RECORD_VERSION_NUMBER',l_record_version_num);
144:
145:
146: OPEN getProjectInfo(l_project_id);

Line 151: wf_engine.SetItemAttrText(p_item_type, p_item_key,

147: FETCH getProjectInfo into l_project_name, l_project_num;
148: CLOSE getProjectInfo;
149:
150: --set project_name
151: wf_engine.SetItemAttrText(p_item_type, p_item_key,
152: 'PROJECT_NAME', l_project_name);
153: --set project_num
154: wf_engine.SetItemAttrText(p_item_type, p_item_key,
155: 'PROJECT_NUM', l_project_num);

Line 154: wf_engine.SetItemAttrText(p_item_type, p_item_key,

150: --set project_name
151: wf_engine.SetItemAttrText(p_item_type, p_item_key,
152: 'PROJECT_NAME', l_project_name);
153: --set project_num
154: wf_engine.SetItemAttrText(p_item_type, p_item_key,
155: 'PROJECT_NUM', l_project_num);
156: --set project_id
157: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,
158: 'PROJECT_ID', l_project_id);

Line 157: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,

153: --set project_num
154: wf_engine.SetItemAttrText(p_item_type, p_item_key,
155: 'PROJECT_NUM', l_project_num);
156: --set project_id
157: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,
158: 'PROJECT_ID', l_project_id);
159:
160: --set responsibility_id
161: wf_engine.SetItemAttrNUMBER(p_item_type, p_item_key,

Line 161: wf_engine.SetItemAttrNUMBER(p_item_type, p_item_key,

157: wf_engine.SetItemAttrNumber(p_item_type, p_item_key,
158: 'PROJECT_ID', l_project_id);
159:
160: --set responsibility_id
161: wf_engine.SetItemAttrNUMBER(p_item_type, p_item_key,
162: 'RESPONSIBILITY_ID', p_responsibility_id);
163:
164: --set user_id
165: wf_engine.SetItemAttrNUMBER(p_item_type, p_item_key,

Line 165: wf_engine.SetItemAttrNUMBER(p_item_type, p_item_key,

161: wf_engine.SetItemAttrNUMBER(p_item_type, p_item_key,
162: 'RESPONSIBILITY_ID', p_responsibility_id);
163:
164: --set user_id
165: wf_engine.SetItemAttrNUMBER(p_item_type, p_item_key,
166: 'USER_ID', p_user_id);
167:
168: --set workplan_submitter
169: l_submitter_role := 'SUBMITBY_'||p_item_type||p_item_key;

Line 209: wf_engine.setItemAttrText(p_item_type

205:
206: IF (l_submitter_role_users IS NOT NULL) THEN
207: wf_directory.addUsersToAdHocRole(l_submitter_role,
208: l_submitter_role_users);
209: wf_engine.setItemAttrText(p_item_type
210: ,p_item_key
211: ,'WORKPLAN_SUBMITTER'
212: ,l_submitter_role);
213:

Line 214: wf_engine.SetItemAttrText

210: ,p_item_key
211: ,'WORKPLAN_SUBMITTER'
212: ,l_submitter_role);
213:
214: wf_engine.SetItemAttrText
215: (itemtype => p_item_type,
216: itemkey => p_item_key,
217: aname => '#FROM_ROLE',
218: avalue => l_submitter_role -- Added for bug# 7368606

Line 362: l_project_id := wf_engine.getItemAttrNumber(

358: territory VARCHAR2(2000);
359: l_approver_name per_all_people_f.full_name%type; -- Added for bug# 3732090
360: BEGIN
361: /* get stored values */
362: l_project_id := wf_engine.getItemAttrNumber(
363: itemtype => p_item_type
364: ,itemkey => p_item_key
365: ,aname => 'PROJECT_ID');
366:

Line 367: l_submitted_by_id := wf_engine.getItemAttrNumber(

363: itemtype => p_item_type
364: ,itemkey => p_item_key
365: ,aname => 'PROJECT_ID');
366:
367: l_submitted_by_id := wf_engine.getItemAttrNumber(
368: itemtype => p_item_type
369: ,itemkey => p_item_key
370: ,aname => 'SUBMITTED_BY_ID');
371:

Line 466: /* wf_engine.SetItemAttrText

462: wf_directory.CreateAdHocRole(role_name => l_approval_role
463: ,role_display_name => l_approver_name -- Modifed the parameter from l_approval_role to l_approver_name bug#3732090
464: ,expiration_date => sysdate+15); -- Set an expiration date for bug#5962410
465:
466: /* wf_engine.SetItemAttrText
467: (itemtype => p_item_type,
468: itemkey => p_item_key,
469: aname => '#FROM_ROLE',
470: avalue => l_approval_role ); janani */

Line 477: WF_engine.setItemAttrText(p_item_type,

473: IF (l_approval_role_users IS NOT NULL) THEN
474: --Add the selected user(s) to the role
475: WF_DIRECTORY.ADDUSERSTOADHOCROLE(l_approval_role,
476: l_approval_role_users);
477: WF_engine.setItemAttrText(p_item_type,
478: p_item_key,
479: 'WORKPLAN_APPROVER',
480: l_approval_role);
481: resultout := wf_engine.eng_completed||':'||'T';

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

477: WF_engine.setItemAttrText(p_item_type,
478: p_item_key,
479: 'WORKPLAN_APPROVER',
480: l_approval_role);
481: resultout := wf_engine.eng_completed||':'||'T';
482: ELSE
483: resultout := wf_engine.eng_completed||':'||'F';
484: END IF;
485: EXCEPTION

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

479: 'WORKPLAN_APPROVER',
480: l_approval_role);
481: resultout := wf_engine.eng_completed||':'||'T';
482: ELSE
483: resultout := wf_engine.eng_completed||':'||'F';
484: END IF;
485: EXCEPTION
486: WHEN OTHERS THEN
487: RAISE;

Line 785: l_project_id := wf_engine.GetItemAttrNumber(

781: BEGIN
782: --Need to set the followings
783: -- APPROVED_REJECTED_RECEIVER
784: -- WORKPLAN_VIEWER
785: l_project_id := wf_engine.GetItemAttrNumber(
786: itemtype => p_item_type,
787: itemkey => p_item_key,
788: aname => 'PROJECT_ID');
789:

Line 790: l_structure_version_id := wf_engine.GetItemAttrNumber(

786: itemtype => p_item_type,
787: itemkey => p_item_key,
788: aname => 'PROJECT_ID');
789:
790: l_structure_version_id := wf_engine.GetItemAttrNumber(
791: itemtype => p_item_type,
792: itemkey => p_item_key,
793: aname => 'STRUCTURE_VER_ID');
794:

Line 849: wf_engine.setitemattrtext(p_item_type

845: IF (l_appr_rej_role_usr IS NOT NULL) THEN
846: --Add the selected user(s) to the role
847: wf_directory.adduserstoadhocRole(l_appr_rej_role
848: ,l_appr_rej_role_usr);
849: wf_engine.setitemattrtext(p_item_type
850: ,p_item_key
851: ,'APPROVED_REJECTED_RECEIVER'
852: ,l_appr_rej_role);
853: END IF;

Line 908: wf_engine.setitemattrtext(p_item_type

904: IF (l_wp_viewer_role_usr IS NOT NULL) THEN
905: --Add the selected user(s) to the role
906: wf_directory.adduserstoadhocRole(l_wp_viewer_role
907: ,l_wp_viewer_role_usr);
908: wf_engine.setitemattrtext(p_item_type
909: ,p_item_key
910: ,'WORKPLAN_VIEWER'
911: ,l_wp_viewer_role);
912: END IF;