APPS.QP_UTIL_PUB dependencies on QP_DEBUG_REQ

Line 2151: FROM qp_debug_req

2147: l_return_status_text VARCHAR2(240);
2148:
2149: CURSOR cl_req_dbg IS
2150: SELECT *
2151: FROM qp_debug_req
2152: WHERE request_id = p_request_id;
2153:
2154: CURSOR cl_lines_dbg(p_req_id NUMBER) IS
2155: SELECT *

Line 2156: FROM qp_debug_req_lines

2152: WHERE request_id = p_request_id;
2153:
2154: CURSOR cl_lines_dbg(p_req_id NUMBER) IS
2155: SELECT *
2156: FROM qp_debug_req_lines
2157: WHERE request_id = p_req_id;
2158:
2159: CURSOR cl_qual_dbg(p_req_id NUMBER) IS
2160: SELECT *

Line 2161: FROM qp_debug_req_line_attrs

2157: WHERE request_id = p_req_id;
2158:
2159: CURSOR cl_qual_dbg(p_req_id NUMBER) IS
2160: SELECT *
2161: FROM qp_debug_req_line_attrs
2162: WHERE request_id = p_req_id AND
2163: attribute_type = 'QUALIFIER' AND
2164: line_detail_index IS NULL;
2165:

Line 2168: FROM qp_debug_req_line_attrs

2164: line_detail_index IS NULL;
2165:
2166: CURSOR cl_line_attr_dbg(p_req_id NUMBER) IS
2167: SELECT *
2168: FROM qp_debug_req_line_attrs
2169: WHERE request_id = p_req_id AND
2170: attribute_type IN ('PRODUCT','PRICING') AND
2171: line_detail_index IS NULL;
2172:

Line 2175: FROM qp_debug_req_ldets

2171: line_detail_index IS NULL;
2172:
2173: CURSOR cl_ldets_dbg(p_req_id NUMBER) IS
2174: SELECT *
2175: FROM qp_debug_req_ldets
2176: WHERE request_id = p_req_id;
2177:
2178:
2179: CURSOR cl_rltd_dbg(p_req_id NUMBER) IS

Line 2181: FROM qp_debug_req_rltd_lines

2177:
2178:
2179: CURSOR cl_rltd_dbg(p_req_id NUMBER) IS
2180: SELECT *
2181: FROM qp_debug_req_rltd_lines
2182: WHERE request_id = p_req_id AND
2183: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;
2184:
2185:

Line 2186: l_dbg_req_rec qp_debug_req%ROWTYPE;

2182: WHERE request_id = p_req_id AND
2183: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;
2184:
2185:
2186: l_dbg_req_rec qp_debug_req%ROWTYPE;
2187:
2188: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2189: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2190: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;

Line 2188: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;

2184:
2185:
2186: l_dbg_req_rec qp_debug_req%ROWTYPE;
2187:
2188: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2189: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2190: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2191: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2192: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;

Line 2189: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;

2185:
2186: l_dbg_req_rec qp_debug_req%ROWTYPE;
2187:
2188: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2189: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2190: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2191: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2192: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2193:

Line 2190: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;

2186: l_dbg_req_rec qp_debug_req%ROWTYPE;
2187:
2188: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2189: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2190: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2191: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2192: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2193:
2194: I NUMBER;

Line 2191: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;

2187:
2188: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2189: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2190: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2191: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2192: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2193:
2194: I NUMBER;
2195: BEGIN

Line 2192: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;

2188: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2189: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2190: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2191: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2192: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2193:
2194: I NUMBER;
2195: BEGIN
2196: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;