DBA Data[Home] [Help]

APPS.JTF_BRM_PVT SQL Statements

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

Line: 19

PROCEDURE selector
(
  itemtype  IN     VARCHAR2,
  itemkey   IN     VARCHAR2,
  actid     IN     NUMBER,
  funcmode  IN     VARCHAR2,
  result    IN OUT NOCOPY VARCHAR2
) IS
  --
BEGIN
  --
  -- RUN mode - normal process execution
  --
  IF (funcmode = 'RUN') THEN
    result  := 'MONITOR_RULES';
Line: 39

    wf_core.context('JTF_BRM_PVT', 'SELECTOR',
                    itemtype, itemkey, to_char(actid), funcmode);
Line: 42

END selector;
Line: 176

    SELECT *
    FROM   jtf_brm_parameters
    WHERE  parameter_id = 1;
Line: 236

    JTF_BRMParameter_PVT.Update_BRMParameter(
      p_api_version      => l_api_version,
      p_init_msg_list    => l_init_msg_list,
      p_commit           => l_commit,
      p_validation_level => l_validation_level,
      x_return_status    => l_return_status,
      x_msg_count        => l_msg_count,
      x_msg_data         => l_msg_data,
      p_bp_rec           => l_bp_rec);
Line: 317

    SELECT meaning
    FROM   fnd_lookups
    WHERE  lookup_type        = b_uom_type
    AND    lookup_code        = b_uom_code
    AND    enabled_flag       = 'Y'
    AND    start_date_active <= b_now
    AND    nvl(end_date_active, b_now) >= b_now;
Line: 423

    SELECT jtf_brm_activities_s.nextval
    FROM   DUAL;
Line: 466

    SELECT jbr.view_name,
           jbr.rule_id,
           jbp.rowid,
           jbp.workflow_item_type,
           jbp.workflow_process_name
    FROM   jtf_brm_processes jbp,
           jtf_brm_rules_vl  jbr
    WHERE  jbp.rule_id = jbr.rule_id
    AND    nvl(jbr.start_date_active, b_now + 1) <= b_now
    AND    nvl(jbr.end_date_active, b_now)       >= b_now
    AND    nvl(jbp.brm_uom_type,'JTF_BRM_UOM_TYPE')   = 'JTF_BRM_UOM_TYPE'
    AND    nvl(jbp.last_brm_check_date, b_now - 100) +
           (jbp.brm_check_interval / decode(jbp.brm_check_uom_code,
                                            'MINUTES', 1440,
                                            'HOURS', 24)) <= b_now
    AND    jbr.view_name IS NOT NULL
    and    jbp.workflow_item_type is not null;
Line: 522

      UPDATE jtf_brm_processes
      SET    last_brm_check_date = l_now
      WHERE  rowid = i.rowid;
Line: 526

      l_query := 'SELECT object_type, object_id FROM ' || i.view_name;
Line: 787

    SELECT brm_wf_command_type, brm_wf_command_code
    FROM   jtf_brm_parameters
    WHERE  workflow_process_id = itemkey;
Line: 794

    SELECT meaning
    FROM   fnd_lookups
    WHERE  lookup_type        = b_command_type
    AND    lookup_code        = b_command_code
    AND    enabled_flag       = 'Y'
    AND    start_date_active <= b_now
    AND    nvl(end_date_active, b_now) >= b_now;