APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_QUALIFIERS

Line 821: FROM qp_qualifiers

817:
818: CURSOR qp_headers_qualifiers_cur(p_from_discount_header_id NUMBER)
819: IS
820: SELECT *
821: FROM qp_qualifiers
822: WHERE list_header_id = p_from_discount_header_id and
823: list_line_id = -1;
824:
825: CURSOR qp_line_qualifiers_cur(p_from_discount_header_id NUMBER,

Line 829: FROM qp_qualifiers

825: CURSOR qp_line_qualifiers_cur(p_from_discount_header_id NUMBER,
826: p_from_discount_line_id NUMBER)
827: IS
828: SELECT *
829: FROM qp_qualifiers
830: WHERE list_header_id = p_from_discount_header_id and
831: list_line_id = p_from_discount_line_id ;
832:
833:

Line 834: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part

830: WHERE list_header_id = p_from_discount_header_id and
831: list_line_id = p_from_discount_line_id ;
832:
833:
834: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
835: selects secondary price list */
836:
837: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
838: p_attribute VARCHAR2)

Line 837: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,

833:
834: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
835: selects secondary price list */
836:
837: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
838: p_attribute VARCHAR2)
839: IS
840: SELECT *
841: FROM qp_qualifiers q

Line 841: FROM qp_qualifiers q

837: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
838: p_attribute VARCHAR2)
839: IS
840: SELECT *
841: FROM qp_qualifiers q
842: WHERE (q.list_header_id = p_from_list_header_id AND
843: q.qualifier_attribute <> p_attribute AND
844: Exists (Select Null
845: From qp_list_headers_b a

Line 1442: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)

1438: ELSE
1439: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID', l_context, l_attribute);
1440: END IF;
1441:
1442: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)
1443: LOOP
1444: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1445: BEGIN
1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

Line 1444: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN

1440: END IF;
1441:
1442: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)
1443: LOOP
1444: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1445: BEGIN
1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1447: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1448: EXCEPTION

Line 1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

1442: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)
1443: LOOP
1444: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1445: BEGIN
1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1447: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1448: EXCEPTION
1449: WHEN VALUE_ERROR THEN
1450: NULL;

Line 1447: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

1443: LOOP
1444: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1445: BEGIN
1446: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1447: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1448: EXCEPTION
1449: WHEN VALUE_ERROR THEN
1450: NULL;
1451: WHEN OTHERS THEN

Line 1514: l_qp_qualifiers_rec.qualifier_id,

1510: ARCH_PURG_REQUEST_ID
1511: )
1512: VALUES
1513: (
1514: l_qp_qualifiers_rec.qualifier_id,
1515: l_qp_qualifiers_rec.creation_date,
1516: l_qp_qualifiers_rec.created_by,
1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,

Line 1515: l_qp_qualifiers_rec.creation_date,

1511: )
1512: VALUES
1513: (
1514: l_qp_qualifiers_rec.qualifier_id,
1515: l_qp_qualifiers_rec.creation_date,
1516: l_qp_qualifiers_rec.created_by,
1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,

Line 1516: l_qp_qualifiers_rec.created_by,

1512: VALUES
1513: (
1514: l_qp_qualifiers_rec.qualifier_id,
1515: l_qp_qualifiers_rec.creation_date,
1516: l_qp_qualifiers_rec.created_by,
1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,

Line 1517: l_qp_qualifiers_rec.last_update_date,

1513: (
1514: l_qp_qualifiers_rec.qualifier_id,
1515: l_qp_qualifiers_rec.creation_date,
1516: l_qp_qualifiers_rec.created_by,
1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,

Line 1518: l_qp_qualifiers_rec.last_updated_by,

1514: l_qp_qualifiers_rec.qualifier_id,
1515: l_qp_qualifiers_rec.creation_date,
1516: l_qp_qualifiers_rec.created_by,
1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,

Line 1519: l_qp_qualifiers_rec.last_update_login,

1515: l_qp_qualifiers_rec.creation_date,
1516: l_qp_qualifiers_rec.created_by,
1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,

Line 1520: l_qp_qualifiers_rec.program_application_id,

1516: l_qp_qualifiers_rec.created_by,
1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,

Line 1521: l_qp_qualifiers_rec.program_id,

1517: l_qp_qualifiers_rec.last_update_date,
1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,

Line 1522: l_qp_qualifiers_rec.program_update_date,

1518: l_qp_qualifiers_rec.last_updated_by,
1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,

Line 1523: l_qp_qualifiers_rec.request_id,

1519: l_qp_qualifiers_rec.last_update_login,
1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,

Line 1524: l_qp_qualifiers_rec.excluder_flag,

1520: l_qp_qualifiers_rec.program_application_id,
1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,

Line 1525: l_qp_qualifiers_rec.comparison_operator_code,

1521: l_qp_qualifiers_rec.program_id,
1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,

Line 1526: l_qp_qualifiers_rec.qualifier_context,

1522: l_qp_qualifiers_rec.program_update_date,
1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,

Line 1527: l_qp_qualifiers_rec.qualifier_attribute,

1523: l_qp_qualifiers_rec.request_id,
1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,

Line 1528: l_qp_qualifiers_rec.context,

1524: l_qp_qualifiers_rec.excluder_flag,
1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,

Line 1529: l_qp_qualifiers_rec.attribute1,

1525: l_qp_qualifiers_rec.comparison_operator_code,
1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,

Line 1530: l_qp_qualifiers_rec.attribute2,

1526: l_qp_qualifiers_rec.qualifier_context,
1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,

Line 1531: l_qp_qualifiers_rec.attribute3,

1527: l_qp_qualifiers_rec.qualifier_attribute,
1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,

Line 1532: l_qp_qualifiers_rec.attribute4,

1528: l_qp_qualifiers_rec.context,
1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,

Line 1533: l_qp_qualifiers_rec.attribute5,

1529: l_qp_qualifiers_rec.attribute1,
1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,

Line 1534: l_qp_qualifiers_rec.attribute6,

1530: l_qp_qualifiers_rec.attribute2,
1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,

Line 1535: l_qp_qualifiers_rec.attribute7,

1531: l_qp_qualifiers_rec.attribute3,
1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,

Line 1536: l_qp_qualifiers_rec.attribute8,

1532: l_qp_qualifiers_rec.attribute4,
1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,

Line 1537: l_qp_qualifiers_rec.attribute9,

1533: l_qp_qualifiers_rec.attribute5,
1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,

Line 1538: l_qp_qualifiers_rec.attribute10,

1534: l_qp_qualifiers_rec.attribute6,
1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,

Line 1539: l_qp_qualifiers_rec.attribute11,

1535: l_qp_qualifiers_rec.attribute7,
1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,

Line 1540: l_qp_qualifiers_rec.attribute12,

1536: l_qp_qualifiers_rec.attribute8,
1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,

Line 1541: l_qp_qualifiers_rec.attribute13,

1537: l_qp_qualifiers_rec.attribute9,
1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 1542: l_qp_qualifiers_rec.attribute14,

1538: l_qp_qualifiers_rec.attribute10,
1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,

Line 1543: l_qp_qualifiers_rec.attribute15,

1539: l_qp_qualifiers_rec.attribute11,
1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,

Line 1544: l_qp_qualifiers_rec.qualifier_rule_id,

1540: l_qp_qualifiers_rec.attribute12,
1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,

Line 1545: l_qp_qualifiers_rec.qualifier_grouping_no,

1541: l_qp_qualifiers_rec.attribute13,
1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,

Line 1546: l_qp_qualifiers_rec.qualifier_attr_value,

1542: l_qp_qualifiers_rec.attribute14,
1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,

Line 1547: l_qp_qualifiers_rec.list_header_id,

1543: l_qp_qualifiers_rec.attribute15,
1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,

Line 1548: l_qp_qualifiers_rec.list_line_id,

1544: l_qp_qualifiers_rec.qualifier_rule_id,
1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,

Line 1549: l_qp_qualifiers_rec.created_from_rule_id,

1545: l_qp_qualifiers_rec.qualifier_grouping_no,
1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,

Line 1550: l_qp_qualifiers_rec.start_date_active,

1546: l_qp_qualifiers_rec.qualifier_attr_value,
1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,
1554: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 1551: l_qp_qualifiers_rec.end_date_active,

1547: l_qp_qualifiers_rec.list_header_id,
1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,
1554: l_qp_qualifiers_rec.qualifier_attr_value_to,
1555: l_qp_qualifiers_rec.active_flag,

Line 1552: l_qp_qualifiers_rec.qualifier_precedence,

1548: l_qp_qualifiers_rec.list_line_id,
1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,
1554: l_qp_qualifiers_rec.qualifier_attr_value_to,
1555: l_qp_qualifiers_rec.active_flag,
1556: l_qp_qualifiers_rec.list_type_code,

Line 1553: l_qp_qualifiers_rec.qualifier_datatype,

1549: l_qp_qualifiers_rec.created_from_rule_id,
1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,
1554: l_qp_qualifiers_rec.qualifier_attr_value_to,
1555: l_qp_qualifiers_rec.active_flag,
1556: l_qp_qualifiers_rec.list_type_code,
1557: l_qual_attr_value_from_number,

Line 1554: l_qp_qualifiers_rec.qualifier_attr_value_to,

1550: l_qp_qualifiers_rec.start_date_active,
1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,
1554: l_qp_qualifiers_rec.qualifier_attr_value_to,
1555: l_qp_qualifiers_rec.active_flag,
1556: l_qp_qualifiers_rec.list_type_code,
1557: l_qual_attr_value_from_number,
1558: l_qual_attr_value_to_number,

Line 1555: l_qp_qualifiers_rec.active_flag,

1551: l_qp_qualifiers_rec.end_date_active,
1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,
1554: l_qp_qualifiers_rec.qualifier_attr_value_to,
1555: l_qp_qualifiers_rec.active_flag,
1556: l_qp_qualifiers_rec.list_type_code,
1557: l_qual_attr_value_from_number,
1558: l_qual_attr_value_to_number,
1559: l_qp_qualifiers_rec.search_ind,

Line 1556: l_qp_qualifiers_rec.list_type_code,

1552: l_qp_qualifiers_rec.qualifier_precedence,
1553: l_qp_qualifiers_rec.qualifier_datatype,
1554: l_qp_qualifiers_rec.qualifier_attr_value_to,
1555: l_qp_qualifiers_rec.active_flag,
1556: l_qp_qualifiers_rec.list_type_code,
1557: l_qual_attr_value_from_number,
1558: l_qual_attr_value_to_number,
1559: l_qp_qualifiers_rec.search_ind,
1560: l_qp_qualifiers_rec.distinct_row_count,

Line 1559: l_qp_qualifiers_rec.search_ind,

1555: l_qp_qualifiers_rec.active_flag,
1556: l_qp_qualifiers_rec.list_type_code,
1557: l_qual_attr_value_from_number,
1558: l_qual_attr_value_to_number,
1559: l_qp_qualifiers_rec.search_ind,
1560: l_qp_qualifiers_rec.distinct_row_count,
1561: l_qp_qualifiers_rec.qualifier_group_cnt,
1562: l_qp_qualifiers_rec.header_quals_exist_flag,
1563: l_qp_qualifiers_rec.others_group_cnt,

Line 1560: l_qp_qualifiers_rec.distinct_row_count,

1556: l_qp_qualifiers_rec.list_type_code,
1557: l_qual_attr_value_from_number,
1558: l_qual_attr_value_to_number,
1559: l_qp_qualifiers_rec.search_ind,
1560: l_qp_qualifiers_rec.distinct_row_count,
1561: l_qp_qualifiers_rec.qualifier_group_cnt,
1562: l_qp_qualifiers_rec.header_quals_exist_flag,
1563: l_qp_qualifiers_rec.others_group_cnt,
1564: l_qp_qualifiers_rec.segment_id,

Line 1561: l_qp_qualifiers_rec.qualifier_group_cnt,

1557: l_qual_attr_value_from_number,
1558: l_qual_attr_value_to_number,
1559: l_qp_qualifiers_rec.search_ind,
1560: l_qp_qualifiers_rec.distinct_row_count,
1561: l_qp_qualifiers_rec.qualifier_group_cnt,
1562: l_qp_qualifiers_rec.header_quals_exist_flag,
1563: l_qp_qualifiers_rec.others_group_cnt,
1564: l_qp_qualifiers_rec.segment_id,
1565: l_conc_request_id

Line 1562: l_qp_qualifiers_rec.header_quals_exist_flag,

1558: l_qual_attr_value_to_number,
1559: l_qp_qualifiers_rec.search_ind,
1560: l_qp_qualifiers_rec.distinct_row_count,
1561: l_qp_qualifiers_rec.qualifier_group_cnt,
1562: l_qp_qualifiers_rec.header_quals_exist_flag,
1563: l_qp_qualifiers_rec.others_group_cnt,
1564: l_qp_qualifiers_rec.segment_id,
1565: l_conc_request_id
1566: );

Line 1563: l_qp_qualifiers_rec.others_group_cnt,

1559: l_qp_qualifiers_rec.search_ind,
1560: l_qp_qualifiers_rec.distinct_row_count,
1561: l_qp_qualifiers_rec.qualifier_group_cnt,
1562: l_qp_qualifiers_rec.header_quals_exist_flag,
1563: l_qp_qualifiers_rec.others_group_cnt,
1564: l_qp_qualifiers_rec.segment_id,
1565: l_conc_request_id
1566: );
1567:

Line 1564: l_qp_qualifiers_rec.segment_id,

1560: l_qp_qualifiers_rec.distinct_row_count,
1561: l_qp_qualifiers_rec.qualifier_group_cnt,
1562: l_qp_qualifiers_rec.header_quals_exist_flag,
1563: l_qp_qualifiers_rec.others_group_cnt,
1564: l_qp_qualifiers_rec.segment_id,
1565: l_conc_request_id
1566: );
1567:
1568: g_count_qualifier := g_count_qualifier + sql%rowcount;

Line 1573: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)

1569: END LOOP;
1570:
1571: ELSE --Modifier and agreement price list
1572: --Following code archives the Modifier header qualifier information
1573: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)
1574: LOOP
1575: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1576: BEGIN
1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

Line 1575: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN

1571: ELSE --Modifier and agreement price list
1572: --Following code archives the Modifier header qualifier information
1573: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)
1574: LOOP
1575: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1576: BEGIN
1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1578: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1579: EXCEPTION

Line 1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

1573: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)
1574: LOOP
1575: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1576: BEGIN
1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1578: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1579: EXCEPTION
1580: WHEN VALUE_ERROR THEN
1581: NULL;

Line 1578: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

1574: LOOP
1575: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1576: BEGIN
1577: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1578: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1579: EXCEPTION
1580: WHEN VALUE_ERROR THEN
1581: NULL;
1582: WHEN OTHERS THEN

Line 1645: l_qp_qualifiers_rec.qualifier_id,

1641: ARCH_PURG_REQUEST_ID
1642: )
1643: VALUES
1644: (
1645: l_qp_qualifiers_rec.qualifier_id,
1646: l_qp_qualifiers_rec.creation_date,
1647: l_qp_qualifiers_rec.created_by,
1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,

Line 1646: l_qp_qualifiers_rec.creation_date,

1642: )
1643: VALUES
1644: (
1645: l_qp_qualifiers_rec.qualifier_id,
1646: l_qp_qualifiers_rec.creation_date,
1647: l_qp_qualifiers_rec.created_by,
1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,

Line 1647: l_qp_qualifiers_rec.created_by,

1643: VALUES
1644: (
1645: l_qp_qualifiers_rec.qualifier_id,
1646: l_qp_qualifiers_rec.creation_date,
1647: l_qp_qualifiers_rec.created_by,
1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,

Line 1648: l_qp_qualifiers_rec.last_update_date,

1644: (
1645: l_qp_qualifiers_rec.qualifier_id,
1646: l_qp_qualifiers_rec.creation_date,
1647: l_qp_qualifiers_rec.created_by,
1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,

Line 1649: l_qp_qualifiers_rec.last_updated_by,

1645: l_qp_qualifiers_rec.qualifier_id,
1646: l_qp_qualifiers_rec.creation_date,
1647: l_qp_qualifiers_rec.created_by,
1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,

Line 1650: l_qp_qualifiers_rec.last_update_login,

1646: l_qp_qualifiers_rec.creation_date,
1647: l_qp_qualifiers_rec.created_by,
1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,

Line 1651: l_qp_qualifiers_rec.program_application_id,

1647: l_qp_qualifiers_rec.created_by,
1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,

Line 1652: l_qp_qualifiers_rec.program_id,

1648: l_qp_qualifiers_rec.last_update_date,
1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,

Line 1653: l_qp_qualifiers_rec.program_update_date,

1649: l_qp_qualifiers_rec.last_updated_by,
1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,

Line 1654: l_qp_qualifiers_rec.request_id,

1650: l_qp_qualifiers_rec.last_update_login,
1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,

Line 1655: l_qp_qualifiers_rec.excluder_flag,

1651: l_qp_qualifiers_rec.program_application_id,
1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,

Line 1656: l_qp_qualifiers_rec.comparison_operator_code,

1652: l_qp_qualifiers_rec.program_id,
1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,

Line 1657: l_qp_qualifiers_rec.qualifier_context,

1653: l_qp_qualifiers_rec.program_update_date,
1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,

Line 1658: l_qp_qualifiers_rec.qualifier_attribute,

1654: l_qp_qualifiers_rec.request_id,
1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,

Line 1659: l_qp_qualifiers_rec.context,

1655: l_qp_qualifiers_rec.excluder_flag,
1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,

Line 1660: l_qp_qualifiers_rec.attribute1,

1656: l_qp_qualifiers_rec.comparison_operator_code,
1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,

Line 1661: l_qp_qualifiers_rec.attribute2,

1657: l_qp_qualifiers_rec.qualifier_context,
1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,

Line 1662: l_qp_qualifiers_rec.attribute3,

1658: l_qp_qualifiers_rec.qualifier_attribute,
1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,

Line 1663: l_qp_qualifiers_rec.attribute4,

1659: l_qp_qualifiers_rec.context,
1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,

Line 1664: l_qp_qualifiers_rec.attribute5,

1660: l_qp_qualifiers_rec.attribute1,
1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,

Line 1665: l_qp_qualifiers_rec.attribute6,

1661: l_qp_qualifiers_rec.attribute2,
1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,

Line 1666: l_qp_qualifiers_rec.attribute7,

1662: l_qp_qualifiers_rec.attribute3,
1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,

Line 1667: l_qp_qualifiers_rec.attribute8,

1663: l_qp_qualifiers_rec.attribute4,
1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,

Line 1668: l_qp_qualifiers_rec.attribute9,

1664: l_qp_qualifiers_rec.attribute5,
1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,

Line 1669: l_qp_qualifiers_rec.attribute10,

1665: l_qp_qualifiers_rec.attribute6,
1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,

Line 1670: l_qp_qualifiers_rec.attribute11,

1666: l_qp_qualifiers_rec.attribute7,
1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,

Line 1671: l_qp_qualifiers_rec.attribute12,

1667: l_qp_qualifiers_rec.attribute8,
1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,

Line 1672: l_qp_qualifiers_rec.attribute13,

1668: l_qp_qualifiers_rec.attribute9,
1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 1673: l_qp_qualifiers_rec.attribute14,

1669: l_qp_qualifiers_rec.attribute10,
1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,

Line 1674: l_qp_qualifiers_rec.attribute15,

1670: l_qp_qualifiers_rec.attribute11,
1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,

Line 1675: l_qp_qualifiers_rec.qualifier_rule_id,

1671: l_qp_qualifiers_rec.attribute12,
1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,

Line 1676: l_qp_qualifiers_rec.qualifier_grouping_no,

1672: l_qp_qualifiers_rec.attribute13,
1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,

Line 1677: l_qp_qualifiers_rec.qualifier_attr_value,

1673: l_qp_qualifiers_rec.attribute14,
1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,

Line 1678: l_qp_qualifiers_rec.list_header_id,

1674: l_qp_qualifiers_rec.attribute15,
1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,

Line 1679: l_qp_qualifiers_rec.list_line_id,

1675: l_qp_qualifiers_rec.qualifier_rule_id,
1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,

Line 1680: l_qp_qualifiers_rec.created_from_rule_id,

1676: l_qp_qualifiers_rec.qualifier_grouping_no,
1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,

Line 1681: l_qp_qualifiers_rec.start_date_active,

1677: l_qp_qualifiers_rec.qualifier_attr_value,
1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,
1685: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 1682: l_qp_qualifiers_rec.end_date_active,

1678: l_qp_qualifiers_rec.list_header_id,
1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,
1685: l_qp_qualifiers_rec.qualifier_attr_value_to,
1686: l_qp_qualifiers_rec.active_flag,

Line 1683: l_qp_qualifiers_rec.qualifier_precedence,

1679: l_qp_qualifiers_rec.list_line_id,
1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,
1685: l_qp_qualifiers_rec.qualifier_attr_value_to,
1686: l_qp_qualifiers_rec.active_flag,
1687: l_qp_qualifiers_rec.list_type_code,

Line 1684: l_qp_qualifiers_rec.qualifier_datatype,

1680: l_qp_qualifiers_rec.created_from_rule_id,
1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,
1685: l_qp_qualifiers_rec.qualifier_attr_value_to,
1686: l_qp_qualifiers_rec.active_flag,
1687: l_qp_qualifiers_rec.list_type_code,
1688: l_qual_attr_value_from_number,

Line 1685: l_qp_qualifiers_rec.qualifier_attr_value_to,

1681: l_qp_qualifiers_rec.start_date_active,
1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,
1685: l_qp_qualifiers_rec.qualifier_attr_value_to,
1686: l_qp_qualifiers_rec.active_flag,
1687: l_qp_qualifiers_rec.list_type_code,
1688: l_qual_attr_value_from_number,
1689: l_qual_attr_value_to_number,

Line 1686: l_qp_qualifiers_rec.active_flag,

1682: l_qp_qualifiers_rec.end_date_active,
1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,
1685: l_qp_qualifiers_rec.qualifier_attr_value_to,
1686: l_qp_qualifiers_rec.active_flag,
1687: l_qp_qualifiers_rec.list_type_code,
1688: l_qual_attr_value_from_number,
1689: l_qual_attr_value_to_number,
1690: l_qp_qualifiers_rec.search_ind,

Line 1687: l_qp_qualifiers_rec.list_type_code,

1683: l_qp_qualifiers_rec.qualifier_precedence,
1684: l_qp_qualifiers_rec.qualifier_datatype,
1685: l_qp_qualifiers_rec.qualifier_attr_value_to,
1686: l_qp_qualifiers_rec.active_flag,
1687: l_qp_qualifiers_rec.list_type_code,
1688: l_qual_attr_value_from_number,
1689: l_qual_attr_value_to_number,
1690: l_qp_qualifiers_rec.search_ind,
1691: l_qp_qualifiers_rec.distinct_row_count,

Line 1690: l_qp_qualifiers_rec.search_ind,

1686: l_qp_qualifiers_rec.active_flag,
1687: l_qp_qualifiers_rec.list_type_code,
1688: l_qual_attr_value_from_number,
1689: l_qual_attr_value_to_number,
1690: l_qp_qualifiers_rec.search_ind,
1691: l_qp_qualifiers_rec.distinct_row_count,
1692: l_qp_qualifiers_rec.qualifier_group_cnt,
1693: l_qp_qualifiers_rec.header_quals_exist_flag,
1694: l_qp_qualifiers_rec.others_group_cnt,

Line 1691: l_qp_qualifiers_rec.distinct_row_count,

1687: l_qp_qualifiers_rec.list_type_code,
1688: l_qual_attr_value_from_number,
1689: l_qual_attr_value_to_number,
1690: l_qp_qualifiers_rec.search_ind,
1691: l_qp_qualifiers_rec.distinct_row_count,
1692: l_qp_qualifiers_rec.qualifier_group_cnt,
1693: l_qp_qualifiers_rec.header_quals_exist_flag,
1694: l_qp_qualifiers_rec.others_group_cnt,
1695: l_qp_qualifiers_rec.segment_id,

Line 1692: l_qp_qualifiers_rec.qualifier_group_cnt,

1688: l_qual_attr_value_from_number,
1689: l_qual_attr_value_to_number,
1690: l_qp_qualifiers_rec.search_ind,
1691: l_qp_qualifiers_rec.distinct_row_count,
1692: l_qp_qualifiers_rec.qualifier_group_cnt,
1693: l_qp_qualifiers_rec.header_quals_exist_flag,
1694: l_qp_qualifiers_rec.others_group_cnt,
1695: l_qp_qualifiers_rec.segment_id,
1696: l_conc_request_id

Line 1693: l_qp_qualifiers_rec.header_quals_exist_flag,

1689: l_qual_attr_value_to_number,
1690: l_qp_qualifiers_rec.search_ind,
1691: l_qp_qualifiers_rec.distinct_row_count,
1692: l_qp_qualifiers_rec.qualifier_group_cnt,
1693: l_qp_qualifiers_rec.header_quals_exist_flag,
1694: l_qp_qualifiers_rec.others_group_cnt,
1695: l_qp_qualifiers_rec.segment_id,
1696: l_conc_request_id
1697: );

Line 1694: l_qp_qualifiers_rec.others_group_cnt,

1690: l_qp_qualifiers_rec.search_ind,
1691: l_qp_qualifiers_rec.distinct_row_count,
1692: l_qp_qualifiers_rec.qualifier_group_cnt,
1693: l_qp_qualifiers_rec.header_quals_exist_flag,
1694: l_qp_qualifiers_rec.others_group_cnt,
1695: l_qp_qualifiers_rec.segment_id,
1696: l_conc_request_id
1697: );
1698:

Line 1695: l_qp_qualifiers_rec.segment_id,

1691: l_qp_qualifiers_rec.distinct_row_count,
1692: l_qp_qualifiers_rec.qualifier_group_cnt,
1693: l_qp_qualifiers_rec.header_quals_exist_flag,
1694: l_qp_qualifiers_rec.others_group_cnt,
1695: l_qp_qualifiers_rec.segment_id,
1696: l_conc_request_id
1697: );
1698:
1699: g_count_qualifier := g_count_qualifier + sql%rowcount;

Line 1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)

1971: IF l_list_type_code NOT IN ('PRL','AGR') THEN
1972: IF l_qp_list_lines_rec.list_line_id is not null AND
1973: l_qp_list_lines_rec.list_line_id <> -1 THEN
1974:
1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
1978: BEGIN
1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

Line 1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then

1973: l_qp_list_lines_rec.list_line_id <> -1 THEN
1974:
1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
1978: BEGIN
1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1980: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1981: EXCEPTION

Line 1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

1975: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
1978: BEGIN
1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1980: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1981: EXCEPTION
1982: WHEN VALUE_ERROR THEN
1983: NULL;

Line 1980: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);

1976: LOOP
1977: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
1978: BEGIN
1979: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1980: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1981: EXCEPTION
1982: WHEN VALUE_ERROR THEN
1983: NULL;
1984: WHEN OTHERS THEN

Line 1989: --Insert into qp_qualifiers

1985: NULL;
1986: END;
1987: END IF;
1988:
1989: --Insert into qp_qualifiers
1990: INSERT INTO QP_ARCH_QUALIFIERS
1991: (
1992: qualifier_id,
1993: creation_date,

Line 2047: l_qp_qualifiers_rec.qualifier_id,

2043: ARCH_PURG_REQUEST_ID
2044: )
2045: VALUES
2046: (
2047: l_qp_qualifiers_rec.qualifier_id,
2048: l_qp_qualifiers_rec.creation_date,
2049: l_qp_qualifiers_rec.created_by,
2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,

Line 2048: l_qp_qualifiers_rec.creation_date,

2044: )
2045: VALUES
2046: (
2047: l_qp_qualifiers_rec.qualifier_id,
2048: l_qp_qualifiers_rec.creation_date,
2049: l_qp_qualifiers_rec.created_by,
2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,

Line 2049: l_qp_qualifiers_rec.created_by,

2045: VALUES
2046: (
2047: l_qp_qualifiers_rec.qualifier_id,
2048: l_qp_qualifiers_rec.creation_date,
2049: l_qp_qualifiers_rec.created_by,
2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,

Line 2050: l_qp_qualifiers_rec.last_update_date,

2046: (
2047: l_qp_qualifiers_rec.qualifier_id,
2048: l_qp_qualifiers_rec.creation_date,
2049: l_qp_qualifiers_rec.created_by,
2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,

Line 2051: l_qp_qualifiers_rec.last_updated_by,

2047: l_qp_qualifiers_rec.qualifier_id,
2048: l_qp_qualifiers_rec.creation_date,
2049: l_qp_qualifiers_rec.created_by,
2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,

Line 2052: l_qp_qualifiers_rec.last_update_login,

2048: l_qp_qualifiers_rec.creation_date,
2049: l_qp_qualifiers_rec.created_by,
2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,

Line 2053: l_qp_qualifiers_rec.program_application_id,

2049: l_qp_qualifiers_rec.created_by,
2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,

Line 2054: l_qp_qualifiers_rec.program_id,

2050: l_qp_qualifiers_rec.last_update_date,
2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,

Line 2055: l_qp_qualifiers_rec.program_update_date,

2051: l_qp_qualifiers_rec.last_updated_by,
2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,

Line 2056: l_qp_qualifiers_rec.request_id,

2052: l_qp_qualifiers_rec.last_update_login,
2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,

Line 2057: l_qp_qualifiers_rec.excluder_flag,

2053: l_qp_qualifiers_rec.program_application_id,
2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,

Line 2058: l_qp_qualifiers_rec.comparison_operator_code,

2054: l_qp_qualifiers_rec.program_id,
2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,

Line 2059: l_qp_qualifiers_rec.qualifier_context,

2055: l_qp_qualifiers_rec.program_update_date,
2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,

Line 2060: l_qp_qualifiers_rec.qualifier_attribute,

2056: l_qp_qualifiers_rec.request_id,
2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,

Line 2061: l_qp_qualifiers_rec.context,

2057: l_qp_qualifiers_rec.excluder_flag,
2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,

Line 2062: l_qp_qualifiers_rec.attribute1,

2058: l_qp_qualifiers_rec.comparison_operator_code,
2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,

Line 2063: l_qp_qualifiers_rec.attribute2,

2059: l_qp_qualifiers_rec.qualifier_context,
2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,

Line 2064: l_qp_qualifiers_rec.attribute3,

2060: l_qp_qualifiers_rec.qualifier_attribute,
2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,

Line 2065: l_qp_qualifiers_rec.attribute4,

2061: l_qp_qualifiers_rec.context,
2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,

Line 2066: l_qp_qualifiers_rec.attribute5,

2062: l_qp_qualifiers_rec.attribute1,
2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,

Line 2067: l_qp_qualifiers_rec.attribute6,

2063: l_qp_qualifiers_rec.attribute2,
2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,

Line 2068: l_qp_qualifiers_rec.attribute7,

2064: l_qp_qualifiers_rec.attribute3,
2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,

Line 2069: l_qp_qualifiers_rec.attribute8,

2065: l_qp_qualifiers_rec.attribute4,
2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,

Line 2070: l_qp_qualifiers_rec.attribute9,

2066: l_qp_qualifiers_rec.attribute5,
2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,

Line 2071: l_qp_qualifiers_rec.attribute10,

2067: l_qp_qualifiers_rec.attribute6,
2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,

Line 2072: l_qp_qualifiers_rec.attribute11,

2068: l_qp_qualifiers_rec.attribute7,
2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,

Line 2073: l_qp_qualifiers_rec.attribute12,

2069: l_qp_qualifiers_rec.attribute8,
2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,

Line 2074: l_qp_qualifiers_rec.attribute13,

2070: l_qp_qualifiers_rec.attribute9,
2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 2075: l_qp_qualifiers_rec.attribute14,

2071: l_qp_qualifiers_rec.attribute10,
2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,

Line 2076: l_qp_qualifiers_rec.attribute15,

2072: l_qp_qualifiers_rec.attribute11,
2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,

Line 2077: l_qp_qualifiers_rec.qualifier_rule_id,

2073: l_qp_qualifiers_rec.attribute12,
2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,

Line 2078: l_qp_qualifiers_rec.qualifier_grouping_no,

2074: l_qp_qualifiers_rec.attribute13,
2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,

Line 2079: l_qp_qualifiers_rec.qualifier_attr_value,

2075: l_qp_qualifiers_rec.attribute14,
2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,

Line 2080: l_qp_qualifiers_rec.list_header_id,

2076: l_qp_qualifiers_rec.attribute15,
2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,

Line 2081: l_qp_qualifiers_rec.list_line_id,

2077: l_qp_qualifiers_rec.qualifier_rule_id,
2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,

Line 2082: l_qp_qualifiers_rec.created_from_rule_id,

2078: l_qp_qualifiers_rec.qualifier_grouping_no,
2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,

Line 2083: l_qp_qualifiers_rec.start_date_active,

2079: l_qp_qualifiers_rec.qualifier_attr_value,
2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,
2087: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 2084: l_qp_qualifiers_rec.end_date_active,

2080: l_qp_qualifiers_rec.list_header_id,
2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,
2087: l_qp_qualifiers_rec.qualifier_attr_value_to,
2088: l_qp_qualifiers_rec.active_flag,

Line 2085: l_qp_qualifiers_rec.qualifier_precedence,

2081: l_qp_qualifiers_rec.list_line_id,
2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,
2087: l_qp_qualifiers_rec.qualifier_attr_value_to,
2088: l_qp_qualifiers_rec.active_flag,
2089: l_qp_qualifiers_rec.list_type_code,

Line 2086: l_qp_qualifiers_rec.qualifier_datatype,

2082: l_qp_qualifiers_rec.created_from_rule_id,
2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,
2087: l_qp_qualifiers_rec.qualifier_attr_value_to,
2088: l_qp_qualifiers_rec.active_flag,
2089: l_qp_qualifiers_rec.list_type_code,
2090: l_qual_attr_value_from_number,

Line 2087: l_qp_qualifiers_rec.qualifier_attr_value_to,

2083: l_qp_qualifiers_rec.start_date_active,
2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,
2087: l_qp_qualifiers_rec.qualifier_attr_value_to,
2088: l_qp_qualifiers_rec.active_flag,
2089: l_qp_qualifiers_rec.list_type_code,
2090: l_qual_attr_value_from_number,
2091: l_qual_attr_value_to_number,

Line 2088: l_qp_qualifiers_rec.active_flag,

2084: l_qp_qualifiers_rec.end_date_active,
2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,
2087: l_qp_qualifiers_rec.qualifier_attr_value_to,
2088: l_qp_qualifiers_rec.active_flag,
2089: l_qp_qualifiers_rec.list_type_code,
2090: l_qual_attr_value_from_number,
2091: l_qual_attr_value_to_number,
2092: l_qp_qualifiers_rec.search_ind,

Line 2089: l_qp_qualifiers_rec.list_type_code,

2085: l_qp_qualifiers_rec.qualifier_precedence,
2086: l_qp_qualifiers_rec.qualifier_datatype,
2087: l_qp_qualifiers_rec.qualifier_attr_value_to,
2088: l_qp_qualifiers_rec.active_flag,
2089: l_qp_qualifiers_rec.list_type_code,
2090: l_qual_attr_value_from_number,
2091: l_qual_attr_value_to_number,
2092: l_qp_qualifiers_rec.search_ind,
2093: l_qp_qualifiers_rec.distinct_row_count,

Line 2092: l_qp_qualifiers_rec.search_ind,

2088: l_qp_qualifiers_rec.active_flag,
2089: l_qp_qualifiers_rec.list_type_code,
2090: l_qual_attr_value_from_number,
2091: l_qual_attr_value_to_number,
2092: l_qp_qualifiers_rec.search_ind,
2093: l_qp_qualifiers_rec.distinct_row_count,
2094: l_qp_qualifiers_rec.qualifier_group_cnt,
2095: l_qp_qualifiers_rec.header_quals_exist_flag,
2096: l_qp_qualifiers_rec.others_group_cnt,

Line 2093: l_qp_qualifiers_rec.distinct_row_count,

2089: l_qp_qualifiers_rec.list_type_code,
2090: l_qual_attr_value_from_number,
2091: l_qual_attr_value_to_number,
2092: l_qp_qualifiers_rec.search_ind,
2093: l_qp_qualifiers_rec.distinct_row_count,
2094: l_qp_qualifiers_rec.qualifier_group_cnt,
2095: l_qp_qualifiers_rec.header_quals_exist_flag,
2096: l_qp_qualifiers_rec.others_group_cnt,
2097: l_qp_qualifiers_rec.segment_id,

Line 2094: l_qp_qualifiers_rec.qualifier_group_cnt,

2090: l_qual_attr_value_from_number,
2091: l_qual_attr_value_to_number,
2092: l_qp_qualifiers_rec.search_ind,
2093: l_qp_qualifiers_rec.distinct_row_count,
2094: l_qp_qualifiers_rec.qualifier_group_cnt,
2095: l_qp_qualifiers_rec.header_quals_exist_flag,
2096: l_qp_qualifiers_rec.others_group_cnt,
2097: l_qp_qualifiers_rec.segment_id,
2098: l_conc_request_id

Line 2095: l_qp_qualifiers_rec.header_quals_exist_flag,

2091: l_qual_attr_value_to_number,
2092: l_qp_qualifiers_rec.search_ind,
2093: l_qp_qualifiers_rec.distinct_row_count,
2094: l_qp_qualifiers_rec.qualifier_group_cnt,
2095: l_qp_qualifiers_rec.header_quals_exist_flag,
2096: l_qp_qualifiers_rec.others_group_cnt,
2097: l_qp_qualifiers_rec.segment_id,
2098: l_conc_request_id
2099: );

Line 2096: l_qp_qualifiers_rec.others_group_cnt,

2092: l_qp_qualifiers_rec.search_ind,
2093: l_qp_qualifiers_rec.distinct_row_count,
2094: l_qp_qualifiers_rec.qualifier_group_cnt,
2095: l_qp_qualifiers_rec.header_quals_exist_flag,
2096: l_qp_qualifiers_rec.others_group_cnt,
2097: l_qp_qualifiers_rec.segment_id,
2098: l_conc_request_id
2099: );
2100:

Line 2097: l_qp_qualifiers_rec.segment_id,

2093: l_qp_qualifiers_rec.distinct_row_count,
2094: l_qp_qualifiers_rec.qualifier_group_cnt,
2095: l_qp_qualifiers_rec.header_quals_exist_flag,
2096: l_qp_qualifiers_rec.others_group_cnt,
2097: l_qp_qualifiers_rec.segment_id,
2098: l_conc_request_id
2099: );
2100:
2101: g_count_qualifier := g_count_qualifier + sql%rowcount;

Line 2103: DELETE FROM qp_qualifiers

2099: );
2100:
2101: g_count_qualifier := g_count_qualifier + sql%rowcount;
2102:
2103: DELETE FROM qp_qualifiers
2104: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2105: and list_header_id = l_qp_qualifiers_rec.list_header_id
2106: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2107: END LOOP;

Line 2104: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id

2100:
2101: g_count_qualifier := g_count_qualifier + sql%rowcount;
2102:
2103: DELETE FROM qp_qualifiers
2104: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2105: and list_header_id = l_qp_qualifiers_rec.list_header_id
2106: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2107: END LOOP;
2108:

Line 2105: and list_header_id = l_qp_qualifiers_rec.list_header_id

2101: g_count_qualifier := g_count_qualifier + sql%rowcount;
2102:
2103: DELETE FROM qp_qualifiers
2104: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2105: and list_header_id = l_qp_qualifiers_rec.list_header_id
2106: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2107: END LOOP;
2108:
2109: END IF;

Line 2106: and list_line_id = l_qp_qualifiers_rec.list_line_id;

2102:
2103: DELETE FROM qp_qualifiers
2104: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2105: and list_header_id = l_qp_qualifiers_rec.list_header_id
2106: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2107: END LOOP;
2108:
2109: END IF;
2110: END IF; -- List type code end

Line 2361: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/

2357: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2358:
2359: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2360: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');
2361: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2362: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS( ERR_BUFF => errbuf,
2363: RETCODE => retcode,
2364: P_LIST_HEADER_ID => p_entity);
2365: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);

Line 2368: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');

2364: P_LIST_HEADER_ID => p_entity);
2365: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);
2366:
2367: IF retcode = 2 THEN
2368: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2369: ELSE
2370: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2371: END IF;
2372: END IF;

Line 2370: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');

2366:
2367: IF retcode = 2 THEN
2368: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2369: ELSE
2370: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2371: END IF;
2372: END IF;
2373:
2374: COMMIT;