APPS.CAC_AVLBLTY_PVT dependencies on CAC_AVLBLTY_PVT

Line 1: PACKAGE BODY CAC_AVLBLTY_PVT AS

1: PACKAGE BODY CAC_AVLBLTY_PVT AS
2: /* $Header: caccapb.pls 120.7.12010000.7 2009/01/21 11:57:23 anangupt ship $ */
3:
4: /*******************************************************************************
5: ** Private APIs

Line 1098: 'SELECT GREATEST( CAC_AVLBLTY_PVT.AdjustForTimezone( jtb.timezone_id ' ||

1094: -- This is the base query for picking up all opague records from the task table
1095: --
1096: l_query VARCHAR2(2000) :=
1097:
1098: 'SELECT GREATEST( CAC_AVLBLTY_PVT.AdjustForTimezone( jtb.timezone_id ' ||
1099: ', :b_ToTimeZone ' ||
1100: ', jtb.calendar_start_date ' ||
1101: ') ' ||
1102: ', :b_PeriodStartDateTime ' ||

Line 1104: ', LEAST( CAC_AVLBLTY_PVT.AdjustForTimezone( jtb.timezone_id ' ||

1100: ', jtb.calendar_start_date ' ||
1101: ') ' ||
1102: ', :b_PeriodStartDateTime ' ||
1103: ') StartDateTime ' ||
1104: ', LEAST( CAC_AVLBLTY_PVT.AdjustForTimezone( jtb.timezone_id ' ||
1105: ', :b_ToTimeZone ' ||
1106: ', jtb.calendar_end_date ' ||
1107: ') ' ||
1108: ', :b_PeriodEndDateTime ' ||

Line 2355: END CAC_AVLBLTY_PVT;

2351:
2352: END POST_DELETE_SCHEDULE;
2353:
2354:
2355: END CAC_AVLBLTY_PVT;