APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKX_QUOTE_LINES_V

Line 482: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1

478: -- PROCEDURE to get SALES CREDITS information from ASO or ONT tables
479: -- get_sales_credit_tab stores it's output in global PL/SQL table g_sales_credit_tab
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:

Line 493: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE ) IS

489: p_ole_id IN NUMBER ,
490:
491: p_q_flag IN VARCHAR2 ,
492: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE ,
493: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE ) IS
494:
495: l_no_data_found BOOLEAN := TRUE;
496:
497: i BINARY_INTEGER := 0;

Line 502: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1

498:
499: -- cursor to get okx_qte_sls_credits_v or
500: -- okx_ord_sls_credits_v information
501: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
502: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
503: CURSOR c_source_sales_credit_rec (cp_q_flag IN VARCHAR2,
504: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,
505: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,
506: cp_o_flag IN VARCHAR2,

Line 505: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,

501: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
502: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
503: CURSOR c_source_sales_credit_rec (cp_q_flag IN VARCHAR2,
504: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,
505: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,
506: cp_o_flag IN VARCHAR2,
507: cp_ohr_id IN NUMBER,
508: cp_ole_id IN NUMBER) IS
509: --could be either ASO or ONT