[Home] [Help]
137: -- cursor to retrieve the contract number against a given contract id
138: -- this cursor is used to include the contract number in error messages
139: CURSOR c_knumber (c_k_id NUMBER) IS
140: SELECT contract_number
141: FROM okc_k_headers_b
142: WHERE id = c_k_id;
143:
144: -- cursor to retrieve the order number against a given order id
145: -- this cursor is used to include the order number in error messages
256: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
257: PROCEDURE create_k_pricing (
258: x_return_status OUT NOCOPY VARCHAR2,
259:
260: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
261: p_o_flag IN VARCHAR2 ,
262: p_ohr_id IN NUMBER ,
263: p_q_flag IN VARCHAR2 ,
264: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1176: ----------------------------------------------------------------------------
1177: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1178: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1179: PROCEDURE get_patv_tab(
1180: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1181: p_cle_id IN OKC_K_LINES_B.ID%TYPE ,
1182: p_o_flag IN VARCHAR2 ,
1183: p_ohr_id IN NUMBER ,
1184: p_ole_id IN NUMBER ,
1836: ----------------------------------------------------------------------
1837: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1838: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1839: PROCEDURE get_pavv_tab(
1840: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
1841: p_cle_id IN OKC_K_LINES_B.ID%TYPE ,
1842:
1843: p_o_flag IN VARCHAR2 ,
1844: p_ohr_id IN NUMBER ,
4830: --
4831:
4832:
4833: PROCEDURE build_pricing_from_k(
4834: p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
4835: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type ,
4836: --
4837: p_q_flag IN VARCHAR2 ,
4838: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,