APPS.OE_NEGOTIATE_WF dependencies on OE_BLANKET_HEADERS_ALL

Line 482: from oe_blanket_headers_all

478: -- even though there is no offer expiration date for blanket for now
479: -- we will still fetch it for the future
480: select expiration_date
481: into l_expiration_date
482: from oe_blanket_headers_all
483: where header_id = to_number(itemkey);
484: END IF;
485:
486:

Line 633: from oe_blanket_headers_all

629: where header_id = to_number(itemkey);
630: ELSE
631: select sold_to_org_id, expiration_date, salesrep_id
632: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
633: from oe_blanket_headers_all
634: where header_id = to_number(itemkey);
635: END IF;
636:
637: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 710: FROM oe_blanket_headers_all

706: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, l_header_id, 'SALES_DOCUMENT_TYPE_CODE');
707: IF l_sales_document_type_code = 'B' THEN
708: SELECT order_number
709: INTO l_blanket_number
710: FROM oe_blanket_headers_all
711: WHERE header_id = l_header_id;
712:
713: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
714: fnd_message.set_token('BLANKET_NUMBER', to_char(l_blanket_number));

Line 893: from oe_blanket_headers_all

889: raise FND_API.G_EXC_ERROR;
890: ELSE
891: select count(1)
892: into l_bsa_count
893: from oe_blanket_headers_all
894: where header_id = p_header_id;
895:
896: IF l_bsa_count > 0 THEN
897: l_sales_document_type_code := 'B';

Line 1190: from oe_blanket_headers_all

1186: raise FND_API.G_EXC_ERROR;
1187: ELSE --should never come here, given how BSA is coded now
1188: select count(1)
1189: into l_bsa_count
1190: from oe_blanket_headers_all
1191: where header_id = p_header_id;
1192:
1193: IF l_bsa_count > 0 THEN
1194: l_sales_document_type_code := 'B';

Line 1303: from oe_blanket_headers_all

1299: where header_id = p_header_id;
1300: ELSE
1301: select sold_to_org_id, expiration_date, salesrep_id
1302: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
1303: from oe_blanket_headers_all
1304: where header_id = p_header_id;
1305: END IF;
1306:
1307: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 1408: from oe_blanket_headers_all

1404: -- even though there is no offer expiration date for blanket for now
1405: -- we will still fetch it for the future
1406: select expiration_date
1407: into l_expiration_date
1408: from oe_blanket_headers_all
1409: where header_id = to_number(itemkey);
1410: END IF;
1411:
1412: IF l_expiration_date IS NULL THEN