[Home] [Help]
84: --this puts price adjustment relationship information in OKC
85: --<
86:
87: The OKX related quote pricing views concerned are:
88: okx_qte_prc_atrbs_v
89: okx_qte_prc_adjmnts_v
90: okx_qte_prc_adj_atrbs_v
91: okx_qte_prc_adj_rlshp_v
92:
1851: ) IS
1852:
1853: l_no_data_found BOOLEAN := TRUE;
1854:
1855: ------remove later l_aso_pavv_rec okx_qte_prc_atrbs_v%ROWTYPE;
1856: -------remove later l_ont_pavv_rec okx_ord_prc_atrbs_v%ROWTYPE;
1857: i BINARY_INTEGER := 0;
1858:
1859: -- cursor to get okx_qte_prc_atrbs_v or
1855: ------remove later l_aso_pavv_rec okx_qte_prc_atrbs_v%ROWTYPE;
1856: -------remove later l_ont_pavv_rec okx_ord_prc_atrbs_v%ROWTYPE;
1857: i BINARY_INTEGER := 0;
1858:
1859: -- cursor to get okx_qte_prc_atrbs_v or
1860: -- okx_ord_prc_atrbs_v information
1861: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1862: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1863: CURSOR c_source_pavv_rec (cp_q_flag IN VARCHAR2,
1869: --could be either ASO or ONT
1870: --only ONE of the following two queries in the union will be executed in
1871: --a call depending on which flag (p_q_flag or p_o_flag) is true
1872:
1873: -- first query to get okx_qte_prc_atrbs_v information
1874: SELECT quote_header_id source_header_id,
1875: quote_line_id source_line_id,
1876: flex_title,
1877: pricing_context,
1991: attribute13,
1992: attribute14,
1993: attribute15,
1994: object_version_number
1995: FROM okx_qte_prc_atrbs_v
1996: WHERE cp_q_flag = OKC_API.G_TRUE
1997: AND quote_header_id = cp_qhr_id
1998: AND ((cp_qle_id = OKC_API.G_MISS_NUM AND quote_line_id IS NULL) OR
1999: (cp_qle_id <> OKC_API.G_MISS_NUM AND quote_line_id = cp_qle_id))
2170: i := g_pavv_tab.COUNT + 1;
2171: FETCH c_source_pavv_rec INTO l_source_pavv_rec;
2172: EXIT WHEN c_source_pavv_rec%NOTFOUND;
2173:
2174: -- map okx_qte_prc_atrbs_v or
2175: -- okx_ord_prc_atrbs_v to OKC_PRICE_ATT_VALUES
2176:
2177: -- we don't need to enter the ID because it is automatically generated
2178:
3865: b_o_flag IN VARCHAR, b_oh_id NUMBER, b_ol_id NUMBER ) IS
3866: SELECT
3867: qpattr.PRICE_ATTRIBUTE_ID -- quote header price attribute id
3868: FROM
3869: OKX_QTE_PRC_ATRBS_V qpattr
3870: WHERE b_q_flag = OKC_API.G_TRUE
3871: AND qpattr.quote_header_id = b_qh_id
3872: AND (( b_ql_id IS NULL AND qpattr.quote_line_id IS NULL ) OR
3873: (b_ql_id IS NOT NULL AND qpattr.quote_line_id = b_ql_id ))