eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PARAM_UTIL dependencies on QP_PARAMETER_VALUES

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

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

Line 45: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

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

Line 47: INSERT INTO qp_parameter_values(parameter_value_id,

43: --bug 11826293
44: --SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
45: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
46:
47: INSERT INTO qp_parameter_values(parameter_value_id,
48: parameter_id,
49: level_name,
50: seeded_default_value,
51: created_by,

Line 73: DELETE FROM QP_PARAMETER_VALUES

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

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

91:
92: IF p_parameter_level = 'REQ' THEN
93: FOR param_value_rec in l_request_type_cur LOOP
94: --bug 11826293
95: --SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
96: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
97:
98: INSERT INTO qp_parameter_values(parameter_value_id,
99: parameter_id,

Line 96: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

92: IF p_parameter_level = 'REQ' THEN
93: FOR param_value_rec in l_request_type_cur LOOP
94: --bug 11826293
95: --SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
96: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
97:
98: INSERT INTO qp_parameter_values(parameter_value_id,
99: parameter_id,
100: level_name,

Line 98: INSERT INTO qp_parameter_values(parameter_value_id,

94: --bug 11826293
95: --SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
96: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
97:
98: INSERT INTO qp_parameter_values(parameter_value_id,
99: parameter_id,
100: level_name,
101: seeded_default_value,
102: created_by,

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

120:
121: IF p_parameter_level = 'PTE' THEN
122: FOR param_value_rec in l_pte_type_cur LOOP
123: --bug 11826293
124: --SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
125: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
126:
127: INSERT INTO qp_parameter_values(parameter_value_id,
128: parameter_id,

Line 125: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;

121: IF p_parameter_level = 'PTE' THEN
122: FOR param_value_rec in l_pte_type_cur LOOP
123: --bug 11826293
124: --SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
125: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
126:
127: INSERT INTO qp_parameter_values(parameter_value_id,
128: parameter_id,
129: level_name,

Line 127: INSERT INTO qp_parameter_values(parameter_value_id,

123: --bug 11826293
124: --SELECT QP.QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
125: SELECT QP_PARAMETER_VALUES_S.nextval into l_parameter_value_id FROM dual;
126:
127: INSERT INTO qp_parameter_values(parameter_value_id,
128: parameter_id,
129: level_name,
130: seeded_default_value,
131: created_by,

Line 157: parameter_value qp_parameter_values.user_assigned_value%type;

153: p_parameter_code in varchar2)
154: RETURN VARCHAR2 AS
155: l_routine VARCHAR2(100) := 'QP_Param_Util.Get_Parameter_Value';
156: l_debug VARCHAR2(3);
157: parameter_value qp_parameter_values.user_assigned_value%type;
158: Begin
159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
160: SELECT nvl(V.USER_ASSIGNED_VALUE,V.SEEDED_DEFAULT_VALUE)
161: INTO parameter_value

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

158: Begin
159: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
160: SELECT nvl(V.USER_ASSIGNED_VALUE,V.SEEDED_DEFAULT_VALUE)
161: INTO parameter_value
162: from qp_parameters_b B, qp_parameters_tl T, qp_parameter_values V
163: Where T.parameter_id = B.parameter_id
164: and T.Language = userenv('LANG')
165: and B.parameter_id = V.parameter_id
166: and B.PARAMETER_LEVEL = p_level