DBA Data[Home] [Help]

APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on GMS_WF_PKG

Line 496: IF GMS_WF_PKG.Excl_Person_From_Notification(p_award_id, l_user_id) = 'N' THEN

492: --The Exit statement should get executed first, Else the last USERID gets repeated--
493:
494: EXIT WHEN l_wf_notification_role_csr%NOTFOUND;
495: --Start Bug Fix 3224843
496: IF GMS_WF_PKG.Excl_Person_From_Notification(p_award_id, l_user_id) = 'N' THEN
497: l_user_roles := (l_user_roles||','||l_user_name);
498: END IF;
499: --End Bug Fix 3224843
500: --exit when l_wf_notification_role_csr%NOTFOUND;

Line 1231: IF GMS_WF_PKG.Excl_Person_From_Notification(p_award_id, l_user_id) = 'N' THEN

1227: --start bug fix 2204122--
1228: --Exit statement to be executed first , Else the last user id gets repeated--
1229: EXIT WHEN l_wf_notification_role_csr%NOTFOUND;
1230: --start bug fix 3224843--
1231: IF GMS_WF_PKG.Excl_Person_From_Notification(p_award_id, l_user_id) = 'N' THEN
1232: l_user_roles := l_user_roles||','||l_user_name;
1233: END IF;
1234: --end bug fix 3224843--
1235: --exit when l_wf_notification_role_csr%NOTFOUND;