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_PUB dependencies on GMS_AWARDS_ALL

Line 177: AWARD_REC IN OUT NOCOPY gms_awards_all%ROWTYPE ) is

173: BILLING_OFFSET IN NUMBER,
174: BILLING_CYCLE_ID IN NUMBER,
175: BUDGET_WF_ENABLED_FLAG IN VARCHAR2,
176: PROPOSAL_ID IN NUMBER,
177: AWARD_REC IN OUT NOCOPY gms_awards_all%ROWTYPE ) is
178: BEGIN
179: award_rec.AWARD_NUMBER := AWARD_NUMBER ;
180: award_rec.AWARD_SHORT_NAME := AWARD_SHORT_NAME ;
181: award_rec.AWARD_FULL_NAME := AWARD_FULL_NAME ;

Line 263: -- Create award has all the parameters that we have in gms_awards_all table.

259: -- p_award_id : The Award ID created.
260:
261: -- ===============================================================================
262: -- CREATE_AWARD :
263: -- Create award has all the parameters that we have in gms_awards_all table.
264: -- The ID's in the table are replaced by corresponding value. Users must
265: -- provide decode values instead of code values for certain arguments.
266: -- X_return_status : S- Success,
267: -- E- Business Rule Validation error

Line 352: L_award_rec GMS_AWARDS_ALL%ROWTYPE ;

348:
349: L_IDC_schedule_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE ;
350: L_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE ;
351:
352: L_award_rec GMS_AWARDS_ALL%ROWTYPE ;
353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;
354:
355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;
356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;

Line 353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;

349: L_IDC_schedule_type pa_ind_rate_schedules.ind_rate_schedule_type%TYPE ;
350: L_ind_rate_sch_id pa_ind_rate_schedules.ind_rate_sch_id%TYPE ;
351:
352: L_award_rec GMS_AWARDS_ALL%ROWTYPE ;
353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;
354:
355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;
356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;
357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;

Line 356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;

352: L_award_rec GMS_AWARDS_ALL%ROWTYPE ;
353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;
354:
355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;
356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;
357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;
358: L_fctrl_RGP gms_awards_all.fund_control_level_res_grp%TYPE;
359: L_fctrl_res gms_awards_all.fund_control_level_res%TYPE;
360: L_row_id varchar2(45) ;

Line 357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;

353: L_award_id GMS_AWARDS_ALL.AWARD_ID%TYPE ;
354:
355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;
356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;
357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;
358: L_fctrl_RGP gms_awards_all.fund_control_level_res_grp%TYPE;
359: L_fctrl_res gms_awards_all.fund_control_level_res%TYPE;
360: L_row_id varchar2(45) ;
361: l_default_org_id GMS_AWARDS_ALL.ORG_ID%TYPE;

Line 358: L_fctrl_RGP gms_awards_all.fund_control_level_res_grp%TYPE;

354:
355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;
356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;
357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;
358: L_fctrl_RGP gms_awards_all.fund_control_level_res_grp%TYPE;
359: L_fctrl_res gms_awards_all.fund_control_level_res%TYPE;
360: L_row_id varchar2(45) ;
361: l_default_org_id GMS_AWARDS_ALL.ORG_ID%TYPE;
362: MO_ORG_INVALID_EXCEPTION EXCEPTION;

Line 359: L_fctrl_res gms_awards_all.fund_control_level_res%TYPE;

355: L_billing_cycle_id pa_billing_cycles.billing_cycle_id%TYPE ;
356: L_fctrl_award gms_awards_all.fund_control_level_award%TYPE;
357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;
358: L_fctrl_RGP gms_awards_all.fund_control_level_res_grp%TYPE;
359: L_fctrl_res gms_awards_all.fund_control_level_res%TYPE;
360: L_row_id varchar2(45) ;
361: l_default_org_id GMS_AWARDS_ALL.ORG_ID%TYPE;
362: MO_ORG_INVALID_EXCEPTION EXCEPTION;
363:

Line 361: l_default_org_id GMS_AWARDS_ALL.ORG_ID%TYPE;

357: L_fctrl_task gms_awards_all.fund_control_level_task%TYPE;
358: L_fctrl_RGP gms_awards_all.fund_control_level_res_grp%TYPE;
359: L_fctrl_res gms_awards_all.fund_control_level_res%TYPE;
360: L_row_id varchar2(45) ;
361: l_default_org_id GMS_AWARDS_ALL.ORG_ID%TYPE;
362: MO_ORG_INVALID_EXCEPTION EXCEPTION;
363:
364:
365: CURSOR C_BILL is

Line 795: FROM gms_awards_all

791: L_award_id GMS_INSTALLMENTS.AWARD_ID%TYPE;
792:
793: CURSOR C_AWARD is
794: SELECT award_id
795: FROM gms_awards_all
796: WHERE award_number = P_AWARD_NUMBER;
797:
798: BEGIN
799: /* NULL ; */ /* commented the line and added below code for 12720195 */