APPS.QP_PRICE_LIST_UTIL dependencies on QP_LIST_HEADERS_TL

Line 1579: update QP_LIST_HEADERS_TL set

1575: , ORIG_ORG_ID = p_PRICE_LIST_rec.org_id
1576: WHERE LIST_HEADER_ID = p_PRICE_LIST_rec.list_header_id
1577: ;
1578:
1579: update QP_LIST_HEADERS_TL set
1580: NAME = p_PRICE_LIST_rec.name,
1581: DESCRIPTION = p_PRICE_LIST_rec.description,
1582: LAST_UPDATE_DATE = p_PRICE_LIST_rec.LAST_UPDATE_DATE,
1583: LAST_UPDATED_BY = p_PRICE_LIST_rec.LAST_UPDATED_BY,

Line 1748: insert into QP_LIST_HEADERS_TL (

1744: , p_PRICE_LIST_rec.sold_to_org_id
1745: , p_PRICE_LIST_rec.locked_from_list_header_id
1746: );
1747:
1748: insert into QP_LIST_HEADERS_TL (
1749: LAST_UPDATE_LOGIN,
1750: NAME,
1751: DESCRIPTION,
1752: VERSION_NO,

Line 1776: from QP_LIST_HEADERS_TL T

1772: from FND_LANGUAGES L
1773: where L.INSTALLED_FLAG in ('I', 'B')
1774: and not exists
1775: (select NULL
1776: from QP_LIST_HEADERS_TL T
1777: where T.LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
1778: and T.LANGUAGE = L.LANGUAGE_CODE);
1779:
1780: IF p_PRICE_LIST_rec.list_type_code = 'AGR' THEN

Line 1834: delete from QP_LIST_HEADERS_TL

1830: and qualifier_context = 'MODLIST'
1831: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4' );
1832:
1833:
1834: delete from QP_LIST_HEADERS_TL
1835: where LIST_HEADER_ID = p_list_header_id;
1836:
1837: /*
1838: if (sql%notfound) then

Line 1987: FROM QP_LIST_HEADERS_TL

1983: , VERSION_NO
1984: INTO l_PRICE_LIST_rec.name
1985: , l_PRICE_LIST_rec.description
1986: , l_PRICE_LIST_rec.version_no
1987: FROM QP_LIST_HEADERS_TL
1988: WHERE LIST_HEADER_ID = p_list_header_id
1989: AND LANGUAGE = userenv('LANG');
1990:
1991:

Line 2024: from QP_LIST_HEADERS_TL

2020: NAME,
2021: DESCRIPTION,
2022: VERSION_NO,
2023: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
2024: from QP_LIST_HEADERS_TL
2025: where LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
2026: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
2027: for update of LIST_HEADER_ID nowait;
2028: