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 2424: l_personnel_rec gms_personnel%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 ;
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:

Line 2470: -- c_gms_personnel

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

Line 2471: -- Copy c_gms_personnel cursor

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

Line 2473: cursor c_gms_personnel is

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

Line 2475: from gms_personnel

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

Line 2931: FOR L_REC in c_gms_personnel LOOP

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

Line 3468: P_PERSONNEL_REC IN GMS_PERSONNEL%ROWTYPE

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

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

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

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

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

Line 3580: FROM gms_personnel

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

Line 3825: SELECT gms_personnel_s.nextval

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

Line 3830: gms_personnel_pkg.insert_row

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