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.QP_COPY_MODIFIERS_PVT dependencies on QP_RLTD_MODIFIERS

Line 23: FROM qp_rltd_modifiers

19:
20: CURSOR price_break_line_cur(a_list_line_id NUMBER)
21: IS
22: SELECT to_rltd_modifier_id
23: FROM qp_rltd_modifiers
24: WHERE to_rltd_modifier_id = a_list_line_id;
25:
26: BEGIN
27:

Line 227: DELETE FROM qp_rltd_modifiers

223: l_rows,
224: l_effdates);
225:
226: IF l_status= FALSE THEN
227: DELETE FROM qp_rltd_modifiers
228: WHERE from_RLTD_MODIFIER_ID=l_del_dup_cur_rec.list_line_id;
229:
230: DELETE qp_pricing_Attributes
231: where list_line_id=l_del_dup_cur_rec.list_line_id;

Line 387: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)

383: SELECT *
384: FROM qp_pricing_attributes
385: WHERE list_line_id = p_from_discount_line_id;
386:
387: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
388: IS
389: SELECT *
390: FROM qp_rltd_modifiers
391: WHERE from_rltd_modifier_id = a_list_line_id;

Line 390: FROM qp_rltd_modifiers

386:
387: CURSOR qp_rltd_modifiers_cur(a_list_line_id NUMBER)
388: IS
389: SELECT *
390: FROM qp_rltd_modifiers
391: WHERE from_rltd_modifier_id = a_list_line_id;
392:
393:
394: BEGIN

Line 912: from qp_rltd_modifiers

908:
909: insert_flag :='N';
910: BEGIN
911: select from_rltd_modifier_id into l_line_id
912: from qp_rltd_modifiers
913: where to_rltd_modifier_id=l_qp_discount_lines_rec.list_line_id;
914: Exception
915: when no_data_found then
916: l_line_id:=null;

Line 1494: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen

1490: END LOOP; /* For copying pricing attributes for each discount line */
1491: END IF;
1492: END LOOP; /* For copying discount lines*/
1493:
1494: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen
1495: above which are stored in the mapping table */
1496:
1497: IF l_mapping_tbl.COUNT > 0 THEN
1498: FOR l_count IN 1..l_mapping_tbl.COUNT

Line 1504: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(

1500:
1501: --IF l_mapping_tbl(l_count).list_line_type_code = 'PBH' THEN
1502: IF l_mapping_tbl(l_count).list_line_type_code in ('PBH','OID','PRG','CIE') THEN
1503:
1504: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
1505: l_mapping_tbl(l_count).old_list_line_id)
1506: LOOP
1507:
1508: SELECT qp_rltd_modifiers_s.nextval

Line 1508: SELECT qp_rltd_modifiers_s.nextval

1504: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(
1505: l_mapping_tbl(l_count).old_list_line_id)
1506: LOOP
1507:
1508: SELECT qp_rltd_modifiers_s.nextval
1509: INTO l_new_rltd_modifier_id
1510: FROM dual;
1511:
1512: l_new_from_id := Get_New_Id(

Line 1513: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

1509: INTO l_new_rltd_modifier_id
1510: FROM dual;
1511:
1512: l_new_from_id := Get_New_Id(
1513: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1514: l_mapping_tbl);
1515: l_new_to_id := Get_New_Id(
1516: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1517: l_mapping_tbl);

Line 1516: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

1512: l_new_from_id := Get_New_Id(
1513: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,
1514: l_mapping_tbl);
1515: l_new_to_id := Get_New_Id(
1516: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1517: l_mapping_tbl);
1518: INSERT INTO qp_rltd_modifiers
1519: (creation_date,
1520: created_by,

Line 1518: INSERT INTO qp_rltd_modifiers

1514: l_mapping_tbl);
1515: l_new_to_id := Get_New_Id(
1516: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,
1517: l_mapping_tbl);
1518: INSERT INTO qp_rltd_modifiers
1519: (creation_date,
1520: created_by,
1521: last_update_date,
1522: last_updated_by,

Line 1552: l_qp_rltd_modifiers_rec.context,

1548: l_user_id,
1549: sysdate,
1550: l_user_id,
1551: l_conc_login_id,
1552: l_qp_rltd_modifiers_rec.context,
1553: l_qp_rltd_modifiers_rec.attribute1,
1554: l_qp_rltd_modifiers_rec.attribute2,
1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,

Line 1553: l_qp_rltd_modifiers_rec.attribute1,

1549: sysdate,
1550: l_user_id,
1551: l_conc_login_id,
1552: l_qp_rltd_modifiers_rec.context,
1553: l_qp_rltd_modifiers_rec.attribute1,
1554: l_qp_rltd_modifiers_rec.attribute2,
1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,

Line 1554: l_qp_rltd_modifiers_rec.attribute2,

1550: l_user_id,
1551: l_conc_login_id,
1552: l_qp_rltd_modifiers_rec.context,
1553: l_qp_rltd_modifiers_rec.attribute1,
1554: l_qp_rltd_modifiers_rec.attribute2,
1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,

Line 1555: l_qp_rltd_modifiers_rec.attribute3,

1551: l_conc_login_id,
1552: l_qp_rltd_modifiers_rec.context,
1553: l_qp_rltd_modifiers_rec.attribute1,
1554: l_qp_rltd_modifiers_rec.attribute2,
1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,

Line 1556: l_qp_rltd_modifiers_rec.attribute4,

1552: l_qp_rltd_modifiers_rec.context,
1553: l_qp_rltd_modifiers_rec.attribute1,
1554: l_qp_rltd_modifiers_rec.attribute2,
1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,

Line 1557: l_qp_rltd_modifiers_rec.attribute5,

1553: l_qp_rltd_modifiers_rec.attribute1,
1554: l_qp_rltd_modifiers_rec.attribute2,
1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,

Line 1558: l_qp_rltd_modifiers_rec.attribute6,

1554: l_qp_rltd_modifiers_rec.attribute2,
1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,

Line 1559: l_qp_rltd_modifiers_rec.attribute7,

1555: l_qp_rltd_modifiers_rec.attribute3,
1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,

Line 1560: l_qp_rltd_modifiers_rec.attribute8,

1556: l_qp_rltd_modifiers_rec.attribute4,
1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,

Line 1561: l_qp_rltd_modifiers_rec.attribute9,

1557: l_qp_rltd_modifiers_rec.attribute5,
1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,
1565: l_qp_rltd_modifiers_rec.attribute13,

Line 1562: l_qp_rltd_modifiers_rec.attribute10,

1558: l_qp_rltd_modifiers_rec.attribute6,
1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,
1565: l_qp_rltd_modifiers_rec.attribute13,
1566: l_qp_rltd_modifiers_rec.attribute14,

Line 1563: l_qp_rltd_modifiers_rec.attribute11,

1559: l_qp_rltd_modifiers_rec.attribute7,
1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,
1565: l_qp_rltd_modifiers_rec.attribute13,
1566: l_qp_rltd_modifiers_rec.attribute14,
1567: l_qp_rltd_modifiers_rec.attribute15,

Line 1564: l_qp_rltd_modifiers_rec.attribute12,

1560: l_qp_rltd_modifiers_rec.attribute8,
1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,
1565: l_qp_rltd_modifiers_rec.attribute13,
1566: l_qp_rltd_modifiers_rec.attribute14,
1567: l_qp_rltd_modifiers_rec.attribute15,
1568: l_new_rltd_modifier_id,

Line 1565: l_qp_rltd_modifiers_rec.attribute13,

1561: l_qp_rltd_modifiers_rec.attribute9,
1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,
1565: l_qp_rltd_modifiers_rec.attribute13,
1566: l_qp_rltd_modifiers_rec.attribute14,
1567: l_qp_rltd_modifiers_rec.attribute15,
1568: l_new_rltd_modifier_id,
1569: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

Line 1566: l_qp_rltd_modifiers_rec.attribute14,

1562: l_qp_rltd_modifiers_rec.attribute10,
1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,
1565: l_qp_rltd_modifiers_rec.attribute13,
1566: l_qp_rltd_modifiers_rec.attribute14,
1567: l_qp_rltd_modifiers_rec.attribute15,
1568: l_new_rltd_modifier_id,
1569: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1570: l_new_from_id,

Line 1567: l_qp_rltd_modifiers_rec.attribute15,

1563: l_qp_rltd_modifiers_rec.attribute11,
1564: l_qp_rltd_modifiers_rec.attribute12,
1565: l_qp_rltd_modifiers_rec.attribute13,
1566: l_qp_rltd_modifiers_rec.attribute14,
1567: l_qp_rltd_modifiers_rec.attribute15,
1568: l_new_rltd_modifier_id,
1569: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1570: l_new_from_id,
1571: l_new_to_id,

Line 1569: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

1565: l_qp_rltd_modifiers_rec.attribute13,
1566: l_qp_rltd_modifiers_rec.attribute14,
1567: l_qp_rltd_modifiers_rec.attribute15,
1568: l_new_rltd_modifier_id,
1569: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1570: l_new_from_id,
1571: l_new_to_id,
1572: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
1573: );

Line 1572: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type

1568: l_new_rltd_modifier_id,
1569: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,
1570: l_new_from_id,
1571: l_new_to_id,
1572: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type
1573: );
1574:
1575: END LOOP; -- Loop through rltd modifiers records
1576: END IF; --For lines that are Parent Price Break lines