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 3095: P_INSTALLMENT_REC IN GMS_INSTALLMENTS%ROWTYPE

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

Line 3115: FROM gms_installments

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

Line 3367: SELECT gms_installments_s.nextval

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

Line 3373: gms_installments_pkg.insert_row(

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

Line 4943: gms_installments gi

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

Line 5141: FROM gms_installments

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

Line 5169: FROM gms_installments i,

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

Line 5206: l_installment_rec GMS_INSTALLMENTS%ROWTYPE;

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