APPS.QP_ARCHIVE_ENTITY_PVT dependencies on QP_QUALIFIERS

Line 842: FROM qp_qualifiers

838:
839: CURSOR qp_headers_qualifiers_cur(p_from_discount_header_id NUMBER)
840: IS
841: SELECT *
842: FROM qp_qualifiers
843: WHERE list_header_id = p_from_discount_header_id and
844: list_line_id = -1;
845:
846: CURSOR qp_line_qualifiers_cur(p_from_discount_header_id NUMBER,

Line 850: FROM qp_qualifiers

846: CURSOR qp_line_qualifiers_cur(p_from_discount_header_id NUMBER,
847: p_from_discount_line_id NUMBER)
848: IS
849: SELECT *
850: FROM qp_qualifiers
851: WHERE list_header_id = p_from_discount_header_id and
852: list_line_id = p_from_discount_line_id ;
853:
854:

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

851: WHERE list_header_id = p_from_discount_header_id and
852: list_line_id = p_from_discount_line_id ;
853:
854:
855: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
856: selects secondary price list */
857:
858: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
859: p_attribute VARCHAR2)

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

854:
855: /* First part of cursor qp_qualifiers_cur selects qualifiers while the second part
856: selects secondary price list */
857:
858: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
859: p_attribute VARCHAR2)
860: IS
861: SELECT *
862: FROM qp_qualifiers q

Line 862: FROM qp_qualifiers q

858: CURSOR qp_qualifiers_cur(p_from_list_header_id NUMBER, p_context VARCHAR2,
859: p_attribute VARCHAR2)
860: IS
861: SELECT *
862: FROM qp_qualifiers q
863: WHERE (q.list_header_id = p_from_list_header_id AND
864: q.qualifier_attribute <> p_attribute AND
865: Exists (Select Null
866: From qp_list_headers_b a

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

1504: ELSE
1505: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID', l_context, l_attribute);
1506: END IF;
1507:
1508: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)
1509: LOOP
1510: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1511: BEGIN
1512: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

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

1506: END IF;
1507:
1508: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)
1509: LOOP
1510: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1511: BEGIN
1512: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1513: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1514: EXCEPTION

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

1508: FOR l_qp_qualifiers_rec IN qp_qualifiers_cur(p_entity, l_context,l_attribute)
1509: LOOP
1510: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1511: BEGIN
1512: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1513: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1514: EXCEPTION
1515: WHEN VALUE_ERROR THEN
1516: NULL;

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

1509: LOOP
1510: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1511: BEGIN
1512: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1513: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1514: EXCEPTION
1515: WHEN VALUE_ERROR THEN
1516: NULL;
1517: WHEN OTHERS THEN

Line 1580: l_qp_qualifiers_rec.qualifier_id,

1576: ARCH_PURG_REQUEST_ID
1577: )
1578: VALUES
1579: (
1580: l_qp_qualifiers_rec.qualifier_id,
1581: l_qp_qualifiers_rec.creation_date,
1582: l_qp_qualifiers_rec.created_by,
1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,

Line 1581: l_qp_qualifiers_rec.creation_date,

1577: )
1578: VALUES
1579: (
1580: l_qp_qualifiers_rec.qualifier_id,
1581: l_qp_qualifiers_rec.creation_date,
1582: l_qp_qualifiers_rec.created_by,
1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,

Line 1582: l_qp_qualifiers_rec.created_by,

1578: VALUES
1579: (
1580: l_qp_qualifiers_rec.qualifier_id,
1581: l_qp_qualifiers_rec.creation_date,
1582: l_qp_qualifiers_rec.created_by,
1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,

Line 1583: l_qp_qualifiers_rec.last_update_date,

1579: (
1580: l_qp_qualifiers_rec.qualifier_id,
1581: l_qp_qualifiers_rec.creation_date,
1582: l_qp_qualifiers_rec.created_by,
1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,

Line 1584: l_qp_qualifiers_rec.last_updated_by,

1580: l_qp_qualifiers_rec.qualifier_id,
1581: l_qp_qualifiers_rec.creation_date,
1582: l_qp_qualifiers_rec.created_by,
1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,

Line 1585: l_qp_qualifiers_rec.last_update_login,

1581: l_qp_qualifiers_rec.creation_date,
1582: l_qp_qualifiers_rec.created_by,
1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,

Line 1586: l_qp_qualifiers_rec.program_application_id,

1582: l_qp_qualifiers_rec.created_by,
1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,

Line 1587: l_qp_qualifiers_rec.program_id,

1583: l_qp_qualifiers_rec.last_update_date,
1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,

Line 1588: l_qp_qualifiers_rec.program_update_date,

1584: l_qp_qualifiers_rec.last_updated_by,
1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,

Line 1589: l_qp_qualifiers_rec.request_id,

1585: l_qp_qualifiers_rec.last_update_login,
1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,

Line 1590: l_qp_qualifiers_rec.excluder_flag,

1586: l_qp_qualifiers_rec.program_application_id,
1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,

Line 1591: l_qp_qualifiers_rec.comparison_operator_code,

1587: l_qp_qualifiers_rec.program_id,
1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,

Line 1592: l_qp_qualifiers_rec.qualifier_context,

1588: l_qp_qualifiers_rec.program_update_date,
1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,

Line 1593: l_qp_qualifiers_rec.qualifier_attribute,

1589: l_qp_qualifiers_rec.request_id,
1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,

Line 1594: l_qp_qualifiers_rec.context,

1590: l_qp_qualifiers_rec.excluder_flag,
1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,

Line 1595: l_qp_qualifiers_rec.attribute1,

1591: l_qp_qualifiers_rec.comparison_operator_code,
1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,

Line 1596: l_qp_qualifiers_rec.attribute2,

1592: l_qp_qualifiers_rec.qualifier_context,
1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,

Line 1597: l_qp_qualifiers_rec.attribute3,

1593: l_qp_qualifiers_rec.qualifier_attribute,
1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,

Line 1598: l_qp_qualifiers_rec.attribute4,

1594: l_qp_qualifiers_rec.context,
1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,

Line 1599: l_qp_qualifiers_rec.attribute5,

1595: l_qp_qualifiers_rec.attribute1,
1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,

Line 1600: l_qp_qualifiers_rec.attribute6,

1596: l_qp_qualifiers_rec.attribute2,
1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,

Line 1601: l_qp_qualifiers_rec.attribute7,

1597: l_qp_qualifiers_rec.attribute3,
1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,

Line 1602: l_qp_qualifiers_rec.attribute8,

1598: l_qp_qualifiers_rec.attribute4,
1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,

Line 1603: l_qp_qualifiers_rec.attribute9,

1599: l_qp_qualifiers_rec.attribute5,
1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,

Line 1604: l_qp_qualifiers_rec.attribute10,

1600: l_qp_qualifiers_rec.attribute6,
1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,

Line 1605: l_qp_qualifiers_rec.attribute11,

1601: l_qp_qualifiers_rec.attribute7,
1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,

Line 1606: l_qp_qualifiers_rec.attribute12,

1602: l_qp_qualifiers_rec.attribute8,
1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,

Line 1607: l_qp_qualifiers_rec.attribute13,

1603: l_qp_qualifiers_rec.attribute9,
1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 1608: l_qp_qualifiers_rec.attribute14,

1604: l_qp_qualifiers_rec.attribute10,
1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,

Line 1609: l_qp_qualifiers_rec.attribute15,

1605: l_qp_qualifiers_rec.attribute11,
1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,

Line 1610: l_qp_qualifiers_rec.qualifier_rule_id,

1606: l_qp_qualifiers_rec.attribute12,
1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,

Line 1611: l_qp_qualifiers_rec.qualifier_grouping_no,

1607: l_qp_qualifiers_rec.attribute13,
1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,

Line 1612: l_qp_qualifiers_rec.qualifier_attr_value,

1608: l_qp_qualifiers_rec.attribute14,
1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,

Line 1613: l_qp_qualifiers_rec.list_header_id,

1609: l_qp_qualifiers_rec.attribute15,
1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,

Line 1614: l_qp_qualifiers_rec.list_line_id,

1610: l_qp_qualifiers_rec.qualifier_rule_id,
1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,

Line 1615: l_qp_qualifiers_rec.created_from_rule_id,

1611: l_qp_qualifiers_rec.qualifier_grouping_no,
1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,

Line 1616: l_qp_qualifiers_rec.start_date_active,

1612: l_qp_qualifiers_rec.qualifier_attr_value,
1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,
1620: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 1617: l_qp_qualifiers_rec.end_date_active,

1613: l_qp_qualifiers_rec.list_header_id,
1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,
1620: l_qp_qualifiers_rec.qualifier_attr_value_to,
1621: l_qp_qualifiers_rec.active_flag,

Line 1618: l_qp_qualifiers_rec.qualifier_precedence,

1614: l_qp_qualifiers_rec.list_line_id,
1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,
1620: l_qp_qualifiers_rec.qualifier_attr_value_to,
1621: l_qp_qualifiers_rec.active_flag,
1622: l_qp_qualifiers_rec.list_type_code,

Line 1619: l_qp_qualifiers_rec.qualifier_datatype,

1615: l_qp_qualifiers_rec.created_from_rule_id,
1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,
1620: l_qp_qualifiers_rec.qualifier_attr_value_to,
1621: l_qp_qualifiers_rec.active_flag,
1622: l_qp_qualifiers_rec.list_type_code,
1623: l_qual_attr_value_from_number,

Line 1620: l_qp_qualifiers_rec.qualifier_attr_value_to,

1616: l_qp_qualifiers_rec.start_date_active,
1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,
1620: l_qp_qualifiers_rec.qualifier_attr_value_to,
1621: l_qp_qualifiers_rec.active_flag,
1622: l_qp_qualifiers_rec.list_type_code,
1623: l_qual_attr_value_from_number,
1624: l_qual_attr_value_to_number,

Line 1621: l_qp_qualifiers_rec.active_flag,

1617: l_qp_qualifiers_rec.end_date_active,
1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,
1620: l_qp_qualifiers_rec.qualifier_attr_value_to,
1621: l_qp_qualifiers_rec.active_flag,
1622: l_qp_qualifiers_rec.list_type_code,
1623: l_qual_attr_value_from_number,
1624: l_qual_attr_value_to_number,
1625: l_qp_qualifiers_rec.search_ind,

Line 1622: l_qp_qualifiers_rec.list_type_code,

1618: l_qp_qualifiers_rec.qualifier_precedence,
1619: l_qp_qualifiers_rec.qualifier_datatype,
1620: l_qp_qualifiers_rec.qualifier_attr_value_to,
1621: l_qp_qualifiers_rec.active_flag,
1622: l_qp_qualifiers_rec.list_type_code,
1623: l_qual_attr_value_from_number,
1624: l_qual_attr_value_to_number,
1625: l_qp_qualifiers_rec.search_ind,
1626: l_qp_qualifiers_rec.distinct_row_count,

Line 1625: l_qp_qualifiers_rec.search_ind,

1621: l_qp_qualifiers_rec.active_flag,
1622: l_qp_qualifiers_rec.list_type_code,
1623: l_qual_attr_value_from_number,
1624: l_qual_attr_value_to_number,
1625: l_qp_qualifiers_rec.search_ind,
1626: l_qp_qualifiers_rec.distinct_row_count,
1627: l_qp_qualifiers_rec.qualifier_group_cnt,
1628: l_qp_qualifiers_rec.header_quals_exist_flag,
1629: l_qp_qualifiers_rec.others_group_cnt,

Line 1626: l_qp_qualifiers_rec.distinct_row_count,

1622: l_qp_qualifiers_rec.list_type_code,
1623: l_qual_attr_value_from_number,
1624: l_qual_attr_value_to_number,
1625: l_qp_qualifiers_rec.search_ind,
1626: l_qp_qualifiers_rec.distinct_row_count,
1627: l_qp_qualifiers_rec.qualifier_group_cnt,
1628: l_qp_qualifiers_rec.header_quals_exist_flag,
1629: l_qp_qualifiers_rec.others_group_cnt,
1630: l_qp_qualifiers_rec.segment_id,

Line 1627: l_qp_qualifiers_rec.qualifier_group_cnt,

1623: l_qual_attr_value_from_number,
1624: l_qual_attr_value_to_number,
1625: l_qp_qualifiers_rec.search_ind,
1626: l_qp_qualifiers_rec.distinct_row_count,
1627: l_qp_qualifiers_rec.qualifier_group_cnt,
1628: l_qp_qualifiers_rec.header_quals_exist_flag,
1629: l_qp_qualifiers_rec.others_group_cnt,
1630: l_qp_qualifiers_rec.segment_id,
1631: l_conc_request_id

Line 1628: l_qp_qualifiers_rec.header_quals_exist_flag,

1624: l_qual_attr_value_to_number,
1625: l_qp_qualifiers_rec.search_ind,
1626: l_qp_qualifiers_rec.distinct_row_count,
1627: l_qp_qualifiers_rec.qualifier_group_cnt,
1628: l_qp_qualifiers_rec.header_quals_exist_flag,
1629: l_qp_qualifiers_rec.others_group_cnt,
1630: l_qp_qualifiers_rec.segment_id,
1631: l_conc_request_id
1632: );

Line 1629: l_qp_qualifiers_rec.others_group_cnt,

1625: l_qp_qualifiers_rec.search_ind,
1626: l_qp_qualifiers_rec.distinct_row_count,
1627: l_qp_qualifiers_rec.qualifier_group_cnt,
1628: l_qp_qualifiers_rec.header_quals_exist_flag,
1629: l_qp_qualifiers_rec.others_group_cnt,
1630: l_qp_qualifiers_rec.segment_id,
1631: l_conc_request_id
1632: );
1633:

Line 1630: l_qp_qualifiers_rec.segment_id,

1626: l_qp_qualifiers_rec.distinct_row_count,
1627: l_qp_qualifiers_rec.qualifier_group_cnt,
1628: l_qp_qualifiers_rec.header_quals_exist_flag,
1629: l_qp_qualifiers_rec.others_group_cnt,
1630: l_qp_qualifiers_rec.segment_id,
1631: l_conc_request_id
1632: );
1633:
1634: g_count_qualifier := g_count_qualifier + sql%rowcount;

Line 1639: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)

1635: END LOOP;
1636:
1637: ELSE --Modifier and agreement price list
1638: --Following code archives the Modifier header qualifier information
1639: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)
1640: LOOP
1641: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1642: BEGIN
1643: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

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

1637: ELSE --Modifier and agreement price list
1638: --Following code archives the Modifier header qualifier information
1639: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)
1640: LOOP
1641: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1642: BEGIN
1643: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1644: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1645: EXCEPTION

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

1639: FOR l_qp_qualifiers_rec IN qp_headers_qualifiers_cur(p_entity)
1640: LOOP
1641: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1642: BEGIN
1643: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1644: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1645: EXCEPTION
1646: WHEN VALUE_ERROR THEN
1647: NULL;

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

1640: LOOP
1641: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' THEN
1642: BEGIN
1643: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
1644: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
1645: EXCEPTION
1646: WHEN VALUE_ERROR THEN
1647: NULL;
1648: WHEN OTHERS THEN

Line 1711: l_qp_qualifiers_rec.qualifier_id,

1707: ARCH_PURG_REQUEST_ID
1708: )
1709: VALUES
1710: (
1711: l_qp_qualifiers_rec.qualifier_id,
1712: l_qp_qualifiers_rec.creation_date,
1713: l_qp_qualifiers_rec.created_by,
1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,

Line 1712: l_qp_qualifiers_rec.creation_date,

1708: )
1709: VALUES
1710: (
1711: l_qp_qualifiers_rec.qualifier_id,
1712: l_qp_qualifiers_rec.creation_date,
1713: l_qp_qualifiers_rec.created_by,
1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,

Line 1713: l_qp_qualifiers_rec.created_by,

1709: VALUES
1710: (
1711: l_qp_qualifiers_rec.qualifier_id,
1712: l_qp_qualifiers_rec.creation_date,
1713: l_qp_qualifiers_rec.created_by,
1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,

Line 1714: l_qp_qualifiers_rec.last_update_date,

1710: (
1711: l_qp_qualifiers_rec.qualifier_id,
1712: l_qp_qualifiers_rec.creation_date,
1713: l_qp_qualifiers_rec.created_by,
1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,

Line 1715: l_qp_qualifiers_rec.last_updated_by,

1711: l_qp_qualifiers_rec.qualifier_id,
1712: l_qp_qualifiers_rec.creation_date,
1713: l_qp_qualifiers_rec.created_by,
1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,

Line 1716: l_qp_qualifiers_rec.last_update_login,

1712: l_qp_qualifiers_rec.creation_date,
1713: l_qp_qualifiers_rec.created_by,
1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,

Line 1717: l_qp_qualifiers_rec.program_application_id,

1713: l_qp_qualifiers_rec.created_by,
1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,

Line 1718: l_qp_qualifiers_rec.program_id,

1714: l_qp_qualifiers_rec.last_update_date,
1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,

Line 1719: l_qp_qualifiers_rec.program_update_date,

1715: l_qp_qualifiers_rec.last_updated_by,
1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,

Line 1720: l_qp_qualifiers_rec.request_id,

1716: l_qp_qualifiers_rec.last_update_login,
1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,

Line 1721: l_qp_qualifiers_rec.excluder_flag,

1717: l_qp_qualifiers_rec.program_application_id,
1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,

Line 1722: l_qp_qualifiers_rec.comparison_operator_code,

1718: l_qp_qualifiers_rec.program_id,
1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,

Line 1723: l_qp_qualifiers_rec.qualifier_context,

1719: l_qp_qualifiers_rec.program_update_date,
1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,

Line 1724: l_qp_qualifiers_rec.qualifier_attribute,

1720: l_qp_qualifiers_rec.request_id,
1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,

Line 1725: l_qp_qualifiers_rec.context,

1721: l_qp_qualifiers_rec.excluder_flag,
1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,

Line 1726: l_qp_qualifiers_rec.attribute1,

1722: l_qp_qualifiers_rec.comparison_operator_code,
1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,

Line 1727: l_qp_qualifiers_rec.attribute2,

1723: l_qp_qualifiers_rec.qualifier_context,
1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,

Line 1728: l_qp_qualifiers_rec.attribute3,

1724: l_qp_qualifiers_rec.qualifier_attribute,
1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,

Line 1729: l_qp_qualifiers_rec.attribute4,

1725: l_qp_qualifiers_rec.context,
1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,

Line 1730: l_qp_qualifiers_rec.attribute5,

1726: l_qp_qualifiers_rec.attribute1,
1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,

Line 1731: l_qp_qualifiers_rec.attribute6,

1727: l_qp_qualifiers_rec.attribute2,
1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,

Line 1732: l_qp_qualifiers_rec.attribute7,

1728: l_qp_qualifiers_rec.attribute3,
1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,

Line 1733: l_qp_qualifiers_rec.attribute8,

1729: l_qp_qualifiers_rec.attribute4,
1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,

Line 1734: l_qp_qualifiers_rec.attribute9,

1730: l_qp_qualifiers_rec.attribute5,
1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,

Line 1735: l_qp_qualifiers_rec.attribute10,

1731: l_qp_qualifiers_rec.attribute6,
1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,

Line 1736: l_qp_qualifiers_rec.attribute11,

1732: l_qp_qualifiers_rec.attribute7,
1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,

Line 1737: l_qp_qualifiers_rec.attribute12,

1733: l_qp_qualifiers_rec.attribute8,
1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,

Line 1738: l_qp_qualifiers_rec.attribute13,

1734: l_qp_qualifiers_rec.attribute9,
1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 1739: l_qp_qualifiers_rec.attribute14,

1735: l_qp_qualifiers_rec.attribute10,
1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,

Line 1740: l_qp_qualifiers_rec.attribute15,

1736: l_qp_qualifiers_rec.attribute11,
1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,

Line 1741: l_qp_qualifiers_rec.qualifier_rule_id,

1737: l_qp_qualifiers_rec.attribute12,
1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,

Line 1742: l_qp_qualifiers_rec.qualifier_grouping_no,

1738: l_qp_qualifiers_rec.attribute13,
1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,

Line 1743: l_qp_qualifiers_rec.qualifier_attr_value,

1739: l_qp_qualifiers_rec.attribute14,
1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,

Line 1744: l_qp_qualifiers_rec.list_header_id,

1740: l_qp_qualifiers_rec.attribute15,
1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,

Line 1745: l_qp_qualifiers_rec.list_line_id,

1741: l_qp_qualifiers_rec.qualifier_rule_id,
1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,

Line 1746: l_qp_qualifiers_rec.created_from_rule_id,

1742: l_qp_qualifiers_rec.qualifier_grouping_no,
1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,

Line 1747: l_qp_qualifiers_rec.start_date_active,

1743: l_qp_qualifiers_rec.qualifier_attr_value,
1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,
1751: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 1748: l_qp_qualifiers_rec.end_date_active,

1744: l_qp_qualifiers_rec.list_header_id,
1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,
1751: l_qp_qualifiers_rec.qualifier_attr_value_to,
1752: l_qp_qualifiers_rec.active_flag,

Line 1749: l_qp_qualifiers_rec.qualifier_precedence,

1745: l_qp_qualifiers_rec.list_line_id,
1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,
1751: l_qp_qualifiers_rec.qualifier_attr_value_to,
1752: l_qp_qualifiers_rec.active_flag,
1753: l_qp_qualifiers_rec.list_type_code,

Line 1750: l_qp_qualifiers_rec.qualifier_datatype,

1746: l_qp_qualifiers_rec.created_from_rule_id,
1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,
1751: l_qp_qualifiers_rec.qualifier_attr_value_to,
1752: l_qp_qualifiers_rec.active_flag,
1753: l_qp_qualifiers_rec.list_type_code,
1754: l_qual_attr_value_from_number,

Line 1751: l_qp_qualifiers_rec.qualifier_attr_value_to,

1747: l_qp_qualifiers_rec.start_date_active,
1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,
1751: l_qp_qualifiers_rec.qualifier_attr_value_to,
1752: l_qp_qualifiers_rec.active_flag,
1753: l_qp_qualifiers_rec.list_type_code,
1754: l_qual_attr_value_from_number,
1755: l_qual_attr_value_to_number,

Line 1752: l_qp_qualifiers_rec.active_flag,

1748: l_qp_qualifiers_rec.end_date_active,
1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,
1751: l_qp_qualifiers_rec.qualifier_attr_value_to,
1752: l_qp_qualifiers_rec.active_flag,
1753: l_qp_qualifiers_rec.list_type_code,
1754: l_qual_attr_value_from_number,
1755: l_qual_attr_value_to_number,
1756: l_qp_qualifiers_rec.search_ind,

Line 1753: l_qp_qualifiers_rec.list_type_code,

1749: l_qp_qualifiers_rec.qualifier_precedence,
1750: l_qp_qualifiers_rec.qualifier_datatype,
1751: l_qp_qualifiers_rec.qualifier_attr_value_to,
1752: l_qp_qualifiers_rec.active_flag,
1753: l_qp_qualifiers_rec.list_type_code,
1754: l_qual_attr_value_from_number,
1755: l_qual_attr_value_to_number,
1756: l_qp_qualifiers_rec.search_ind,
1757: l_qp_qualifiers_rec.distinct_row_count,

Line 1756: l_qp_qualifiers_rec.search_ind,

1752: l_qp_qualifiers_rec.active_flag,
1753: l_qp_qualifiers_rec.list_type_code,
1754: l_qual_attr_value_from_number,
1755: l_qual_attr_value_to_number,
1756: l_qp_qualifiers_rec.search_ind,
1757: l_qp_qualifiers_rec.distinct_row_count,
1758: l_qp_qualifiers_rec.qualifier_group_cnt,
1759: l_qp_qualifiers_rec.header_quals_exist_flag,
1760: l_qp_qualifiers_rec.others_group_cnt,

Line 1757: l_qp_qualifiers_rec.distinct_row_count,

1753: l_qp_qualifiers_rec.list_type_code,
1754: l_qual_attr_value_from_number,
1755: l_qual_attr_value_to_number,
1756: l_qp_qualifiers_rec.search_ind,
1757: l_qp_qualifiers_rec.distinct_row_count,
1758: l_qp_qualifiers_rec.qualifier_group_cnt,
1759: l_qp_qualifiers_rec.header_quals_exist_flag,
1760: l_qp_qualifiers_rec.others_group_cnt,
1761: l_qp_qualifiers_rec.segment_id,

Line 1758: l_qp_qualifiers_rec.qualifier_group_cnt,

1754: l_qual_attr_value_from_number,
1755: l_qual_attr_value_to_number,
1756: l_qp_qualifiers_rec.search_ind,
1757: l_qp_qualifiers_rec.distinct_row_count,
1758: l_qp_qualifiers_rec.qualifier_group_cnt,
1759: l_qp_qualifiers_rec.header_quals_exist_flag,
1760: l_qp_qualifiers_rec.others_group_cnt,
1761: l_qp_qualifiers_rec.segment_id,
1762: l_conc_request_id

Line 1759: l_qp_qualifiers_rec.header_quals_exist_flag,

1755: l_qual_attr_value_to_number,
1756: l_qp_qualifiers_rec.search_ind,
1757: l_qp_qualifiers_rec.distinct_row_count,
1758: l_qp_qualifiers_rec.qualifier_group_cnt,
1759: l_qp_qualifiers_rec.header_quals_exist_flag,
1760: l_qp_qualifiers_rec.others_group_cnt,
1761: l_qp_qualifiers_rec.segment_id,
1762: l_conc_request_id
1763: );

Line 1760: l_qp_qualifiers_rec.others_group_cnt,

1756: l_qp_qualifiers_rec.search_ind,
1757: l_qp_qualifiers_rec.distinct_row_count,
1758: l_qp_qualifiers_rec.qualifier_group_cnt,
1759: l_qp_qualifiers_rec.header_quals_exist_flag,
1760: l_qp_qualifiers_rec.others_group_cnt,
1761: l_qp_qualifiers_rec.segment_id,
1762: l_conc_request_id
1763: );
1764:

Line 1761: l_qp_qualifiers_rec.segment_id,

1757: l_qp_qualifiers_rec.distinct_row_count,
1758: l_qp_qualifiers_rec.qualifier_group_cnt,
1759: l_qp_qualifiers_rec.header_quals_exist_flag,
1760: l_qp_qualifiers_rec.others_group_cnt,
1761: l_qp_qualifiers_rec.segment_id,
1762: l_conc_request_id
1763: );
1764:
1765: g_count_qualifier := g_count_qualifier + sql%rowcount;

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

2037: IF l_list_type_code NOT IN ('PRL','AGR') THEN
2038: IF l_qp_list_lines_rec.list_line_id is not null AND
2039: l_qp_list_lines_rec.list_line_id <> -1 THEN
2040:
2041: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
2042: LOOP
2043: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
2044: BEGIN
2045: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);

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

2039: l_qp_list_lines_rec.list_line_id <> -1 THEN
2040:
2041: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
2042: LOOP
2043: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
2044: BEGIN
2045: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
2046: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
2047: EXCEPTION

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

2041: FOR l_qp_qualifiers_rec IN qp_line_qualifiers_cur(p_entity,l_qp_list_lines_rec.list_line_id)
2042: LOOP
2043: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
2044: BEGIN
2045: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
2046: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
2047: EXCEPTION
2048: WHEN VALUE_ERROR THEN
2049: NULL;

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

2042: LOOP
2043: IF l_qp_qualifiers_rec.qualifier_datatype = 'N' then
2044: BEGIN
2045: l_qual_attr_value_from_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value);
2046: l_qual_attr_value_to_number := qp_number.canonical_to_number(l_qp_qualifiers_rec.qualifier_attr_value_to);
2047: EXCEPTION
2048: WHEN VALUE_ERROR THEN
2049: NULL;
2050: WHEN OTHERS THEN

Line 2055: --Insert into qp_qualifiers

2051: NULL;
2052: END;
2053: END IF;
2054:
2055: --Insert into qp_qualifiers
2056: INSERT INTO QP_ARCH_QUALIFIERS
2057: (
2058: qualifier_id,
2059: creation_date,

Line 2113: l_qp_qualifiers_rec.qualifier_id,

2109: ARCH_PURG_REQUEST_ID
2110: )
2111: VALUES
2112: (
2113: l_qp_qualifiers_rec.qualifier_id,
2114: l_qp_qualifiers_rec.creation_date,
2115: l_qp_qualifiers_rec.created_by,
2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,

Line 2114: l_qp_qualifiers_rec.creation_date,

2110: )
2111: VALUES
2112: (
2113: l_qp_qualifiers_rec.qualifier_id,
2114: l_qp_qualifiers_rec.creation_date,
2115: l_qp_qualifiers_rec.created_by,
2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,

Line 2115: l_qp_qualifiers_rec.created_by,

2111: VALUES
2112: (
2113: l_qp_qualifiers_rec.qualifier_id,
2114: l_qp_qualifiers_rec.creation_date,
2115: l_qp_qualifiers_rec.created_by,
2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,

Line 2116: l_qp_qualifiers_rec.last_update_date,

2112: (
2113: l_qp_qualifiers_rec.qualifier_id,
2114: l_qp_qualifiers_rec.creation_date,
2115: l_qp_qualifiers_rec.created_by,
2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,

Line 2117: l_qp_qualifiers_rec.last_updated_by,

2113: l_qp_qualifiers_rec.qualifier_id,
2114: l_qp_qualifiers_rec.creation_date,
2115: l_qp_qualifiers_rec.created_by,
2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,

Line 2118: l_qp_qualifiers_rec.last_update_login,

2114: l_qp_qualifiers_rec.creation_date,
2115: l_qp_qualifiers_rec.created_by,
2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,

Line 2119: l_qp_qualifiers_rec.program_application_id,

2115: l_qp_qualifiers_rec.created_by,
2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,

Line 2120: l_qp_qualifiers_rec.program_id,

2116: l_qp_qualifiers_rec.last_update_date,
2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,

Line 2121: l_qp_qualifiers_rec.program_update_date,

2117: l_qp_qualifiers_rec.last_updated_by,
2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,

Line 2122: l_qp_qualifiers_rec.request_id,

2118: l_qp_qualifiers_rec.last_update_login,
2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,

Line 2123: l_qp_qualifiers_rec.excluder_flag,

2119: l_qp_qualifiers_rec.program_application_id,
2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,

Line 2124: l_qp_qualifiers_rec.comparison_operator_code,

2120: l_qp_qualifiers_rec.program_id,
2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,

Line 2125: l_qp_qualifiers_rec.qualifier_context,

2121: l_qp_qualifiers_rec.program_update_date,
2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,

Line 2126: l_qp_qualifiers_rec.qualifier_attribute,

2122: l_qp_qualifiers_rec.request_id,
2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,

Line 2127: l_qp_qualifiers_rec.context,

2123: l_qp_qualifiers_rec.excluder_flag,
2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,

Line 2128: l_qp_qualifiers_rec.attribute1,

2124: l_qp_qualifiers_rec.comparison_operator_code,
2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,

Line 2129: l_qp_qualifiers_rec.attribute2,

2125: l_qp_qualifiers_rec.qualifier_context,
2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,

Line 2130: l_qp_qualifiers_rec.attribute3,

2126: l_qp_qualifiers_rec.qualifier_attribute,
2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,

Line 2131: l_qp_qualifiers_rec.attribute4,

2127: l_qp_qualifiers_rec.context,
2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,

Line 2132: l_qp_qualifiers_rec.attribute5,

2128: l_qp_qualifiers_rec.attribute1,
2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,

Line 2133: l_qp_qualifiers_rec.attribute6,

2129: l_qp_qualifiers_rec.attribute2,
2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,

Line 2134: l_qp_qualifiers_rec.attribute7,

2130: l_qp_qualifiers_rec.attribute3,
2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,

Line 2135: l_qp_qualifiers_rec.attribute8,

2131: l_qp_qualifiers_rec.attribute4,
2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,

Line 2136: l_qp_qualifiers_rec.attribute9,

2132: l_qp_qualifiers_rec.attribute5,
2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,

Line 2137: l_qp_qualifiers_rec.attribute10,

2133: l_qp_qualifiers_rec.attribute6,
2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,

Line 2138: l_qp_qualifiers_rec.attribute11,

2134: l_qp_qualifiers_rec.attribute7,
2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,

Line 2139: l_qp_qualifiers_rec.attribute12,

2135: l_qp_qualifiers_rec.attribute8,
2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,

Line 2140: l_qp_qualifiers_rec.attribute13,

2136: l_qp_qualifiers_rec.attribute9,
2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,

Line 2141: l_qp_qualifiers_rec.attribute14,

2137: l_qp_qualifiers_rec.attribute10,
2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,

Line 2142: l_qp_qualifiers_rec.attribute15,

2138: l_qp_qualifiers_rec.attribute11,
2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,

Line 2143: l_qp_qualifiers_rec.qualifier_rule_id,

2139: l_qp_qualifiers_rec.attribute12,
2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,

Line 2144: l_qp_qualifiers_rec.qualifier_grouping_no,

2140: l_qp_qualifiers_rec.attribute13,
2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,

Line 2145: l_qp_qualifiers_rec.qualifier_attr_value,

2141: l_qp_qualifiers_rec.attribute14,
2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,

Line 2146: l_qp_qualifiers_rec.list_header_id,

2142: l_qp_qualifiers_rec.attribute15,
2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,

Line 2147: l_qp_qualifiers_rec.list_line_id,

2143: l_qp_qualifiers_rec.qualifier_rule_id,
2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,

Line 2148: l_qp_qualifiers_rec.created_from_rule_id,

2144: l_qp_qualifiers_rec.qualifier_grouping_no,
2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,

Line 2149: l_qp_qualifiers_rec.start_date_active,

2145: l_qp_qualifiers_rec.qualifier_attr_value,
2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,
2153: l_qp_qualifiers_rec.qualifier_attr_value_to,

Line 2150: l_qp_qualifiers_rec.end_date_active,

2146: l_qp_qualifiers_rec.list_header_id,
2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,
2153: l_qp_qualifiers_rec.qualifier_attr_value_to,
2154: l_qp_qualifiers_rec.active_flag,

Line 2151: l_qp_qualifiers_rec.qualifier_precedence,

2147: l_qp_qualifiers_rec.list_line_id,
2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,
2153: l_qp_qualifiers_rec.qualifier_attr_value_to,
2154: l_qp_qualifiers_rec.active_flag,
2155: l_qp_qualifiers_rec.list_type_code,

Line 2152: l_qp_qualifiers_rec.qualifier_datatype,

2148: l_qp_qualifiers_rec.created_from_rule_id,
2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,
2153: l_qp_qualifiers_rec.qualifier_attr_value_to,
2154: l_qp_qualifiers_rec.active_flag,
2155: l_qp_qualifiers_rec.list_type_code,
2156: l_qual_attr_value_from_number,

Line 2153: l_qp_qualifiers_rec.qualifier_attr_value_to,

2149: l_qp_qualifiers_rec.start_date_active,
2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,
2153: l_qp_qualifiers_rec.qualifier_attr_value_to,
2154: l_qp_qualifiers_rec.active_flag,
2155: l_qp_qualifiers_rec.list_type_code,
2156: l_qual_attr_value_from_number,
2157: l_qual_attr_value_to_number,

Line 2154: l_qp_qualifiers_rec.active_flag,

2150: l_qp_qualifiers_rec.end_date_active,
2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,
2153: l_qp_qualifiers_rec.qualifier_attr_value_to,
2154: l_qp_qualifiers_rec.active_flag,
2155: l_qp_qualifiers_rec.list_type_code,
2156: l_qual_attr_value_from_number,
2157: l_qual_attr_value_to_number,
2158: l_qp_qualifiers_rec.search_ind,

Line 2155: l_qp_qualifiers_rec.list_type_code,

2151: l_qp_qualifiers_rec.qualifier_precedence,
2152: l_qp_qualifiers_rec.qualifier_datatype,
2153: l_qp_qualifiers_rec.qualifier_attr_value_to,
2154: l_qp_qualifiers_rec.active_flag,
2155: l_qp_qualifiers_rec.list_type_code,
2156: l_qual_attr_value_from_number,
2157: l_qual_attr_value_to_number,
2158: l_qp_qualifiers_rec.search_ind,
2159: l_qp_qualifiers_rec.distinct_row_count,

Line 2158: l_qp_qualifiers_rec.search_ind,

2154: l_qp_qualifiers_rec.active_flag,
2155: l_qp_qualifiers_rec.list_type_code,
2156: l_qual_attr_value_from_number,
2157: l_qual_attr_value_to_number,
2158: l_qp_qualifiers_rec.search_ind,
2159: l_qp_qualifiers_rec.distinct_row_count,
2160: l_qp_qualifiers_rec.qualifier_group_cnt,
2161: l_qp_qualifiers_rec.header_quals_exist_flag,
2162: l_qp_qualifiers_rec.others_group_cnt,

Line 2159: l_qp_qualifiers_rec.distinct_row_count,

2155: l_qp_qualifiers_rec.list_type_code,
2156: l_qual_attr_value_from_number,
2157: l_qual_attr_value_to_number,
2158: l_qp_qualifiers_rec.search_ind,
2159: l_qp_qualifiers_rec.distinct_row_count,
2160: l_qp_qualifiers_rec.qualifier_group_cnt,
2161: l_qp_qualifiers_rec.header_quals_exist_flag,
2162: l_qp_qualifiers_rec.others_group_cnt,
2163: l_qp_qualifiers_rec.segment_id,

Line 2160: l_qp_qualifiers_rec.qualifier_group_cnt,

2156: l_qual_attr_value_from_number,
2157: l_qual_attr_value_to_number,
2158: l_qp_qualifiers_rec.search_ind,
2159: l_qp_qualifiers_rec.distinct_row_count,
2160: l_qp_qualifiers_rec.qualifier_group_cnt,
2161: l_qp_qualifiers_rec.header_quals_exist_flag,
2162: l_qp_qualifiers_rec.others_group_cnt,
2163: l_qp_qualifiers_rec.segment_id,
2164: l_conc_request_id

Line 2161: l_qp_qualifiers_rec.header_quals_exist_flag,

2157: l_qual_attr_value_to_number,
2158: l_qp_qualifiers_rec.search_ind,
2159: l_qp_qualifiers_rec.distinct_row_count,
2160: l_qp_qualifiers_rec.qualifier_group_cnt,
2161: l_qp_qualifiers_rec.header_quals_exist_flag,
2162: l_qp_qualifiers_rec.others_group_cnt,
2163: l_qp_qualifiers_rec.segment_id,
2164: l_conc_request_id
2165: );

Line 2162: l_qp_qualifiers_rec.others_group_cnt,

2158: l_qp_qualifiers_rec.search_ind,
2159: l_qp_qualifiers_rec.distinct_row_count,
2160: l_qp_qualifiers_rec.qualifier_group_cnt,
2161: l_qp_qualifiers_rec.header_quals_exist_flag,
2162: l_qp_qualifiers_rec.others_group_cnt,
2163: l_qp_qualifiers_rec.segment_id,
2164: l_conc_request_id
2165: );
2166:

Line 2163: l_qp_qualifiers_rec.segment_id,

2159: l_qp_qualifiers_rec.distinct_row_count,
2160: l_qp_qualifiers_rec.qualifier_group_cnt,
2161: l_qp_qualifiers_rec.header_quals_exist_flag,
2162: l_qp_qualifiers_rec.others_group_cnt,
2163: l_qp_qualifiers_rec.segment_id,
2164: l_conc_request_id
2165: );
2166:
2167: g_count_qualifier := g_count_qualifier + sql%rowcount;

Line 2169: DELETE FROM qp_qualifiers

2165: );
2166:
2167: g_count_qualifier := g_count_qualifier + sql%rowcount;
2168:
2169: DELETE FROM qp_qualifiers
2170: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2171: and list_header_id = l_qp_qualifiers_rec.list_header_id
2172: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2173: END LOOP;

Line 2170: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id

2166:
2167: g_count_qualifier := g_count_qualifier + sql%rowcount;
2168:
2169: DELETE FROM qp_qualifiers
2170: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2171: and list_header_id = l_qp_qualifiers_rec.list_header_id
2172: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2173: END LOOP;
2174:

Line 2171: and list_header_id = l_qp_qualifiers_rec.list_header_id

2167: g_count_qualifier := g_count_qualifier + sql%rowcount;
2168:
2169: DELETE FROM qp_qualifiers
2170: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2171: and list_header_id = l_qp_qualifiers_rec.list_header_id
2172: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2173: END LOOP;
2174:
2175: END IF;

Line 2172: and list_line_id = l_qp_qualifiers_rec.list_line_id;

2168:
2169: DELETE FROM qp_qualifiers
2170: WHERE qualifier_id = l_qp_qualifiers_rec.qualifier_id
2171: and list_header_id = l_qp_qualifiers_rec.list_header_id
2172: and list_line_id = l_qp_qualifiers_rec.list_line_id;
2173: END LOOP;
2174:
2175: END IF;
2176: END IF; -- List type code end

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

2433: fnd_file.put_line(FND_FILE.LOG, 'Number of related lines archived into QP_ARCH_RLTD_MODIFIERS: '|| g_count_rldt);
2434:
2435: IF (g_count_list_line > 0) THEN -- Invoke update_qualifiers only if number of list lines archived > 0.
2436: fnd_file.put_line(FND_FILE.LOG, 'Before calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS.');
2437: /* This code will call the API to update the denormalized columns on QP_QUALIFIERS*/
2438: QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS( ERR_BUFF => errbuf,
2439: RETCODE => retcode,
2440: P_LIST_HEADER_ID => p_entity);
2441: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);

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

2440: P_LIST_HEADER_ID => p_entity);
2441: fnd_file.put_line(FND_FILE.LOG, 'After calling QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS. Return code: '|| retcode);
2442:
2443: IF retcode = 2 THEN
2444: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2445: ELSE
2446: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2447: END IF;
2448: END IF;

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

2442:
2443: IF retcode = 2 THEN
2444: fnd_file.put_line(FND_FILE.LOG,'Error in Update of denormalized columns in QP_Qualifiers');
2445: ELSE
2446: fnd_file.put_line(FND_FILE.LOG,'Update of denormalized columns in QP_Qualifiers completed successfully');
2447: END IF;
2448: END IF;
2449:
2450: COMMIT;