APPS.POS_SUPPLIER_UDA_BO_PKG SQL Statements

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

Line: 124

        l_request_table.delete;

Line: 125

        FOR j IN (SELECT DISTINCT attr_group_id
                  FROM   pos_supp_prof_ext_b
                  WHERE  party_id = p_party_id) LOOP
            l_attributes_data_table := ego_user_attr_data_table();

Line: 131

                SELECT attr_group_name
                INTO   l_attr_group_disp_name
                FROM   ego_attr_groups_v
                WHERE  attr_group_id = l_attr_group_id;

Line: 170

                l_request_table.delete;

Line: 174

                l_attributes_data_table.delete;

Line: 179

        l_request_table.delete;

Line: 182

            pos_obj_list.delete;

Line: 248

                                      p_create_update_flag   IN VARCHAR2,
                                      x_return_status        OUT NOCOPY VARCHAR2,
                                      x_msg_count            OUT NOCOPY NUMBER,
                                      x_msg_data             OUT NOCOPY VARCHAR2) IS
        l_failed_row_id_buffer VARCHAR2(1000);

Line: 278

        create_update_mode VARCHAR2(100);

Line: 286

        IF p_create_update_flag = 'C' THEN
            create_update_mode := ego_user_attrs_data_pvt.g_create_mode;

Line: 288

        ELSIF p_create_update_flag = 'U' THEN
            create_update_mode := ego_user_attrs_data_pvt.g_update_mode;

Line: 292

            x_msg_data      := 'create update flag is not set';

Line: 298

            SELECT ag.attr_group_id,
                   ag.application_id,
                   eas.data_level_id,
                   ag.multi_row,
                   eas.attr_group_type,
                   ag.descriptive_flex_context_code,
                   ag.descriptive_flexfield_name,
                   eas.classification_code
            INTO   attributes_group_tab
            FROM   ego_fnd_dsc_flx_ctx_ext   ag,
                   ego_obj_attr_grp_assocs_v eas
            WHERE  ag.application_id = 177
            AND    ag.attr_group_id = eas.attr_group_id
            AND    eas.application_id = ag.application_id
            AND    eas.data_level_int_name = l_data_level
            AND    eas.attr_group_name =
                   p_pos_supplier_uda_obj.attribute_group_name;

Line: 335

                                                                                     create_update_mode --TRANSACTION_TYPE
                                                                                     );

Line: 411

                          p_create_update_flag IN VARCHAR2,
                          x_return_status      OUT NOCOPY VARCHAR2,
                          x_msg_count          OUT NOCOPY NUMBER,
                          x_msg_data           OUT NOCOPY VARCHAR2) IS
        l_data_level_1   NUMBER;

Line: 453

                                    p_create_update_flag,
                                    x_return_status,
                                    x_msg_count,
                                    x_msg_data);