[Home] [Help]
351: CURSOR GET_DOC_INFO(p_header_In NUMBER) IS
352: SELECT order_number,
353: version_number,
354: order_type_id
355: FROM OE_ORDER_HEADERS
356: WHERE header_id = p_header_in;
357:
358: --
359: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
420: IS
421: l_api_name CONSTANT VARCHAR(30) := 'Copy_Header';
422: l_orig_category VARCHAR2(30);
423: l_cpy_category VARCHAR2(30);
424: l_orig_ship_from_org_id OE_Order_Headers.ship_from_org_id%TYPE;
425: --
426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
427: --
428: --R12 CC Encryption
965:
966: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
967: SELECT version_number
968: INTO l_v_number
969: FROM oe_order_headers_all /*Modified to base table for bug 9701486 */
970: WHERE header_id = p_header_id;
971:
972: IF NOT OE_GLOBALS.EQUAL(l_v_number,p_version_number) THEN
973: RETURN l_action_request_tbl;
1132: From Oe_invoice_to_orgs_v
1133: Where organization_id = oe_order_cache.g_header_rec.invoice_to_org_id;
1134: Select invoice_to_org_id
1135: into l_invoice_to_org_id
1136: from oe_order_headers_all
1137: where header_id = p_header_id;
1138:
1139: --populate the header payment table with the trxn_extension_id
1140: --before process order api is called for the new order.
3922: -- Get header_id from first line.
3923: l_line_id := p_line_id_tbl(1).id1;
3924:
3925: -- Set the version number as NULL so that the current version
3926: -- of Order Header will be selected from oe_order_headers.
3927:
3928: l_copy_rec.version_number := NULL;
3929: l_copy_rec.phase_change_flag := NULL;
3930:
4028: l_cpy_category := Get_Order_Category(p_copy_rec.hdr_type);
4029: IF nvl(l_cpy_category,'NULL') <> 'RETURN' THEN --R12 CC Encryption
4030: --bug 5113795
4031: select payment_type_code into l_payment_type_code
4032: from oe_order_headers_all where header_id = l_header_id;
4033: IF l_debug_level > 0 THEN
4034: oe_debug_pub.add('Payment type code in copy order..ksurendr'||l_payment_type_code);
4035: oe_debug_pub.add('Header_id ...'||l_header_id);
4036: oe_debug_pub.add('Copy Header Payments flag...'||l_copy_header_payments);
4054: END IF;
4055: END IF;
4056:
4057: -- Pre-populate header_id on the header record.
4058: SELECT OE_ORDER_HEADERS_S.NEXTVAL
4059: INTO l_header_rec.header_id
4060: FROM DUAL;
4061:
4062: --R12 CC Encryption
4450: BEGIN
4451: l_to_header_id := l_header_rec.header_id;
4452: SELECT header_id
4453: INTO l_dummy_header
4454: FROM OE_ORDER_HEADERS
4455: WHERE header_id = l_header_rec.header_id;
4456: EXCEPTION
4457: WHEN NO_DATA_FOUND THEN
4458: l_header_exists := FALSE;
5628: l.top_model_line_id,
5629: l.item_type_code
5630: FROM
5631: oe_order_lines l,
5632: oe_order_headers h
5633: WHERE l.line_id = l_line_id(i)
5634: and l.header_id = h.header_id
5635: --and h.version_number = NVL(p_version_number,h.version_number) -- bug 7443507
5636: and h.version_number = p_version_number -- bug 7443507
5681: l.top_model_line_id,
5682: l.item_type_code
5683: FROM
5684: oe_order_lines l,
5685: oe_order_headers h
5686: WHERE l.line_id = l_line_id(i)
5687: and l.header_id = h.header_id;
5688:
5689: --bug 7443507 new code ends
5731: l.top_model_line_id,
5732: l.item_type_code
5733: FROM
5734: oe_order_lines l,
5735: oe_order_headers h,
5736: oe_copy_line_sort_tmp c
5737: WHERE c.line_id = c.top_model_line_id
5738: and l.top_model_line_id = c.line_id
5739: --and l.line_id <> l.top_model_line_id --bug 7443507
5791: l.top_model_line_id,
5792: l.item_type_code
5793: FROM
5794: oe_order_lines l,
5795: oe_order_headers h,
5796: oe_copy_line_sort_tmp c
5797: WHERE c.line_id = c.top_model_line_id
5798: and l.top_model_line_id = c.line_id
5799: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')