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.PA_DISPLAY_PERIOD_MASKS dependencies on PA_DISPLAY_PERIOD_MASKS

Line 1: PACKAGE BODY PA_DISPLAY_PERIOD_MASKS AS

1: PACKAGE BODY PA_DISPLAY_PERIOD_MASKS AS
2: /*$Header: PAFPPMKB.pls 120.2 2006/02/24 00:04:20 prachand noship $*/
3:
4: --g_module_name VARCHAR2(100) := 'pa.plsql.PA_DISPLAY_PERIOD_MASKS';
5:

Line 4: --g_module_name VARCHAR2(100) := 'pa.plsql.PA_DISPLAY_PERIOD_MASKS';

1: PACKAGE BODY PA_DISPLAY_PERIOD_MASKS AS
2: /*$Header: PAFPPMKB.pls 120.2 2006/02/24 00:04:20 prachand noship $*/
3:
4: --g_module_name VARCHAR2(100) := 'pa.plsql.PA_DISPLAY_PERIOD_MASKS';
5:
6: --P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
7:
8: g_plan_period_start_name gl_periods.period_name%TYPE := NULL;

Line 463: --hr_utility.trace('Entered PA_DISPLAY_PERIOD_MASKS');

459:
460:
461:
462: BEGIN
463: --hr_utility.trace('Entered PA_DISPLAY_PERIOD_MASKS');
464:
465: --hr_utility.trace('p_budget_version_id := '||to_char(p_budget_version_id));
466: --hr_utility.trace('p_resource_assignment_id := '||to_char(p_resource_assignment_id));
467:

Line 556: g_get_mask_start := pa_display_period_masks.get_period_mask_start(g_period_mask_id);

552: --hr_utility.trace('g_plan_period_start_name := '||g_plan_period_start_name);
553: --hr_utility.trace('g_plan_period_start_date := '||to_char(g_plan_period_start_date));
554:
555: -- get min AND max of the current mask
556: g_get_mask_start := pa_display_period_masks.get_period_mask_start(g_period_mask_id);
557: g_get_mask_end := pa_display_period_masks.get_period_mask_end(g_period_mask_id);
558:
559: -----remove below after testing ---------
560: --hr_utility.trace('g_get_mask_start '||g_get_mask_start);

Line 557: g_get_mask_end := pa_display_period_masks.get_period_mask_end(g_period_mask_id);

553: --hr_utility.trace('g_plan_period_start_date := '||to_char(g_plan_period_start_date));
554:
555: -- get min AND max of the current mask
556: g_get_mask_start := pa_display_period_masks.get_period_mask_start(g_period_mask_id);
557: g_get_mask_end := pa_display_period_masks.get_period_mask_end(g_period_mask_id);
558:
559: -----remove below after testing ---------
560: --hr_utility.trace('g_get_mask_start '||g_get_mask_start);
561: --hr_utility.trace('g_get_mask_end '||g_get_mask_end);

Line 679: --hr_utility.trace('Leaving PA_DISPLAY_PERIOD_MASKS');

675: ----- remove after testing -----
676:
677: --hr_utility.trace('g_preceeding_end ' ||g_preceeding_end );
678: --hr_utility.trace('g_suceeding_start ' ||g_suceeding_start);
679: --hr_utility.trace('Leaving PA_DISPLAY_PERIOD_MASKS');
680: RETURN l_return;
681: END get_periods;
682:
683:

Line 787: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start)

783: IF get_period_mask_details_csr%NOTFOUND THEN
784: NULL;
785: --hr_utility.trace('start_period.get_period_mask_details_csr does not contain anything! exception');
786: ELSIF
787: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start)
788: THEN l_start_period :=
789: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_start).period_name;
790:
791: /*

Line 789: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_start).period_name;

785: --hr_utility.trace('start_period.get_period_mask_details_csr does not contain anything! exception');
786: ELSIF
787: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start)
788: THEN l_start_period :=
789: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_start).period_name;
790:
791: /*
792: -- if from_anchor_start does not exist check if from_anchor_end exists
793: -- set start period = periods_tab.first period name

Line 796: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end))

792: -- if from_anchor_start does not exist check if from_anchor_end exists
793: -- set start period = periods_tab.first period name
794: */
795: ELSIF
796: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end))
797: THEN l_start_period := get_min_start_period;
798: /*
799: -- if from_anchor_start and from_anchor_end do not exist then
800: -- set start period = NULL

Line 863: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end)

859: IF get_period_mask_details_csr%NOTFOUND
860: THEN NULL;
861: --hr_utility.trace('end_period.get_period_mask_details_csr does not contain anything! exception');
862: ELSIF
863: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end)
864: THEN l_end_period :=
865: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_end).period_name;
866:
867:

Line 865: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_end).period_name;

861: --hr_utility.trace('end_period.get_period_mask_details_csr does not contain anything! exception');
862: ELSIF
863: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end)
864: THEN l_end_period :=
865: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_end).period_name;
866:
867:
868: /*
869: -- if from_anchor_end does not exist check if from_anchor_start exists

Line 873: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start))

869: -- if from_anchor_end does not exist check if from_anchor_start exists
870: -- set end period = periods_tab.last period name
871: */
872: ELSIF
873: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start))
874: THEN
875: l_end_period := get_max_end_period;
876:
877: /*

Line 921: pa_display_period_masks.start_period(p_from_anchor_position) = pa_display_period_masks.end_period(p_from_anchor_position)

917: -- l_display_name := 'Suceeding';
918: l_display_name := g_succeeding;
919: END IF;
920: ELSIF
921: pa_display_period_masks.start_period(p_from_anchor_position) = pa_display_period_masks.end_period(p_from_anchor_position)
922: THEN
923: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position);
924: ELSIF
925: pa_display_period_masks.start_period(p_from_anchor_position) IS NULL OR

Line 923: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position);

919: END IF;
920: ELSIF
921: pa_display_period_masks.start_period(p_from_anchor_position) = pa_display_period_masks.end_period(p_from_anchor_position)
922: THEN
923: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position);
924: ELSIF
925: pa_display_period_masks.start_period(p_from_anchor_position) IS NULL OR
926: pa_display_period_masks.end_period(p_from_anchor_position) IS NULL
927: THEN l_display_name := NULL;

Line 925: pa_display_period_masks.start_period(p_from_anchor_position) IS NULL OR

921: pa_display_period_masks.start_period(p_from_anchor_position) = pa_display_period_masks.end_period(p_from_anchor_position)
922: THEN
923: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position);
924: ELSIF
925: pa_display_period_masks.start_period(p_from_anchor_position) IS NULL OR
926: pa_display_period_masks.end_period(p_from_anchor_position) IS NULL
927: THEN l_display_name := NULL;
928: ELSE
929: -- Bug Fix 3671424

Line 926: pa_display_period_masks.end_period(p_from_anchor_position) IS NULL

922: THEN
923: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position);
924: ELSIF
925: pa_display_period_masks.start_period(p_from_anchor_position) IS NULL OR
926: pa_display_period_masks.end_period(p_from_anchor_position) IS NULL
927: THEN l_display_name := NULL;
928: ELSE
929: -- Bug Fix 3671424
930: -- l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' - '

Line 930: -- l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' - '

926: pa_display_period_masks.end_period(p_from_anchor_position) IS NULL
927: THEN l_display_name := NULL;
928: ELSE
929: -- Bug Fix 3671424
930: -- l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' - '
931: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' '||g_to||' '
932: || pa_display_period_masks.end_period(p_from_anchor_position);
933: END IF;
934:

Line 931: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' '||g_to||' '

927: THEN l_display_name := NULL;
928: ELSE
929: -- Bug Fix 3671424
930: -- l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' - '
931: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' '||g_to||' '
932: || pa_display_period_masks.end_period(p_from_anchor_position);
933: END IF;
934:
935: --hr_utility.trace('l_display_name := '||l_display_name);

Line 932: || pa_display_period_masks.end_period(p_from_anchor_position);

928: ELSE
929: -- Bug Fix 3671424
930: -- l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' - '
931: l_display_name := pa_display_period_masks.start_period(p_from_anchor_position) || ' '||g_to||' '
932: || pa_display_period_masks.end_period(p_from_anchor_position);
933: END IF;
934:
935: --hr_utility.trace('l_display_name := '||l_display_name);
936: RETURN l_display_name;

Line 965: THEN l_start_date:= pa_display_period_masks.g_suceeding_start;

961:
962: IF p_from_anchor_position = -99999
963: THEN l_start_date:= to_date('01/01/0001','DD/MM/YYYY');
964: ELSIF p_from_anchor_position = 99999
965: THEN l_start_date:= pa_display_period_masks.g_suceeding_start;
966: ELSE
967:
968: OPEN get_period_mask_details_csr;
969: FETCH get_period_mask_details_csr INTO get_period_mask_details_rec;

Line 974: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start)

970: IF get_period_mask_details_csr%NOTFOUND THEN
971: NULL;
972: --hr_utility.trace('start_date.get_period_mask_details_csr does not contain anything! exception');
973: ELSIF
974: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start)
975: THEN l_start_date :=
976: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_start).start_date;
977:
978: /*

Line 976: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_start).start_date;

972: --hr_utility.trace('start_date.get_period_mask_details_csr does not contain anything! exception');
973: ELSIF
974: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start)
975: THEN l_start_date :=
976: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_start).start_date;
977:
978: /*
979: -- if from_anchor_start does not exist check if from_anchor_end exists
980: -- set start date = periods_tab.first start_date

Line 983: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end))

979: -- if from_anchor_start does not exist check if from_anchor_end exists
980: -- set start date = periods_tab.first start_date
981: */
982: ELSIF
983: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end))
984: THEN l_start_date := get_min_start_date;
985:
986: /*
987: -- if from_anchor_start and from_anchor_end do not exist then

Line 1023: THEN l_end_date:= pa_display_period_masks.g_preceeding_end;

1019:
1020: BEGIN
1021:
1022: IF p_from_anchor_position = -99999
1023: THEN l_end_date:= pa_display_period_masks.g_preceeding_end;
1024: ELSIF p_from_anchor_position = 99999
1025: THEN l_end_date:= to_date('31/12/4712','DD/MM/YYYY'); --xin
1026: ELSE
1027:

Line 1035: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end)

1031: THEN
1032: NULL;
1033: --hr_utility.trace('end_date.get_period_mask_details_csr does not contain anything! exception');
1034: ELSIF
1035: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end)
1036: THEN l_end_date :=
1037: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_end).end_date;
1038:
1039: /*

Line 1037: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_end).end_date;

1033: --hr_utility.trace('end_date.get_period_mask_details_csr does not contain anything! exception');
1034: ELSIF
1035: pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_end)
1036: THEN l_end_date :=
1037: pa_display_period_masks.periods_tab(get_period_mask_details_rec.from_anchor_end).end_date;
1038:
1039: /*
1040: -- if from_anchor_end does not exist check if from_anchor_start exists
1041: -- set end date= periods_tab.last end_date

Line 1044: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start))

1040: -- if from_anchor_end does not exist check if from_anchor_start exists
1041: -- set end date= periods_tab.last end_date
1042: */
1043: ELSIF
1044: (pa_display_period_masks.periods_tab.EXISTS(get_period_mask_details_rec.from_anchor_start))
1045: THEN l_end_date := get_max_end_date;
1046:
1047: /*
1048: -- if from_anchor_start and from_anchor_end do not exist then

Line 1189: END pa_display_period_masks;

1185: Raise;
1186:
1187: END update_current_pp;
1188:
1189: END pa_display_period_masks;