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 4923: P_NOTIFICATION_REC IN GMS_NOTIFICATIONS%ROWTYPE

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

Line 4929: FROM gms_notifications

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