APPS.QP_PARAM_UTIL SQL Statements

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

Line: 3

PROCEDURE Get_Valueset_Select( p_valueset_id IN VARCHAR2,
                                x_select_stmt OUT NOCOPY VARCHAR2) IS
    v_select_clause varchar2(4000) := null;

Line: 20

       v_select_clause := 'select ' || v_cols || ' from ' || v_table_r.TABLE_NAME;

Line: 22

       v_select_clause := 'select flex_value attribute_id, flex_value_meaning attribute_name, nvl(description, flex_value_meaning) attribute_meaning FROM fnd_flex_values_vl WHERE flex_value_set_id = '|| v_value_set_id;

Line: 26

      v_select_clause := v_select_clause || ' ' || v_table_r.WHERE_CLAUSE;

Line: 29

    x_select_stmt :=  'Select * from (' || v_select_clause || ') PVVO';

Line: 30

END Get_Valueset_Select;

Line: 32

PROCEDURE Insert_Parameter_Values( p_level IN VARCHAR2,
				   p_level_name IN VARCHAR2) IS
   CURSOR l_param_id_cur(p_level_type VARCHAR2) IS
   SELECT parameter_id,seeded_value
   FROM qp_parameters_b
   WHERE parameter_level = p_level_type;

Line: 45

        SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

Line: 47

	INSERT INTO qp_parameter_values(parameter_value_id,
					parameter_id,
					level_name,
					seeded_default_value,
					created_by,
					creation_date,
					last_updated_by,
					last_update_date,
					last_update_login)
	VALUES
				       (l_parameter_value_id,
					param_rec.parameter_id,
					p_level_name,
					param_rec.seeded_value,
					FND_GLOBAL.user_id,
					sysdate,
					fnd_global.user_id,
					sysdate,
					FND_GLOBAL.login_id);

Line: 67

END Insert_Parameter_Values;

Line: 69

PROCEDURE Delete_Parameter_Values( p_level IN VARCHAR2,
				   p_level_name IN VARCHAR2) IS
BEGIN

   DELETE FROM QP_PARAMETER_VALUES
   WHERE level_name = p_level_name
   AND parameter_id IN ( SELECT parameter_id FROM QP_PARAMETERS_VL
   			 WHERE parameter_level = p_level );

Line: 78

END Delete_Parameter_Values;

Line: 84

 SELECT request_type_code   from qp_pte_request_types_b ;

Line: 87

 SELECT lookup_code from qp_lookups where lookup_type = 'QP_PTE_TYPE';

Line: 96

        SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

Line: 98

        INSERT INTO qp_parameter_values(parameter_value_id,
                                        parameter_id,
                                        level_name,
                                        seeded_default_value,
                                        created_by,
                                        creation_date,
                                        last_updated_by,
                                        last_update_date,
                                        last_update_login)
        VALUES
                                       (l_parameter_value_id,
                                        p_parameter_id,
                                        param_value_rec.request_type_code,
                                        p_seeded_value,
                                        FND_GLOBAL.user_id,
                                        sysdate,
                                        fnd_global.user_id,
                                        sysdate,
                                        FND_GLOBAL.login_id);

Line: 125

	SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

Line: 127

        INSERT INTO qp_parameter_values(parameter_value_id,
                                        parameter_id,
                                        level_name,
                                        seeded_default_value,
                                        created_by,
                                        creation_date,
                                        last_updated_by,
                                        last_update_date,
                                        last_update_login)
        VALUES
                                       (l_parameter_value_id,
                                        p_parameter_id,
                                        param_value_rec.lookup_code,
                                        p_seeded_value,
                                        FND_GLOBAL.user_id,
                                        sysdate,
                                        fnd_global.user_id,
                                        sysdate,
                                        FND_GLOBAL.login_id);

Line: 160

  SELECT nvl(V.USER_ASSIGNED_VALUE,V.SEEDED_DEFAULT_VALUE)
         INTO parameter_value
  from qp_parameters_b B, qp_parameters_tl T, qp_parameter_values V
  Where T.parameter_id = B.parameter_id
  and   T.Language = userenv('LANG')
  and   B.parameter_id = V.parameter_id
  and   B.PARAMETER_LEVEL = p_level
  and   B.Parameter_code = p_parameter_code
  and   V.Level_Name = p_level_name;