eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_PN_REQUEST_HDRS_B

Line 1890: from qpr_pn_request_hdrs_b

1886: l_dummy number;
1887: begin
1888: begin
1889: select request_header_id into l_dummy
1890: from qpr_pn_request_hdrs_b
1891: where instance_id = p_instance_id
1892: and source_id = decode(p_src_choice,1, 660, 2, 697, p_src_choice)
1893: and source_ref_hdr_short_desc = (p_quote_number || ' - Ver '|| p_quote_version)
1894: and nvl(request_status, 'ACTIVE') = 'ACTIVE'

Line 2009: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;

2005: p_instance_id in number,
2006: p_source_id in number,
2007: p_src_quote_header_id in number)
2008: return varchar2 is
2009: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2010: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2011: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2012: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2013: r_hdr qpr_pn_int_headers%rowtype;

Line 2010: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;

2006: p_source_id in number,
2007: p_src_quote_header_id in number)
2008: return varchar2 is
2009: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2010: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2011: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2012: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2013: r_hdr qpr_pn_int_headers%rowtype;
2014: r_lines qpr_pn_int_lines%rowtype;

Line 2011: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;

2007: p_src_quote_header_id in number)
2008: return varchar2 is
2009: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2010: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2011: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2012: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2013: r_hdr qpr_pn_int_headers%rowtype;
2014: r_lines qpr_pn_int_lines%rowtype;
2015: l_hdr_matching boolean := false;

Line 2012: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;

2008: return varchar2 is
2009: l_resp_cust qpr_pn_request_hdrs_b.customer_id%type;
2010: l_resp_sales_rep qpr_pn_request_hdrs_b.sales_rep_id%type;
2011: l_resp_sc qpr_pn_request_hdrs_b.sales_channel_code%type;
2012: l_request_hdr_id qpr_pn_request_hdrs_b.request_header_id%type;
2013: r_hdr qpr_pn_int_headers%rowtype;
2014: r_lines qpr_pn_int_lines%rowtype;
2015: l_hdr_matching boolean := false;
2016: l_line_matching boolean := false;

Line 2075: from qpr_pn_request_hdrs_b req

2071: begin
2072: select req.CUSTOMER_ID, req.SALES_REP_ID, req.SALES_CHANNEL_CODE,
2073: req.request_header_id
2074: into l_resp_cust, l_resp_sales_rep, l_resp_sc, l_request_hdr_id
2075: from qpr_pn_request_hdrs_b req
2076: where instance_id = p_instance_id
2077: and source_id = p_source_id
2078: and source_ref_hdr_id = p_src_quote_header_id
2079: and request_status = 'ACTIVE'