DBA Data[Home] [Help]

APPS.OE_STANDARD_WF dependencies on OE_BLANKET_HEADERS_ALL

Line 481: FROM oe_blanket_headers_all

477: WHERE header_id = to_number (p_itemkey);
478: ELSIF l_sales_document_type_code = 'B' THEN
479: SELECT org_id
480: INTO l_org_id
481: FROM oe_blanket_headers_all
482: WHERE header_id = to_number (p_itemkey);
483: ELSE
484: -- Should never get here. In negotiation phase it should be O or B
485: oe_debug_pub.add('l_sales_document_type_code is NULL for:' || p_itemkey);

Line 525: FROM oe_blanket_headers_all

521: WHERE header_id = to_number (p_itemkey);
522: ELSIF l_sales_document_type_code = 'B' THEN
523: SELECT org_id
524: INTO l_org_id
525: FROM oe_blanket_headers_all
526: WHERE header_id = to_number (p_itemkey);
527: ELSE
528: -- Should never get here. In negotiation phase it should be O or B
529: oe_debug_pub.add('l_sales_document_type_code is NULL for:' || p_itemkey);

Line 623: FROM oe_blanket_headers_all

619:
620: IF G_RESET_APPS_CONTEXT THEN
621: SELECT org_id
622: INTO l_org_id
623: FROM oe_blanket_headers_all
624: WHERE header_id = to_number (p_itemkey);
625:
626: MO_GLOBAL.set_policy_context ('S', l_org_id);
627:

Line 654: FROM oe_blanket_headers_all

650: OE_GLOBALS.G_FLOW_RESTARTED := TRUE;
651:
652: SELECT org_id
653: INTO l_org_id
654: FROM oe_blanket_headers_all
655: WHERE header_id = to_number (p_itemkey);
656: IF l_debug_level > 0 THEN
657: oe_debug_pub.add('ORG ID IS ' || l_org_id ) ;
658: END IF;