APPS.QP_PARAM_UTIL dependencies on QP_PARAMETER_VALUES

Line 43: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

39: l_parameter_value_id NUMBER;
40:
41: BEGIN
42: FOR param_rec in l_param_id_cur(p_level) LOOP
43: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
44: INSERT INTO qp_parameter_values(parameter_value_id,
45: parameter_id,
46: level_name,
47: seeded_default_value,

Line 44: INSERT INTO qp_parameter_values(parameter_value_id,

40:
41: BEGIN
42: FOR param_rec in l_param_id_cur(p_level) LOOP
43: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
44: INSERT INTO qp_parameter_values(parameter_value_id,
45: parameter_id,
46: level_name,
47: seeded_default_value,
48: created_by,

Line 70: DELETE FROM QP_PARAMETER_VALUES

66: PROCEDURE Delete_Parameter_Values( p_level IN VARCHAR2,
67: p_level_name IN VARCHAR2) IS
68: BEGIN
69:
70: DELETE FROM QP_PARAMETER_VALUES
71: WHERE level_name = p_level_name
72: AND parameter_id IN ( SELECT parameter_id FROM QP_PARAMETERS_VL
73: WHERE parameter_level = p_level );
74:

Line 91: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

87: BEGIN
88:
89: IF p_parameter_level = 'REQ' THEN
90: FOR param_value_rec in l_request_type_cur LOOP
91: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
92:
93: INSERT INTO qp_parameter_values(parameter_value_id,
94: parameter_id,
95: level_name,

Line 93: INSERT INTO qp_parameter_values(parameter_value_id,

89: IF p_parameter_level = 'REQ' THEN
90: FOR param_value_rec in l_request_type_cur LOOP
91: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
92:
93: INSERT INTO qp_parameter_values(parameter_value_id,
94: parameter_id,
95: level_name,
96: seeded_default_value,
97: created_by,

Line 118: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

114:
115:
116: IF p_parameter_level = 'PTE' THEN
117: FOR param_value_rec in l_pte_type_cur LOOP
118: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
119:
120: INSERT INTO qp_parameter_values(parameter_value_id,
121: parameter_id,
122: level_name,

Line 120: INSERT INTO qp_parameter_values(parameter_value_id,

116: IF p_parameter_level = 'PTE' THEN
117: FOR param_value_rec in l_pte_type_cur LOOP
118: SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
119:
120: INSERT INTO qp_parameter_values(parameter_value_id,
121: parameter_id,
122: level_name,
123: seeded_default_value,
124: created_by,

Line 150: parameter_value qp_parameter_values.user_assigned_value%type;

146: p_parameter_code in varchar2)
147: RETURN VARCHAR2 AS
148: l_routine VARCHAR2(100) := 'QP_Param_Util.Get_Parameter_Value';
149: l_debug VARCHAR2(3);
150: parameter_value qp_parameter_values.user_assigned_value%type;
151: Begin
152: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
153: SELECT nvl(V.USER_ASSIGNED_VALUE,V.SEEDED_DEFAULT_VALUE)
154: INTO parameter_value

Line 155: from qp_parameters_b B, qp_parameters_tl T, qp_parameter_values V

151: Begin
152: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
153: SELECT nvl(V.USER_ASSIGNED_VALUE,V.SEEDED_DEFAULT_VALUE)
154: INTO parameter_value
155: from qp_parameters_b B, qp_parameters_tl T, qp_parameter_values V
156: Where T.parameter_id = B.parameter_id
157: and T.Language = userenv('LANG')
158: and B.parameter_id = V.parameter_id
159: and B.PARAMETER_LEVEL = p_level