APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on OZF_QUOTA_ALERTS_S

Line 393: UPDATE OZF_QUOTA_ALERTS SET mtd_alert = NULL, qtd_alert = NULL,

389:
390: IF l_resource_list.FIRST IS NOT NULL AND l_resource_list.LAST IS NOT NULL THEN
391:
392: FORALL i in l_resource_list.FIRST .. l_resource_list.LAST
393: UPDATE OZF_QUOTA_ALERTS SET mtd_alert = NULL, qtd_alert = NULL,
394: ytd_alert = NULL, back_order_alert = NULL, outstand_order_alert = NULL
395: WHERE report_date = trunc(sysdate) and resource_id = l_resource_list(i);
396:
397: FORALL i in l_resource_list.FIRST .. l_resource_list.LAST

Line 1271: SELECT ozf_quota_alerts_s.NEXTVAL

1267: l_quota_alert_id NUMBER;
1268: l_update BOOLEAN;
1269:
1270: CURSOR c_quota_alert_seq IS
1271: SELECT ozf_quota_alerts_s.NEXTVAL
1272: FROM DUAL;
1273:
1274: BEGIN
1275: -- Standard call to check for call compatibility.

Line 1341: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;

1337:
1338: IF l_update THEN
1339:
1340: /*
1341: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;
1342: l_sql_str := l_sql_str || ' = ''' || l_new_alert_type ;
1343: l_sql_str := l_sql_str || ''' WHERE report_date = trunc(SYSDATE) AND resource_id = ' || p_resource_id;
1344: l_sql_str := l_sql_str || ' AND alert_for = ''PROD'' AND product_attribute = ''' || p_product_attribute;
1345: l_sql_str := l_sql_str || ''' AND product_attr_value = ' || p_attribute2;

Line 1360: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;

1356: l_ignore := DBMS_SQL.execute(l_ins_csr);
1357: */
1358:
1359: --kvattiku updated
1360: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;
1361: l_sql_str := l_sql_str || ' = :1 ';
1362: l_sql_str := l_sql_str || ' WHERE report_date = trunc(SYSDATE) AND resource_id = :2';
1363: l_sql_str := l_sql_str || ' AND alert_for = ''PROD'' AND product_attribute = :3';
1364: l_sql_str := l_sql_str || ' AND product_attr_value = :4';

Line 1437: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;

1433:
1434: IF l_update THEN
1435:
1436: /* commented by kvattiku
1437: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;
1438: l_sql_str := l_sql_str || ' = ''' || l_new_alert_type ;
1439: l_sql_str := l_sql_str || ''' WHERE report_date = trunc(SYSDATE) AND resource_id = ' || p_resource_id;
1440: l_sql_str := l_sql_str || ' AND alert_for = ''CUST'' AND cust_account_id = ''' || p_cust_account_id;
1441: l_sql_str := l_sql_str || ''' AND ship_to_site_use_id = ' || p_attribute2;

Line 1456: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;

1452: l_ignore := DBMS_SQL.execute(l_ins_csr);
1453: */
1454:
1455: --added by kvattiku
1456: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;
1457: l_sql_str := l_sql_str || ' = :1';
1458: l_sql_str := l_sql_str || ' WHERE report_date = trunc(SYSDATE) AND resource_id = :2';
1459: l_sql_str := l_sql_str || ' AND alert_for = ''CUST'' AND cust_account_id = :3';
1460: l_sql_str := l_sql_str || ' AND ship_to_site_use_id = :4';