APPS.GMS_AWARD_PVT dependencies on GMS_INSTALLMENTS

Line 20: G_installment_rec GMS_INSTALLMENTS%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) ;
24: G_calling_module varchar2(30) ;

Line 3096: P_INSTALLMENT_REC IN GMS_INSTALLMENTS%ROWTYPE

3092: X_INSTALLMENT_ID OUT NOCOPY NUMBER ,
3093: P_CALLING_MODULE IN VARCHAR2 ,
3094: P_API_VERSION_NUMBER IN NUMBER,
3095: P_validate IN BOOLEAN DEFAULT TRUE ,
3096: P_INSTALLMENT_REC IN GMS_INSTALLMENTS%ROWTYPE
3097: ) IS
3098:
3099: l_award_start_date_active DATE ;
3100: l_award_end_date_active DATE ;

Line 3116: FROM gms_installments

3112:
3113: -- This is to check the uniqueness of the reference number for that award.
3114: CURSOR l_installment_num_csr(p_installment_num IN VARCHAR2 ,p_award_id IN NUMBER ) IS
3115: SELECT 'X'
3116: FROM gms_installments
3117: WHERE installment_num = p_installment_num
3118: AND award_id = p_award_id ;
3119:
3120: CURSOR l_award_rec_csr(p_award_id IN NUMBER ) IS

Line 3368: SELECT gms_installments_s.nextval

3364: RAISE FND_API.G_EXC_ERROR;
3365: END IF ;
3366:
3367:
3368: SELECT gms_installments_s.nextval
3369: INTO G_installment_rec.installment_id
3370: FROM dual;
3371:
3372: G_stage := 'FND_API.Create_Installment' ;

Line 3374: gms_installments_pkg.insert_row(

3370: FROM dual;
3371:
3372: G_stage := 'FND_API.Create_Installment' ;
3373:
3374: gms_installments_pkg.insert_row(
3375: X_ROWID => l_rowid,
3376: X_INSTALLMENT_ID => G_installment_rec.installment_id,
3377: X_INSTALLMENT_NUM => G_installment_rec.installment_num,
3378: X_AWARD_ID => G_installment_rec.award_id,

Line 4945: gms_installments gi

4941:
4942: CURSOR l_report_csr(x_report_template_id NUMBER) IS
4943: SELECT 'X'
4944: FROM gms_reports gr,
4945: gms_installments gi
4946: WHERE gi.award_id = G_notification_rec.award_id
4947: AND gi.installment_id = gr.installment_id
4948: AND gr.report_template_id = x_report_template_id;
4949:

Line 5143: FROM gms_installments

5139: WHERE award_id = P_AWARD_ID;
5140:
5141: CURSOR l_valid_installment_csr IS
5142: SELECT *
5143: FROM gms_installments
5144: WHERE award_id = P_AWARD_ID
5145: AND installment_id = P_INSTALLMENT_ID;
5146:
5147: CURSOR l_valid_project_csr IS

Line 5171: FROM gms_installments i,

5167: AND task_id = top_task_id;
5168:
5169: CURSOR l_invalid_funding_level_csr IS
5170: SELECT 'X'
5171: FROM gms_installments i,
5172: gms_summary_project_fundings f
5173: WHERE i.award_id = p_award_id
5174: AND f.installment_id = i.installment_id
5175: AND project_id = p_project_id

Line 5208: l_installment_rec GMS_INSTALLMENTS%ROWTYPE;

5204: l_existing_funding_amount NUMBER;
5205: l_total_installment_amount NUMBER;
5206: l_total_funding_amount NUMBER;
5207: l_project_funding_id NUMBER;
5208: l_installment_rec GMS_INSTALLMENTS%ROWTYPE;
5209: l_award_rec GMS_AWARDS_ALL%ROWTYPE;
5210:
5211:
5212: