eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_AWARD_PVT dependencies on GMS_AWARDS_ALL

Line 7: G_award_rec GMS_AWARDS_ALL%ROWTYPE ;

3:
4: -- To check on, whether to print debug messages in log file or not
5: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');
6:
7: G_award_rec GMS_AWARDS_ALL%ROWTYPE ;
8: g_api_version_number CONSTANT NUMBER := 1.0;
9: g_pkg_name CONSTANT VARCHAR2(30) := 'GMS_AWARD_PVT';
10: e_ver_mismatch EXCEPTION ;
11:

Line 198: p_award_rec IN GMS_AWARDS_ALL%ROWTYPE )

194: X_row_id OUT NOCOPY VARCHAR2,
195: X_award_id OUT NOCOPY NUMBER ,
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:

Line 1299: x_awd_snm gms_awards_all.award_short_name%TYPE;

1295: PROCEDURE validate_award( X_return_status IN out NOCOPY varchar2) IS
1296:
1297: x_dummy number := 0;
1298: x_agreement_type pa_agreement_types.agreement_type%TYPE ;
1299: x_awd_snm gms_awards_all.award_short_name%TYPE;
1300: L_error BOOLEAN := FALSE ;
1301:
1302: Project_Check NUMBER(2) := 0;
1303:

Line 1312: from gms_awards_all

1308: OR SEGMENT1 = g_award_rec.award_number) ;
1309:
1310: cursor C_AWDNUM_DUP is
1311: select award_id
1312: from gms_awards_all
1313: where award_number = g_award_rec.award_number ;
1314:
1315: cursor C_AWDSNM_DUP is
1316: select award_id

Line 1317: from gms_awards_all

1313: where award_number = g_award_rec.award_number ;
1314:
1315: cursor C_AWDSNM_DUP is
1316: select award_id
1317: from gms_awards_all
1318: where award_SHORT_NAME = g_award_rec.award_short_name ;
1319:
1320: /* Bug 2534936
1321:

Line 1793: INSERT into gms_awards_all

1789: create_agreement(L_agreement_id ) ;
1790:
1791: g_award_rec.agreement_id := L_agreement_id ;
1792:
1793: INSERT into gms_awards_all
1794: (
1795: AWARD_ID ,
1796: AWARD_NUMBER ,
1797: LAST_UPDATE_DATE ,

Line 2419: l_award_rec gms_awards_all%ROWTYPE ;

2415: P_ATTRIBUTE25 IN VARCHAR2 DEFAULT NULL,
2416: P_PROPOSAL_ID IN NUMBER DEFAULT NULL) IS
2417:
2418: L_api_name varchar2(30) := 'GMS_AWARD_PVT.COPY_AWARD';
2419: l_award_rec gms_awards_all%ROWTYPE ;
2420:
2421: l_awards_contacts gms_awards_contacts%ROWTYPE ;
2422: l_report_rec gms_default_reports%ROWTYPE ;
2423: l_refnum_rec gms_reference_numbers%ROWTYPE ;

Line 2427: l_base_fund_src_id gms_awards_all.funding_source_id%TYPE ;

2423: l_refnum_rec gms_reference_numbers%ROWTYPE ;
2424: l_personnel_rec gms_personnel%ROWTYPE ;
2425: l_termscond_rec gms_awards_terms_conditions%ROWTYPE ;
2426:
2427: l_base_fund_src_id gms_awards_all.funding_source_id%TYPE ;
2428:
2429: l_default_report_id NUMBER ;
2430: l_term_id NUMBER ;
2431:

Line 2443: from gms_awards_all

2439: -- to copy award.
2440: -- =========
2441: cursor c_award is
2442: select *
2443: from gms_awards_all
2444: where award_id = p_award_base_id ;
2445:
2446: -- ======
2447: -- gms_awards_contacts

Line 3121: FROM gms_awards_all

3117: AND award_id = p_award_id ;
3118:
3119: CURSOR l_award_rec_csr(p_award_id IN NUMBER ) IS
3120: SELECT start_date_active , end_date_active,close_date
3121: FROM gms_awards_all
3122: WHERE award_id = p_award_id ;
3123:
3124:
3125: PROCEDURE check_installment_required (p_validate IN BOOLEAN ,

Line 3474: l_award_project_id gms_awards_all.award_project_id%TYPE := NULL ;

3470:
3471: l_api_name VARCHAR2(30) := 'CREATE_PERSONNEL';
3472: l_start_date_active gms_personnel.start_date_active%TYPE := NULL ;
3473: l_end_date_active gms_personnel.end_date_active%TYPE := NULL ;
3474: l_award_project_id gms_awards_all.award_project_id%TYPE := NULL ;
3475: l_award_template_flag gms_awards_all.award_template_flag%TYPE := NULL ;
3476: l_budget_wf_enabled_flag gms_awards_all.budget_wf_enabled_flag%TYPE := NULL ;
3477: l_rowid varchar2(45) ;
3478:

Line 3475: l_award_template_flag gms_awards_all.award_template_flag%TYPE := NULL ;

3471: l_api_name VARCHAR2(30) := 'CREATE_PERSONNEL';
3472: l_start_date_active gms_personnel.start_date_active%TYPE := NULL ;
3473: l_end_date_active gms_personnel.end_date_active%TYPE := NULL ;
3474: l_award_project_id gms_awards_all.award_project_id%TYPE := NULL ;
3475: l_award_template_flag gms_awards_all.award_template_flag%TYPE := NULL ;
3476: l_budget_wf_enabled_flag gms_awards_all.budget_wf_enabled_flag%TYPE := NULL ;
3477: l_rowid varchar2(45) ;
3478:
3479:

Line 3476: l_budget_wf_enabled_flag gms_awards_all.budget_wf_enabled_flag%TYPE := NULL ;

3472: l_start_date_active gms_personnel.start_date_active%TYPE := NULL ;
3473: l_end_date_active gms_personnel.end_date_active%TYPE := NULL ;
3474: l_award_project_id gms_awards_all.award_project_id%TYPE := NULL ;
3475: l_award_template_flag gms_awards_all.award_template_flag%TYPE := NULL ;
3476: l_budget_wf_enabled_flag gms_awards_all.budget_wf_enabled_flag%TYPE := NULL ;
3477: l_rowid varchar2(45) ;
3478:
3479:
3480: l_error_code VARCHAR2(2000) ;

Line 3513: FROM gms_awards_all

3509:
3510: CURSOR l_rec_csr(p_award_id IN NUMBER ) IS
3511: SELECT start_date_active,budget_wf_enabled_flag , award_template_flag,
3512: award_project_id , end_date_active
3513: FROM gms_awards_all
3514: WHERE award_id = p_award_id ;
3515:
3516: -- ===============================================================
3517:

Line 3961: FROM gms_awards_all

3957: -- ========================================================================
3958:
3959: CURSOR l_award_rec_csr IS
3960: SELECT start_date_active,end_date_active
3961: FROM gms_awards_all
3962: WHERE award_id = G_term_condition_rec.award_id ;
3963:
3964: -- =======================================================================================
3965: -- This procedure will verify whehter all the NOT NULL columns have values or not.

Line 4331: FROM gms_awards_all

4327: IS
4328: --TCA enhancement : Changing RA tables with HZ tables
4329: CURSOR l_valid_award_csr IS
4330: SELECT award_id,award_project_id
4331: FROM gms_awards_all
4332: WHERE award_id = G_contact_rec.award_id;
4333:
4334: CURSOR l_valid_contact_csr IS
4335: SELECT 'X'

Line 4336: FROM gms_awards_all ga,

4332: WHERE award_id = G_contact_rec.award_id;
4333:
4334: CURSOR l_valid_contact_csr IS
4335: SELECT 'X'
4336: FROM gms_awards_all ga,
4337: Hz_cust_account_roles acct_roles
4338: WHERE ga.award_id = G_contact_rec.award_id
4339: AND decode(ga.billing_format,'LOC',ga.bill_to_customer_id,ga.funding_source_id)=acct_roles.cust_account_id
4340: AND acct_roles.cust_account_role_id = G_contact_rec.contact_id;

Line 4348: gms_awards_all ga

4344: SELECT 'X'
4345: FROM hz_cust_site_uses a,
4346: Hz_cust_acct_sites b,
4347: ar_lookups c,
4348: gms_awards_all ga
4349: WHERE a.cust_acct_site_id = b.cust_acct_site_id
4350: AND b.cust_account_id = decode(ga.billing_format,'LOC',ga.bill_to_customer_id,ga.funding_source_id)
4351: AND c.lookup_type = 'SITE_USE_CODE'
4352: AND c.lookup_code = g_contact_rec.usage_code;

Line 4628: gms_awards_all d

4624: SELECT 'X'
4625: FROM hz_cust_site_uses a,
4626: Hz_cust_acct_sites b,
4627: ar_lookups c,
4628: gms_awards_all d
4629: WHERE a.cust_acct_site_id = b. cust_acct_site_id
4630: AND b. cust_account_id = d.funding_source_id
4631: AND d.award_id = G_report_rec.award_id
4632: AND c.lookup_type = 'SITE_USE_CODE'

Line 5136: FROM gms_awards_all

5132: IS
5133:
5134: CURSOR l_valid_award_csr IS
5135: SELECT *
5136: FROM gms_awards_all
5137: WHERE award_id = P_AWARD_ID;
5138:
5139: CURSOR l_valid_installment_csr IS
5140: SELECT *

Line 5207: l_award_rec GMS_AWARDS_ALL%ROWTYPE;

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:
5211: