APPS.QP_QUALIFIERS_UTIL dependencies on QP_QUALIFIERS_FWK_DUMMY

Line 1494: insert into qp_qualifiers_fwk_dummy

1490: p_transaction_id IN NUMBER) IS
1491: PRAGMA AUTONOMOUS_TRANSACTION;
1492: BEGIN
1493:
1494: insert into qp_qualifiers_fwk_dummy
1495: ( ATTRIBUTE1
1496: , ATTRIBUTE10
1497: , ATTRIBUTE11
1498: , ATTRIBUTE12

Line 1622: and not exists (select 'Y' from qp_qualifiers_fwk_dummy dummy

1618: or qualifier_grouping_no = p_qual_grp_no)))
1619: and ((qual.list_type_code = 'PRL'
1620: and not (qual.qualifier_context = 'MODLIST' and qual.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'))
1621: or (qual.list_type_code <> 'PRL'))
1622: and not exists (select 'Y' from qp_qualifiers_fwk_dummy dummy
1623: where dummy.qualifier_id = qual.qualifier_id
1624: and dummy.transaction_id = p_transaction_id);
1625:
1626: --AUTONOMOUS commit

Line 1638: delete from qp_qualifiers_fwk_dummy where transaction_id = p_transaction_id

1634: --to delete rows from dummy table
1635: Procedure Delete_Dummy_Rows(p_transaction_id IN NUMBER) IS
1636: PRAGMA AUTONOMOUS_TRANSACTION;
1637: BEGIN
1638: delete from qp_qualifiers_fwk_dummy where transaction_id = p_transaction_id
1639: or last_update_date < sysdate-5;
1640: -- where list_header_id = p_list_header_id
1641: -- and list_line_id = p_list_line_id;
1642:

Line 1656: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = decode(p_mode, 'HGRID', 'X', 'D'),

1652: ,p_mode IN VARCHAR2
1653: ,p_transaction_id IN NUMBER) IS
1654: PRAGMA AUTONOMOUS_TRANSACTION;
1655: BEGIN
1656: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = decode(p_mode, 'HGRID', 'X', 'D'),
1657: last_update_date = sysdate
1658: where qualifier_id = p_qual_id
1659: and transaction_id = p_transaction_id;
1660:

Line 1662: insert into qp_qualifiers_fwk_dummy

1658: where qualifier_id = p_qual_id
1659: and transaction_id = p_transaction_id;
1660:
1661: IF SQL%ROWCOUNT < 1 THEN
1662: insert into qp_qualifiers_fwk_dummy
1663: ( ATTRIBUTE1
1664: , ATTRIBUTE10
1665: , ATTRIBUTE11
1666: , ATTRIBUTE12

Line 1796: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = 'X'

1792: p_list_line_id IN NUMBER,
1793: p_transaction_id IN NUMBER) IS
1794: PRAGMA AUTONOMOUS_TRANSACTION;
1795: BEGIN
1796: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = 'X'
1797: ,last_update_date = sysdate
1798: where qualifier_grouping_no = p_qual_grp_no
1799: and list_header_id = p_list_header_id
1800: and list_line_id = p_list_line_id

Line 1807: insert into qp_qualifiers_fwk_dummy

1803: or (list_type_code <> 'PRL'))
1804: and transaction_id = p_transaction_id;
1805:
1806: IF SQL%ROWCOUNT < 1 THEN
1807: insert into qp_qualifiers_fwk_dummy
1808: ( ATTRIBUTE1
1809: , ATTRIBUTE10
1810: , ATTRIBUTE11
1811: , ATTRIBUTE12

Line 1947: delete from qp_qualifiers_fwk_dummy

1943: p_transaction_id IN NUMBER) IS
1944: PRAGMA AUTONOMOUS_TRANSACTION;
1945: BEGIN
1946: IF p_action_type = 'CANCEL' THEN
1947: delete from qp_qualifiers_fwk_dummy
1948: where list_header_id = p_list_header_id
1949: and list_line_id = p_list_line_id
1950: and transaction_id = p_transaction_id
1951: and nvl(header_quals_exist_flag, 'N') in ('Q');--, 'D', 'U', 'N');

Line 1953: delete from qp_qualifiers_fwk_dummy

1949: and list_line_id = p_list_line_id
1950: and transaction_id = p_transaction_id
1951: and nvl(header_quals_exist_flag, 'N') in ('Q');--, 'D', 'U', 'N');
1952: ELSIF p_action_type = 'APPLY' THEN
1953: delete from qp_qualifiers_fwk_dummy
1954: where list_header_id = p_list_header_id
1955: and list_line_id = p_list_line_id
1956: and transaction_id = p_transaction_id
1957: and nvl(header_quals_exist_flag, 'N') = 'Q';

Line 2037: delete from qp_qualifiers_fwk_dummy

2033: IS
2034: PRAGMA AUTONOMOUS_TRANSACTION;
2035: BEGIN
2036:
2037: delete from qp_qualifiers_fwk_dummy
2038: where transaction_id = p_transaction_id
2039: or last_update_date < sysdate - 5;
2040: --where qualifier_grouping_no = p_qual_grp_no
2041: --and list_header_id = p_list_header_id