APPS.PN_REC_ARCL_DTL_PKG SQL Statements

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

Line: 13

PROCEDURE insert_row(
             x_org_id                 pn_rec_arcl_dtl.org_id%TYPE,
             x_area_class_id          pn_rec_arcl_dtl.area_class_id%TYPE,
             x_area_class_dtl_id      IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
             x_as_of_date             pn_rec_arcl_dtl.as_of_date%TYPE,
             x_from_date              pn_rec_arcl_dtl.from_date%TYPE,
             x_to_date                pn_rec_arcl_dtl.to_date%TYPE,
             x_status                 pn_rec_arcl_dtl.status%TYPE,
             x_ttl_assignable_area    pn_rec_arcl_dtl.total_assignable_area%TYPE,
             x_ttl_occupied_area      pn_rec_arcl_dtl.total_occupied_area%TYPE,
             x_ttl_occupied_area_ovr  pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
             x_ttl_occupied_area_exc  pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
             x_ttl_vacant_area        pn_rec_arcl_dtl.total_vacant_area%TYPE,
             x_ttl_vacant_area_ovr    pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
             x_ttl_vacant_area_exc    pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
             x_ttl_weighted_avg       pn_rec_arcl_dtl.total_weighted_avg%TYPE,
             x_ttl_weighted_avg_ovr   pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
             x_ttl_weighted_avg_exc   pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
             x_last_update_date       pn_rec_arcl_dtl.last_update_date%TYPE,
             x_last_updated_by        pn_rec_arcl_dtl.last_updated_by%TYPE,
             x_creation_date          pn_rec_arcl_dtl.creation_date%TYPE,
             x_created_by             pn_rec_arcl_dtl.created_by%TYPE,
             x_last_update_login      pn_rec_arcl_dtl.last_update_login%TYPE)
IS
   l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';

Line: 40

    SELECT org_id
    FROM pn_rec_arcl_all
    WHERE area_class_id = x_area_class_id;

Line: 58

   INSERT INTO pn_rec_arcl_dtl_all
   (
      org_id,
      area_class_id,
      area_class_dtl_id,
      as_of_date,
      from_date,
      to_date,
      status,
      total_assignable_area,
      total_occupied_area,
      total_occupied_area_ovr,
      total_occupied_area_exc,
      total_vacant_area,
      total_vacant_area_ovr,
      total_vacant_area_exc,
      total_weighted_avg,
      total_weighted_avg_ovr,
      total_weighted_avg_exc,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login)
   VALUES(
      l_org_id,
      x_area_class_id,
      pn_rec_arcl_dtl_s.nextval,
      x_as_of_date,
      x_from_date,
      x_to_date,
      x_status,
      x_ttl_assignable_area,
      x_ttl_occupied_area,
      x_ttl_occupied_area_ovr,
      x_ttl_occupied_area_exc,
      x_ttl_vacant_area,
      x_ttl_vacant_area_ovr,
      x_ttl_vacant_area_exc,
      x_ttl_weighted_avg,
      x_ttl_weighted_avg_ovr,
      x_ttl_weighted_avg_exc,
      x_last_update_date,
      x_last_updated_by,
      x_creation_date,
      x_created_by,
      x_last_update_login)
   RETURNING area_class_dtl_id INTO x_area_class_dtl_id;

Line: 113

END insert_row;

Line: 123

PROCEDURE update_row(
             x_area_class_id          pn_rec_arcl_dtl.area_class_id%TYPE,
             x_area_class_dtl_id      pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
             x_as_of_date             pn_rec_arcl_dtl.as_of_date%TYPE,
             x_from_date              pn_rec_arcl_dtl.from_date%TYPE,
             x_to_date                pn_rec_arcl_dtl.to_date%TYPE,
             x_status                 pn_rec_arcl_dtl.status%TYPE,
             x_ttl_assignable_area    pn_rec_arcl_dtl.total_assignable_area%TYPE,
             x_ttl_occupied_area      pn_rec_arcl_dtl.total_occupied_area%TYPE,
             x_ttl_occupied_area_ovr  pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
             x_ttl_occupied_area_exc  pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
             x_ttl_vacant_area        pn_rec_arcl_dtl.total_vacant_area%TYPE,
             x_ttl_vacant_area_ovr    pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
             x_ttl_vacant_area_exc    pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
             x_ttl_weighted_avg       pn_rec_arcl_dtl.total_weighted_avg%TYPE,
             x_ttl_weighted_avg_ovr   pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
             x_ttl_weighted_avg_exc   pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
             x_last_update_date       pn_rec_arcl_dtl.last_update_date%TYPE,
             x_last_updated_by        pn_rec_arcl_dtl.last_updated_by%TYPE,
             x_creation_date          pn_rec_arcl_dtl.creation_date%TYPE,
             x_created_by             pn_rec_arcl_dtl.created_by%TYPE,
             x_last_update_login      pn_rec_arcl_dtl.last_update_login%TYPE)
IS
   l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';

Line: 151

   UPDATE pn_rec_arcl_dtl_all
   SET
      area_class_id                    = x_area_class_id,
      as_of_date                       = x_as_of_date,
      from_date                        = x_from_date,
      to_date                          = x_to_date,
      status                           = x_status,
      total_assignable_area            = x_ttl_assignable_area,
      total_occupied_area              = x_ttl_occupied_area,
      total_occupied_area_ovr          = x_ttl_occupied_area_ovr,
      total_occupied_area_exc          = x_ttl_occupied_area_exc,
      total_vacant_area                = x_ttl_vacant_area,
      total_vacant_area_ovr            = x_ttl_vacant_area_ovr,
      total_vacant_area_exc            = x_ttl_vacant_area_exc,
      total_weighted_avg               = x_ttl_weighted_avg,
      total_weighted_avg_ovr           = x_ttl_weighted_avg_ovr,
      total_weighted_avg_exc           = x_ttl_weighted_avg_exc,
      last_update_date                 = x_last_update_date,
      last_updated_by                  = x_last_updated_by,
      creation_date                    = x_creation_date,
      created_by                       = x_created_by,
      last_update_login                = x_last_update_login
   WHERE area_class_dtl_id             = x_area_class_dtl_id;

Line: 181

END update_row;

Line: 191

PROCEDURE delete_row(x_area_class_dtl_id    pn_rec_arcl_dtl.area_class_dtl_id%TYPE)
IS
   l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.delete_row';

Line: 198

   DELETE pn_rec_arcl_dtl_all
   WHERE  area_class_dtl_id = x_area_class_dtl_id;

Line: 207

END delete_row;