DBA Data[Home] [Help]

APPS.GMS_AWARD_PVT dependencies on GMS_NOTIFICATIONS

Line 16: G_notification_rec GMS_NOTIFICATIONS%ROWTYPE ;

12: G_personnel_rec GMS_PERSONNEL%ROWTYPE ;
13: G_reference_number_rec GMS_REFERENCE_NUMBERS%ROWTYPE ;
14: G_contact_rec GMS_AWARDS_CONTACTS%ROWTYPE ;
15: G_report_rec GMS_DEFAULT_REPORTS%ROWTYPE ;
16: G_notification_rec GMS_NOTIFICATIONS%ROWTYPE ;
17:
18: G_gmsimpl_rec GMS_IMPLEMENTATIONS_ALL%ROWTYPE ;
19: G_term_condition_rec GMS_AWARDS_TERMS_CONDITIONS%ROWTYPE ;
20: G_installment_rec GMS_INSTALLMENTS%ROWTYPE ;

Line 4925: P_NOTIFICATION_REC IN GMS_NOTIFICATIONS%ROWTYPE

4921: X_ROW_ID OUT NOCOPY VARCHAR2 ,
4922: P_CALLING_MODULE IN VARCHAR2 ,
4923: P_API_VERSION_NUMBER IN NUMBER ,
4924: P_VALIDATE IN BOOLEAN default TRUE,
4925: P_NOTIFICATION_REC IN GMS_NOTIFICATIONS%ROWTYPE
4926: )
4927: IS
4928:
4929: CURSOR l_dup_event_csr IS

Line 4931: FROM gms_notifications

4927: IS
4928:
4929: CURSOR l_dup_event_csr IS
4930: SELECT 'X'
4931: FROM gms_notifications
4932: WHERE award_id = G_notification_rec.award_id
4933: AND event_type = G_notification_rec.event_type
4934: AND user_id = G_notification_rec.user_id;
4935: