eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OC_INT_SALESCDT_PVT dependencies on OKX_QUOTE_HEADERS_V

Line 75: FROM okx_quote_headers_v

71: -- cursor to retrieve the quote number against a given quote id
72: -- this cursor is used to include the quote number in error messages
73: CURSOR c_qnumber (c_q_id NUMBER) IS
74: SELECT TO_CHAR(quote_number)
75: FROM okx_quote_headers_v
76: WHERE id1 = c_q_id;
77:
78: -- used for including in error messages
79: l_order_number VARCHAR2(120) := OKC_API.G_MISS_CHAR;

Line 157: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

153:
154: ---------------------------------------------------------------------------
155: --Procedure to create contract sales credit information at the header and line levels
156: ----------------------------------------------------------------------------
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,

Line 165: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

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
166: ,
167: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
168:
169: -- this PL/SQL table has quote (or order) lines against contract lines

Line 371: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

367: ----------------------------------------------------------------------------
368: -- Procedure creates sales credit information in OKC from
369: -- ASO or ONT sales credit
370: ----------------------------------------------------------------------------
371: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
372: PROCEDURE get_sales_credit(
373: p_chr_id IN NUMBER,
374: p_q_flag IN VARCHAR2 ,
375: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

Line 375: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

371: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
372: PROCEDURE get_sales_credit(
373: p_chr_id IN NUMBER,
374: p_q_flag IN VARCHAR2 ,
375: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
376: ,
377: p_o_flag IN VARCHAR2 ,
378: p_ohr_id IN NUMBER ,
379: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

Line 481: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

477: ----------------------------------------------------------------------
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 ,

Line 492: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE ,

488: p_ohr_id IN NUMBER ,
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:

Line 501: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1

497: i BINARY_INTEGER := 0;
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,

Line 504: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,

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,
507: cp_ohr_id IN NUMBER,
508: cp_ole_id IN NUMBER) IS

Line 1314: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,

1310: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type
1311: ,
1312: --
1313: p_q_flag IN VARCHAR2 ,
1314: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,
1315: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
1316: --
1317: p_o_flag IN VARCHAR2 ,
1318: p_ohr_id IN OKX_ORDER_HEADERS_V.id1%TYPE ,