APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIST_HEADERS_TL

Line 1670: update QP_LIST_HEADERS_TL set

1666: ;
1667:
1668: Begin
1669:
1670: update QP_LIST_HEADERS_TL set
1671: NAME = p_MODIFIER_LIST_rec.NAME
1672: , DESCRIPTION = p_MODIFIER_LIST_rec.DESCRIPTION
1673: , VERSION_NO = p_MODIFIER_LIST_rec.VERSION_NO
1674: , LAST_UPDATE_DATE = p_MODIFIER_LIST_rec.LAST_UPDATE_DATE

Line 1741: insert into QP_LIST_HEADERS_TL

1737: BEGIN
1738:
1739: Begin
1740:
1741: insert into QP_LIST_HEADERS_TL
1742: ( LIST_HEADER_ID
1743: , NAME
1744: , DESCRIPTION
1745: , VERSION_NO

Line 1768: (select NULL from QP_LIST_HEADERS_TL T

1764: , userenv('LANG')
1765: from FND_LANGUAGES L
1766: where L.INSTALLED_FLAG in ('I','B')
1767: and not exists
1768: (select NULL from QP_LIST_HEADERS_TL T
1769: where T.LIST_HEADER_ID = p_MODIFIER_LIST_rec.LIST_HEADER_ID
1770: and T.LANGUAGE = L.LANGUAGE_CODE);
1771:
1772: Exception

Line 2067: DELETE FROM QP_LIST_HEADERS_TL

2063:
2064: DELETE FROM QP_QUALIFIERS
2065: WHERE LIST_HEADER_ID = p_list_header_id;
2066:
2067: DELETE FROM QP_LIST_HEADERS_TL
2068: WHERE LIST_HEADER_ID = p_list_header_id;
2069:
2070: DELETE FROM QP_LIST_HEADERS_B
2071: WHERE LIST_HEADER_ID = p_list_header_id ;

Line 2223: FROM qp_list_headers_tl

2219: , VERSION_NO
2220: INTO l_MODIFIER_LIST_rec.name
2221: , l_MODIFIER_LIST_rec.description
2222: , l_MODIFIER_LIST_rec.version_no
2223: FROM qp_list_headers_tl
2224: WHERE LIST_HEADER_ID = p_list_header_id
2225: AND LANGUAGE = userenv('LANG');
2226:
2227: oe_debug_pub.add('version_no QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);

Line 2387: FROM qp_list_headers_tl

2383: , VERSION_NO
2384: INTO l_MODIFIER_LIST_rec.name
2385: , l_MODIFIER_LIST_rec.description
2386: , l_MODIFIER_LIST_rec.version_no
2387: FROM qp_list_headers_tl
2388: WHERE LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
2389: AND LANGUAGE = userenv('LANG');
2390:
2391: -- Row locked. Compare IN attributes to DB attributes.