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 766: FROM oe_blanket_headers_all

762: IF l_sales_document_type_code = 'B'
763: THEN
764: SELECT order_number
765: INTO l_blanket_number
766: FROM oe_blanket_headers_all
767: WHERE header_id = l_header_id;
768:
769: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
770: fnd_message.set_token ('BLANKET_NUMBER', TO_CHAR (l_blanket_number));

Line 948: from oe_blanket_headers_all

944: raise FND_API.G_EXC_ERROR;
945: ELSE
946: select count(1)
947: into l_bsa_count
948: from oe_blanket_headers_all
949: where header_id = p_header_id;
950:
951: IF l_bsa_count > 0 THEN
952: l_sales_document_type_code := 'B';

Line 1245: from oe_blanket_headers_all

1241: raise FND_API.G_EXC_ERROR;
1242: ELSE --should never come here, given how BSA is coded now
1243: select count(1)
1244: into l_bsa_count
1245: from oe_blanket_headers_all
1246: where header_id = p_header_id;
1247:
1248: IF l_bsa_count > 0 THEN
1249: l_sales_document_type_code := 'B';

Line 1358: from oe_blanket_headers_all

1354: where header_id = p_header_id;
1355: ELSE
1356: select sold_to_org_id, expiration_date, salesrep_id
1357: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
1358: from oe_blanket_headers_all
1359: where header_id = p_header_id;
1360: END IF;
1361:
1362: l_salesrep := OE_Id_To_Value.Salesrep(p_salesrep_id=>l_salesrep_id);

Line 1465: from oe_blanket_headers_all

1461: -- even though there is no offer expiration date for blanket for now
1462: -- we will still fetch it for the future
1463: select expiration_date
1464: into l_expiration_date
1465: from oe_blanket_headers_all
1466: where header_id = to_number(itemkey);
1467: END IF;
1468:
1469: IF l_expiration_date IS NULL THEN