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

Line 903: --- insert qpr_pn_response_hdrs ----

899: where L.INSTALLED_FLAG in ('I', 'B');
900:
901: log_debug('Inserted Request header TL values');
902:
903: --- insert qpr_pn_response_hdrs ----
904: insert into qpr_pn_response_hdrs(
905: RESPONSE_HEADER_ID,
906: REQUEST_HEADER_ID,
907: OWNER_ID,

Line 904: insert into qpr_pn_response_hdrs(

900:
901: log_debug('Inserted Request header TL values');
902:
903: --- insert qpr_pn_response_hdrs ----
904: insert into qpr_pn_response_hdrs(
905: RESPONSE_HEADER_ID,
906: REQUEST_HEADER_ID,
907: OWNER_ID,
908: DEAL_HEADER_SCORE,

Line 922: (qpr_pn_response_hdrs_s.nextval,

918: LAST_UPDATE_DATE,
919: LAST_UPDATED_BY,
920: LAST_UPDATE_LOGIN
921: ) values
922: (qpr_pn_response_hdrs_s.nextval,
923: l_request_id, fnd_global.user_id,
924: null,
925: 'APPROVE_REQ',
926: null,

Line 1283: update qpr_pn_response_hdrs

1279: end;
1280:
1281: log_debug('Header Score:' || round(l_total_score, 2));
1282:
1283: update qpr_pn_response_hdrs
1284: set deal_header_score = round(l_total_score, 2)
1285: where response_header_id = l_response_id;
1286:
1287: log_debug('Check compliance and fetch approvers if needed...');

Line 1308: update qpr_pn_response_hdrs

1304: l_response_status := 'APPROVE_REQ';
1305: log_debug('Deal is non-compliant. Requires approval');
1306: end if;
1307:
1308: update qpr_pn_response_hdrs
1309: set response_status = l_response_status
1310: where response_header_id = l_response_id;
1311: end if;
1312:

Line 2059: l_description QPR_PN_RESPONSE_HDRS.DESCRIPTION%type;

2055: l_request_hdr_id number;
2056: l_version_no number;
2057: l_hdr_score number;
2058: l_return_status varchar2(10);
2059: l_description QPR_PN_RESPONSE_HDRS.DESCRIPTION%type;
2060: l_comments QPR_PN_RESPONSE_HDRS.COMMENTS%type;
2061: l_response_stat QPR_PN_RESPONSE_HDRS.RESPONSE_STATUS%type;
2062: t_er_type char240_type;
2063: t_er_name char240_type;

Line 2060: l_comments QPR_PN_RESPONSE_HDRS.COMMENTS%type;

2056: l_version_no number;
2057: l_hdr_score number;
2058: l_return_status varchar2(10);
2059: l_description QPR_PN_RESPONSE_HDRS.DESCRIPTION%type;
2060: l_comments QPR_PN_RESPONSE_HDRS.COMMENTS%type;
2061: l_response_stat QPR_PN_RESPONSE_HDRS.RESPONSE_STATUS%type;
2062: t_er_type char240_type;
2063: t_er_name char240_type;
2064: t_er_desc char240_type;

Line 2061: l_response_stat QPR_PN_RESPONSE_HDRS.RESPONSE_STATUS%type;

2057: l_hdr_score number;
2058: l_return_status varchar2(10);
2059: l_description QPR_PN_RESPONSE_HDRS.DESCRIPTION%type;
2060: l_comments QPR_PN_RESPONSE_HDRS.COMMENTS%type;
2061: l_response_stat QPR_PN_RESPONSE_HDRS.RESPONSE_STATUS%type;
2062: t_er_type char240_type;
2063: t_er_name char240_type;
2064: t_er_desc char240_type;
2065: t_unit_val num_type;

Line 2078: from qpr_pn_response_hdrs

2074: select request_header_id, version_number, deal_header_score,
2075: description,comments, response_status
2076: into l_request_hdr_id, l_version_no, l_hdr_score,
2077: l_description, l_comments, l_response_stat
2078: from qpr_pn_response_hdrs
2079: where response_header_id = p_response_hdr_id
2080: and rownum < 2;
2081:
2082: select nvl(max(version_number), 0) into l_version_no

Line 2083: from qpr_pn_response_hdrs

2079: where response_header_id = p_response_hdr_id
2080: and rownum < 2;
2081:
2082: select nvl(max(version_number), 0) into l_version_no
2083: from qpr_pn_response_hdrs
2084: where request_header_id = l_request_hdr_id;
2085:
2086: insert into qpr_pn_response_hdrs(
2087: RESPONSE_HEADER_ID,

Line 2086: insert into qpr_pn_response_hdrs(

2082: select nvl(max(version_number), 0) into l_version_no
2083: from qpr_pn_response_hdrs
2084: where request_header_id = l_request_hdr_id;
2085:
2086: insert into qpr_pn_response_hdrs(
2087: RESPONSE_HEADER_ID,
2088: REQUEST_HEADER_ID,
2089: DEAL_HEADER_SCORE,
2090: RESPONSE_STATUS,

Line 2105: (qpr_pn_response_hdrs_s.nextval,

2101: DESCRIPTION,
2102: VERSION_NUMBER,
2103: BOOKMARK_FLAG
2104: ) values
2105: (qpr_pn_response_hdrs_s.nextval,
2106: l_request_hdr_id,
2107: l_hdr_score,
2108: l_response_stat,
2109: p_response_hdr_id,

Line 2409: from qpr_pn_lines l, qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req

2405: if nvl(i_is_qty_changed, 'N') = 'Y' then
2406:
2407: select l.uom_code, req.instance_id,l.currency_code
2408: into l_uom_code, l_deal_instance, l_deal_currency
2409: from qpr_pn_lines l, qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req
2410: where l.pn_line_id = i_line_id
2411: and l.response_header_id = i_response_header_id
2412: and l.response_header_id = resp.response_header_id
2413: and resp.request_header_id = req.request_header_id