eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on OZF_QUOTA_ALERTS

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 1312: /*l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '

1308: l_update := FALSE;
1309:
1310: IF p_alert_for = 'PROD' THEN
1311: BEGIN
1312: /*l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '
1313: || 'WHERE report_date = trunc(SYSDATE) AND resource_id = ' || p_resource_id
1314: || 'AND alert_for = ''PROD'' AND product_attribute = ''' || p_product_attribute
1315: || ''' AND product_attr_value = ' || p_attribute2 */
1316: l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '

Line 1316: l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '

1312: /*l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '
1313: || 'WHERE report_date = trunc(SYSDATE) AND resource_id = ' || p_resource_id
1314: || 'AND alert_for = ''PROD'' AND product_attribute = ''' || p_product_attribute
1315: || ''' AND product_attr_value = ' || p_attribute2 */
1316: l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '
1317: || 'WHERE report_date = trunc(SYSDATE) AND resource_id = :1 '
1318: || 'AND alert_for = ''PROD'' AND product_attribute = :2 '
1319: || 'AND product_attr_value = :3';
1320: EXECUTE IMMEDIATE l_sql_stmt

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 1376: l_sql_str := 'INSERT INTO OZF_QUOTA_ALERTS ';

1372: OPEN c_quota_alert_seq;
1373: FETCH c_quota_alert_seq INTO l_quota_alert_id;
1374: CLOSE c_quota_alert_seq;
1375:
1376: l_sql_str := 'INSERT INTO OZF_QUOTA_ALERTS ';
1377: l_sql_str := l_sql_str || '(quota_alert_id, report_date, resource_id, alert_for, ';
1378: l_sql_str := l_sql_str || 'product_attribute, product_attr_value, ' || p_select_attribute;
1379: l_sql_str := l_sql_str || ') VALUES (' || l_quota_alert_id || ',''' || TRUNC(SYSDATE) || ''',';
1380: l_sql_str := l_sql_str || p_resource_id || ','''||'PROD'',''' || p_product_attribute || ''',';

Line 1412: l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '

1408: END;
1409:
1410: ELSIF p_alert_for = 'CUST' THEN
1411: BEGIN
1412: l_sql_stmt := 'SELECT ' || p_select_attribute || ' FROM OZF_QUOTA_ALERTS '
1413: || 'WHERE report_date = trunc(SYSDATE) AND resource_id = :1 '
1414: || 'AND alert_for = ''CUST'' AND cust_account_id = :2 '
1415: || 'AND ship_to_site_use_id = :3';
1416: EXECUTE IMMEDIATE l_sql_stmt

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';

Line 1473: l_sql_str := 'INSERT INTO OZF_QUOTA_ALERTS ';

1469: OPEN c_quota_alert_seq;
1470: FETCH c_quota_alert_seq INTO l_quota_alert_id;
1471: CLOSE c_quota_alert_seq;
1472:
1473: l_sql_str := 'INSERT INTO OZF_QUOTA_ALERTS ';
1474: l_sql_str := l_sql_str || '(quota_alert_id, report_date, resource_id, alert_for, ';
1475: l_sql_str := l_sql_str || 'cust_account_id, ship_to_site_use_id, ' || p_select_attribute;
1476: l_sql_str := l_sql_str || ') VALUES (' || l_quota_alert_id || ',''' || TRUNC(SYSDATE) || ''',';
1477: l_sql_str := l_sql_str || p_resource_id || ','''||'CUST'',''' || p_cust_account_id || ''',';