DBA Data[Home] [Help]

APPS.PA_FORECASTITEM_PVT dependencies on PA_SCHEDULE_GLOB

Line 9489: PROCEDURE refresh_schedule_tab(p_TmpScheduleTab IN PA_SCHEDULE_GLOB.ScheduleTabTyp

9485:
9486: /** This Api refreshes the plsql schedule table after deleting the records
9487: ** so that it donot cause no data found error
9488: */
9489: PROCEDURE refresh_schedule_tab(p_TmpScheduleTab IN PA_SCHEDULE_GLOB.ScheduleTabTyp
9490: ,x_TmpScheduleTab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp) /* 2674619 - Nocopy change */
9491: IS
9492:
9493: l_msg_index_out NUMBER;

Line 9490: ,x_TmpScheduleTab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp) /* 2674619 - Nocopy change */

9486: /** This Api refreshes the plsql schedule table after deleting the records
9487: ** so that it donot cause no data found error
9488: */
9489: PROCEDURE refresh_schedule_tab(p_TmpScheduleTab IN PA_SCHEDULE_GLOB.ScheduleTabTyp
9490: ,x_TmpScheduleTab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp) /* 2674619 - Nocopy change */
9491: IS
9492:
9493: l_msg_index_out NUMBER;
9494: l_counter INTEGER :=0;

Line 9495: l_dummy_TmpScheduleTab PA_SCHEDULE_GLOB.ScheduleTabTyp;

9491: IS
9492:
9493: l_msg_index_out NUMBER;
9494: l_counter INTEGER :=0;
9495: l_dummy_TmpScheduleTab PA_SCHEDULE_GLOB.ScheduleTabTyp;
9496:
9497: BEGIN
9498: IF p_TmpScheduleTab.COUNT > 0 then
9499:

Line 9565: TmpScheduleTab PA_SCHEDULE_GLOB.ScheduleTabTyp;

9561: x_msg_data OUT NOCOPY VARCHAR2) IS -- 4537865
9562:
9563: l_msg_index_out NUMBER;
9564: l_data varchar2(2000) ; -- 4537865
9565: TmpScheduleTab PA_SCHEDULE_GLOB.ScheduleTabTyp;
9566: TmpResScheduleTab PA_FORECAST_GLOB.ScheduleTabTyp;
9567: TmpAsgnScheduleTab PA_FORECAST_GLOB.ScheduleTabTyp;
9568: TmpResFIDayTab PA_FORECAST_GLOB.FIDayTabTyp;
9569: TmpAsgnFIDayTab PA_FORECAST_GLOB.FIDayTabTyp;

Line 9918: -- as TmpScheduleTab datatype is PA_SCHEDULE_GLOB.scheduletabtyp

9914: Return;
9915: End if;
9916:
9917: -- Move TmpScheduleTab to TmpResScheduleTab
9918: -- as TmpScheduleTab datatype is PA_SCHEDULE_GLOB.scheduletabtyp
9919: -- Uniform datatype is required FOR subsequent procedure calls
9920:
9921:
9922: FOR i IN TmpScheduleTab.FIRST..TmpScheduleTab.LAST LOOP