APPS.BIS_CORRECTIVE_ACTION_PVT dependencies on WF_DIRECTORY

Line 88: , x_user_tbl OUT NOCOPY wf_directory.UserTable

84: --
85:
86: PROCEDURE Get_User_List_From_Role -- 2684836
87: ( p_recipient_short_name IN VARCHAR2
88: , x_user_tbl OUT NOCOPY wf_directory.UserTable
89: , x_return_status OUT NOCOPY VARCHAR2
90: , x_return_msg OUT NOCOPY VARCHAR2
91: ) ;
92:

Line 437: l_wf_user_table wf_directory.UserTable; -- 2684836

433: l_unscubscribe_url VARCHAR2(32000) := NULL; -- begin 1898436
434: l_notifiers_code bis_pmf_alert_parameters.notifiers_code%TYPE;
435: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type; -- end 1898436
436:
437: l_wf_user_table wf_directory.UserTable; -- 2684836
438: l_return_message VARCHAR2(32000);
439: k NUMBER;
440:
441: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 1340: , x_user_tbl OUT NOCOPY wf_directory.UserTable

1336:
1337:
1338: PROCEDURE Get_User_List_From_Role -- 2684836
1339: ( p_recipient_short_name IN VARCHAR2
1340: , x_user_tbl OUT NOCOPY wf_directory.UserTable
1341: , x_return_status OUT NOCOPY VARCHAR2
1342: , x_return_msg OUT NOCOPY VARCHAR2
1343: )
1344: IS

Line 1346: l_user_tbl wf_directory.UserTable;

1342: , x_return_msg OUT NOCOPY VARCHAR2
1343: )
1344: IS
1345:
1346: l_user_tbl wf_directory.UserTable;
1347: l_num_users NUMBER := 0;
1348:
1349: BEGIN
1350:

Line 1361: wf_directory.GetRoleUsers(p_recipient_short_name, l_user_tbl);

1357: RETURN;
1358: END IF;
1359:
1360:
1361: wf_directory.GetRoleUsers(p_recipient_short_name, l_user_tbl);
1362: x_user_tbl := l_user_tbl;
1363: x_return_status := FND_API.G_RET_STS_SUCCESS;
1364:
1365:

Line 1401: l_user_tbl wf_directory.UserTable;

1397: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;
1398: l_Alert_recipients_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1399: l_Alert_recipients_sh_nm_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
1400: l_notifiers_code VARCHAR2(32000);
1401: l_user_tbl wf_directory.UserTable;
1402: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1403: l_return_status VARCHAR2(32000);
1404:
1405: BEGIN

Line 1487: wf_directory.GetRoleUsers(l_notifiers_code,l_user_tbl);

1483:
1484: BIS_UTILITIES_PUB.put_line(p_text =>'total number of owners: '||l_Alert_recipients_tbl.count);
1485:
1486: l_notifiers_code := l_param_set_tbl(l_param_set_tbl.FIRST).NOTIFIERS_CODE;
1487: wf_directory.GetRoleUsers(l_notifiers_code,l_user_tbl);
1488: IF l_user_tbl.COUNT > 0 THEN
1489: l_Alert_recipients_tbl(l_Alert_recipients_tbl.COUNT+1) := l_notifiers_code;
1490: l_Alert_recipients_sh_nm_tbl(l_Alert_recipients_sh_nm_tbl.COUNT+1) := l_notifiers_code;
1491: BIS_UTILITIES_PUB.put_line(p_text =>'Recipients include '||l_user_tbl.COUNT||' subscriber(s)');

Line 2183: l_users_table Wf_Directory.UserTable;

2179: l_UserExists NUMBER;
2180: l_Count NUMBER := 0;
2181: l_notifiers_code VARCHAR2(300);
2182: l_return_status VARCHAR2(100);
2183: l_users_table Wf_Directory.UserTable;
2184: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
2185: l_user_in_role BOOLEAN := FALSE;
2186: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2187: i NUMBER;

Line 2188: l_user_tbl wf_directory.UserTable;

2184: l_Param_Set_rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
2185: l_user_in_role BOOLEAN := FALSE;
2186: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2187: i NUMBER;
2188: l_user_tbl wf_directory.UserTable;
2189: l_role VARCHAR2(300) := NULL; -- 'BIS_ALERT880';
2190: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2191:
2192:

Line 2221: wf_directory.GetRoleUsers ( l_Notifiers_Code, l_users_table);

2217: , x_Notifiers_Code => l_Notifiers_Code
2218: , x_return_status => l_return_status
2219: );
2220:
2221: wf_directory.GetRoleUsers ( l_Notifiers_Code, l_users_table);
2222:
2223: FOR i IN 1..l_users_table.count LOOP
2224: IF ( l_users_table(i) = l_UserName ) THEN
2225: l_user_in_role := TRUE;

Line 2231: wf_directory.RemoveUsersFromAdHocRole( l_notifiers_code , l_UserName);

2227: END IF;
2228: END LOOP;
2229:
2230: IF l_user_in_role THEN
2231: wf_directory.RemoveUsersFromAdHocRole( l_notifiers_code , l_UserName);
2232: END IF;
2233:
2234: COMMIT;
2235: