DBA Data[Home] [Help]

APPS.OKC_OC_INT_PRICING_PVT dependencies on OKX_QUOTE_LINES_V

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

1174: -- PROCEDURE to get PRICE ADJUSTMENTS information from ASO or ONT tables
1175: -- get_patv_tab stores it's output in global PL/SQL table g_patv_tab
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 ,

Line 1188: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE

1184: p_ole_id IN NUMBER ,
1185: p_q_flag IN VARCHAR2 ,
1186: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1187: ,
1188: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
1189: ) IS
1190:
1191:
1192: --------------l_no_data_found BOOLEAN := TRUE;

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

1195:
1196: --cursor to get okx_qte_prc_adjmnts_v or
1197: -- okx_ord_prc_adjmnts_v information
1198: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1199: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1200: CURSOR c_source_patv_rec (cp_q_flag IN VARCHAR2,
1201: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,
1202: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,
1203: cp_o_flag IN VARCHAR2,

Line 1202: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,

1198: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1199: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1200: CURSOR c_source_patv_rec (cp_q_flag IN VARCHAR2,
1201: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,
1202: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,
1203: cp_o_flag IN VARCHAR2,
1204: cp_ohr_id IN NUMBER,
1205: cp_ole_id IN NUMBER) IS
1206: --could be either ASO or ONT

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

1834: -- PROCEDURE to get PRICE ATTRIBUTES information from ASO or ONT tables
1835: -- get_pavv_tab stores it's output in global PL/SQL table g_pavv_tab
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:

Line 1850: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE

1846:
1847: p_q_flag IN VARCHAR2 ,
1848: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1849: ,
1850: p_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE
1851: ) IS
1852:
1853: l_no_data_found BOOLEAN := TRUE;
1854:

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

1858:
1859: -- cursor to get okx_qte_prc_atrbs_v or
1860: -- okx_ord_prc_atrbs_v information
1861: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1862: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1863: CURSOR c_source_pavv_rec (cp_q_flag IN VARCHAR2,
1864: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,
1865: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,
1866: cp_o_flag IN VARCHAR2,

Line 1865: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,

1861: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1862: -- ASO_QUOTE_LINES_ALL.LINE_HEADER_ID to OKX_QUOTE_LINES_V.ID1
1863: CURSOR c_source_pavv_rec (cp_q_flag IN VARCHAR2,
1864: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,
1865: cp_qle_id IN OKX_QUOTE_LINES_V.ID1%TYPE,
1866: cp_o_flag IN VARCHAR2,
1867: cp_ohr_id IN NUMBER,
1868: cp_ole_id IN NUMBER) IS
1869: --could be either ASO or ONT