[Home] [Help]
57: -- cursor to retrieve the contract number against a given contract id
58: -- this cursor is used to include the contract number in error messages
59: CURSOR c_knumber (c_k_id NUMBER) IS
60: SELECT contract_number
61: FROM okc_k_headers_b
62: WHERE id = c_k_id;
63:
64: -- cursor to retrieve the order number against a given order id
65: -- this cursor is used to include the order number in error messages
157: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
158: PROCEDURE create_k_sales_credit (
159: x_return_status OUT NOCOPY VARCHAR2,
160:
161: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
162: p_o_flag IN VARCHAR2 ,
163: p_ohr_id IN NUMBER ,
164: p_q_flag IN VARCHAR2 ,
165: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
480: ----------------------------------------------------------------------
481: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
482: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
483: PROCEDURE get_sales_credit_tab(
484: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
485: p_cle_id IN OKC_K_LINES_B.ID%TYPE ,
486:
487: p_o_flag IN VARCHAR2 ,
488: p_ohr_id IN NUMBER ,
1305: --
1306: -- ========================================
1307:
1308: PROCEDURE build_sales_credit_from_k(
1309: p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
1310: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type
1311: ,
1312: --
1313: p_q_flag IN VARCHAR2 ,