DBA Data[Home] [Help]

APPS.QPR_WKFL_UTIL dependencies on QPR_PN_REQUEST_HDRS_B

Line 275: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;

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;
278: l_hdr_status qpr_pn_response_hdrs.response_status%type;
279: l_description qpr_pn_response_hdrs.description%type;

Line 276: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;

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;
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;

Line 277: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%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;
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');

Line 280: l_req_date qpr_pn_request_hdrs_b.deal_creation_date%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);
284: l_request_hdr_id number;

Line 509: l_cus_name qpr_pn_request_hdrs_b.CUSTOMER_LONG_DESC%type;

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;
512: l_hdr_status qpr_pn_response_hdrs.response_status%type;
513: l_description qpr_pn_response_hdrs.description%type;

Line 510: l_rep_name qpr_pn_request_hdrs_b.SALES_REP_LONG_DESC%type;

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;
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;

Line 511: l_hdr_curr qpr_pn_request_hdrs_b.currency_short_desc%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;
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:

Line 514: l_req_date qpr_pn_request_hdrs_b.deal_creation_date%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);
518: l_hdr_msg varchar2(2000);