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 2425: l_termscond_rec gms_awards_terms_conditions%ROWTYPE ;

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

Line 2494: from gms_awards_terms_conditions

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

Line 3896: P_AWARD_TERM_CONDITION_REC IN GMS_AWARDS_TERMS_CONDITIONS%ROWTYPE

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

Line 3912: FROM gms_awards_terms_conditions

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