APPS.GMS_AWARD_PVT dependencies on GMS_AWARDS_CONTACTS

Line 14: G_contact_rec GMS_AWARDS_CONTACTS%ROWTYPE ;

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:
18: G_gmsimpl_rec GMS_IMPLEMENTATIONS_ALL%ROWTYPE ;

Line 200: L_contact_rec GMS_AWARDS_CONTACTS%ROWTYPE ;

196: p_calling_module IN VARCHAR2 ,
197: p_api_version_number IN NUMBER ,
198: p_award_rec IN GMS_AWARDS_ALL%ROWTYPE )
199: IS
200: L_contact_rec GMS_AWARDS_CONTACTS%ROWTYPE ;
201: L_personnel_rec gms_personnel%ROWTYPE ;
202:
203: L_setup_award_project_id NUMBER ;
204:

Line 362: --columns are used in creating gms_awards_contacts records.

358:
359: IF L_error THEN
360: set_return_status( X_return_status, 'B') ;
361: ELSE
362: --columns are used in creating gms_awards_contacts records.
363: G_bill_contact_rec.bill_to_contact_id := l_bill_to_cont ;
364: G_bill_contact_rec.ship_to_contact_id := l_ship_to_cont ;
365: G_bill_contact_rec.customer_id := l_customer_id ;
366: G_bill_contact_rec.bill_to_address_id := l_bill_to_adr ;

Line 2422: l_awards_contacts gms_awards_contacts%ROWTYPE ;

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

Line 2448: -- gms_awards_contacts

2444: from gms_awards_all
2445: where award_id = p_award_base_id ;
2446:
2447: -- ======
2448: -- gms_awards_contacts
2449: -- Copy Contacts cursor.
2450: -- ======
2451: -- Bug 2244805. Copy all contacts not just primary contacts
2452: cursor c_award_contacts is

Line 2454: from gms_awards_contacts

2450: -- ======
2451: -- Bug 2244805. Copy all contacts not just primary contacts
2452: cursor c_award_contacts is
2453: select *
2454: from gms_awards_contacts
2455: where award_id = p_award_base_id;
2456: -- and primary_flag <> 'Y' Bug 2244805
2457: -- and l_base_fund_src_id = g_award_rec.funding_source_id ; -- Bug 2244805
2458:

Line 2826: delete from gms_awards_contacts

2822: --
2823: /*****
2824: if (l_base_fund_src_id = g_award_rec.funding_source_id) then
2825:
2826: delete from gms_awards_contacts
2827: where award_id = g_award_rec.award_id;
2828:
2829: for l_rec in c_award_contacts
2830: LOOP

Line 4327: P_CONTACT_REC IN GMS_AWARDS_CONTACTS%ROWTYPE

4323: X_ROW_ID OUT NOCOPY VARCHAR2 ,
4324: P_CALLING_MODULE IN VARCHAR2 ,
4325: P_API_VERSION_NUMBER IN NUMBER ,
4326: P_VALIDATE IN BOOLEAN default TRUE,
4327: P_CONTACT_REC IN GMS_AWARDS_CONTACTS%ROWTYPE
4328: )
4329: IS
4330: --TCA enhancement : Changing RA tables with HZ tables
4331: CURSOR l_valid_award_csr IS

Line 4358: FROM gms_awards_contacts

4354: AND c.lookup_code = g_contact_rec.usage_code;
4355:
4356: CURSOR l_dup_usage_csr IS
4357: SELECT 'X'
4358: FROM gms_awards_contacts
4359: WHERE award_id = G_contact_rec.award_id
4360: AND contact_id = G_contact_rec.contact_id -- Bug 2672027
4361: AND customer_id = G_contact_rec.customer_id
4362: AND usage_code = G_contact_rec.usage_code;

Line 4554: G_stage := 'gms_awards_contacts_pkg.insert_row' ;

4550: -- ========================================
4551: -- Calling Table Handler to Insert the Row.
4552: -- ========================================
4553:
4554: G_stage := 'gms_awards_contacts_pkg.insert_row' ;
4555:
4556: gms_awards_contacts_pkg.insert_row
4557: ( x_rowid => L_rowid,
4558: x_award_id => G_contact_rec.award_id,

Line 4556: gms_awards_contacts_pkg.insert_row

4552: -- ========================================
4553:
4554: G_stage := 'gms_awards_contacts_pkg.insert_row' ;
4555:
4556: gms_awards_contacts_pkg.insert_row
4557: ( x_rowid => L_rowid,
4558: x_award_id => G_contact_rec.award_id,
4559: x_customer_id => G_contact_rec.customer_id,
4560: x_contact_id => G_contact_rec.contact_id,