APPS.ASG_SERVICE_ACC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

PROCEDURE InsertAcc
  ( x_acc       IN varchar2
  , x_pk        IN varchar2
  , x_pk_id     IN number
  , x_server_id IN number
  )
IS
BEGIN
  NULL;

Line: 33

END InsertAcc;

Line: 35

FUNCTION UpdateAcc
  ( x_acc       IN varchar2
  , x_pk        IN varchar2
  , x_pk_id     IN number
  , x_server_id IN number
  , x_op        IN varchar2
  ) RETURN NUMBER
IS
BEGIN
  NULL;

Line: 45

END UpdateAcc;

Line: 64

PROCEDURE UpdateAccesses_Partyid
  ( x_party_id  IN number
  , x_server_id IN number
  , x_op        IN varchar2
  )
IS
BEGIN
  NULL;

Line: 72

END UpdateAccesses_Partyid;

Line: 74

PROCEDURE UpdateAccesses_Incidentid
  ( x_incident_id IN number
  , x_server_id   IN number
  , x_op          IN varchar2
  )
IS
BEGIN
  NULL;

Line: 82

END UpdateAccesses_Incidentid;

Line: 84

PROCEDURE UpdateAccesses_Taskid
  ( x_task_id   IN number
  , x_server_id IN number
  , x_op        IN varchar2
  )
IS
BEGIN
  NULL;

Line: 92

END UpdateAccesses_Taskid;

Line: 94

PROCEDURE UpdateMobileUserAcc
  ( x_resource_id in number
  , x_server_id   in number
  , x_op          in varchar2
  )
IS
BEGIN
  NULL;

Line: 102

END UpdateMobileUserAcc;

Line: 104

PROCEDURE INCIDENT_PRE_UPDATE
  ( x_return_status OUT NOCOPY  varchar2
  )
IS
BEGIN
   x_return_status := 'S';

Line: 110

END INCIDENT_PRE_UPDATE;

Line: 112

PROCEDURE INCIDENT_POST_UPDATE
  ( x_return_status OUT NOCOPY  varchar2
  )
IS
BEGIN
  x_return_status := 'S';

Line: 118

END INCIDENT_POST_UPDATE;

Line: 120

PROCEDURE TASKS_POST_INSERT
  ( x_return_status OUT NOCOPY  varchar2
  )
IS
BEGIN
  x_return_status := 'S';

Line: 126

END TASKS_POST_INSERT;

Line: 128

PROCEDURE TASKS_PRE_UPDATE
  ( x_return_status OUT NOCOPY  varchar2
  )
IS
BEGIN
  x_return_status := 'S';

Line: 134

END TASKS_PRE_UPDATE;

Line: 136

PROCEDURE TASK_ASSIGN_POST_INSERT
  ( x_return_status OUT NOCOPY  varchar2
  )
IS
BEGIN
  x_return_status :='S';

Line: 142

END TASK_ASSIGN_POST_INSERT;

Line: 144

PROCEDURE TASK_ASSIGN_PRE_UPDATE
  ( x_return_status OUT NOCOPY  varchar2
  )
IS
BEGIN
  x_return_status := 'S';

Line: 150

END TASK_ASSIGN_PRE_UPDATE;

Line: 152

PROCEDURE TASK_ASSIGN_PRE_DELETE
  ( x_return_status OUT NOCOPY  varchar2
  )
IS
BEGIN
  x_return_status :='S';

Line: 158

END TASK_ASSIGN_PRE_DELETE;