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 1794: INSERT into gms_awards_all

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

Line 2420: l_award_rec gms_awards_all%ROWTYPE ;

2416: P_ATTRIBUTE25 IN VARCHAR2 DEFAULT NULL,
2417: P_PROPOSAL_ID IN NUMBER DEFAULT NULL) IS
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 ;

Line 2428: l_base_fund_src_id gms_awards_all.funding_source_id%TYPE ;

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 ;
2429:
2430: l_default_report_id NUMBER ;
2431: l_term_id NUMBER ;
2432:

Line 2444: from gms_awards_all

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

Line 3122: FROM gms_awards_all

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

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

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

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

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

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

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

Line 3515: FROM gms_awards_all

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

Line 3963: FROM gms_awards_all

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

Line 4333: FROM gms_awards_all

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

Line 4338: FROM gms_awards_all ga,

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

Line 4350: gms_awards_all ga

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

Line 4630: gms_awards_all d

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

Line 5138: FROM gms_awards_all

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

Line 5209: l_award_rec GMS_AWARDS_ALL%ROWTYPE;

5205: l_total_installment_amount NUMBER;
5206: l_total_funding_amount NUMBER;
5207: l_project_funding_id NUMBER;
5208: l_installment_rec GMS_INSTALLMENTS%ROWTYPE;
5209: l_award_rec GMS_AWARDS_ALL%ROWTYPE;
5210:
5211:
5212:
5213: