APPS.PA_SCH_EXCEPT_PKG dependencies on PA_SCHEDULE_EXCEPTIONS

Line 11: SELECT pa_schedule_exceptions_s.nextval

7: IS
8: l_nextval NUMBER;
9: BEGIN
10:
11: SELECT pa_schedule_exceptions_s.nextval
12: INTO l_nextval
13: FROM SYS.DUAL;
14:
15: RETURN(l_nextval);

Line 102: INSERT INTO PA_SCHEDULE_EXCEPTIONS

98:
99:
100: FORALL l_J IN p_sch_except_record_tab.first..p_sch_except_record_tab.last
101:
102: INSERT INTO PA_SCHEDULE_EXCEPTIONS
103: ( schedule_exception_id ,
104: calendar_id ,
105: assignment_id ,
106: project_id ,

Line 240: as schedule_exception_id into PA_SCHEDULE_EXCEPTIONS */

236: -- l_t_schedule_exception_id := get_nextval;
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: /*Bug 5854571: Added following for inserting l_t_schedule_exception_id
240: as schedule_exception_id into PA_SCHEDULE_EXCEPTIONS */
241: SELECT pa_schedule_exceptions_s.nextval
242: INTO l_t_schedule_exception_id
243: FROM dual;
244:

Line 241: SELECT pa_schedule_exceptions_s.nextval

237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: /*Bug 5854571: Added following for inserting l_t_schedule_exception_id
240: as schedule_exception_id into PA_SCHEDULE_EXCEPTIONS */
241: SELECT pa_schedule_exceptions_s.nextval
242: INTO l_t_schedule_exception_id
243: FROM dual;
244:
245:

Line 246: INSERT INTO PA_SCHEDULE_EXCEPTIONS

242: INTO l_t_schedule_exception_id
243: FROM dual;
244:
245:
246: INSERT INTO PA_SCHEDULE_EXCEPTIONS
247: ( schedule_exception_id ,
248: calendar_id ,
249: assignment_id ,
250: project_id ,

Line 278: (l_t_schedule_exception_id, -- removed pa_schedule_exceptions_s.nextval /*Bug 5854571*/

274: last_update_date ,
275: last_update_by ,
276: last_update_login)
277: VALUES
278: (l_t_schedule_exception_id, -- removed pa_schedule_exceptions_s.nextval /*Bug 5854571*/
279: p_calendar_id ,
280: p_assignment_id ,
281: p_project_id ,
282: p_schedule_type_code ,

Line 401: UPDATE PA_SCHEDULE_EXCEPTIONS

397:
398: END LOOP;
399:
400: FORALL l_J IN p_sch_except_record_tab.first..p_sch_except_record_tab.last
401: UPDATE PA_SCHEDULE_EXCEPTIONS
402: SET
403: calendar_id = l_calendar_id(l_J),
404: assignment_id = l_assignment_id(l_J),
405: project_id = l_project_id(l_J),

Line 507: UPDATE PA_SCHEDULE_EXCEPTIONS

503: BEGIN
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: UPDATE PA_SCHEDULE_EXCEPTIONS
508: SET
509: calendar_id = p_calendar_id,
510: assignment_id = p_assignment_id,
511: project_id = p_project_id,

Line 608: UPDATE PA_SCHEDULE_EXCEPTIONS

604: BEGIN
605:
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: UPDATE PA_SCHEDULE_EXCEPTIONS
609: SET
610: calendar_id = p_calendar_id,
611: assignment_id = p_assignment_id,
612: project_id = p_project_id,

Line 649: -- This procedure will delete the records in pa_schedule_exceptions table

645: raise;
646:
647: END update_rows;
648:
649: -- This procedure will delete the records in pa_schedule_exceptions table
650: -- Input parameters
651: -- Parameters Type Required Description
652: -- P_Sch_Except_Record_Tab TABLETYPE YES It contains the exception record
653: --

Line 677: DELETE FROM PA_SCHEDULE_EXCEPTIONS WHERE schedule_exception_id = l_schedule_exception_id(l_J);

673:
674: END LOOP;
675:
676: FORALL l_J IN l_schedule_exception_id.first..l_schedule_exception_id.last
677: DELETE FROM PA_SCHEDULE_EXCEPTIONS WHERE schedule_exception_id = l_schedule_exception_id(l_J);
678:
679: EXCEPTION
680: WHEN OTHERS THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 688: -- This procedure will delete the records in pa_schedule_exceptions table

684: raise;
685:
686: END delete_rows;
687:
688: -- This procedure will delete the records in pa_schedule_exceptions table
689: -- Input parameters
690: -- Parameters Type Required Description
691: -- P_Schedule_Exception_Id NUMBER YES It schedule exception id
692: --

Line 705: FROM PA_SCHEDULE_EXCEPTIONS

701:
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: DELETE
705: FROM PA_SCHEDULE_EXCEPTIONS
706: WHERE schedule_exception_id = p_schedule_exception_id;
707:
708: EXCEPTION
709: WHEN OTHERS THEN

Line 717: -- This procedure will delete the records in pa_schedule_exceptions table

713: raise;
714:
715: END delete_rows;
716:
717: -- This procedure will delete the records in pa_schedule_exceptions table
718: -- Input parameters
719: -- Parameters Type Required Description
720: -- P_Exceptrowid ROWID YES It exception row id
721: --

Line 734: FROM PA_SCHEDULE_EXCEPTIONS

730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:
733: DELETE
734: FROM PA_SCHEDULE_EXCEPTIONS
735: WHERE rowid = p_exceptrowid;
736:
737: EXCEPTION
738: WHEN OTHERS THEN