APPS.QP_UTIL_PUB dependencies on QP_DEBUG_REQ

Line 2481: FROM qp_debug_req

2477: l_return_status_text VARCHAR2(240);
2478:
2479: CURSOR cl_req_dbg IS
2480: SELECT *
2481: FROM qp_debug_req
2482: WHERE request_id = p_request_id;
2483:
2484: CURSOR cl_lines_dbg(p_req_id NUMBER) IS
2485: SELECT *

Line 2486: FROM qp_debug_req_lines

2482: WHERE request_id = p_request_id;
2483:
2484: CURSOR cl_lines_dbg(p_req_id NUMBER) IS
2485: SELECT *
2486: FROM qp_debug_req_lines
2487: WHERE request_id = p_req_id;
2488:
2489: CURSOR cl_qual_dbg(p_req_id NUMBER) IS
2490: SELECT *

Line 2491: FROM qp_debug_req_line_attrs

2487: WHERE request_id = p_req_id;
2488:
2489: CURSOR cl_qual_dbg(p_req_id NUMBER) IS
2490: SELECT *
2491: FROM qp_debug_req_line_attrs
2492: WHERE request_id = p_req_id AND
2493: attribute_type = 'QUALIFIER' AND
2494: line_detail_index IS NULL;
2495:

Line 2498: FROM qp_debug_req_line_attrs

2494: line_detail_index IS NULL;
2495:
2496: CURSOR cl_line_attr_dbg(p_req_id NUMBER) IS
2497: SELECT *
2498: FROM qp_debug_req_line_attrs
2499: WHERE request_id = p_req_id AND
2500: attribute_type IN ('PRODUCT','PRICING') AND
2501: line_detail_index IS NULL;
2502:

Line 2505: FROM qp_debug_req_ldets

2501: line_detail_index IS NULL;
2502:
2503: CURSOR cl_ldets_dbg(p_req_id NUMBER) IS
2504: SELECT *
2505: FROM qp_debug_req_ldets
2506: WHERE request_id = p_req_id;
2507:
2508:
2509: CURSOR cl_rltd_dbg(p_req_id NUMBER) IS

Line 2511: FROM qp_debug_req_rltd_lines

2507:
2508:
2509: CURSOR cl_rltd_dbg(p_req_id NUMBER) IS
2510: SELECT *
2511: FROM qp_debug_req_rltd_lines
2512: WHERE request_id = p_req_id AND
2513: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;
2514:
2515:

Line 2516: l_dbg_req_rec qp_debug_req%ROWTYPE;

2512: WHERE request_id = p_req_id AND
2513: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;
2514:
2515:
2516: l_dbg_req_rec qp_debug_req%ROWTYPE;
2517:
2518: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2519: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2520: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;

Line 2518: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;

2514:
2515:
2516: l_dbg_req_rec qp_debug_req%ROWTYPE;
2517:
2518: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2519: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2520: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2521: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2522: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;

Line 2519: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;

2515:
2516: l_dbg_req_rec qp_debug_req%ROWTYPE;
2517:
2518: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2519: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2520: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2521: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2522: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2523:

Line 2520: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;

2516: l_dbg_req_rec qp_debug_req%ROWTYPE;
2517:
2518: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2519: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2520: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2521: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2522: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2523:
2524: I NUMBER;

Line 2521: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;

2517:
2518: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2519: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2520: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2521: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2522: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2523:
2524: I NUMBER;
2525: BEGIN

Line 2522: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;

2518: --l_dbg_req_lines qp_debug_req_lines%ROWTYPE;
2519: --l_dbg_req_ldets qp_debug_req_ldets%ROWTYPE;
2520: --l_dbg_req_qual qp_debug_req_line_attrs%ROWTYPE;
2521: --l_dbg_req_attr qp_debug_req_line_attrs%ROWTYPE;
2522: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2523:
2524: I NUMBER;
2525: BEGIN
2526: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;