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.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on DUAL

Line 3038: x_display_rec.end_period_1 FROM DUAL;

3034: IF l_start_date IS NOT NULL THEN
3035: x_display_rec.start_period_1 := l_start_date-1;
3036:
3037: SELECT ADD_MONTHS(x_display_rec.start_period_1,1) INTO
3038: x_display_rec.end_period_1 FROM DUAL;
3039: --
3040: l_count := Get_Number_of_Dvisits(l_department_id,
3041: p_simulation_plan_id,
3042: p_plan_flag,

Line 3069: x_display_rec.end_period_2 FROM DUAL;

3065: IF x_display_rec.end_period_1 IS NOT NULL THEN
3066: x_display_rec.start_period_2:= x_display_rec.end_period_1;
3067: --
3068: SELECT ADD_MONTHS(x_display_rec.start_period_2,1) INTO
3069: x_display_rec.end_period_2 FROM DUAL;
3070:
3071: l_count := Get_Number_of_Dvisits(l_department_id,
3072: p_simulation_plan_id,
3073: p_plan_flag,

Line 3099: x_display_rec.end_period_3 FROM DUAL;

3095: IF x_display_rec.end_period_2 IS NOT NULL THEN
3096: x_display_rec.start_period_3:= x_display_rec.end_period_2;
3097: --
3098: SELECT ADD_MONTHS(x_display_rec.start_period_3,1) INTO
3099: x_display_rec.end_period_3 FROM DUAL;
3100:
3101: l_count := Get_Number_of_Dvisits(l_department_id,
3102: p_simulation_plan_id,
3103: p_plan_flag,

Line 3129: x_display_rec.end_period_4 FROM DUAL;

3125: IF x_display_rec.end_period_3 IS NOT NULL THEN
3126: x_display_rec.start_period_4:= x_display_rec.end_period_3;
3127: --
3128: SELECT ADD_MONTHS(x_display_rec.start_period_4,1) INTO
3129: x_display_rec.end_period_4 FROM DUAL;
3130:
3131: l_count := Get_Number_of_Dvisits(l_department_id,
3132: p_simulation_plan_id,
3133: p_plan_flag,

Line 3159: x_display_rec.end_period_5 FROM DUAL;

3155: IF x_display_rec.end_period_4 IS NOT NULL THEN
3156: x_display_rec.start_period_5:= x_display_rec.end_period_4;
3157: --
3158: SELECT ADD_MONTHS(x_display_rec.start_period_5,1) INTO
3159: x_display_rec.end_period_5 FROM DUAL;
3160:
3161: l_count := Get_Number_of_Dvisits(l_department_id,
3162: p_simulation_plan_id,
3163: p_plan_flag,

Line 3187: x_display_rec.end_period_6 FROM DUAL;

3183: IF x_display_rec.end_period_5 IS NOT NULL THEN
3184: x_display_rec.start_period_6:= x_display_rec.end_period_5;
3185: --
3186: SELECT ADD_MONTHS(x_display_rec.start_period_6,1) INTO
3187: x_display_rec.end_period_6 FROM DUAL;
3188:
3189: l_count := Get_Number_of_Dvisits(l_department_id,
3190: p_simulation_plan_id,
3191: p_plan_flag,

Line 3215: x_display_rec.end_period_7 FROM DUAL;

3211: IF x_display_rec.end_period_6 IS NOT NULL THEN
3212: x_display_rec.start_period_7:= x_display_rec.end_period_6;
3213: --
3214: SELECT ADD_MONTHS(x_display_rec.start_period_7,1) INTO
3215: x_display_rec.end_period_7 FROM DUAL;
3216:
3217: l_count := Get_Number_of_Dvisits(l_department_id,
3218: p_simulation_plan_id,
3219: p_plan_flag,

Line 3243: x_display_rec.end_period_8 FROM DUAL;

3239: IF x_display_rec.end_period_7 IS NOT NULL THEN
3240: x_display_rec.start_period_8:= x_display_rec.end_period_7;
3241: --
3242: SELECT ADD_MONTHS(x_display_rec.start_period_8,1) INTO
3243: x_display_rec.end_period_8 FROM DUAL;
3244:
3245: l_count := Get_Number_of_Dvisits(l_department_id,
3246: p_simulation_plan_id,
3247: p_plan_flag,

Line 3271: x_display_rec.end_period_9 FROM DUAL;

3267: IF x_display_rec.end_period_8 IS NOT NULL THEN
3268: x_display_rec.start_period_9:= x_display_rec.end_period_8;
3269: --
3270: SELECT ADD_MONTHS(x_display_rec.start_period_9,1) INTO
3271: x_display_rec.end_period_9 FROM DUAL;
3272:
3273: l_count := Get_Number_of_Dvisits(l_department_id,
3274: p_simulation_plan_id,
3275: p_plan_flag,

Line 3299: x_display_rec.end_period_10 FROM DUAL;

3295: IF x_display_rec.end_period_9 IS NOT NULL THEN
3296: x_display_rec.start_period_10:= x_display_rec.end_period_9;
3297: --
3298: SELECT ADD_MONTHS(x_display_rec.start_period_10,1) INTO
3299: x_display_rec.end_period_10 FROM DUAL;
3300:
3301: l_count := Get_Number_of_Dvisits(l_department_id,
3302: p_simulation_plan_id,
3303: p_plan_flag,

Line 3327: x_display_rec.end_period_11 FROM DUAL;

3323: IF x_display_rec.end_period_10 IS NOT NULL THEN
3324: x_display_rec.start_period_11:= x_display_rec.end_period_10;
3325: --
3326: SELECT ADD_MONTHS(x_display_rec.start_period_11,1) INTO
3327: x_display_rec.end_period_11 FROM DUAL;
3328:
3329: l_count := Get_Number_of_Dvisits(l_department_id,
3330: p_simulation_plan_id,
3331: p_plan_flag,

Line 3355: x_display_rec.end_period_12 FROM DUAL;

3351: IF x_display_rec.end_period_11 IS NOT NULL THEN
3352: x_display_rec.start_period_12:= x_display_rec.end_period_11;
3353: --
3354: SELECT ADD_MONTHS(x_display_rec.start_period_12,1) INTO
3355: x_display_rec.end_period_12 FROM DUAL;
3356:
3357: l_count := Get_Number_of_Dvisits(l_department_id,
3358: p_simulation_plan_id,
3359: p_plan_flag,

Line 3383: x_display_rec.end_period_13 FROM DUAL;

3379: IF x_display_rec.end_period_12 IS NOT NULL THEN
3380: x_display_rec.start_period_13:= x_display_rec.end_period_12;
3381: --
3382: SELECT ADD_MONTHS(x_display_rec.start_period_13,1) INTO
3383: x_display_rec.end_period_13 FROM DUAL;
3384:
3385: l_count := Get_Number_of_Dvisits(l_department_id,
3386: p_simulation_plan_id,
3387: p_plan_flag,

Line 3411: x_display_rec.end_period_14 FROM DUAL;

3407: IF x_display_rec.end_period_13 IS NOT NULL THEN
3408: x_display_rec.start_period_14:= x_display_rec.end_period_13;
3409: --
3410: SELECT ADD_MONTHS(x_display_rec.start_period_14,1) INTO
3411: x_display_rec.end_period_14 FROM DUAL;
3412:
3413: l_count := Get_Number_of_Dvisits(l_department_id,
3414: p_simulation_plan_id,
3415: p_plan_flag,

Line 3470: x_display_rec.end_period_1 FROM DUAL;

3466: IF l_start_date IS NOT NULL THEN
3467: x_display_rec.start_period_1 := l_start_date-1;
3468:
3469: SELECT ADD_MONTHS(x_display_rec.start_period_1,1) INTO
3470: x_display_rec.end_period_1 FROM DUAL;
3471:
3472:
3473: l_count := Get_count_of_Visits(l_space_id,
3474: p_simulation_plan_id,

Line 3508: x_display_rec.end_period_2 FROM DUAL;

3504: IF x_display_rec.end_period_1 IS NOT NULL THEN
3505: x_display_rec.start_period_2:= x_display_rec.end_period_1;
3506: --
3507: SELECT ADD_MONTHS(x_display_rec.start_period_2,1) INTO
3508: x_display_rec.end_period_2 FROM DUAL;
3509:
3510: l_count := Get_count_of_Visits(l_space_id,
3511: p_simulation_plan_id,
3512: p_plan_flag,

Line 3545: x_display_rec.end_period_3 FROM DUAL;

3541: IF x_display_rec.end_period_2 IS NOT NULL THEN
3542: x_display_rec.start_period_3:= x_display_rec.end_period_2;
3543: --
3544: SELECT ADD_MONTHS(x_display_rec.start_period_3,1) INTO
3545: x_display_rec.end_period_3 FROM DUAL;
3546:
3547: l_count := Get_count_of_Visits(l_space_id,
3548: p_simulation_plan_id,
3549: p_plan_flag,

Line 3581: x_display_rec.end_period_4 FROM DUAL;

3577: IF x_display_rec.end_period_3 IS NOT NULL THEN
3578: x_display_rec.start_period_4:= x_display_rec.end_period_3;
3579: --
3580: SELECT ADD_MONTHS(x_display_rec.start_period_4,1) INTO
3581: x_display_rec.end_period_4 FROM DUAL;
3582:
3583: l_count := Get_count_of_Visits(l_space_id,
3584: p_simulation_plan_id,
3585: p_plan_flag,

Line 3617: x_display_rec.end_period_5 FROM DUAL;

3613: IF x_display_rec.end_period_4 IS NOT NULL THEN
3614: x_display_rec.start_period_5:= x_display_rec.end_period_4;
3615: --
3616: SELECT ADD_MONTHS(x_display_rec.start_period_5,1) INTO
3617: x_display_rec.end_period_5 FROM DUAL;
3618:
3619: l_count := Get_count_of_Visits(l_space_id,
3620: p_simulation_plan_id,
3621: p_plan_flag,

Line 3651: x_display_rec.end_period_6 FROM DUAL;

3647: IF x_display_rec.end_period_5 IS NOT NULL THEN
3648: x_display_rec.start_period_6:= x_display_rec.end_period_5;
3649: --
3650: SELECT ADD_MONTHS(x_display_rec.start_period_6,1) INTO
3651: x_display_rec.end_period_6 FROM DUAL;
3652:
3653: l_count := Get_count_of_Visits(l_space_id,
3654: p_simulation_plan_id,
3655: p_plan_flag,

Line 3685: x_display_rec.end_period_7 FROM DUAL;

3681: IF x_display_rec.end_period_6 IS NOT NULL THEN
3682: x_display_rec.start_period_7:= x_display_rec.end_period_6;
3683: --
3684: SELECT ADD_MONTHS(x_display_rec.start_period_7,1) INTO
3685: x_display_rec.end_period_7 FROM DUAL;
3686:
3687: l_count := Get_count_of_Visits(l_space_id,
3688: p_simulation_plan_id,
3689: p_plan_flag,

Line 3719: x_display_rec.end_period_8 FROM DUAL;

3715: IF x_display_rec.end_period_7 IS NOT NULL THEN
3716: x_display_rec.start_period_8:= x_display_rec.end_period_7;
3717: --
3718: SELECT ADD_MONTHS(x_display_rec.start_period_8,1) INTO
3719: x_display_rec.end_period_8 FROM DUAL;
3720:
3721: l_count := Get_count_of_Visits(l_space_id,
3722: p_simulation_plan_id,
3723: p_plan_flag,

Line 3753: x_display_rec.end_period_9 FROM DUAL;

3749: IF x_display_rec.end_period_8 IS NOT NULL THEN
3750: x_display_rec.start_period_9:= x_display_rec.end_period_8;
3751: --
3752: SELECT ADD_MONTHS(x_display_rec.start_period_9,1) INTO
3753: x_display_rec.end_period_9 FROM DUAL;
3754:
3755: l_count := Get_count_of_Visits(l_space_id,
3756: p_simulation_plan_id,
3757: p_plan_flag,

Line 3787: x_display_rec.end_period_10 FROM DUAL;

3783: IF x_display_rec.end_period_9 IS NOT NULL THEN
3784: x_display_rec.start_period_10:= x_display_rec.end_period_9;
3785: --
3786: SELECT ADD_MONTHS(x_display_rec.start_period_10,1) INTO
3787: x_display_rec.end_period_10 FROM DUAL;
3788:
3789: l_count := Get_count_of_Visits(l_space_id,
3790: p_simulation_plan_id,
3791: p_plan_flag,

Line 3821: x_display_rec.end_period_11 FROM DUAL;

3817: IF x_display_rec.end_period_10 IS NOT NULL THEN
3818: x_display_rec.start_period_11:= x_display_rec.end_period_10;
3819: --
3820: SELECT ADD_MONTHS(x_display_rec.start_period_11,1) INTO
3821: x_display_rec.end_period_11 FROM DUAL;
3822:
3823: l_count := Get_count_of_Visits(l_space_id,
3824: p_simulation_plan_id,
3825: p_plan_flag,

Line 3855: x_display_rec.end_period_12 FROM DUAL;

3851: IF x_display_rec.end_period_11 IS NOT NULL THEN
3852: x_display_rec.start_period_12:= x_display_rec.end_period_11;
3853: --
3854: SELECT ADD_MONTHS(x_display_rec.start_period_12,1) INTO
3855: x_display_rec.end_period_12 FROM DUAL;
3856:
3857: l_count := Get_count_of_Visits(l_space_id,
3858: p_simulation_plan_id,
3859: p_plan_flag,

Line 3889: x_display_rec.end_period_13 FROM DUAL;

3885: IF x_display_rec.end_period_12 IS NOT NULL THEN
3886: x_display_rec.start_period_13:= x_display_rec.end_period_12;
3887: --
3888: SELECT ADD_MONTHS(x_display_rec.start_period_13,1) INTO
3889: x_display_rec.end_period_13 FROM DUAL;
3890:
3891: l_count := Get_count_of_Visits(l_space_id,
3892: p_simulation_plan_id,
3893: p_plan_flag,

Line 3923: x_display_rec.end_period_14 FROM DUAL;

3919: IF x_display_rec.end_period_13 IS NOT NULL THEN
3920: x_display_rec.start_period_14:= x_display_rec.end_period_13;
3921: --
3922: SELECT ADD_MONTHS(x_display_rec.start_period_14,1) INTO
3923: x_display_rec.end_period_14 FROM DUAL;
3924:
3925: l_count := Get_count_of_Visits(l_space_id,
3926: p_simulation_plan_id,
3927: p_plan_flag,

Line 4431: x_display_rec.end_period_1 FROM DUAL;

4427: END LOOP;
4428: END IF;
4429:
4430: SELECT ADD_MONTHS(x_display_rec.start_period_1,1) INTO
4431: x_display_rec.end_period_1 FROM DUAL;
4432:
4433: --In case of null records send display record
4434: IF l_display_rec.field_1 IS NULL THEN
4435: --

Line 4439: x_display_rec.end_period_1 FROM DUAL;

4435: --
4436: x_display_rec.field_1 := to_char( l_start_date ,'mm/yy');
4437: --
4438: SELECT ADD_MONTHS(l_start_date,1) INTO
4439: x_display_rec.end_period_1 FROM DUAL;
4440: --
4441: x_display_rec.field_2 := to_char(x_display_rec.end_period_1,'mm/yy');
4442: --
4443: SELECT ADD_MONTHS(x_display_rec.end_period_1,1) INTO

Line 4444: x_display_rec.end_period_2 FROM DUAL;

4440: --
4441: x_display_rec.field_2 := to_char(x_display_rec.end_period_1,'mm/yy');
4442: --
4443: SELECT ADD_MONTHS(x_display_rec.end_period_1,1) INTO
4444: x_display_rec.end_period_2 FROM DUAL;
4445: --
4446: x_display_rec.field_3 := to_char(x_display_rec.end_period_2,'mm/yy');
4447: --
4448: SELECT ADD_MONTHS(x_display_rec.end_period_2,1) INTO

Line 4449: x_display_rec.end_period_3 FROM DUAL;

4445: --
4446: x_display_rec.field_3 := to_char(x_display_rec.end_period_2,'mm/yy');
4447: --
4448: SELECT ADD_MONTHS(x_display_rec.end_period_2,1) INTO
4449: x_display_rec.end_period_3 FROM DUAL;
4450: --
4451: x_display_rec.field_4 := to_char(x_display_rec.end_period_3,'mm/yy');
4452: --
4453: SELECT ADD_MONTHS(x_display_rec.end_period_3,1) INTO

Line 4454: x_display_rec.end_period_4 FROM DUAL;

4450: --
4451: x_display_rec.field_4 := to_char(x_display_rec.end_period_3,'mm/yy');
4452: --
4453: SELECT ADD_MONTHS(x_display_rec.end_period_3,1) INTO
4454: x_display_rec.end_period_4 FROM DUAL;
4455: --
4456: x_display_rec.field_5 := to_char(x_display_rec.end_period_4,'mm/yy');
4457: --
4458: SELECT ADD_MONTHS(x_display_rec.end_period_4,1) INTO

Line 4459: x_display_rec.end_period_5 FROM DUAL;

4455: --
4456: x_display_rec.field_5 := to_char(x_display_rec.end_period_4,'mm/yy');
4457: --
4458: SELECT ADD_MONTHS(x_display_rec.end_period_4,1) INTO
4459: x_display_rec.end_period_5 FROM DUAL;
4460: --
4461: x_display_rec.field_6 := to_char(x_display_rec.end_period_5,'mm/yy');
4462: --
4463: SELECT ADD_MONTHS(x_display_rec.end_period_5,1) INTO

Line 4464: x_display_rec.end_period_6 FROM DUAL;

4460: --
4461: x_display_rec.field_6 := to_char(x_display_rec.end_period_5,'mm/yy');
4462: --
4463: SELECT ADD_MONTHS(x_display_rec.end_period_5,1) INTO
4464: x_display_rec.end_period_6 FROM DUAL;
4465: --
4466: x_display_rec.field_7 := to_char(x_display_rec.end_period_6,'mm/yy');
4467: --
4468: SELECT ADD_MONTHS(x_display_rec.end_period_6,1) INTO

Line 4469: x_display_rec.end_period_7 FROM DUAL;

4465: --
4466: x_display_rec.field_7 := to_char(x_display_rec.end_period_6,'mm/yy');
4467: --
4468: SELECT ADD_MONTHS(x_display_rec.end_period_6,1) INTO
4469: x_display_rec.end_period_7 FROM DUAL;
4470: --
4471: x_display_rec.field_8 := to_char(x_display_rec.end_period_7,'mm/yy');
4472: --
4473: SELECT ADD_MONTHS(x_display_rec.end_period_7,1) INTO

Line 4474: x_display_rec.end_period_8 FROM DUAL;

4470: --
4471: x_display_rec.field_8 := to_char(x_display_rec.end_period_7,'mm/yy');
4472: --
4473: SELECT ADD_MONTHS(x_display_rec.end_period_7,1) INTO
4474: x_display_rec.end_period_8 FROM DUAL;
4475: --
4476: x_display_rec.field_9 := to_char(x_display_rec.end_period_8,'mm/yy');
4477: --
4478: SELECT ADD_MONTHS(x_display_rec.end_period_8,1) INTO

Line 4479: x_display_rec.end_period_9 FROM DUAL;

4475: --
4476: x_display_rec.field_9 := to_char(x_display_rec.end_period_8,'mm/yy');
4477: --
4478: SELECT ADD_MONTHS(x_display_rec.end_period_8,1) INTO
4479: x_display_rec.end_period_9 FROM DUAL;
4480: --
4481: x_display_rec.field_10 := to_char(x_display_rec.end_period_9,'mm/yy');
4482: --
4483: SELECT ADD_MONTHS(x_display_rec.end_period_9,1) INTO

Line 4484: x_display_rec.end_period_10 FROM DUAL;

4480: --
4481: x_display_rec.field_10 := to_char(x_display_rec.end_period_9,'mm/yy');
4482: --
4483: SELECT ADD_MONTHS(x_display_rec.end_period_9,1) INTO
4484: x_display_rec.end_period_10 FROM DUAL;
4485: --
4486: x_display_rec.field_11 := to_char(x_display_rec.end_period_10,'mm/yy');
4487: --
4488: SELECT ADD_MONTHS(x_display_rec.end_period_10,1) INTO

Line 4489: x_display_rec.end_period_11 FROM DUAL;

4485: --
4486: x_display_rec.field_11 := to_char(x_display_rec.end_period_10,'mm/yy');
4487: --
4488: SELECT ADD_MONTHS(x_display_rec.end_period_10,1) INTO
4489: x_display_rec.end_period_11 FROM DUAL;
4490: --
4491: x_display_rec.field_12 := to_char(x_display_rec.end_period_11,'mm/yy');
4492: --
4493: SELECT ADD_MONTHS(x_display_rec.end_period_11,1) INTO

Line 4494: x_display_rec.end_period_12 FROM DUAL;

4490: --
4491: x_display_rec.field_12 := to_char(x_display_rec.end_period_11,'mm/yy');
4492: --
4493: SELECT ADD_MONTHS(x_display_rec.end_period_11,1) INTO
4494: x_display_rec.end_period_12 FROM DUAL;
4495: --
4496: x_display_rec.field_13 := to_char(x_display_rec.end_period_12,'mm/yy');
4497: --
4498: SELECT ADD_MONTHS(x_display_rec.end_period_12,1) INTO

Line 4499: x_display_rec.end_period_13 FROM DUAL;

4495: --
4496: x_display_rec.field_13 := to_char(x_display_rec.end_period_12,'mm/yy');
4497: --
4498: SELECT ADD_MONTHS(x_display_rec.end_period_12,1) INTO
4499: x_display_rec.end_period_13 FROM DUAL;
4500: --
4501: x_display_rec.field_14 := to_char(x_display_rec.end_period_13,'mm/yy');
4502: --
4503: