APPS.GMS_AWARD_PVT dependencies on GMS_AWARDS_TERMS_CONDITIONS

Line 19: G_term_condition_rec GMS_AWARDS_TERMS_CONDITIONS%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 ;
21: G_msg_count NUMBER ;
22:
23: G_msg_data varchar2(2000) ;

Line 2426: l_termscond_rec gms_awards_terms_conditions%ROWTYPE ;

2422: l_awards_contacts gms_awards_contacts%ROWTYPE ;
2423: l_report_rec gms_default_reports%ROWTYPE ;
2424: l_refnum_rec gms_reference_numbers%ROWTYPE ;
2425: l_personnel_rec gms_personnel%ROWTYPE ;
2426: l_termscond_rec gms_awards_terms_conditions%ROWTYPE ;
2427:
2428: l_base_fund_src_id gms_awards_all.funding_source_id%TYPE ;
2429:
2430: l_default_report_id NUMBER ;

Line 2495: from gms_awards_terms_conditions

2491: -- Copy Terms and conditions cursor.
2492: -- ======
2493: cursor c_terms_conditions is
2494: select *
2495: from gms_awards_terms_conditions
2496: where award_id = p_award_base_id;
2497:
2498: -- ========================================
2499: -- copy award Main Logic.

Line 3898: P_AWARD_TERM_CONDITION_REC IN GMS_AWARDS_TERMS_CONDITIONS%ROWTYPE

3894: X_ROW_ID OUT NOCOPY VARCHAR2 ,
3895: P_CALLING_MODULE IN VARCHAR2 ,
3896: P_API_VERSION_NUMBER IN NUMBER ,
3897: P_validate IN BOOLEAN DEFAULT TRUE ,
3898: P_AWARD_TERM_CONDITION_REC IN GMS_AWARDS_TERMS_CONDITIONS%ROWTYPE
3899: ) IS
3900:
3901: l_award_start_date_active DATE ;
3902: l_award_end_date_active DATE ;

Line 3914: FROM gms_awards_terms_conditions

3910: -- =======================================================================
3911:
3912: CURSOR l_check_duplicate_csr IS
3913: SELECT 'X'
3914: FROM gms_awards_terms_conditions
3915: WHERE award_id = G_term_condition_rec.award_id
3916: AND category_id = G_term_condition_rec.category_id
3917: AND term_id = G_term_condition_rec.term_id ;
3918: