APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on GMS_NOTIFICATIONS_V

Line 305: FROM gms_notifications_v

301:
302: CURSOR l_wf_notification_role_csr(p_award_id NUMBER)
303: IS
304: SELECT user_id, user_name
305: FROM gms_notifications_v
306: WHERE award_id = p_award_id
307: AND event_type = 'BUDGET_BASELINE';
308:
309: -- Get System Date for Worflow-Started-Date

Line 486: -- GMS_NOTIFICATIONS_V table/view.

482: CLOSE l_wf_started_date_csr;
483:
484: --------------------------------------------------------------------------------
485: -- Creating Role and Users required for GMS Workflow process; based on data in
486: -- GMS_NOTIFICATIONS_V table/view.
487:
488: OPEN l_wf_notification_role_csr(p_award_id);
489: LOOP
490: FETCH l_wf_notification_role_csr INTO l_user_id, l_user_name;

Line 548: -- If there is atleast one user defined in GMS_NOTIFICATIONS_V for this award

544:
545: wf_directory.RemoveUsersFromAdhocRole(role_name => l_role_name);
546:
547: -------------------------------------------------------------------------------------------------------------
548: -- If there is atleast one user defined in GMS_NOTIFICATIONS_V for this award
549: -- then
550: -- add the user to the above created role.
551: -- else
552: -- raise exception since WF will fail while looking for users to send notifications to.

Line 1043: FROM gms_notifications_v

1039:
1040: CURSOR l_wf_notification_role_csr(p_award_id NUMBER)
1041: IS
1042: SELECT user_id, user_name
1043: FROM gms_notifications_v
1044: WHERE award_id = p_award_id
1045: AND event_type = 'BUDGET_BASELINE';
1046:
1047: -- Get System Date for Worflow-Started-Date

Line 1222: -- GMS_NOTIFICATIONS_V table/view.

1218: CLOSE l_wf_started_date_csr;
1219:
1220: --------------------------------------------------------------------------------
1221: -- Creating Role and Users required for GMS Workflow process; based on data in
1222: -- GMS_NOTIFICATIONS_V table/view.
1223:
1224: OPEN l_wf_notification_role_csr(p_award_id);
1225: LOOP
1226: FETCH l_wf_notification_role_csr INTO l_user_id, l_user_name;

Line 1289: -- If there is atleast one user defined in GMS_NOTIFICATIONS_V for this award

1285:
1286: wf_directory.RemoveUsersFromAdhocRole(role_name => l_role_name);
1287:
1288: -------------------------------------------------------------------------------------------------------------
1289: -- If there is atleast one user defined in GMS_NOTIFICATIONS_V for this award
1290: -- then
1291: -- add the user to the above created role.
1292: -- else
1293: -- raise exception since WF will fail while looking for users to send notifications to.