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_WKFL_UTIL dependencies on QPR_PN_RESPONSE_HDRS

Line 272: l_hdr_score qpr_pn_response_hdrs.DEAL_HEADER_SCORE%type;

268: end get_table_header;
269:
270: procedure form_deal_doc(p_response_header_id in number,
271: p_blob in out nocopy clob) is
272: l_hdr_score qpr_pn_response_hdrs.DEAL_HEADER_SCORE%type;
273: l_version_no qpr_pn_response_hdrs.VERSION_NUMBER%type;
274: l_ref_name varchar2(10000);
275: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
276: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;

Line 273: l_version_no qpr_pn_response_hdrs.VERSION_NUMBER%type;

269:
270: procedure form_deal_doc(p_response_header_id in number,
271: p_blob in out nocopy clob) is
272: l_hdr_score qpr_pn_response_hdrs.DEAL_HEADER_SCORE%type;
273: l_version_no qpr_pn_response_hdrs.VERSION_NUMBER%type;
274: l_ref_name varchar2(10000);
275: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
276: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;
277: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%type;

Line 278: l_hdr_status qpr_pn_response_hdrs.response_status%type;

274: l_ref_name varchar2(10000);
275: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
276: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;
277: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%type;
278: l_hdr_status qpr_pn_response_hdrs.response_status%type;
279: l_description qpr_pn_response_hdrs.description%type;
280: l_req_date qpr_pn_request_hdrs_b.deal_creation_date%type;
281: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
282:

Line 279: l_description qpr_pn_response_hdrs.description%type;

275: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
276: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;
277: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%type;
278: l_hdr_status qpr_pn_response_hdrs.response_status%type;
279: l_description qpr_pn_response_hdrs.description%type;
280: l_req_date qpr_pn_request_hdrs_b.deal_creation_date%type;
281: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
282:
283: l_document varchar2(32000);

Line 363: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_vl req

359: resp.description, req.deal_creation_date , req.request_header_id
360: into l_hdr_score, l_version_no, l_ref_name,
361: l_cus_name, l_rep_name, l_hdr_curr, l_hdr_status,
362: l_description, l_req_date, l_request_hdr_id
363: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_vl req
364: where resp.response_header_id = p_response_header_id
365: and resp.request_header_id = req.request_header_id;
366: exception
367: when no_data_found then

Line 506: l_hdr_score qpr_pn_response_hdrs.DEAL_HEADER_SCORE%type;

502:
503: l_resp_hdr_id number;
504: l_document varchar2(32000) := '';
505:
506: l_hdr_score qpr_pn_response_hdrs.DEAL_HEADER_SCORE%type;
507: l_version_no qpr_pn_response_hdrs.VERSION_NUMBER%type;
508: l_ref_name varchar2(10000);
509: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
510: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;

Line 507: l_version_no qpr_pn_response_hdrs.VERSION_NUMBER%type;

503: l_resp_hdr_id number;
504: l_document varchar2(32000) := '';
505:
506: l_hdr_score qpr_pn_response_hdrs.DEAL_HEADER_SCORE%type;
507: l_version_no qpr_pn_response_hdrs.VERSION_NUMBER%type;
508: l_ref_name varchar2(10000);
509: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
510: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;
511: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%type;

Line 512: l_hdr_status qpr_pn_response_hdrs.response_status%type;

508: l_ref_name varchar2(10000);
509: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
510: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;
511: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%type;
512: l_hdr_status qpr_pn_response_hdrs.response_status%type;
513: l_description qpr_pn_response_hdrs.description%type;
514: l_req_date qpr_pn_request_hdrs_b.deal_creation_date%type;
515:
516: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

Line 513: l_description qpr_pn_response_hdrs.description%type;

509: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;
510: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;
511: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%type;
512: l_hdr_status qpr_pn_response_hdrs.response_status%type;
513: l_description qpr_pn_response_hdrs.description%type;
514: l_req_date qpr_pn_request_hdrs_b.deal_creation_date%type;
515:
516: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
517: l_url varchar2(1000);

Line 535: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_vl req

531: resp.request_header_id
532: into l_hdr_score, l_version_no, l_ref_name,
533: l_cus_name, l_rep_name, l_hdr_curr, l_hdr_status,
534: l_description, l_req_date, l_request_hdr_id
535: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_vl req
536: where resp.response_header_id = l_resp_hdr_id
537: and resp.request_header_id = req.request_header_id;
538: exception
539: when no_data_found then

Line 657: from qpr_pn_response_hdrs

653: where user_id = fnd_global.user_id;
654:
655: select request_header_id, version_number
656: into l_request_hdr_id, l_version_no
657: from qpr_pn_response_hdrs
658: where response_header_id = p_response_id
659: and rownum < 2;
660:
661: l_init_key := 'TOAPP_' || p_response_id || p_fwd_to_user;

Line 819: from qpr_pn_response_hdrs

815: where user_id = fnd_global.user_id;
816:
817: select request_header_id, version_number
818: into l_request_hdr_id, l_version_no
819: from qpr_pn_response_hdrs
820: where response_header_id = p_response_id
821: and rownum < 2;
822:
823: if p_usr_list.count = 0 then

Line 889: from qpr_pn_response_hdrs

885: where user_id = fnd_global.user_id;
886:
887: select request_header_id, version_number
888: into l_request_hdr_id, l_version_no
889: from qpr_pn_response_hdrs
890: where response_header_id = p_response_id
891: and rownum < 2;
892:
893: if p_usr_list.count = 0 then