[Home] [Help]
195:
196: IF p_doc_type = OE_CONTRACTS_UTIL.G_BSA_DOC_TYPE THEN
197: SELECT version_number
198: INTO l_latest_version_number
199: FROM oe_blanket_headers_all
200: WHERE header_id = p_copy_from_doc_id;
201:
202: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
203: SELECT version_number
1172: /*********
1173: --cursor to get the version number of the blanket
1174: CURSOR c_get_bsa_version (cp_header_id NUMBER) IS
1175: SELECT version_number
1176: FROM oe_blanket_headers_all
1177: WHERE header_id = cp_header_id;
1178:
1179:
1180: --cursor to get the version number of the sales order
1878: IS
1879:
1880:
1881:
1882: /** note: in cursors based on table OE_BLANKET_HEADERS_ALL, we select on the basis
1883: of HEADER_ID only as it is unique and an index is based on that, we don't need SALES_DOCUMENT_TYPE_CODE **/
1884:
1885: --cursor to fetch value of header level variables such as OKC$S_BLANKET_NUMBER etc. for blankets
1886: CURSOR c_get_bsa_header_variables IS
1901: bh.invoicing_rule_id,
1902: bhe.blanket_min_amount,
1903: bhe.blanket_max_amount,
1904: bh.org_id
1905: FROM oe_blanket_headers_all bh,
1906: oe_blanket_headers_ext bhe
1907: WHERE bh.header_id = p_doc_id
1908: AND bh.order_number = bhe.order_number;
1909:
1951: END IF;
1952:
1953:
1954: -- For articles QA: -
1955: -- Query OM tables OE_BLANKET_HEADERS_ALL and OE_BLANKET_HEADERS_EXT to retrieve values against variable codes
1956: -- sent in by calling articles QA API.
1957:
1958: ----IF p_sys_var_value_tbl.COUNT > 0 THEN
1959: IF p_sys_var_value_tbl.FIRST IS NOT NULL THEN
2399: END IF;
2400:
2401:
2402: -- For articles wizard expert: -
2403: -- Query OM tables OE_BLANKET_HEADERS_ALL and OE_BLANKET_LINES_ALL to retrieve values against variable codes sent
2404: -- in by calling articles wizard expert API
2405:
2406: IF p_line_var_tbl.FIRST IS NOT NULL THEN
2407: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP