APPS.QP_PARAM_UTIL dependencies on DUAL

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 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 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,