DBA Data[Home] [Help]

APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_QUOTE_LINES_V

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

102: -- PROCEDURE to get PRICE ADJUSTMENTS information from ASO or ONT tables
103: -- get_patv_tab stores it's output in global PL/SQL table g_patv_tbl
104: ----------------------------------------------------------------------------
105: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
106: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
107: PROCEDURE get_patv_tab(
108: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
109: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
110: p_o_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 116: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE

112: p_ole_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
113: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
115: DEFAULT OKC_API.G_MISS_NUM,
116: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
117: DEFAULT OKC_API.G_MISS_NUM);
118:
119:
120: ---------------------------------------------------------------

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

154: -- PROCEDURE to get PRICE ATTRIBUTES information from ASO or ONT tables
155: -- get_pavv_tab stores it's output in global PL/SQL table g_pavv_tbl
156: ----------------------------------------------------------------------
157: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
158: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
159: PROCEDURE get_pavv_tab(
160: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
161: p_cle_id IN OKC_K_LINES_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM,
162:

Line 170: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE

166:
167: p_q_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE, --quote flag
168: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
169: DEFAULT OKC_API.G_MISS_NUM,
170: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
171: DEFAULT OKC_API.G_MISS_NUM);
172:
173:
174: