[Home] [Help]
417: This accepts a Requisition Line Id and returns the corresponding
418: Order Header Id.
419:
420: p_type='S' will get it from so_headers/oe_order_headers table and
421: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources
422: ------------------------------------------------------------------
423: */
424: -- aksingh question ask whether they are sending id in ref column ????? 11/28
425: FUNCTION Get_Header_Id (
466: AND nvl(h.org_id,-1) = l_org_id;--added nvl for bug5394855
467: ELSIF p_type = 'D' THEN
468: SELECT max(d.header_id)
469: INTO x_header_id
470: FROM oe_drop_ship_sources d
471: WHERE d.requisition_header_id = p_requisition_header_id
472: AND d.requisition_line_id =
473: nvl(p_requisition_line_id, d.requisition_line_id);
474: END IF;
504: This accepts a Order Header Id and returns the corresponding
505: Requisition Header Id.
506:
507: p_type='S' will get it from so_headers/oe_order_headers table and
508: ='D' will get it from so_drop_ship_sources/oe_drop_ship_sources
509: ------------------------------------------------------------------
510: */
511: FUNCTION Get_Req_Header_Id (
512: p_header_id IN NUMBER
531: SELECT source_document_id
532: INTO x_req_header_id
533: FROM oe_order_headers_all
534: WHERE header_id = p_header_id;
535: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
536: SELECT max(d.requisition_header_id)
537: INTO x_req_header_id
538: FROM oe_drop_ship_sources d
539: WHERE d.header_id = p_header_id;
534: WHERE header_id = p_header_id;
535: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
536: SELECT max(d.requisition_header_id)
537: INTO x_req_header_id
538: FROM oe_drop_ship_sources d
539: WHERE d.header_id = p_header_id;
540: END IF;
541: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
542: IF p_type = 'H' THEN /* From oe_order_headers */
544: INTO x_req_header_id
545: FROM so_headers h, po_requisition_headers r
546: WHERE h.header_id = p_header_id
547: AND h.original_system_reference = r.segment1;
548: ELSIF p_type = 'D' THEN /* From oe_drop_ship_sources */
549: SELECT d.requisition_header_id
550: INTO x_req_header_id
551: FROM so_drop_ship_sources d
552: WHERE d.header_id = p_header_id;
643: l_header_id_count NUMBER := 0;
644: -- Addded not null condition for the bug 3688591
645: CURSOR header_id_cur is
646: SELECT distinct d.requisition_header_id
647: FROM oe_drop_ship_sources d
648: WHERE d.header_id = p_header_id
649: And d.requisition_header_id is not null;
650: --
651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;