APPS.QP_PRICE_LIST_UTIL dependencies on QP_LIST_HEADERS_TL

Line 1440: update QP_LIST_HEADERS_TL set

1436: , ORIG_ORG_ID = p_PRICE_LIST_rec.org_id
1437: WHERE LIST_HEADER_ID = p_PRICE_LIST_rec.list_header_id
1438: ;
1439:
1440: update QP_LIST_HEADERS_TL set
1441: NAME = p_PRICE_LIST_rec.name,
1442: DESCRIPTION = p_PRICE_LIST_rec.description,
1443: LAST_UPDATE_DATE = p_PRICE_LIST_rec.LAST_UPDATE_DATE,
1444: LAST_UPDATED_BY = p_PRICE_LIST_rec.LAST_UPDATED_BY,

Line 1609: insert into QP_LIST_HEADERS_TL (

1605: , p_PRICE_LIST_rec.sold_to_org_id
1606: , p_PRICE_LIST_rec.locked_from_list_header_id
1607: );
1608:
1609: insert into QP_LIST_HEADERS_TL (
1610: LAST_UPDATE_LOGIN,
1611: NAME,
1612: DESCRIPTION,
1613: VERSION_NO,

Line 1637: from QP_LIST_HEADERS_TL T

1633: from FND_LANGUAGES L
1634: where L.INSTALLED_FLAG in ('I', 'B')
1635: and not exists
1636: (select NULL
1637: from QP_LIST_HEADERS_TL T
1638: where T.LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
1639: and T.LANGUAGE = L.LANGUAGE_CODE);
1640:
1641: IF p_PRICE_LIST_rec.list_type_code = 'AGR' THEN

Line 1695: delete from QP_LIST_HEADERS_TL

1691: and qualifier_context = 'MODLIST'
1692: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4' );
1693:
1694:
1695: delete from QP_LIST_HEADERS_TL
1696: where LIST_HEADER_ID = p_list_header_id;
1697:
1698: /*
1699: if (sql%notfound) then

Line 1848: FROM QP_LIST_HEADERS_TL

1844: , VERSION_NO
1845: INTO l_PRICE_LIST_rec.name
1846: , l_PRICE_LIST_rec.description
1847: , l_PRICE_LIST_rec.version_no
1848: FROM QP_LIST_HEADERS_TL
1849: WHERE LIST_HEADER_ID = p_list_header_id
1850: AND LANGUAGE = userenv('LANG');
1851:
1852:

Line 1885: from QP_LIST_HEADERS_TL

1881: NAME,
1882: DESCRIPTION,
1883: VERSION_NO,
1884: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
1885: from QP_LIST_HEADERS_TL
1886: where LIST_HEADER_ID = p_PRICE_LIST_rec.LIST_HEADER_ID
1887: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
1888: for update of LIST_HEADER_ID nowait;
1889: