APPS.GMS_AWARD_PVT dependencies on GMS_REFERENCE_NUMBERS

Line 13: G_reference_number_rec GMS_REFERENCE_NUMBERS%ROWTYPE ;

9: g_pkg_name CONSTANT VARCHAR2(30) := 'GMS_AWARD_PVT';
10: e_ver_mismatch EXCEPTION ;
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:

Line 2424: l_refnum_rec gms_reference_numbers%ROWTYPE ;

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:
2428: l_base_fund_src_id gms_awards_all.funding_source_id%TYPE ;

Line 2486: from gms_reference_numbers

2482: -- Copy c_reference_numbers cursor.
2483: -- ======
2484: cursor c_reference_numbers is
2485: select *
2486: from gms_reference_numbers
2487: where award_id = p_award_base_id;
2488:
2489: -- ======
2490: -- c_terms_conditions

Line 4143: P_REFERENCE_NUMBER_REC IN GMS_REFERENCE_NUMBERS%ROWTYPE

4139: X_ROW_ID OUT NOCOPY VARCHAR2 ,
4140: P_CALLING_MODULE IN VARCHAR2 ,
4141: P_API_VERSION_NUMBER IN NUMBER ,
4142: P_validate IN BOOLEAN DEFAULT TRUE ,
4143: P_REFERENCE_NUMBER_REC IN GMS_REFERENCE_NUMBERS%ROWTYPE
4144: ) IS
4145:
4146: -- This Cursor is used to validate the incoming TYPE parameter
4147: -- with the lookup_code. It it doesn't exist then we raise an error

Line 4163: FROM gms_reference_numbers

4159: -- ==============================================================================
4160:
4161: CURSOR l_duplicate_ref_type IS
4162: SELECT 'X'
4163: FROM gms_reference_numbers
4164: WHERE award_id = G_reference_number_rec.award_id
4165: AND type = G_reference_number_rec.type ;
4166:
4167: l_api_name VARCHAR2(30) := 'CREATE_PERSONNEL';

Line 4273: gms_reference_numbers_pkg.insert_row

4269:
4270: -- Creating the Reference_number Record .
4271:
4272: G_stage := 'FND_API.Creating_reference_number' ;
4273: gms_reference_numbers_pkg.insert_row
4274: ( x_rowid => l_rowid,
4275: x_award_id => G_reference_number_rec.award_id,
4276: x_type => G_reference_number_rec.type,
4277: x_value => G_reference_number_rec.value,