eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASGN_CONFLICT_HIST_PKG SQL Statements

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

Line: 8


PROCEDURE insert_rows
      ( p_conflict_group_id                IN Number := NULL                ,
        p_assignment_id                    IN Number                        ,
        p_conflict_assignment_id           IN Number                        ,
        p_resolve_conflict_action_code     IN VARCHAR2                      ,
        p_intra_txn_conflict_flag          IN VARCHAR2                      ,
        p_processed_flag                   IN VARCHAR2 := 'N'               ,
        p_self_conflict_flag               IN VARCHAR2                      ,
        x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN
  INSERT INTO pa_assignment_conflict_hist
      ( conflict_group_id ,
        assignment_id           ,
        conflict_assignment_id  ,
        resolve_conflicts_action_code  ,
        intra_txn_conflict_flag ,
        processed_flag          ,
        self_conflict_flag      ,
        creation_date           ,
        created_by              ,
        last_update_date        ,
        last_updated_by          ,
        last_update_login       )
 VALUES
	(nvl(p_conflict_group_id, pa_assignment_conflict_hist_s.nextval),
        p_assignment_id           ,
        p_conflict_assignment_id  ,
        p_resolve_conflict_action_code    ,
        p_intra_txn_conflict_flag ,
        p_processed_flag          ,
        p_self_conflict_flag      ,
        sysdate                      ,
        fnd_global.user_id           ,
        sysdate                      ,
        fnd_global.user_id           ,
        fnd_global.login_id          );

Line: 54


                          p_procedure_name   => 'insert_rows');

Line: 57


END insert_rows;

Line: 65


PROCEDURE insert_rows
      ( p_conflict_group_id                IN NUMBER := NULL                ,
        p_assignment_id                    IN NUMBER                        ,
        p_conflict_assignment_id_tbl       IN PA_PLSQL_DATATYPES.NumTabTyp  ,
        p_resolve_conflict_action_code     IN VARCHAR2                      ,
        p_intra_txn_conflict_flag_tbl      IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE:=NULL,
        p_processed_flag                   IN VARCHAR2 := 'N'               ,
        x_conflict_group_id                OUT NOCOPY NUMBER                       , --File.Sql.39 bug 4440895
        x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS
  l_conflict_group_id NUMBER := p_conflict_group_id;

Line: 81


    SELECT pa_assignment_conflict_hist_s.nextval
    INTO l_conflict_group_id
    FROM dual;

Line: 90


        INSERT INTO pa_assignment_conflict_hist
        ( conflict_group_id ,
        assignment_id           ,
        conflict_assignment_id  ,
        resolve_conflicts_action_code  ,
        intra_txn_conflict_flag ,
        processed_flag          ,
        self_conflict_flag      ,
        creation_date           ,
        created_by              ,
        last_update_date        ,
        last_updated_by          ,
        last_update_login       )
     VALUES
	   (  l_conflict_group_id       ,
        p_assignment_id           ,
        p_conflict_assignment_id_tbl(j)  ,
        p_resolve_conflict_action_code    ,
        'N' ,
        p_processed_flag          ,
        decode((p_assignment_id - p_conflict_assignment_id_tbl(j)), 0, 'Y', 'N'),
        sysdate                      ,
        fnd_global.user_id           ,
        sysdate                      ,
        fnd_global.user_id           ,
        fnd_global.login_id          );

Line: 119


        INSERT INTO pa_assignment_conflict_hist
        ( conflict_group_id ,
        assignment_id           ,
        conflict_assignment_id  ,
        resolve_conflicts_action_code  ,
        intra_txn_conflict_flag ,
        processed_flag          ,
        self_conflict_flag      ,
        creation_date           ,
        created_by              ,
        last_update_date        ,
        last_updated_by         ,
        last_update_login       )
     VALUES
	   (  l_conflict_group_id              ,
        p_assignment_id                  ,
        p_conflict_assignment_id_tbl(j)  ,
        p_resolve_conflict_action_code   ,
        p_intra_txn_conflict_flag_tbl(j) ,
        p_processed_flag          ,
        decode((p_assignment_id - p_conflict_assignment_id_tbl(j)), 0, 'Y', 'N'),
        sysdate                      ,
        fnd_global.user_id           ,
        sysdate                      ,
        fnd_global.user_id           ,
        fnd_global.login_id          );

Line: 154


                          p_procedure_name   => 'insert_rows');

Line: 157


END insert_rows;

Line: 166


PROCEDURE update_rows
      ( p_conflict_group_id                IN Number                        ,
        p_assignment_id                    IN Number                        ,
        p_conflict_assignment_id           IN Number                        ,
        p_resolve_conflict_action_code     IN VARCHAR2                      ,
        x_return_status              OUT  NOCOPY VARCHAR2          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN

  UPDATE PA_ASSIGNMENT_CONFLICT_HIST
  SET
      resolve_conflicts_action_code = p_resolve_conflict_action_code,
      last_update_date              = sysdate,
      last_updated_by               = fnd_global.user_id,
      last_update_login             = fnd_global.login_id
  WHERE conflict_group_id        = p_conflict_group_id
  AND   assignment_id            = p_assignment_id
  AND   conflict_assignment_id   = p_conflict_assignment_id;

Line: 194


                           p_procedure_name     => 'update_rows');

Line: 197


END update_rows;

Line: 206


PROCEDURE update_rows
      ( p_conflict_group_id                IN Number                        ,
        p_resolve_conflict_action_code     IN VARCHAR2                      ,
        x_return_status              OUT  NOCOPY VARCHAR2          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN

  UPDATE PA_ASSIGNMENT_CONFLICT_HIST
  SET
      resolve_conflicts_action_code = p_resolve_conflict_action_code,
      last_update_date              = sysdate,
      last_updated_by               = fnd_global.user_id,
      last_update_login             = fnd_global.login_id
  WHERE conflict_group_id        = p_conflict_group_id;

Line: 230


                           p_procedure_name     => 'update_rows');

Line: 233


END update_rows;

Line: 242


PROCEDURE update_rows
      ( p_conflict_group_id                IN Number                        ,
        p_assignment_id_arr                IN SYSTEM.PA_NUM_TBL_TYPE       ,
        p_action_code_arr                  IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE      ,
        x_return_status              OUT  NOCOPY VARCHAR2          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN

  IF p_assignment_id_arr.COUNT > 0 THEN
    FORALL j IN p_assignment_id_arr.FIRST .. p_assignment_id_arr.LAST
      UPDATE pa_assignment_conflict_hist
      SET
         resolve_conflicts_action_code = p_action_code_arr(j),
         last_update_date              = sysdate,
         last_updated_by               = fnd_global.user_id,
         last_update_login             = fnd_global.login_id
         WHERE conflict_group_id       = p_conflict_group_id
         AND assignment_id             = p_assignment_id_arr(j);

Line: 272


                           p_procedure_name     => 'update_rows');

Line: 275


END update_rows;

Line: 284


PROCEDURE update_rows
      ( p_conflict_group_id                IN Number                        ,
        p_assignment_id                    IN Number                        ,
        p_processed_flag                   IN VARCHAR2                      ,
        x_return_status              OUT  NOCOPY VARCHAR2          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN

  UPDATE PA_ASSIGNMENT_CONFLICT_HIST
  SET
      processed_flag                = p_processed_flag,
      last_update_date              = sysdate,
      last_updated_by               = fnd_global.user_id,
      last_update_login             = fnd_global.login_id
  WHERE conflict_group_id        = p_conflict_group_id
  AND   assignment_id            = p_assignment_id;

Line: 310


                           p_procedure_name     => 'update_rows');

Line: 313


END update_rows;

Line: 322


PROCEDURE delete_rows
        ( p_conflict_group_id          IN NUMBER,
          p_assignment_id              IN NUMBER,
          p_conflict_assignment_id     IN NUMBER,
          x_return_status              OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
          x_msg_count                  OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
          x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN

  DELETE FROM PA_ASSIGNMENT_CONFLICT_HIST
     WHERE conflict_group_id        = p_conflict_group_id
     AND   assignment_id            = p_assignment_id
     AND   conflict_assignment_id   = p_conflict_assignment_id;

Line: 344


                           p_procedure_name     => 'delete_rows');

Line: 347


END delete_rows;

Line: 356


PROCEDURE delete_rows
        ( p_assignment_id              IN NUMBER,
          x_return_status              OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
          x_msg_count                  OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
          x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN

  DELETE FROM PA_ASSIGNMENT_CONFLICT_HIST          -- Bug 9356152
     WHERE assignment_id            = p_assignment_id
     OR CONFLICT_ASSIGNMENT_ID      = p_assignment_id;

Line: 375


                           p_procedure_name     => 'delete_conflict_rows');

Line: 378


END delete_rows;