[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
1887: IS
1888:
1889:
1890:
1891: /** note: in cursors based on table OE_BLANKET_HEADERS_ALL, we select on the basis
1892: of HEADER_ID only as it is unique and an index is based on that, we don't need SALES_DOCUMENT_TYPE_CODE **/
1893:
1894: --cursor to fetch value of header level variables such as OKC$S_BLANKET_NUMBER etc. for blankets
1895: CURSOR c_get_bsa_header_variables IS
1910: bh.invoicing_rule_id,
1911: bhe.blanket_min_amount,
1912: bhe.blanket_max_amount,
1913: bh.org_id
1914: FROM oe_blanket_headers_all bh,
1915: oe_blanket_headers_ext bhe
1916: WHERE bh.header_id = p_doc_id
1917: AND bh.order_number = bhe.order_number;
1918:
1960: END IF;
1961:
1962:
1963: -- For articles QA: -
1964: -- Query OM tables OE_BLANKET_HEADERS_ALL and OE_BLANKET_HEADERS_EXT to retrieve values against variable codes
1965: -- sent in by calling articles QA API.
1966:
1967: ----IF p_sys_var_value_tbl.COUNT > 0 THEN
1968: IF p_sys_var_value_tbl.FIRST IS NOT NULL THEN
2408: END IF;
2409:
2410:
2411: -- For articles wizard expert: -
2412: -- Query OM tables OE_BLANKET_HEADERS_ALL and OE_BLANKET_LINES_ALL to retrieve values against variable codes sent
2413: -- in by calling articles wizard expert API
2414:
2415: IF p_line_var_tbl.FIRST IS NOT NULL THEN
2416: FOR i IN p_line_var_tbl.FIRST..p_line_var_tbl.LAST LOOP