APPS.OE_DEALS_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 33: OE_ORDER_HEADERS_ALL where header_id = p_header_id;

29: l_TRANSACTION_PHASE_CODE varchar2(1);
30: BEGIN
31:
32: select TRANSACTION_PHASE_CODE into l_TRANSACTION_PHASE_CODE FROM
33: OE_ORDER_HEADERS_ALL where header_id = p_header_id;
34:
35: IF NVL(l_TRANSACTION_PHASE_CODE,'F') = 'F' THEN
36: l_item_type := 'OEOH';
37: ELSE

Line 308: oe_order_headers_all where header_id= l_header_id;

304: ORDER_NUMBER , QUOTE_NUMBER, VERSION_NUMBER, ORDER_TYPE_ID , ORG_ID
305: INTO
306: L_ORDER_NUMBER , L_QUOTE_NUMBER, L_VERSION_NUMBER, L_ORDER_TYPE_ID , L_ORG_ID
307: FROM
308: oe_order_headers_all where header_id= l_header_id;
309:
310: L_ORDER_NUMBER := nvl(L_ORDER_NUMBER, L_QUOTE_NUMBER);
311:
312: l_instance_id := FND_PROFILE.VALUE('QPR_CURRENT_INSTANCE') ;

Line 375: UPDATE oe_order_headers_all SET

371: OE_MSG_PUB.ADD;
372: END IF;
373: return;
374: ELSE
375: UPDATE oe_order_headers_all SET
376: flow_status_code = 'PRICING_APPROVED'
377: WHERE header_id = l_header_id;
378:
379: --Bug 7322917

Line 513: FROM OE_ORDER_HEADERS_ALL

509: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id,
510: ORDER_NUMBER , quote_number, VERSION_NUMBER, ORDER_TYPE_ID , ORG_ID
511: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id,
512: L_ORDER_NUMBER , l_quote_number, L_VERSION_NUMBER, L_ORDER_TYPE_ID , L_ORG_ID
513: FROM OE_ORDER_HEADERS_ALL
514: WHERE HEADER_ID = p_header_id;
515:
516: L_ORDER_NUMBER := nvl(L_ORDER_NUMBER, L_QUOTE_NUMBER); --For Quote Order No is NULL
517:

Line 705: OE_ORDER_HEADERS_ALL where header_id = l_header_id;

701: oe_Debug_pub.setdebuglevel(5);
702: oe_debug_pub.add( 'deals called OM with-event' || EVENT || '-Header-' || l_header_id) ;
703:
704: select TRANSACTION_PHASE_CODE , flow_status_code into l_TRANSACTION_PHASE_CODE , l_status FROM
705: OE_ORDER_HEADERS_ALL where header_id = l_header_id;
706:
707: IF NVL(l_TRANSACTION_PHASE_CODE,'F') = 'F' THEN
708: l_item_type := 'OEOH';
709: ELSE

Line 758: UPDATE oe_order_headers_all SET

754: , x_return_status => x_return_status
755: , x_msg_count => l_msg_count
756: , x_msg_data => l_msg_data);
757: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
758: UPDATE oe_order_headers_all SET
759: flow_status_code = 'PENDING_PRICING_APPROVAL'
760: WHERE header_id = l_header_id;
761: ELSE
762: x_return_status := FND_API.G_RET_STS_ERROR;

Line 774: UPDATE oe_order_headers_all SET

770:
771:
772: --when deal is Approved just change status to Approved in deals, No wf change
773: IF (event = 'APPROVED') THEN
774: UPDATE oe_order_headers_all SET
775: flow_status_code = 'DEAL_APPROVED'
776: WHERE header_id = l_header_id;
777: END IF;
778:

Line 812: UPDATE oe_order_headers_all SET

808: l_new_status:= 'ENTERED';
809: else
810: l_new_status:= 'DRAFT';
811: end if;
812: UPDATE oe_order_headers_all SET
813: flow_status_code = l_new_status
814: WHERE header_id = l_header_id;
815: l_notified_activity := get_notified_activity(to_char(l_header_id) , l_item_type);
816: if( nvl(l_notified_activity,'!@#$@#$') = 'SUBMITTED_DEAL_WB') THEN

Line 1212: FROM OE_ORDER_HEADERS_ALL

1208: END IF;
1209:
1210: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id
1211: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id
1212: FROM OE_ORDER_HEADERS_ALL
1213: WHERE HEADER_ID = p_header_id;
1214:
1215: OE_MSG_PUB.set_msg_context(
1216: p_entity_code => 'HEADER'