APPS.OKC_SPLIT2_PAV_PVT dependencies on OKC_PRICE_ATT_VALUES

Line 236: INSERT INTO okc_price_att_values

232:
233: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
234:
235: BEGIN
236: INSERT INTO okc_price_att_values
237: (
238:
239: id,
240: flex_title,

Line 674: FROM okc_price_att_values_h

670: program_id,
671: program_update_date,
672: request_id,
673: object_version_number
674: FROM okc_price_att_values_h
675: WHERE chr_id = p_chr_id
676: AND major_version = p_major_version
677: UNION /* bugfix 2138898 - OR is replaced by UNION */
678: SELECT

Line 895: FROM okc_price_att_values_h

891: program_id,
892: program_update_date,
893: request_id,
894: object_version_number
895: FROM okc_price_att_values_h
896: WHERE cle_id IN
897: (SELECT id
898: FROM OKC_K_LINES_B
899: WHERE dnz_chr_id = p_chr_id

Line 920: -- Procedure for mass insert in OKC_PRICE_ATT_VALUES _B and TL tables

916: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
917: return l_return_status;
918: END restore_version;
919: ---------------------------------------------------------------
920: -- Procedure for mass insert in OKC_PRICE_ATT_VALUES _B and TL tables
921: ---------------------------------------------------------------
922: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_pavv_tbl OKC_PAV_PVT.pavv_tbl_type) IS
923: l_tabsize NUMBER := p_pavv_tbl.COUNT;
924: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 1372: INTO OKC_PRICE_ATT_VALUES

1368: END LOOP;
1369:
1370: FORALL i in 1..l_tabsize
1371: INSERT
1372: INTO OKC_PRICE_ATT_VALUES
1373: (
1374: id,
1375: flex_title,
1376: pricing_context,