DBA Data[Home] [Help]

APPS.AP_IAW_PKG dependencies on WF_DIRECTORY

Line 1433: --amy see if we have an TCA/WF Directory api for this select

1429:
1430: --Now set the environment
1431: fnd_client_info.set_org_context(l_org_id);
1432:
1433: --amy see if we have an TCA/WF Directory api for this select
1434: SELECT supervisor_id
1435: INTO l_esc_approver_id
1436: FROM per_employees_current_x
1437: WHERE employee_id = l_approver_id;

Line 1439: WF_DIRECTORY.GetUserName('PER',

1435: INTO l_esc_approver_id
1436: FROM per_employees_current_x
1437: WHERE employee_id = l_approver_id;
1438:
1439: WF_DIRECTORY.GetUserName('PER',
1440: l_esc_approver_id,
1441: l_name,
1442: l_esc_approver_name);
1443:

Line 1444: WF_DIRECTORY.GetRoleName('PER',

1440: l_esc_approver_id,
1441: l_name,
1442: l_esc_approver_name);
1443:
1444: WF_DIRECTORY.GetRoleName('PER',
1445: l_esc_approver_id,
1446: l_esc_role,
1447: l_esc_role_display);
1448:

Line 1564: --amy see if we have an TCA/WF Directory api for this select

1560:
1561: --Now set the environment
1562: fnd_client_info.set_org_context(l_org_id);
1563:
1564: --amy see if we have an TCA/WF Directory api for this select
1565: SELECT supervisor_id
1566: INTO l_esc_approver_id
1567: FROM per_employees_current_x
1568: WHERE employee_id = l_approver_id;

Line 1570: WF_DIRECTORY.GetUserName('PER',

1566: INTO l_esc_approver_id
1567: FROM per_employees_current_x
1568: WHERE employee_id = l_approver_id;
1569:
1570: WF_DIRECTORY.GetUserName('PER',
1571: l_esc_approver_id,
1572: l_name,
1573: l_esc_approver_name);
1574:

Line 1575: WF_DIRECTORY.GetRoleName('PER',

1571: l_esc_approver_id,
1572: l_name,
1573: l_esc_approver_name);
1574:
1575: WF_DIRECTORY.GetRoleName('PER',
1576: l_esc_approver_id,
1577: l_esc_role,
1578: l_esc_role_display);
1579:

Line 4134: WF_DIRECTORY.createAdHocRole(

4130: where name = l_adhoc_role_name
4131: and display_name = l_adhoc_display_name;
4132:
4133: IF ( l_adhoc_role_count <= 0 ) THEN
4134: WF_DIRECTORY.createAdHocRole(
4135: role_name => l_adhoc_role_name,
4136: role_display_name => l_adhoc_display_name,
4137: email_address => l_internal_contact_email,
4138: notification_preference => 'QUERY',

Line 4964: wf_directory.getRoleInfo(p_role, display_name, email_address, notification_pref, language, territory);

4960: notification_pref varchar2(30);
4961: language varchar2(30);
4962: territory varchar2(30);
4963: begin
4964: wf_directory.getRoleInfo(p_role, display_name, email_address, notification_pref, language, territory);
4965: return email_address;
4966: end;
4967:
4968: PROCEDURE launch_approval_notif_flow(itemtype IN VARCHAR2,