APPS.PV_OPPORTUNITY_VHUK dependencies on WF_DIRECTORY

Line 65: l_role_list wf_directory.usertable;

61: cursor lc_role_exist_chk (pc_rolename varchar2) is
62: select name from wf_local_roles
63: where name = pc_rolename;
64:
65: l_role_list wf_directory.usertable;
66: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
67: l_username varchar2(50);
68: l_adhoc_role varchar2(80);
69: l_exist_rolename varchar2(80);

Line 145: wf_directory.CreateAdHocRole2(role_name => l_adhoc_role,

141: END LOOP;
142:
143:
144: if l_exist_rolename is null then
145: wf_directory.CreateAdHocRole2(role_name => l_adhoc_role,
146: role_display_name => l_adhoc_role,
147: role_users => l_role_list,
148: expiration_date => sysdate + 5);
149: else

Line 150: wf_directory.AddUsersToAdHocRole2(role_name => l_adhoc_role,

146: role_display_name => l_adhoc_role,
147: role_users => l_role_list,
148: expiration_date => sysdate + 5);
149: else
150: wf_directory.AddUsersToAdHocRole2(role_name => l_adhoc_role,
151: role_users => l_role_list);
152: end if;
153:
154: x_roleName := l_adhoc_role;

Line 230: l_cm_role_list wf_directory.usertable;

226:
227: l_api_name CONSTANT VARCHAR2(30) := 'Send_Email_By_Workflow';
228: l_api_version_number CONSTANT NUMBER := 1.0;
229:
230: l_cm_role_list wf_directory.usertable;
231: l_am_role_list wf_directory.usertable;
232: l_ot_role_list wf_directory.usertable;
233: l_pt_role_list wf_directory.usertable;
234:

Line 231: l_am_role_list wf_directory.usertable;

227: l_api_name CONSTANT VARCHAR2(30) := 'Send_Email_By_Workflow';
228: l_api_version_number CONSTANT NUMBER := 1.0;
229:
230: l_cm_role_list wf_directory.usertable;
231: l_am_role_list wf_directory.usertable;
232: l_ot_role_list wf_directory.usertable;
233: l_pt_role_list wf_directory.usertable;
234:
235: l_am_adhoc_role VARCHAR2(80);

Line 232: l_ot_role_list wf_directory.usertable;

228: l_api_version_number CONSTANT NUMBER := 1.0;
229:
230: l_cm_role_list wf_directory.usertable;
231: l_am_role_list wf_directory.usertable;
232: l_ot_role_list wf_directory.usertable;
233: l_pt_role_list wf_directory.usertable;
234:
235: l_am_adhoc_role VARCHAR2(80);
236: l_cm_adhoc_role VARCHAR2(80);

Line 233: l_pt_role_list wf_directory.usertable;

229:
230: l_cm_role_list wf_directory.usertable;
231: l_am_role_list wf_directory.usertable;
232: l_ot_role_list wf_directory.usertable;
233: l_pt_role_list wf_directory.usertable;
234:
235: l_am_adhoc_role VARCHAR2(80);
236: l_cm_adhoc_role VARCHAR2(80);
237: l_pt_adhoc_role VARCHAR2(80);

Line 334: wf_directory.CreateAdHocRole2(role_name => l_am_adhoc_role,

330: END IF;
331:
332: END LOOP;
333:
334: wf_directory.CreateAdHocRole2(role_name => l_am_adhoc_role,
335: role_display_name => l_am_adhoc_role,
336: role_users => l_am_role_list);
337: END IF;
338:

Line 353: wf_directory.CreateAdHocRole2(role_name => l_cm_adhoc_role,

349: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
350: dEBUG( l_cm_role_list(i) );
351: END IF;
352: END LOOP;
353: wf_directory.CreateAdHocRole2(role_name => l_cm_adhoc_role,
354: role_display_name => l_cm_adhoc_role,
355: role_users => l_cm_role_list);
356: END IF;
357:

Line 372: wf_directory.CreateAdHocRole2(role_name => l_pt_adhoc_role,

368: dEBUG( l_pt_role_list(i) );
369: END IF;
370: END LOOP;
371:
372: wf_directory.CreateAdHocRole2(role_name => l_pt_adhoc_role,
373: role_display_name => l_pt_adhoc_role,
374: role_users => l_pt_role_list);
375: END IF;
376:

Line 391: wf_directory.CreateAdHocRole2(role_name => l_ot_adhoc_role,

387: dEBUG( l_ot_role_list(i) );
388: END IF;
389: END LOOP;
390:
391: wf_directory.CreateAdHocRole2(role_name => l_ot_adhoc_role,
392: role_display_name => l_ot_adhoc_role,
393: role_users => l_ot_role_list);
394:
395: END IF;