APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_PN_REQUEST_HDRS_B

Line 1903: from qpr_pn_request_hdrs_b

1899: l_dummy number;
1900: begin
1901: begin
1902: select request_header_id into l_dummy
1903: from qpr_pn_request_hdrs_b
1904: where instance_id = p_instance_id
1905: and source_id = decode(p_src_choice,1, 660, 2, 697, p_src_choice)
1906: and source_ref_hdr_short_desc = (p_quote_number || ' - Ver '|| p_quote_version)
1907: and nvl(request_status, 'ACTIVE') = 'ACTIVE'

Line 2022: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;

2018: p_instance_id in number,
2019: p_source_id in number,
2020: p_src_quote_header_id in number)
2021: return varchar2 is
2022: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2023: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2024: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2025: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2026: r_hdr qpr_pn_int_headers%rowtype;

Line 2023: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;

2019: p_source_id in number,
2020: p_src_quote_header_id in number)
2021: return varchar2 is
2022: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2023: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2024: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2025: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2026: r_hdr qpr_pn_int_headers%rowtype;
2027: r_lines qpr_pn_int_lines%rowtype;

Line 2024: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;

2020: p_src_quote_header_id in number)
2021: return varchar2 is
2022: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2023: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2024: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2025: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2026: r_hdr qpr_pn_int_headers%rowtype;
2027: r_lines qpr_pn_int_lines%rowtype;
2028: l_hdr_matching boolean := false;

Line 2025: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;

2021: return varchar2 is
2022: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2023: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2024: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2025: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2026: r_hdr qpr_pn_int_headers%rowtype;
2027: r_lines qpr_pn_int_lines%rowtype;
2028: l_hdr_matching boolean := false;
2029: l_line_matching boolean := false;

Line 2088: from qpr_pn_request_hdrs_b req

2084: begin
2085: select req.CUSTOMER_ID, req.SALES_REP_ID, req.SALES_CHANNEL_CODE,
2086: req.request_header_id
2087: into l_resp_cust, l_resp_sales_rep, l_resp_sc, l_request_hdr_id
2088: from qpr_pn_request_hdrs_b req
2089: where instance_id = p_instance_id
2090: and source_id = p_source_id
2091: and source_ref_hdr_id = p_src_quote_header_id
2092: and request_status = 'ACTIVE'