35: IF p_alert_type = 'MTD' THEN
36: SELECT
37: MTD_ALERT INTO x_return_value
38: FROM
39: ozf_quota_alerts
40: WHERE
41: ship_to_site_use_id = p_object_id
42: AND report_date = p_report_date
43: AND resource_id = p_resource_id
45: ELSIF p_alert_type = 'QTD' THEN
46: SELECT
47: QTD_ALERT INTO x_return_value
48: FROM
49: ozf_quota_alerts
50: WHERE
51: ship_to_site_use_id = p_object_id
52: AND report_date = p_report_date
53: AND resource_id = p_resource_id
55: ELSIF p_alert_type = 'YTD' THEN
56: SELECT
57: YTD_ALERT INTO x_return_value
58: FROM
59: ozf_quota_alerts
60: WHERE
61: ship_to_site_use_id = p_object_id
62: AND report_date = p_report_date
63: AND resource_id = p_resource_id
65: ELSIF p_alert_type = 'BACK_ORDER' THEN
66: SELECT
67: BACK_ORDER_ALERT INTO x_return_value
68: FROM
69: ozf_quota_alerts
70: WHERE
71: ship_to_site_use_id = p_object_id
72: AND report_date = p_report_date
73: AND resource_id = p_resource_id
75: ELSIF p_alert_type = 'OUTSTAND_ORDER' THEN
76: SELECT
77: OUTSTAND_ORDER_ALERT INTO x_return_value
78: FROM
79: ozf_quota_alerts
80: WHERE
81: ship_to_site_use_id = p_object_id
82: AND report_date = p_report_date
83: AND resource_id = p_resource_id
120: IF p_alert_type = 'MTD' THEN
121: SELECT
122: MTD_ALERT INTO x_return_value
123: FROM
124: ozf_quota_alerts
125: WHERE
126: cust_account_id = p_cust_account_id
127: AND ship_to_site_use_id = p_site_use_id
128: AND report_date = p_report_date
131: ELSIF p_alert_type = 'QTD' THEN
132: SELECT
133: QTD_ALERT INTO x_return_value
134: FROM
135: ozf_quota_alerts
136: WHERE
137: cust_account_id = p_cust_account_id
138: AND ship_to_site_use_id = p_site_use_id
139: AND report_date = p_report_date
142: ELSIF p_alert_type = 'YTD' THEN
143: SELECT
144: YTD_ALERT INTO x_return_value
145: FROM
146: ozf_quota_alerts
147: WHERE
148: cust_account_id = p_cust_account_id
149: AND ship_to_site_use_id = p_site_use_id
150: AND report_date = p_report_date
153: ELSIF p_alert_type = 'BACK_ORDER' THEN
154: SELECT
155: BACK_ORDER_ALERT INTO x_return_value
156: FROM
157: ozf_quota_alerts
158: WHERE
159: cust_account_id = p_cust_account_id
160: AND ship_to_site_use_id = p_site_use_id
161: AND report_date = p_report_date
164: ELSIF p_alert_type = 'OUTSTAND_ORDER' THEN
165: SELECT
166: OUTSTAND_ORDER_ALERT INTO x_return_value
167: FROM
168: ozf_quota_alerts
169: WHERE
170: cust_account_id = p_cust_account_id
171: AND ship_to_site_use_id = p_site_use_id
172: AND report_date = p_report_date
211: IF p_alert_type = 'MTD' THEN
212: SELECT
213: MTD_ALERT INTO x_return_value
214: FROM
215: ozf_quota_alerts
216: WHERE
217: product_attribute = p_product_attribute
218: AND product_attr_value = p_product_attr_value
219: AND report_date = p_report_date
222: ELSIF p_alert_type = 'QTD' THEN
223: SELECT
224: QTD_ALERT INTO x_return_value
225: FROM
226: ozf_quota_alerts
227: WHERE
228: product_attribute = p_product_attribute
229: AND product_attr_value = p_product_attr_value
230: AND report_date = p_report_date
233: ELSIF p_alert_type = 'YTD' THEN
234: SELECT
235: YTD_ALERT INTO x_return_value
236: FROM
237: ozf_quota_alerts
238: WHERE
239: product_attribute = p_product_attribute
240: AND product_attr_value = p_product_attr_value
241: AND report_date = p_report_date
244: ELSIF p_alert_type = 'BACK_ORDER' THEN
245: SELECT
246: BACK_ORDER_ALERT INTO x_return_value
247: FROM
248: ozf_quota_alerts
249: WHERE
250: product_attribute = p_product_attribute
251: AND product_attr_value = p_product_attr_value
252: AND report_date = p_report_date
255: ELSIF p_alert_type = 'OUTSTAND_ORDER' THEN
256: SELECT
257: OUTSTAND_ORDER_ALERT INTO x_return_value
258: FROM
259: ozf_quota_alerts
260: WHERE
261: product_attribute = p_product_attribute
262: AND product_attr_value = p_product_attr_value
263: AND report_date = p_report_date