APPS.QP_LIST_UPGRADE_UTIL_PVT dependencies on QP_DISCOUNT_MAPPING

Line 415: from qp_discount_mapping dm

411: SECONDARY_PRICE_LIST_ID,
412: NULL
413: FROM so_price_lists_b prl
414: WHERE not exists ( select 'x'
415: from qp_discount_mapping dm
416: where dm.old_discount_id = prl.price_list_id
417: and dm.new_type in ('P','Z'))
418:
419: AND not exists ( select 'x'

Line 464: FROM QP_DISCOUNT_MAPPING

460: FROM SO_PRICE_LISTS_B PRL
461: WHERE PRL.PRICE_LIST_ID IN ( SELECT PRICE_LIST_ID
462: FROM SO_AGREEMENTS_B)
463: AND NOT EXISTS ( SELECT NULL
464: FROM QP_DISCOUNT_MAPPING
465: WHERE OLD_DISCOUNT_ID = PRL.PRICE_LIST_ID
466: AND NEW_TYPE = 'P');
467: vivek */
468: CURSOR sec_price_list IS

Line 756: /* insert into qp_discount_mapping table for the rows that were

752: v_errortext, 'PRICE_LISTS');
753: RAISE;
754: END;
755:
756: /* insert into qp_discount_mapping table for the rows that were
757: just now inserted */
758:
759: --dbms_output.put_line('pr2.6');
760:

Line 771: INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,

767: IF new_prc_list_maps(l_prc_list_map_index).db_flag = 'N' THEN
768:
769: begin
770:
771: INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,
772: OLD_DISCOUNT_LINE_ID,
773: NEW_LIST_HEADER_ID,
774: NEW_LIST_LINE_ID,
775: OLD_PRICE_BREAK_LINES_LOW,

Line 1513: from qp_discount_mapping

1509: from qp_LIST_lines
1510: where list_line_id = prl.price_list_line_id )
1511: comment start
1512: and not exists ( select null
1513: from qp_discount_mapping
1514: where old_discount_line_id = prl.price_list_line_id
1515: and new_type = 'P')
1516: comment end
1517: and prl.price_list_line_id between l_min_line and l_max_line;

Line 1529: from qp_discount_mapping

1525: from so_agreements_b;
1526:
1527: cursor prc_list_mapping is
1528: select old_discount_id, new_list_header_id
1529: from qp_discount_mapping
1530: where new_type = 'P'
1531: and old_discount_line_id is null;
1532:
1533: vivek */

Line 2921: /* insert into qp_discount_mapping table for the rows that were

2917: -- NULL, 'MAIN-7', v_errortext, 'PRICE_LISTS');
2918:
2919:
2920:
2921: /* insert into qp_discount_mapping table for the rows that were
2922: just now inserted */
2923:
2924: -- qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2925: -- NULL, 'MAIN-8', v_errortext, 'PRICE_LISTS');

Line 2930: INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,

2926:
2927: /*
2928:
2929: FORALL l_prc_list_map_index IN new_prc_list_maps.FIRST..new_prc_list_maps.LAST
2930: INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,
2931: OLD_DISCOUNT_LINE_ID,
2932: NEW_LIST_HEADER_ID,
2933: NEW_LIST_LINE_ID,
2934: OLD_PRICE_BREAK_LINES_LOW,