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 1495: /* Copy qp_rltd_modifiers for the Price Break Parent list_lines chosen

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

Line 1505: FOR l_qp_rltd_modifiers_rec IN qp_rltd_modifiers_cur(

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

Line 1509: SELECT qp_rltd_modifiers_s.nextval

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

Line 1514: l_qp_rltd_modifiers_rec.from_rltd_modifier_id,

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

Line 1517: l_qp_rltd_modifiers_rec.to_rltd_modifier_id,

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

Line 1519: INSERT INTO qp_rltd_modifiers

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

Line 1553: l_qp_rltd_modifiers_rec.context,

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

Line 1554: l_qp_rltd_modifiers_rec.attribute1,

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

Line 1555: l_qp_rltd_modifiers_rec.attribute2,

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

Line 1556: l_qp_rltd_modifiers_rec.attribute3,

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

Line 1557: l_qp_rltd_modifiers_rec.attribute4,

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

Line 1558: l_qp_rltd_modifiers_rec.attribute5,

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

Line 1559: l_qp_rltd_modifiers_rec.attribute6,

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

Line 1560: l_qp_rltd_modifiers_rec.attribute7,

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

Line 1561: l_qp_rltd_modifiers_rec.attribute8,

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

Line 1562: l_qp_rltd_modifiers_rec.attribute9,

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

Line 1563: l_qp_rltd_modifiers_rec.attribute10,

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

Line 1564: l_qp_rltd_modifiers_rec.attribute11,

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

Line 1565: l_qp_rltd_modifiers_rec.attribute12,

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

Line 1566: l_qp_rltd_modifiers_rec.attribute13,

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

Line 1567: l_qp_rltd_modifiers_rec.attribute14,

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

Line 1568: l_qp_rltd_modifiers_rec.attribute15,

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

Line 1570: l_qp_rltd_modifiers_rec.rltd_modifier_grp_no,

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

Line 1573: l_qp_rltd_modifiers_rec.rltd_modifier_grp_type

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