APPS.IEM_RULES_ENGINE_PUB SQL Statements

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

Line: 234

  select
    a.emailproc_id,
    a.boolean_type_code,
    a.all_email
  from
    iem_emailprocs a,
    iem_account_emailprocs b
  where
    a.emailproc_id = b.emailproc_id
  and
    a.rule_type = p_rule_type
  and
    b.enabled_flag = p_enabled_flag
  and
    b.email_account_id = p_account_id
--  and
--    a.emailproc_id <> 0
  order by b.priority;

Line: 256

  select
    key_type_code,
    operator_type_code,
    value
  from
    iem_emailproc_rules
  where
    emailproc_id = p_emailproc_id;

Line: 268

  select b.parameter1, b.parameter2, b.parameter_tag
  from iem_actions a, iem_action_dtls b
  where a.action_id = b.action_id and a.emailproc_id = p_emailproc_id;

Line: 307

    IF (p_rule_type = 'AUTODELETE' ) THEN
        l_module := 'AUTODELETE';

Line: 359

                    select action into l_action from iem_actions where emailproc_id =  v_emailprocs.emailproc_id;

Line: 439

                        x_parameters.delete;

Line: 498

             ruleHold.delete;

Line: 530

                    select action into l_action from iem_actions where emailproc_id =  v_emailprocs.emailproc_id;

Line: 675

                    select action into l_action from iem_actions where emailproc_id =  v_emailprocs.emailproc_id;

Line: 756

                        x_parameters.delete;

Line: 913

                    select count(ib.item_id) into x_total
                    from   amv_c_chl_item_match cim,
                        jtf_amv_items_vl ib
                    where  cim.channel_category_id = p_cat_id
                        and	  cim.channel_id is null
                        and	  cim.approval_status_type ='APPROVED'
                        and	  cim.table_name_code ='ITEM'
                        and	  cim.available_for_channel_date <= sysdate
                        and	  cim.item_id = ib.item_id
                        and   nvl(ib.effective_start_date, sysdate) <= sysdate + 1
                        and	  nvl(ib.expiration_date, sysdate) >= sysdate;

Line: 926

            Select count(*) into x_total
            from
            (
                SELECT i.item_id,i.item_name,i.description,i.item_type,i.last_update_date
                FROM   jtf_amv_items_vl i,jtf_amv_attachments_v a
                WHERE  i.item_id = a.attachment_used_by_id (+)
                AND    i.item_id IN
                (
                    select ib.item_id
                    from   amv_c_chl_item_match cim,
                        jtf_amv_items_vl ib
                    where  cim.channel_category_id = p_cat_id
                        and	  cim.channel_id is null
                        and	  cim.approval_status_type ='APPROVED'
                        and	  cim.table_name_code ='ITEM'
                        and	  cim.available_for_channel_date <= sysdate
                        and	  cim.item_id = ib.item_id
                        and   nvl(ib.effective_start_date, sysdate) <= sysdate + 1
                        and	  nvl(ib.expiration_date, sysdate) >= sysdate
                )
                GROUP BY i.item_id,
                    i.item_name,
                    i.description,
                    i.item_type,
                    i.last_update_date
            );

Line: 970

                    select count(ib.item_id) into l_total
                    from   amv_c_chl_item_match cim,
                        jtf_amv_items_vl ib
                    where  cim.channel_category_id = l_value
                        and	  cim.channel_id is null
                        and	  cim.approval_status_type ='APPROVED'
                        and	  cim.table_name_code ='ITEM'
                        and   ib.item_id = p_doc_id
                        and	  cim.available_for_channel_date <= sysdate
                        and	  cim.item_id = ib.item_id
                        and   nvl(ib.effective_start_date, sysdate) <= sysdate + 1
                        and	  nvl(ib.expiration_date, sysdate) >= sysdate;