APPS.IEU_WP_ACTION_PVT SQL Statements

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

Line: 36

  fnd_msg_pub.delete_msg();

Line: 45

  EXECUTE IMMEDIATE 'select count(wp_action_map_id) from ieu_wp_action_maps where responsibility_id = :1 '||
  ' and application_id =: 2 and action_param_set_id = :3 and action_map_code= :4 and action_map_type_code = :5 '
  INTO l_count USING l_responsibility_id, l_application_id, rec_obj.action_param_set_id,
  rec_obj.action_map_code, rec_obj.action_map_type_code;

Line: 51

        select IEU_wp_action_maps_S1.NEXTVAL into l_action_map_id from sys.dual;

Line: 52

        x_msg_data :=x_msg_data || ' , INSERT INTO maps table with id '|| l_action_map_id;

Line: 53

        sql_stmt := 'insert INTO IEU_wp_action_mapS'||
        ' (WP_ACTION_MAP_ID,'||
        ' OBJECT_VERSION_NUMBER,'||
        ' CREATED_BY,'||
        ' CREATION_DATE,'||
        ' LAST_UPDATED_BY,'||
        ' LAST_UPDATE_DATE,'||
        ' LAST_UPDATE_LOGIN,'||
        ' ACTION_PARAM_SET_ID,'||
        ' APPLICATION_ID,'||
        ' RESPONSIBILITY_ID,'||
        ' ACTION_MAP_TYPE_CODE,'||
        ' ACTION_MAP_CODE,'||
        ' ACTION_MAP_SEQUENCE,'||
        ' PANEL_SEC_CAT_CODE,'||
        ' NOT_VALID_FLAG,'||
        ' DEV_DATA_FLAG '||
        ' )'||
        ' values ('||
        ' :1,'||
        ' :2,'||
        ' :3,'||
        ' :4,'||
        ' :5,'||
        ' :6,'||
        ' :7,'||
        ' :8,'||
        ' :9,'||
        ' :10,'||
        ' :11,'||
        ' :12,'||
        ' :13,'||
        ' :14,'||
        ' :15,'||
        ' :16 '||
        ' )';

Line: 95

            EXECUTE IMMEDIATE 'update ieu_wp_action_maps set responsibility_id = null '||
            ' where responsibility_id = -2 and action_param_set_id = :2 '||
            ' and action_map_code= :3 and action_map_type_code = :4 '
            USING rec_obj.action_param_set_id,
            rec_obj.action_map_code, rec_obj.action_map_type_code;

Line: 103

x_msg_data := x_msg_data || ' , after insert table ';

Line: 121

PROCEDURE DELETE_Actions (x_return_status  OUT NOCOPY VARCHAR2,
                          x_msg_count OUT NOCOPY NUMBER,
                          x_msg_data  OUT NOCOPY VARCHAR2,
                          r_param_set_id IN ieu_wp_act_param_sets_b.action_param_set_id%type
                          ) is

media_count    NUMBER(15);

Line: 131

v_SelectStmt  Varchar2(500);

Line: 137

  SELECT param_property_id
  FROM ieu_wp_param_props_b
  WHERE action_param_set_id =  v_param_set_id;

Line: 142

  fnd_msg_pub.delete_msg();

Line: 152

     delete from IEU_WP_PARAM_PROPS_B
     where param_property_id = cur_rec.param_property_id;

Line: 155

     delete from IEU_WP_PARAM_PROPS_TL
     where param_property_id = cur_rec.param_property_id;

Line: 162

  ' delete from IEU_WP_ACT_PARAM_SETS_B '||
  ' where action_param_set_id = :1 '
  USING r_param_set_id;

Line: 166

  EXECUTE IMMEDIATE 'delete from IEU_WP_ACT_PARAM_SETS_TL where action_param_set_id = :1 '
  USING r_param_set_id;

Line: 169

  EXECUTE IMMEDIATE ' delete from IEU_wp_action_mapS where action_param_set_id  = :1 '
  USING r_param_set_id;

Line: 198

END DELETE_Actions;

Line: 215

PROCEDURE Update_MAction ( x_return_status  OUT NOCOPY VARCHAR2,
                           x_msg_count OUT NOCOPY NUMBER,
                           x_msg_data  OUT NOCOPY VARCHAR2,
                           r_MACTION_DEF_ID IN NUMBER,
                           r_action_user_label IN VARCHAR2,
                           r_action_description IN VARCHAR2,
                           r_param_set_id IN NUMBER)
AS
l_language             VARCHAR2(4);

Line: 225

v_SelectStmt  Varchar2(500);

Line: 230

  fnd_msg_pub.delete_msg();

Line: 236

  execute immediate ' update  IEU_WP_ACT_PARAM_SETS_TL           ' ||
                  '   set                                        ' ||
                  '      LAST_UPDATED_BY = FND_GLOBAL.USER_ID,    ' ||
                  '      LAST_UPDATE_DATE = SYSDATE,               '||
                  '      LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,   '||
                  '      ACTION_PARAM_SET_LABEL = :1 , '||
                  '      ACTION_PARAM_SET_DESC  = :2  ' ||
                  '    where ACTION_PARAM_SET_ID = :3 ' ||
                  '    and language IN (:4 , :5 )'
   using r_action_user_label, r_action_description,r_param_set_id, l_language,l_source_lang ;

Line: 262

END Update_MAction;

Line: 282

PROCEDURE UPDATE_action_map (x_return_status  OUT NOCOPY VARCHAR2,
                             x_msg_count OUT NOCOPY NUMBER,
                             x_msg_data  OUT NOCOPY VARCHAR2,
                             rec_obj IN SYSTEM.IEU_WP_ACTION_MAPS_OBJ
) AS

   l_cur_obj_versn NUMBER;

Line: 292

   fnd_msg_pub.delete_msg();

Line: 297

   execute immediate 'select unique(object_version_number) from ieu_wp_action_maps where wp_action_map_ID = :1'
   into l_cur_obj_versn using rec_obj.wp_action_map_id;

Line: 302

    ' update IEU_WP_ACTION_MAPS   '||
    ' set                         ' ||
    '  OBJECT_VERSION_NUMBER = l_cur_obj_versn+1, '||
    '  LAST_UPDATED_BY = FND_GLOBAL.USER_ID,  '||
    '  LAST_UPDATE_DATE = SYSDATE,  '||
    '  LAST_UPDATE_LOGIN  =FND_GLOBAL.LOGIN_ID, '||
/*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
   -- '  ACTION_MAP_SEQUENCE   = :1, '||
    '  ACTION_MAP_SEQUENCE   = :1 '||
/*********************************************************************************/

    '  NOT_VALID_FLAG  = :2 '||
    ' where WP_ACTION_MAP_ID = :3 '
    USING rec_obj.action_map_sequence, rec_obj.not_valid_flag ,rec_obj.wp_action_map_id;

Line: 336

END UPDATE_action_map;

Line: 357

PROCEDURE UPDATE_action_map_sequence (x_return_status  OUT NOCOPY VARCHAR2,
                                      x_msg_count OUT NOCOPY NUMBER,
                                      x_msg_data  OUT NOCOPY VARCHAR2,
                                      r_action_param_set_id IN IEU_WP_ACTION_MAPS.action_param_set_id%type,
                                      r_MACTION_DEF_TYPE_FLAG IN IEU_UWQ_MACTION_DEFS_B.MACTION_DEF_TYPE_FLAG %type,
                                      r_application_id IN IEU_WP_ACTION_MAPS.application_id%type,
                                      r_sel_enum_id IN IEU_UWQ_SEL_ENUMERATORS.sel_enum_id%type,
                                      r_action_map_sequence IN IEU_WP_ACTION_MAPS.action_map_sequence%type,
                                      r_not_valid_flag IN IEU_WP_ACTION_MAPS.not_valid_flag%type
) AS

   l_cur_obj_versn NUMBER;

Line: 376

  select m.WP_ACTION_MAP_ID, m.object_version_number
  from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
       ieu_wp_act_param_sets_b sb
  where  m.action_map_type_code = v_type_code
        --and m.application_id = db.application_id
        and db.maction_def_type_flag= v_MACTION_DEF_TYPE_FLAG
        and db.maction_def_id = sb.wp_action_def_id
        and sb.action_param_set_id= m.action_param_set_id
        and m.action_param_set_id = v_action_param_set_id
        --and m.APPLICATION_ID = v_application_id
        and m.ACTION_MAP_CODE = (select ENUM_TYPE_UUID
                                 FROM ieu_uwq_sel_enumerators
                                 where sel_enum_id = v_sel_enum_id);

Line: 391

  select m.WP_ACTION_MAP_ID, m.object_version_number
  from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db,
       ieu_wp_act_param_sets_b sb, ieu_uwq_node_ds ds
  where  m.action_map_type_code = v_type_code
        --and m.application_id = db.application_id
        and db.maction_def_type_flag= 'F'
        and db.maction_def_id = sb.wp_action_def_id
        and sb.action_param_set_id= m.action_param_set_id
        and m.action_param_set_id =v_action_param_set_id
        --and m.APPLICATION_ID = v_application_id
        and m.ACTION_MAP_CODE = to_char(ds.NODE_DS_ID)
        and ds.ENUM_TYPE_UUID = (select ENUM_TYPE_UUID
                                 FROM ieu_uwq_sel_enumerators
                                 where sel_enum_id = v_sel_enum_id);

Line: 407

   fnd_msg_pub.delete_msg();

Line: 428

          ' update IEU_WP_ACTION_MAPS  '||
          ' set                        ' ||
          '   OBJECT_VERSION_NUMBER = :1, '||
          '   LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
          '   LAST_UPDATE_DATE = SYSDATE, '||
          ' LAST_UPDATE_LOGIN  =FND_GLOBAL.LOGIN_ID, '||
          '  ACTION_MAP_SEQUENCE   = :2 , '||
          '  NOT_VALID_FLAG  =  :3 '||
          ' where WP_ACTION_MAP_ID = :4  '
          USING v_ver_number, r_action_map_sequence, r_not_valid_flag,  c_rec.wp_action_map_id;

Line: 440

          ' update IEU_WP_ACTION_MAPS  ' ||
          ' set                        ' ||
          '  OBJECT_VERSION_NUMBER = :1 , '||
          '  LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
          '  LAST_UPDATE_DATE = SYSDATE, '||
          '  LAST_UPDATE_LOGIN  =FND_GLOBAL.LOGIN_ID, '||
          '  ACTION_MAP_SEQUENCE   = :2'||
          '  where WP_ACTION_MAP_ID =  :3 '
          USING v_ver_number, r_action_map_sequence, c_rec.wp_action_map_id;

Line: 467

              ' update IEU_WP_ACTION_MAPS   '||
              ' SET '||
              ' OBJECT_VERSION_NUMBER = :1 , '||
              '  LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
              '  LAST_UPDATE_DATE = SYSDATE, '||
              '  LAST_UPDATE_LOGIN  =FND_GLOBAL.LOGIN_ID, '||
              '  ACTION_MAP_SEQUENCE   = :2 , '||
              '  NOT_VALID_FLAG  =  :3 '||
              '  where WP_ACTION_MAP_ID =  :4 '
              USING v_ver_number,  r_action_map_sequence, r_not_valid_flag, c_rec2.wp_action_map_id;

Line: 479

              ' update IEU_WP_ACTION_MAPS  '||
              ' SET '||
              '   OBJECT_VERSION_NUMBER = :1 , '||
              '   LAST_UPDATED_BY = FND_GLOBAL.USER_ID, '||
              '   LAST_UPDATE_DATE = SYSDATE, '||
              '   LAST_UPDATE_LOGIN  =FND_GLOBAL.LOGIN_ID, '||
              '   ACTION_MAP_SEQUENCE   = :2 '||
              '  where WP_ACTION_MAP_ID =  :3 '
              USING v_ver_number, r_action_map_sequence, c_rec2.wp_action_map_id;

Line: 511

END UPDATE_action_map_sequence;

Line: 530

PROCEDURE DELETE_action_map (x_return_status  OUT NOCOPY VARCHAR2,
                             x_msg_count OUT  NOCOPY NUMBER,
                             x_msg_data  OUT NOCOPY  VARCHAR2,
                             r_action_map_id IN NUMBER
    ) is

media_count    NUMBER(15);

Line: 540

fnd_msg_pub.delete_msg();

Line: 544

execute immediate ' select count(*) '||
' from ieu_wp_action_maps where wp_action_map_id = :1  '||
' and responsibility_id is null'
into l_count
using r_action_map_id;

Line: 552

' delete from IEU_wp_action_mapS '||
' where wp_action_map_ID = :1  '
USING r_action_map_id;

Line: 557

  ' update ieu_wp_action_maps set responsibility_id = -2 ' ||
  ' where wp_action_map_id = :1 '
  using r_action_map_id;

Line: 587

 END DELETE_action_map;

Line: 653

    fnd_msg_pub.delete_msg();

Line: 739

v_SelectStmt  Varchar2(500);

Line: 747

SELECT
   PARAM_ID, PROPERTY_ID,property_value
   , value_override_flag,not_valid_flag
    FROM ieu_wp_param_props_b
     WHERE action_param_set_id in
        (select a.action_param_set_id
        from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
        where a.action_param_set_id = b.action_param_set_id(+)
        and b.action_param_set_id = v_param_set_id
        and c.maction_def_key =  LTRIM(RTRIM(v_wp_action_key))
        and b.language = v_language
        and c.maction_def_id = a.wp_action_def_id
        and a.action_param_set_id in (select action_param_set_id
                                      from ieu_wp_action_maps
                                      where action_map_code in (select enum_type_uuid from ieu_uwq_sel_enumerators
                                                           where sel_enum_id =v_enumId
                                                           )
                                     )
        );

Line: 768

SELECT
   object_version_number, application_id, action_map_type_code,
   action_map_code, panel_sec_cat_code, not_valid_flag
    FROM ieu_wp_action_maps
     WHERE responsibility_id = v_responsibility_id
     AND action_param_set_id in
        (select a.action_param_set_id
        from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
        where a.action_param_set_id = b.action_param_set_id(+)
        and b.action_param_set_id = v_param_set_id
        and c.maction_def_key =  LTRIM(RTRIM(v_wp_action_key))
        and b.language = v_language
        and c.maction_def_id = a.wp_action_def_id)
        and action_map_code in (select enum_type_uuid from ieu_uwq_Sel_enumerators
                               where sel_enum_id =v_enumId);

Line: 790

    fnd_msg_pub.delete_msg();

Line: 798

   execute immediate ' select  a.wp_action_def_id  ' ||
                  ' from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b c ' ||
                  ' where a.action_param_set_id = :1  ' ||
                  ' and c.maction_def_key =  :2  ' ||
                  ' and c.maction_def_id = a.wp_action_def_id '
   into l_wp_maction_def_id using r_param_set_id, r_wp_action_key;

Line: 808

       select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;

Line: 816

                      last_updated_by NUMBER(15),
                      last_update_date DATE,
                      last_update_login NUMBER(15),
                      owner VARCHAR2(15) );

Line: 827

       param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 828

       param_sets_rec.last_update_date := SYSDATE;

Line: 829

       param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 831

       IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);

Line: 844

       select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into  l_param_property_id from sys.dual;

Line: 855

                    last_updated_by NUMBER(15),
                    last_update_date DATE,
                    last_update_login NUMBER(15),
                    not_valid_flag     VARCHAR(4000),
                    owner VARCHAR2(15) );

Line: 870

       param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 871

       param_props_rec.last_update_date := SYSDATE;

Line: 872

       param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 875

       IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);

Line: 888

     ' select max(m.action_map_sequence) '||
     ' from ieu_wp_action_maps m, ieu_uwq_maction_defs_b db, '||
     '     ieu_wp_act_param_sets_b sb '||
     -- ' where m.application_id  =  :1 '||
     '      where m.action_map_type_code = :1  '||
     '      and m.action_map_code = :2 '||
     '      and db.maction_def_type_flag = :3 '||
     '      and db.maction_def_id = sb.wp_action_def_id  '||
     '      and sb.action_param_set_id = m.action_param_set_id  '||
     '      and m.responsibility_id = -1 '
      into l_temp_map_sequence USING c_rec2.action_map_type_code,  c_rec2.action_map_code, 'W';

Line: 907

       select IEU_WP_ACTION_MAPS_S1.NEXTVAL into  l_wp_action_map_id from sys.dual;

Line: 909

       ' insert INTO IEU_WP_ACTION_MAPS ' ||
       '    (WP_ACTION_MAP_ID, '||
       '     CREATED_BY, '||
       '     CREATION_DATE, '||
       '     LAST_UPDATED_BY, '||
       '     LAST_UPDATE_DATE, '||
       '     LAST_UPDATE_LOGIN, '||
       '     ACTION_PARAM_SET_ID, '||
       '     APPLICATION_ID, '||
       '     RESPONSIBILITY_ID, '||
       '     ACTION_MAP_TYPE_CODE, '||
       '     ACTION_MAP_CODE, '||
       '     PANEL_SEC_CAT_CODE, '||
       '     NOT_VALID_FLAG, '||
       '     OBJECT_VERSION_NUMBER, '||
       '     action_map_sequence, '||
       '     DEV_DATA_FLAG '||
       '  ) VALUES ( '||
       '      :1 , '||
       '      :2, '||
       '      :3, '||
       '      :4, '||
       '      :5, '||
       '     :6, '||
       '      :7 , '||
       '      :8 , '||
       '      :9, '||
       '      :10 , '||
       '      :11, '||
       '      :12, '||
       '      :13, '||
       '      :14, '||
       '      :15, '||
       '      :16 '||
       '  ) '
         USING l_wp_action_map_id,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID, SYSDATE,
         FND_GLOBAL.LOGIN_ID, l_new_param_set_id, c_rec2.application_id, '-1', c_rec2.action_map_type_code,
         c_rec2.action_map_code, c_rec2.panel_sec_cat_code, c_rec2.not_valid_flag, c_rec2.object_version_number,
         l_temp_map_sequence, r_dev_data_flag;

Line: 951

         select IEU_WP_ACTION_MAPS_S1.NEXTVAL into  l_wp_action_map_id from sys.dual;

Line: 954

         ' insert INTO IEU_WP_ACTION_MAPS '||
         '  (WP_ACTION_MAP_ID, '||
         '   CREATED_BY, '||
         '   CREATION_DATE, '||
         '   LAST_UPDATED_BY, '||
         '   LAST_UPDATE_DATE, '||
         '   LAST_UPDATE_LOGIN, '||
         '   ACTION_PARAM_SET_ID, '||
         '   APPLICATION_ID, '||
         '   ACTION_MAP_TYPE_CODE, '||
         '   ACTION_MAP_CODE, '||
         '   PANEL_SEC_CAT_CODE, '||
         '   NOT_VALID_FLAG, '||
         '   OBJECT_VERSION_NUMBER, '||
         '   action_map_sequence, '||
         '   DEV_DATA_FLAG '||
         ' ) VALUES ( '||
         '    :1, '||
         '    :2, '||
         '    :3, '||
         '    :4, '||
         '    :5, '||
         '    :6, '||
         '    :7 , '||
         '    :8, '||
         '    :9, '||
         '    :10, '||
         '    :11 , '||
         '    :12 , '||
         '    :13 , '||
         '    :14 , '||
          '   :15 )'
         USING l_wp_action_map_id,FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID,
         l_new_param_set_id,  c_rec2.application_id, c_rec2.action_map_type_code,
         c_rec2.action_map_code, c_rec2.panel_sec_cat_code, c_rec2.not_valid_flag, c_rec2.object_version_number,
         l_temp_map_sequence, r_dev_data_flag;

Line: 1033

PROCEDURE UpdateParamProps( x_return_status  OUT NOCOPY VARCHAR2,
                            x_msg_count OUT  NOCOPY NUMBER,
                            x_msg_data  OUT  NOCOPY VARCHAR2,
                            r_applId    IN  NUMBER)

AS
l_user_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;

Line: 1058

l_delete_param_property_id IEU_WP_PARAM_PROPS_B.param_property_id%type;

Line: 1080

select WP_ACTION_DEF_ID, param_id
from ieu_wp_action_params
WHERE param_id IN (SELECT param_id FROM ieu_wp_param_defs_b
                   WHERE application_id =v_applId);

Line: 1090

select distinct action_param_set_id, param_id
from ieu_wp_param_props_b
where param_id in (select param_id from ieu_wp_param_defs_b
                   where DATA_TYPE = v_data_type
                   AND application_id(+) = v_applId)
order by action_param_set_id;

Line: 1100

    fnd_msg_pub.delete_msg();

Line: 1108

    delete from ieu_wp_param_props_b where param_property_id in
    (   select param_property_id
        from ieu_wp_param_props_b
        where param_id not in (select param_id from ieu_wp_param_defs_b));

Line: 1113

   delete from ieu_wp_param_props_tl where param_property_id in
   (    select param_property_id
        from ieu_wp_param_props_b
        where param_id not in (select param_id from ieu_wp_param_defs_b));

Line: 1127

        sql_stmt1 := 'select action_param_set_id '||
                     ' from ieu_wp_act_param_sets_b '||
                     ' where action_param_set_id in (select distinct action_param_set_id '||
                                                    ' from ieu_wp_act_param_sets_b '||
                                                    ' where wp_action_def_id = :action_id '||
                                                    ' ) '||
                     ' and action_param_set_id  not IN '||
                                                    ' (select distinct action_param_set_id '||
                                                    ' from ieu_wp_param_props_b '||
                                                    ' where param_id = :param_id)';

Line: 1144

            sql_stmt := 'select action_param_set_id '||
                        ' from ieu_wp_act_param_sets_b '||
                        ' where action_param_set_id in (select distinct action_param_set_id '||
                                                    ' from ieu_wp_act_param_sets_b '||
                                                    ' where wp_action_def_id = :action_id '||
                                                    ') '||
                        ' and action_param_set_id   IN '||
                                               ' (select distinct action_param_set_id '||
                                               ' from ieu_wp_param_props_b '||
                                               ' where param_id = :param_id)';

Line: 1160

                select count(property_id) into l_index
                from ieu_wp_param_props_b
                where action_param_set_id = l_action_temp_id
                and param_id =  c_rec.param_id;

Line: 1176

                sql_stmt2 := 'select property_id, property_value, VALUE_OVERRIDE_FLAG, NOT_VALID_FLAG '||
                             '  from ieu_wp_param_props_b '||
                             '  where param_id = :param_id '||
                             ' and action_param_set_id = :max_set_id ';

Line: 1185

                    select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into  l_param_property_id from sys.dual;

Line: 1196

                    last_updated_by NUMBER(15),
                    last_update_date DATE,
                    last_update_login NUMBER(15),
                    not_valid_flag     VARCHAR(4000),
                    owner VARCHAR2(15) );

Line: 1211

                     param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 1212

                     param_props_rec.last_update_date := SYSDATE;

Line: 1213

                     param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1216

                     IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);

Line: 1238

        sql_stmt1 :=' select param_property_id '||
                      ' from ieu_wp_param_props_b '||
                      ' where action_param_set_id = :temp '||
                      ' and property_id = 10003'||
                      ' and param_id = :ptemp ';

Line: 1245

            FETCH c_ref2 INTO l_delete_param_property_id;

Line: 1247

            select VALUE_TRANSLATABLE_FLAG into l_trans_flag
            from ieu_wp_properties_b
            where property_id = 10003;

Line: 1251

            if (l_delete_param_property_id is not null ) then
                if (l_trans_flag = 'Y') then
                    update  ieu_wp_param_props_tl set
                    PROPERTY_VALUE = null
                    where param_property_id = l_delete_param_property_id;

Line: 1258

                update  ieu_wp_param_props_b set
                PROPERTY_ID =10022,
                PROPERTY_VALUE = null
                where param_property_id = l_delete_param_property_id;

Line: 1283

end UpdateParamProps;

Line: 1300

select  d.action_param_set_label, b.action_map_sequence,
        d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
     ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
     ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f
where  a.sel_enum_id =v_enumId
and f.maction_def_type_flag = v_panel
and e.language = FND_GLOBAL.CURRENT_LANGUAGE
and a.enum_type_uuid = b.action_map_code
and c.action_param_set_id = b.action_param_set_id
-- and b.application_id = v_applId bug#5585922
and c.wp_action_def_id = e.maction_def_id
and b.responsibility_id = -1
and d.action_param_set_id = c.action_param_set_id
and e.maction_def_id =f.maction_def_id
AND d.language=FND_GLOBAL.CURRENT_LANGUAGE
order by b.action_map_sequence;

Line: 1323

select d.action_param_set_label, b.action_map_sequence,
       d.action_param_set_desc , e.action_user_label, b.not_valid_flag,c.action_param_set_id
from ieu_uwq_Sel_enumerators a, ieu_wp_action_maps b,
     ieu_wp_act_param_sets_b c, ieu_wp_act_param_sets_tl d,
     ieu_uwq_maction_defs_tl e , ieu_uwq_maction_defs_b f, ieu_uwq_node_ds ds
where  a.sel_enum_id =v_enumId
and f.maction_def_type_flag = v_panel
and e.language = FND_GLOBAL.CURRENT_LANGUAGE
AND d.language=FND_GLOBAL.CURRENT_LANGUAGE
and a.enum_type_uuid = ds.enum_type_uuid
AND b.ACTION_MAP_TYPE_CODE = v_action_map_type_code
AND to_char(ds.NODE_DS_ID) = b.ACTION_MAP_CODE
and c.action_param_set_id = b.action_param_set_id
-- and b.application_id = v_applId bug#5585922
and c.wp_action_def_id = e.maction_def_id
and b.responsibility_id = -1
and d.action_param_set_id = c.action_param_set_id
and e.maction_def_id =f.maction_def_id
order by b.action_map_sequence;

Line: 1347

fnd_msg_pub.delete_msg();

Line: 1365

            ' update ieu_wp_action_maps '||
            '  set action_map_sequence = :1 '||
            '  where action_map_sequence IS null '||
            '  and ACTION_MAP_TYPE_CODE = :2 '||
            '  and action_param_set_id = :3  '||
/*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
            --'  and action_param_set_id = :4  '||
/*********************************************************************************/
            '  and action_map_code in (select to_char(node_ds_id) ' ||
            '                          from ieu_uwq_node_ds ' ||
            '                          where enum_type_uuid in (select enum_type_uuid '||
            '                                                    from ieu_uwq_sel_enumerators '||
            '                                                    where sel_enum_id = :5 '||
            '                                                  ) '||
            '                          ) '
            --USING l_count, r_applId,'NODE_DS', c_rec2.action_param_set_id, r_enumId ;

Line: 1384

            ' update ieu_wp_action_maps '||
            '  set action_map_sequence = :1 '||
            '  where action_map_sequence = :2 '||
            '  and ACTION_MAP_TYPE_CODE = :3  ' ||
            '  and action_param_set_id = :4 '||
/*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
            --'  and action_param_set_id = :5 '||
/*********************************************************************************/
            '  and action_map_code in (select to_char(node_ds_id) '||
            '                          from ieu_uwq_node_ds '||
            '                          where enum_type_uuid in (select enum_type_uuid '||
            '                                                    from ieu_uwq_sel_enumerators '||
            '                                                    where sel_enum_id = :6'||
            '                                                  ) '||
            '                          )'
            --USING l_count, r_applId, c_rec2.action_map_sequence,'NODE_DS', c_rec2.action_param_set_id,
            USING l_count, c_rec2.action_map_sequence,'NODE_DS', c_rec2.action_param_set_id,
            c_rec2.action_param_set_id;

Line: 1418

            ' update ieu_wp_action_maps  '||
            '  set action_map_sequence = :1  '||
            '  where action_map_sequence IS null '||
            '  and action_param_set_id = :2 '||
/*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
           --'  and action_param_set_id = :3 '||
/*********************************************************************************/
            '  and action_map_code in (select enum_type_uuid '||
            '                          from ieu_uwq_sel_enumerators '||
            '                          where sel_enum_id = :3) '
            --USING l_count,r_applId, c_rec.action_param_set_id, r_enumId ;

Line: 1432

            ' update ieu_wp_action_maps '||
            '  set action_map_sequence = :1'||
            '  where action_map_sequence = :2 '||
            '  and action_param_set_id = :3 '||
/*******************ADD FOR FORWARD PORT BUG5585922 BY MAJHA**********************/
           -- '  and action_param_set_id = :4 '||
/*********************************************************************************/
            '  and action_map_code in (select enum_type_uuid '||
            '                          from ieu_uwq_sel_enumerators '||
            '                          where sel_enum_id = :4) '
            --USING l_count , r_applId, c_rec.action_map_sequence, c_rec.action_param_set_id, r_enumId;

Line: 1496

v_SelectStmt  Varchar2(500);

Line: 1505

SELECT
   PARAM_ID, PROPERTY_ID,property_value
   , value_override_flag,not_valid_flag
    FROM ieu_wp_param_props_b
     WHERE action_param_set_id in
        (select a.action_param_set_id
        from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
        where a.action_param_set_id = b.action_param_set_id(+)
        and b.action_param_set_id = v_param_set_id
        and c.maction_def_key =  LTRIM(RTRIM(v_wp_action_key))
        and b.language = v_language
        and c.maction_def_id = a.wp_action_def_id
        and a.action_param_set_id in (select action_param_set_id
                                      from ieu_wp_action_maps
                                      where action_map_code in (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e,
                                                                                          ieu_uwq_node_ds ds
                                                                          WHERE e.sel_enum_id = v_enumId
                                                                          and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID)
                                     )
        )
;

Line: 1530

SELECT
   object_version_number, application_id, action_map_type_code,
   action_map_code, panel_sec_cat_code, not_valid_flag
    FROM ieu_wp_action_maps
     WHERE responsibility_id = -1
     AND action_param_set_id in
        (select a.action_param_set_id
        from ieu_wp_act_param_sets_b a, ieu_wp_act_param_sets_tl b, ieu_uwq_maction_defs_b c
        where a.action_param_set_id = b.action_param_set_id(+)
        and b.action_param_set_id = v_param_set_id
        and c.maction_def_key =  LTRIM(RTRIM(v_wp_action_key))
        and b.language = v_language
        and c.maction_def_id = a.wp_action_def_id)
        and action_map_code in (SELECT to_char(ds.NODE_DS_ID) FROM ieu_uwq_sel_enumerators e,  ieu_uwq_node_ds ds
                                                                          WHERE e.sel_enum_id = v_enumId
                                                                          and e.ENUM_TYPE_UUID = ds.ENUM_TYPE_UUID);

Line: 1551

    fnd_msg_pub.delete_msg();

Line: 1558

   execute immediate ' select  a.wp_action_def_id  ' ||
                  ' from ieu_wp_act_param_sets_b a, ieu_uwq_maction_defs_b c ' ||
                  ' where a.action_param_set_id = :1  ' ||
                  ' and c.maction_def_key =  :2  ' ||
                  ' and c.maction_def_id = a.wp_action_def_id '
   into l_wp_maction_def_id using r_param_set_id, r_wp_action_key;

Line: 1567

       select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;

Line: 1575

                      last_updated_by NUMBER(15),
                      last_update_date DATE,
                      last_update_login NUMBER(15),
                      owner VARCHAR2(15) );

Line: 1586

       param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 1587

       param_sets_rec.last_update_date := SYSDATE;

Line: 1588

       param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1590

       IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);

Line: 1602

      select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into  l_param_property_id from sys.dual;

Line: 1613

                    last_updated_by NUMBER(15),
                    last_update_date DATE,
                    last_update_login NUMBER(15),
                    not_valid_flag     VARCHAR(4000),
                    owner VARCHAR2(15) );

Line: 1628

       param_props_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 1629

       param_props_rec.last_update_date := SYSDATE;

Line: 1630

       param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1633

       IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);

Line: 1644

       select IEU_WP_ACTION_MAPS_S1.NEXTVAL into  l_wp_action_map_id from sys.dual;

Line: 1646

       ' insert INTO IEU_WP_ACTION_MAPS '||
       ' (WP_ACTION_MAP_ID, '||
       ' CREATED_BY, '||
       ' CREATION_DATE, '||
       ' LAST_UPDATED_BY, '||
       ' LAST_UPDATE_DATE, '||
       ' LAST_UPDATE_LOGIN, '||
       ' ACTION_PARAM_SET_ID, '||
       ' APPLICATION_ID, '||
       ' RESPONSIBILITY_ID, '||
       ' ACTION_MAP_TYPE_CODE, '||
       ' ACTION_MAP_CODE, '||
       ' PANEL_SEC_CAT_CODE, '||
       ' NOT_VALID_FLAG, '||
       ' OBJECT_VERSION_NUMBER, '||
       ' Security_group_id, '||
       ' action_map_sequence, '||
       ' DEV_DATA_FLAG '||
       ' ) VALUES ( '||
       ' :1, '||
       '  :2, '||
       '  :3, '||
       '  :4, '||
       '  :5, '||
       '  :6, '||
       '  :7 , '||
       '  :8 , '||
       '  :9, '||
       '  :10 , '||
       '  :11, '||
       '  :12, '||
       '  :13, '||
       '  :14, '||
       '  :15 , '||
       '  :16 , '||
       '  :17 '||
       '  ) '
       USING l_wp_action_map_id, FND_GLOBAL.USER_ID, SYSDATE,FND_GLOBAL.USER_ID, SYSDATE, FND_GLOBAL.LOGIN_ID,
       l_new_param_set_id, c_rec2.application_id,'-1', c_rec2.action_map_type_code,
       c_rec2.action_map_code,c_rec2.panel_sec_cat_code, c_rec2.not_valid_flag, c_rec2.object_version_number,
       l_security_group_id, l_temp_map_sequence, r_dev_data_flag;