DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on PA_TIMELINE_UTIL

Line 6559: l_week_start_date := PA_TIMELINE_UTIL.get_week_end_date(p_org_id => NULL,

6555: PA_SCHEDULE_UTILS.debug('daily: x_self_conflict_flag = ' || x_self_conflict_flag);
6556: ELSIF G_AVAILABILITY_CAL_PERIOD = 'WEEKLY' THEN
6557: -- Bug 2288823: check_self_conflict for the period from the week start date of
6558: -- p_start_date and the week end date of p_end_date for WEEKLY profile.
6559: l_week_start_date := PA_TIMELINE_UTIL.get_week_end_date(p_org_id => NULL,
6560: p_given_date => p_start_date) - 6;
6561: l_week_end_date := PA_TIMELINE_UTIL.get_week_end_date(p_org_id => NULL,
6562: p_given_date => p_end_date);
6563: OPEN c2;

Line 6561: l_week_end_date := PA_TIMELINE_UTIL.get_week_end_date(p_org_id => NULL,

6557: -- Bug 2288823: check_self_conflict for the period from the week start date of
6558: -- p_start_date and the week end date of p_end_date for WEEKLY profile.
6559: l_week_start_date := PA_TIMELINE_UTIL.get_week_end_date(p_org_id => NULL,
6560: p_given_date => p_start_date) - 6;
6561: l_week_end_date := PA_TIMELINE_UTIL.get_week_end_date(p_org_id => NULL,
6562: p_given_date => p_end_date);
6563: OPEN c2;
6564: FETCH c2 INTO v_c2;
6565: IF c2%NOTFOUND THEN