APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIST_HEADERS_TL

Line 1901: update QP_LIST_HEADERS_TL set

1897: ;
1898:
1899: Begin
1900:
1901: update QP_LIST_HEADERS_TL set
1902: NAME = p_MODIFIER_LIST_rec.NAME
1903: , DESCRIPTION = p_MODIFIER_LIST_rec.DESCRIPTION
1904: , VERSION_NO = p_MODIFIER_LIST_rec.VERSION_NO
1905: , LAST_UPDATE_DATE = p_MODIFIER_LIST_rec.LAST_UPDATE_DATE

Line 1972: insert into QP_LIST_HEADERS_TL

1968: BEGIN
1969:
1970: Begin
1971:
1972: insert into QP_LIST_HEADERS_TL
1973: ( LIST_HEADER_ID
1974: , NAME
1975: , DESCRIPTION
1976: , VERSION_NO

Line 1999: (select NULL from QP_LIST_HEADERS_TL T

1995: , userenv('LANG')
1996: from FND_LANGUAGES L
1997: where L.INSTALLED_FLAG in ('I','B')
1998: and not exists
1999: (select NULL from QP_LIST_HEADERS_TL T
2000: where T.LIST_HEADER_ID = p_MODIFIER_LIST_rec.LIST_HEADER_ID
2001: and T.LANGUAGE = L.LANGUAGE_CODE);
2002:
2003: Exception

Line 2298: DELETE FROM QP_LIST_HEADERS_TL

2294:
2295: DELETE FROM QP_QUALIFIERS
2296: WHERE LIST_HEADER_ID = p_list_header_id;
2297:
2298: DELETE FROM QP_LIST_HEADERS_TL
2299: WHERE LIST_HEADER_ID = p_list_header_id;
2300:
2301: DELETE FROM QP_LIST_HEADERS_B
2302: WHERE LIST_HEADER_ID = p_list_header_id ;

Line 2454: FROM qp_list_headers_tl

2450: , VERSION_NO
2451: INTO l_MODIFIER_LIST_rec.name
2452: , l_MODIFIER_LIST_rec.description
2453: , l_MODIFIER_LIST_rec.version_no
2454: FROM qp_list_headers_tl
2455: WHERE LIST_HEADER_ID = p_list_header_id
2456: AND LANGUAGE = userenv('LANG');
2457:
2458: oe_debug_pub.add('version_no QPXUMLHB'||l_MODIFIER_LIST_rec.version_no);

Line 2618: FROM qp_list_headers_tl

2614: , VERSION_NO
2615: INTO l_MODIFIER_LIST_rec.name
2616: , l_MODIFIER_LIST_rec.description
2617: , l_MODIFIER_LIST_rec.version_no
2618: FROM qp_list_headers_tl
2619: WHERE LIST_HEADER_ID = p_MODIFIER_LIST_rec.list_header_id
2620: AND LANGUAGE = userenv('LANG');
2621:
2622: -- Row locked. Compare IN attributes to DB attributes.