APPS.AHL_WBS_RULES_PVT SQL Statements

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

Line: 8

G_LAST_UPDATE_DATE DATE        := SYSDATE;

Line: 9

G_LAST_UPDATED_BY NUMBER(15)   := FND_GLOBAL.user_id;

Line: 10

G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;

Line: 100

  SELECT count(route_no)
  FROM ahl_routes_b
  WHERE sysdate BETWEEN nvl(start_date_active, sysdate) AND nvl(end_date_active, sysdate)
  AND route_no = c_route_num;

Line: 107

  SELECT count(lookup_code)
  FROM fnd_lookup_values_vl
  WHERE lookup_type='AHL_ROUTE_TYPE'
  AND sysdate BETWEEN NVL(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
  AND lookup_code = c_route_type;

Line: 115

  SELECT count(CONCATENATED_SEGMENTS)
  FROM AHL_ROUTES_B_KFV
  WHERE CONCATENATED_SEGMENTS = c_system;

Line: 121

  SELECT count(lookup_code)
  FROM fnd_lookup_values_vl
  WHERE lookup_type='AHL_PROCESS_CODE'
  AND sysdate BETWEEN NVL(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
  AND lookup_code = c_process;

Line: 129

  SELECT count(RULE_ID)
  FROM AHL_WBS_RULES
  WHERE RULE_TEXT = c_rule_text
  AND RULE_ID <> p_x_wbs_rules_rec.RULE_ID;

Line: 428

      SELECT COUNT(*) INTO l_counter
      FROM  ahl_wbs_rules
      START WITH POST_ROUTE_NUMBER = p_x_wbs_rules_rec.PRE_ROUTE_NUMBER
      CONNECT BY PRIOR PRE_ROUTE_NUMBER = POST_ROUTE_NUMBER;

Line: 446

         ROLLBACK TO update_rule_sp;

Line: 516

            FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to insert rule');

Line: 519

         INSERT INTO AHL_WBS_RULES
         (
           RULE_ID,
           OBJECT_VERSION_NUMBER,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN,
           RULE_NUMBER,
           RULE_TEXT,
           PRE_ROUTE_NUMBER,
           PRE_ROUTE_TYPE_CODE,
           PRE_SYSTEM_CODE,
           PRE_PROCESS_CODE,
           POST_ROUTE_NUMBER,
           POST_ROUTE_TYPE_CODE,
           POST_SYSTEM_CODE,
           POST_PROCESS_CODE,
           SECURITY_GROUP_ID
         )
         VALUES
         (
           p_x_wbs_rules_rec.RULE_ID,
           1,
           G_LAST_UPDATE_DATE,
           G_LAST_UPDATED_BY,
           G_CREATION_DATE,
           G_CREATED_BY,
           G_LAST_UPDATE_LOGIN,
           p_x_wbs_rules_rec.RULE_NUMBER,
           p_x_wbs_rules_rec.RULE_TEXT,
           p_x_wbs_rules_rec.PRE_ROUTE_NUMBER,
           p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE,
           p_x_wbs_rules_rec.PRE_SYSTEM_CODE,
           p_x_wbs_rules_rec.PRE_PROCESS_CODE,
           p_x_wbs_rules_rec.POST_ROUTE_NUMBER,
           p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE,
           p_x_wbs_rules_rec.POST_SYSTEM_CODE,
           p_x_wbs_rules_rec.POST_PROCESS_CODE,
           null
         );

Line: 628

PROCEDURE update_rule
(
  p_api_version        IN            NUMBER     := 1.0,
  p_init_msg_list      IN            VARCHAR2   := FND_API.G_TRUE,
  p_commit             IN            VARCHAR2   := FND_API.G_FALSE,
  p_validation_level   IN            NUMBER     := FND_API.G_VALID_LEVEL_FULL,
  p_module_type        IN            VARCHAR2   := NULL,
  x_return_status      OUT NOCOPY    VARCHAR2,
  x_msg_count          OUT NOCOPY    NUMBER,
  x_msg_data           OUT NOCOPY    VARCHAR2,
  p_x_wbs_rules_rec    IN OUT NOCOPY wbs_rules_rec_type
)
IS

   L_API_VERSION          CONSTANT NUMBER := 1.0;

Line: 643

   L_API_NAME             CONSTANT VARCHAR2(30) := 'update_rule';

Line: 651

      SAVEPOINT update_rule_sp;

Line: 682

            FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to update rule');

Line: 685

         UPDATE AHL_WBS_RULES
            SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                LAST_UPDATE_DATE = G_LAST_UPDATE_DATE,
                LAST_UPDATED_BY = G_LAST_UPDATED_BY,
                LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN,
                RULE_TEXT = p_x_wbs_rules_rec.RULE_TEXT,
                PRE_ROUTE_NUMBER = p_x_wbs_rules_rec.PRE_ROUTE_NUMBER,
                PRE_ROUTE_TYPE_CODE = p_x_wbs_rules_rec.PRE_ROUTE_TYPE_CODE,
                PRE_SYSTEM_CODE = p_x_wbs_rules_rec.PRE_SYSTEM_CODE,
                PRE_PROCESS_CODE = p_x_wbs_rules_rec.PRE_PROCESS_CODE,
                POST_ROUTE_NUMBER = p_x_wbs_rules_rec.POST_ROUTE_NUMBER,
                POST_ROUTE_TYPE_CODE = p_x_wbs_rules_rec.POST_ROUTE_TYPE_CODE,
                POST_SYSTEM_CODE = p_x_wbs_rules_rec.POST_SYSTEM_CODE,
                POST_PROCESS_CODE = p_x_wbs_rules_rec.POST_PROCESS_CODE
          WHERE RULE_ID = p_x_wbs_rules_rec.rule_id
            AND object_version_number = p_x_wbs_rules_rec.object_version_number;

Line: 732

         ROLLBACK TO update_rule_sp;

Line: 738

            FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_ERROR block' || ' x_msg_count ' || x_msg_count );

Line: 742

         ROLLBACK TO update_rule_sp;

Line: 748

            FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_UNEXPECTED_ERROR block' || ' x_msg_count ' || x_msg_count );

Line: 752

         ROLLBACK TO update_rule_sp;

Line: 761

            FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In OTHERS block' || ' x_msg_count ' || x_msg_count );

Line: 763

END update_rule;