APPS.QPR_DEAL_ETL dependencies on QPR_PN_LINES_S

Line 698: update qpr_pn_lines set PROPOSED_PRICE = l_PROPOSED_PRICE,

694: c_mdl_lines_rec.revised_oq * l_deal_uom_pp_conv;
695: end if;
696: end if;
697:
698: update qpr_pn_lines set PROPOSED_PRICE = l_PROPOSED_PRICE,
699: RECOMMENDED_PRICE = l_recommended_price,
700: REGRESSION_SLOPE = l_regression_slope,
701: LINE_PRICING_SCORE = l_LINE_PRICING_SCORE
702: where pn_line_id = l_line_id;

Line 1001: values(QPR_PN_LINES_S.nextval,

997: CREATED_BY,
998: LAST_UPDATE_DATE,
999: LAST_UPDATE_LOGIN,
1000: LAST_UPDATED_BY)
1001: values(QPR_PN_LINES_S.nextval,
1002: l_response_id,
1003: l_request_id,
1004: int_lines_rec.PRICE_PLAN_ID,
1005: int_lines_rec.SOURCE_REF_LINE_ID,

Line 1162: values(QPR_PN_LINES_S.nextval,

1158: CREATED_BY,
1159: LAST_UPDATE_DATE,
1160: LAST_UPDATE_LOGIN,
1161: LAST_UPDATED_BY)
1162: values(QPR_PN_LINES_S.nextval,
1163: l_response_id,
1164: l_request_id,
1165: int_lines_rec.PRICE_PLAN_ID,
1166: int_lines_rec.SOURCE_REF_LINE_ID,

Line 1250: update qpr_pn_lines set line_pricing_score = round(l_line_score, 2)

1246: log_debug('Determine Line score');
1247: l_line_score := get_line_score(lines_rec.pn_line_id,
1248: lines_rec.recommended_price);
1249:
1250: update qpr_pn_lines set line_pricing_score = round(l_line_score, 2)
1251: where pn_line_id = lines_rec.pn_line_id;
1252: end loop; -- 2nd lines loop
1253:
1254: -- insert adjustment records for header and line total adjustment

Line 2180: values(QPR_PN_LINES_S.nextval,

2176: CREATED_BY,
2177: LAST_UPDATE_DATE,
2178: LAST_UPDATE_LOGIN,
2179: LAST_UPDATED_BY)
2180: values(QPR_PN_LINES_S.nextval,
2181: l_response_id,
2182: lines_rec.REQUEST_HEADER_ID,
2183: lines_rec.PRICE_PLAN_ID,
2184: lines_rec.SOURCE_REF_LINE_ID,