DBA Data[Home] [Help]

APPS.QP_PARAM_UTIL dependencies on DUAL

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