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_PERSONNEL

Line 12: G_personnel_rec GMS_PERSONNEL%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:
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 ;

Line 201: L_personnel_rec gms_personnel%ROWTYPE ;

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

Line 1325: gms_personnel gmsp

1321:
1322: cursor C_awd_manager is
1323: SELECT 1, gmsp.start_date_active, end_date_active
1324: FROM per_assignments_f pera,
1325: gms_personnel gmsp
1326: WHERE pera.person_id = g_award_rec.award_manager_id
1327: and trunc(sysdate) between pera.effective_start_date
1328: and pera.effective_end_date
1329: and pera.primary_flag = 'Y'

Line 2425: l_personnel_rec gms_personnel%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 ;
2429:

Line 2471: -- c_gms_personnel

2467: where award_id = p_award_base_id
2468: and l_base_fund_src_id = g_award_rec.funding_source_id ;
2469:
2470: -- ======
2471: -- c_gms_personnel
2472: -- Copy c_gms_personnel cursor
2473: -- ======
2474: cursor c_gms_personnel is
2475: select *

Line 2472: -- Copy c_gms_personnel cursor

2468: and l_base_fund_src_id = g_award_rec.funding_source_id ;
2469:
2470: -- ======
2471: -- c_gms_personnel
2472: -- Copy c_gms_personnel cursor
2473: -- ======
2474: cursor c_gms_personnel is
2475: select *
2476: from gms_personnel

Line 2474: cursor c_gms_personnel is

2470: -- ======
2471: -- c_gms_personnel
2472: -- Copy c_gms_personnel cursor
2473: -- ======
2474: cursor c_gms_personnel is
2475: select *
2476: from gms_personnel
2477: where award_id = p_award_base_id
2478: and award_role <> 'AM';

Line 2476: from gms_personnel

2472: -- Copy c_gms_personnel cursor
2473: -- ======
2474: cursor c_gms_personnel is
2475: select *
2476: from gms_personnel
2477: where award_id = p_award_base_id
2478: and award_role <> 'AM';
2479:
2480: -- ======

Line 2932: FOR L_REC in c_gms_personnel LOOP

2928:
2929: -- =====
2930: -- Copy Personnel Details
2931: -- =====
2932: FOR L_REC in c_gms_personnel LOOP
2933:
2934: l_personnel_rec.award_id := g_award_rec.award_id ;
2935: l_personnel_rec.person_id := l_rec.person_id ;
2936: l_personnel_rec.award_role := l_rec.award_role ;

Line 3469: P_PERSONNEL_REC IN GMS_PERSONNEL%ROWTYPE

3465: X_ROW_ID OUT NOCOPY VARCHAR2 ,
3466: P_CALLING_MODULE IN VARCHAR2 ,
3467: P_API_VERSION_NUMBER IN NUMBER ,
3468: P_validate IN BOOLEAN DEFAULT TRUE ,
3469: P_PERSONNEL_REC IN GMS_PERSONNEL%ROWTYPE
3470: ) IS
3471:
3472: l_api_name VARCHAR2(30) := 'CREATE_PERSONNEL';
3473: l_start_date_active gms_personnel.start_date_active%TYPE := NULL ;

Line 3473: l_start_date_active gms_personnel.start_date_active%TYPE := NULL ;

3469: P_PERSONNEL_REC IN GMS_PERSONNEL%ROWTYPE
3470: ) IS
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 ;

Line 3474: l_end_date_active gms_personnel.end_date_active%TYPE := NULL ;

3470: ) IS
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) ;

Line 3582: FROM gms_personnel

3578: PROCEDURE Verify_Award_Manager_Dates(p_validate IN BOOLEAN , X_return_status IN OUT NOCOPY VARCHAR2 ) IS
3579:
3580: CURSOR l_award_manager_csr is
3581: SELECT start_date_active, end_date_active
3582: FROM gms_personnel
3583: WHERE award_id = G_personnel_rec.award_id
3584: AND award_role = 'AM'
3585: ORDER BY start_date_active;
3586:

Line 3827: SELECT gms_personnel_s.nextval

3823: RAISE FND_API.G_EXC_ERROR;
3824: END IF ;
3825:
3826:
3827: SELECT gms_personnel_s.nextval
3828: INTO G_personnel_rec.personnel_id
3829: FROM DUAL ;
3830:
3831: G_stage := 'FND_API.Create_Personnel_Record' ;

Line 3832: gms_personnel_pkg.insert_row

3828: INTO G_personnel_rec.personnel_id
3829: FROM DUAL ;
3830:
3831: G_stage := 'FND_API.Create_Personnel_Record' ;
3832: gms_personnel_pkg.insert_row
3833: ( x_rowid => L_rowid,
3834: x_personnel_id => G_personnel_rec.personnel_id,
3835: x_award_id => G_personnel_rec.award_id,
3836: x_person_id => G_personnel_rec.person_id,