APPS.QP_PRICING_ENGINE_PVT dependencies on QP_DISCOUNTS_UPG_TEMP

Line 314: DELETE FROM QP_DISCOUNTS_UPG_TEMP;

310: --dbms_output.put_line('Hellooooo');
311: IF (v_discount_lines_tbl.COUNT > 0) THEN
312:
313: --Delete all the records
314: DELETE FROM QP_DISCOUNTS_UPG_TEMP;
315:
316: v_index := v_discount_lines_tbl.FIRST;
317: LOOP
318: --dbms_output.put_line('Discount Id : ' || v_discount_lines_tbl(v_index).p_discount_id);

Line 324: INSERT INTO QP_DISCOUNTS_UPG_TEMP VALUES(v_discount_lines_tbl(v_index).p_discount_id,

320: --dbms_output.put_line('Discount Name : ' || v_discount_lines_tbl(v_index).p_discount_name);
321: --dbms_output.put_line('Discount Percent : ' || v_discount_lines_tbl(v_index).p_discount_percent);
322:
323:
324: INSERT INTO QP_DISCOUNTS_UPG_TEMP VALUES(v_discount_lines_tbl(v_index).p_discount_id,
325: v_discount_lines_tbl(v_index).p_discount_name,
326: v_discount_lines_tbl(v_index).p_discount_line_id,
327: v_discount_lines_tbl(v_index).p_discount_percent);
328: EXIT WHEN v_index = v_discount_lines_tbl.LAST;

Line 339: FROM QP_DISCOUNTS_UPG_TEMP

335: INTO x_discount_rec.p_discount_id,
336: x_discount_rec.p_discount_name,
337: x_discount_rec.p_discount_line_id,
338: x_discount_rec.p_discount_percent
339: FROM QP_DISCOUNTS_UPG_TEMP
340: WHERE DISCOUNT_PERCENT = (SELECT min(DISCOUNT_PERCENT) FROM QP_DISCOUNTS_UPG_TEMP)
341: AND ROWNUM = 1;
342: ELSE
343: SELECT discount_id , discount_name , discount_line_id, discount_percent

Line 340: WHERE DISCOUNT_PERCENT = (SELECT min(DISCOUNT_PERCENT) FROM QP_DISCOUNTS_UPG_TEMP)

336: x_discount_rec.p_discount_name,
337: x_discount_rec.p_discount_line_id,
338: x_discount_rec.p_discount_percent
339: FROM QP_DISCOUNTS_UPG_TEMP
340: WHERE DISCOUNT_PERCENT = (SELECT min(DISCOUNT_PERCENT) FROM QP_DISCOUNTS_UPG_TEMP)
341: AND ROWNUM = 1;
342: ELSE
343: SELECT discount_id , discount_name , discount_line_id, discount_percent
344: INTO x_discount_rec.p_discount_id,

Line 348: FROM QP_DISCOUNTS_UPG_TEMP

344: INTO x_discount_rec.p_discount_id,
345: x_discount_rec.p_discount_name,
346: x_discount_rec.p_discount_line_id,
347: x_discount_rec.p_discount_percent
348: FROM QP_DISCOUNTS_UPG_TEMP
349: WHERE DISCOUNT_PERCENT = (SELECT max(DISCOUNT_PERCENT) FROM QP_DISCOUNTS_UPG_TEMP)
350: AND ROWNUM = 1;
351: END IF;
352: ELSE

Line 349: WHERE DISCOUNT_PERCENT = (SELECT max(DISCOUNT_PERCENT) FROM QP_DISCOUNTS_UPG_TEMP)

345: x_discount_rec.p_discount_name,
346: x_discount_rec.p_discount_line_id,
347: x_discount_rec.p_discount_percent
348: FROM QP_DISCOUNTS_UPG_TEMP
349: WHERE DISCOUNT_PERCENT = (SELECT max(DISCOUNT_PERCENT) FROM QP_DISCOUNTS_UPG_TEMP)
350: AND ROWNUM = 1;
351: END IF;
352: ELSE
353: x_discount_rec.p_discount_id := NULL;