[Home] [Help]
312: CURSOR GET_DOC_INFO(p_header_In NUMBER) IS
313: SELECT order_number,
314: version_number,
315: order_type_id
316: FROM OE_ORDER_HEADERS
317: WHERE header_id = p_header_in;
318:
319: --
320: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
381: IS
382: l_api_name CONSTANT VARCHAR(30) := 'Copy_Header';
383: l_orig_category VARCHAR2(30);
384: l_cpy_category VARCHAR2(30);
385: l_orig_ship_from_org_id OE_Order_Headers.ship_from_org_id%TYPE;
386: --
387: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
388: --
389: --R12 CC Encryption
893:
894: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
895: SELECT version_number
896: INTO l_v_number
897: FROM oe_order_headers
898: WHERE header_id = p_header_id;
899:
900: IF NOT OE_GLOBALS.EQUAL(l_v_number,p_version_number) THEN
901: RETURN l_action_request_tbl;
1060: From Oe_invoice_to_orgs_v
1061: Where organization_id = oe_order_cache.g_header_rec.invoice_to_org_id;
1062: Select invoice_to_org_id
1063: into l_invoice_to_org_id
1064: from oe_order_headers_all
1065: where header_id = p_header_id;
1066:
1067: --populate the header payment table with the trxn_extension_id
1068: --before process order api is called for the new order.
3772: -- Get header_id from first line.
3773: l_line_id := p_line_id_tbl(1).id1;
3774:
3775: -- Set the version number as NULL so that the current version
3776: -- of Order Header will be selected from oe_order_headers.
3777:
3778: l_copy_rec.version_number := NULL;
3779: l_copy_rec.phase_change_flag := NULL;
3780:
3878: l_cpy_category := Get_Order_Category(p_copy_rec.hdr_type);
3879: IF nvl(l_cpy_category,'NULL') <> 'RETURN' THEN --R12 CC Encryption
3880: --bug 5113795
3881: select payment_type_code into l_payment_type_code
3882: from oe_order_headers_all where header_id = l_header_id;
3883: IF l_debug_level > 0 THEN
3884: oe_debug_pub.add('Payment type code in copy order..ksurendr'||l_payment_type_code);
3885: oe_debug_pub.add('Header_id ...'||l_header_id);
3886: oe_debug_pub.add('Copy Header Payments flag...'||l_copy_header_payments);
3904: END IF;
3905: END IF;
3906:
3907: -- Pre-populate header_id on the header record.
3908: SELECT OE_ORDER_HEADERS_S.NEXTVAL
3909: INTO l_header_rec.header_id
3910: FROM DUAL;
3911:
3912: --R12 CC Encryption
4300: BEGIN
4301: l_to_header_id := l_header_rec.header_id;
4302: SELECT header_id
4303: INTO l_dummy_header
4304: FROM OE_ORDER_HEADERS
4305: WHERE header_id = l_header_rec.header_id;
4306: EXCEPTION
4307: WHEN NO_DATA_FOUND THEN
4308: l_header_exists := FALSE;
5457: l.top_model_line_id,
5458: l.item_type_code
5459: FROM
5460: oe_order_lines l,
5461: oe_order_headers h
5462: WHERE l.line_id = l_line_id(i)
5463: and l.header_id = h.header_id
5464: --and h.version_number = NVL(p_version_number,h.version_number) -- bug 7443507
5465: and h.version_number = p_version_number -- bug 7443507
5510: l.top_model_line_id,
5511: l.item_type_code
5512: FROM
5513: oe_order_lines l,
5514: oe_order_headers h
5515: WHERE l.line_id = l_line_id(i)
5516: and l.header_id = h.header_id;
5517:
5518: --bug 7443507 new code ends
5560: l.top_model_line_id,
5561: l.item_type_code
5562: FROM
5563: oe_order_lines l,
5564: oe_order_headers h,
5565: oe_copy_line_sort_tmp c
5566: WHERE c.line_id = c.top_model_line_id
5567: and l.top_model_line_id = c.line_id
5568: --and l.line_id <> l.top_model_line_id --bug 7443507
5620: l.top_model_line_id,
5621: l.item_type_code
5622: FROM
5623: oe_order_lines l,
5624: oe_order_headers h,
5625: oe_copy_line_sort_tmp c
5626: WHERE c.line_id = c.top_model_line_id
5627: and l.top_model_line_id = c.line_id
5628: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')