APPS.GMS_AWARD_PVT dependencies on GMS_DEFAULT_REPORTS

Line 15: G_report_rec GMS_DEFAULT_REPORTS%ROWTYPE ;

11:
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 ;

Line 2423: l_report_rec gms_default_reports%ROWTYPE ;

2419: L_api_name varchar2(30) := 'GMS_AWARD_PVT.COPY_AWARD';
2420: l_award_rec gms_awards_all%ROWTYPE ;
2421:
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:

Line 2466: from gms_default_reports

2462: -- ======
2463:
2464: cursor c_default_reports is
2465: select *
2466: from gms_default_reports
2467: where award_id = p_award_base_id
2468: and l_base_fund_src_id = g_award_rec.funding_source_id ;
2469:
2470: -- ======

Line 4609: P_REPORT_REC IN GMS_DEFAULT_REPORTS%ROWTYPE

4605: X_ROW_ID OUT NOCOPY VARCHAR2 ,
4606: P_CALLING_MODULE IN VARCHAR2 ,
4607: P_API_VERSION_NUMBER IN NUMBER ,
4608: P_VALIDATE IN BOOLEAN default TRUE,
4609: P_REPORT_REC IN GMS_DEFAULT_REPORTS%ROWTYPE
4610: )
4611: IS
4612:
4613: CURSOR l_dup_reports_csr IS

Line 4615: FROM gms_default_reports

4611: IS
4612:
4613: CURSOR l_dup_reports_csr IS
4614: SELECT 'X'
4615: FROM gms_default_reports
4616: WHERE award_id = G_report_rec.award_id
4617: AND report_template_id = G_report_rec.report_template_id;
4618:
4619: CURSOR l_valid_frequency_csr IS

Line 4812: G_stage := 'gms_default_reports_pkg.insert_row' ;

4808: -- ==================================================
4809: -- Sequence number is required for default report id.
4810: -- ==================================================
4811:
4812: G_stage := 'gms_default_reports_pkg.insert_row' ;
4813:
4814: SELECT gms_default_reports_s.nextval
4815: INTO G_report_rec.default_report_id
4816: FROM dual ;

Line 4814: SELECT gms_default_reports_s.nextval

4810: -- ==================================================
4811:
4812: G_stage := 'gms_default_reports_pkg.insert_row' ;
4813:
4814: SELECT gms_default_reports_s.nextval
4815: INTO G_report_rec.default_report_id
4816: FROM dual ;
4817:
4818: -- ========================================

Line 4822: gms_default_reports_pkg.insert_row(

4818: -- ========================================
4819: -- Calling Table Handler to Insert the Row.
4820: -- ========================================
4821:
4822: gms_default_reports_pkg.insert_row(
4823: X_ROWID => l_rowid,
4824: X_DEFAULT_REPORT_ID => G_report_rec.default_report_id,
4825: X_REPORT_TEMPLATE_ID => G_report_rec.report_template_id,
4826: X_AWARD_ID => G_report_rec.award_id,

Line 4938: FROM gms_default_reports

4934: AND user_id = G_notification_rec.user_id;
4935:
4936: CURSOR l_default_report_csr(x_report_template_id NUMBER) IS
4937: SELECT 'X'
4938: FROM gms_default_reports
4939: WHERE award_id = G_notification_rec.award_id
4940: AND report_template_id = x_report_template_id;
4941:
4942: CURSOR l_report_csr(x_report_template_id NUMBER) IS