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_PRICING_PVT dependencies on OKX_QUOTE_HEADERS_V

Line 155: FROM okx_quote_headers_v

151: -- cursor to retrieve the quote number against a given quote id
152: -- this cursor is used to include the quote number in error messages
153: CURSOR c_qnumber (c_q_id NUMBER) IS
154: SELECT TO_CHAR(quote_number)
155: FROM okx_quote_headers_v
156: WHERE id1 = c_q_id;
157:
158: -- used for including in error messages
159: l_order_number VARCHAR2(120) := OKC_API.G_MISS_CHAR;

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

252: ***********************************************************************/
253: ---------------------------------------------------------------------------
254: --Procedure to contract pricing information at the header and line levels
255: ----------------------------------------------------------------------------
256: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
257: PROCEDURE create_k_pricing (
258: x_return_status OUT NOCOPY VARCHAR2,
259:
260: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 264: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

260: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
261: p_o_flag IN VARCHAR2 ,
262: p_ohr_id IN NUMBER ,
263: p_q_flag IN VARCHAR2 ,
264: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
265: ,
266: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
267: -- this PL/SQL table has quote (or order) lines against contract lines
268:

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

806: ----------------------------------------------------------------------------
807: -- Procedure creates price attribute information in OKC from
808: -- ASO or ONT pricing
809: ----------------------------------------------------------------------------
810: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
811: PROCEDURE get_price_attr(
812: p_chr_id IN NUMBER,
813: p_q_flag IN VARCHAR2 ,
814: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

Line 814: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

810: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
811: PROCEDURE get_price_attr(
812: p_chr_id IN NUMBER,
813: p_q_flag IN VARCHAR2 ,
814: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
815: ,
816: p_o_flag IN VARCHAR2 ,
817: p_ohr_id IN NUMBER,
818: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

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

926:
927: --------------------------------------------------------------------------
928: --------get price adjustments from ASO or ONT and put in OKC pricing tables
929: --------------------------------------------------------------------------
930: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
931: PROCEDURE get_price_adj(
932: p_chr_id IN NUMBER,
933: p_q_flag IN VARCHAR2 ,
934: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

Line 934: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

930: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
931: PROCEDURE get_price_adj(
932: p_chr_id IN NUMBER,
933: p_q_flag IN VARCHAR2 ,
934: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
935: ,
936: p_o_flag IN VARCHAR2 ,
937: p_ohr_id IN NUMBER ,
938: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type

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

1044: ---------------------------------------------------------------------------
1045:
1046:
1047: --put PRICE ADJUSTMENT RELATIONSHIPS FROM ASO (or ONT) into OKC
1048: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1049: PROCEDURE get_price_adj_rltship(
1050: p_o_flag IN VARCHAR2 ,
1051: p_ohr_id IN NUMBER ,
1052: p_q_flag IN VARCHAR2 ,

Line 1053: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

1049: PROCEDURE get_price_adj_rltship(
1050: p_o_flag IN VARCHAR2 ,
1051: p_ohr_id IN NUMBER ,
1052: p_q_flag IN VARCHAR2 ,
1053: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1054: ,
1055: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
1056: ) IS
1057:

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

1113: END get_price_adj_rltship;
1114:
1115: ----------------------------------------------------------------
1116: --put PRICE ADJUSTMENT ATTRIBUTES FROM ASO or ONT into OKC
1117: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1118: PROCEDURE get_price_adj_attr(
1119: p_o_flag IN VARCHAR2 ,
1120: p_ohr_id IN NUMBER ,
1121: p_q_flag IN VARCHAR2 ,

Line 1122: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

1118: PROCEDURE get_price_adj_attr(
1119: p_o_flag IN VARCHAR2 ,
1120: p_ohr_id IN NUMBER ,
1121: p_q_flag IN VARCHAR2 ,
1122: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1123: ) IS
1124:
1125: i BINARY_INTEGER := 0;
1126:

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

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

Line 1186: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

1182: p_o_flag IN VARCHAR2 ,
1183: p_ohr_id IN NUMBER ,
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:

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

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

Line 1201: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,

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

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

1499: -- PROCEDURE to get PRICE ADJUSTMENT RELATIONSHIP information
1500: -- from ASO or ONT tables
1501: -- get_pacv_tab stores all the price adjustment relationships in
1502: -- global PL/SQL table g_pacv_tab
1503: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
1504: PROCEDURE get_pacv_tab(
1505: p_old_pat_id IN NUMBER ,
1506: p_new_pat_id IN NUMBER ,
1507: p_o_flag IN VARCHAR2 ,

Line 1511: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

1507: p_o_flag IN VARCHAR2 ,
1508: p_ohr_id IN NUMBER
1509: ,
1510: p_q_flag IN VARCHAR2 ,
1511: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
1512: ,
1513: p_line_inf_tab IN OKC_OC_INT_CONFIG_PVT.line_inf_tbl_type
1514: )
1515: IS

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

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

Line 1848: p_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE

1844: p_ohr_id IN NUMBER ,
1845: p_ole_id IN NUMBER ,
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:

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

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

Line 1864: cp_qhr_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE,

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

Line 4838: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,

4834: p_chr_id IN OKC_K_HEADERS_B.id%TYPE,
4835: p_kl_rel_tab IN okc_oc_int_config_pvt.line_rel_tab_type ,
4836: --
4837: p_q_flag IN VARCHAR2 ,
4838: p_qhr_id IN OKX_QUOTE_HEADERS_V.id1%TYPE ,
4839: p_qle_tab IN ASO_QUOTE_PUB.qte_line_tbl_type ,
4840: p_qle_shipment_tab IN ASO_QUOTE_PUB.shipment_tbl_type ,
4841: --
4842: p_o_flag IN VARCHAR2 ,