APPS.QP_QUALIFIERS_UTIL dependencies on QP_QUALIFIERS_FWK_DUMMY

Line 1493: insert into qp_qualifiers_fwk_dummy

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

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

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

Line 1637: delete from qp_qualifiers_fwk_dummy where transaction_id = p_transaction_id

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

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

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

Line 1661: insert into qp_qualifiers_fwk_dummy

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

Line 1795: update qp_qualifiers_fwk_dummy set header_quals_exist_flag = 'X'

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

Line 1806: insert into qp_qualifiers_fwk_dummy

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

Line 1946: delete from qp_qualifiers_fwk_dummy

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

Line 1952: delete from qp_qualifiers_fwk_dummy

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

Line 2036: delete from qp_qualifiers_fwk_dummy

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