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 FND_DSQL

Line 1347: FND_DSQL.init;

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;
1346:
1347: FND_DSQL.init;
1348: FND_DSQL.add_text(l_sql_str);
1349: l_ins_csr := DBMS_SQL.open_cursor;
1350: FND_DSQL.set_cursor(l_ins_csr);
1351: l_stmt := FND_DSQL.get_text(FALSE);

Line 1348: FND_DSQL.add_text(l_sql_str);

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;
1346:
1347: FND_DSQL.init;
1348: FND_DSQL.add_text(l_sql_str);
1349: l_ins_csr := DBMS_SQL.open_cursor;
1350: FND_DSQL.set_cursor(l_ins_csr);
1351: l_stmt := FND_DSQL.get_text(FALSE);
1352:

Line 1350: FND_DSQL.set_cursor(l_ins_csr);

1346:
1347: FND_DSQL.init;
1348: FND_DSQL.add_text(l_sql_str);
1349: l_ins_csr := DBMS_SQL.open_cursor;
1350: FND_DSQL.set_cursor(l_ins_csr);
1351: l_stmt := FND_DSQL.get_text(FALSE);
1352:
1353: FND_FILE.PUT_LINE(FND_FILE.LOG,'product UPD query: '|| l_stmt);
1354: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

Line 1351: l_stmt := FND_DSQL.get_text(FALSE);

1347: FND_DSQL.init;
1348: FND_DSQL.add_text(l_sql_str);
1349: l_ins_csr := DBMS_SQL.open_cursor;
1350: FND_DSQL.set_cursor(l_ins_csr);
1351: l_stmt := FND_DSQL.get_text(FALSE);
1352:
1353: FND_FILE.PUT_LINE(FND_FILE.LOG,'product UPD query: '|| l_stmt);
1354: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1355: FND_DSQL.do_binds;

Line 1355: FND_DSQL.do_binds;

1351: l_stmt := FND_DSQL.get_text(FALSE);
1352:
1353: FND_FILE.PUT_LINE(FND_FILE.LOG,'product UPD query: '|| l_stmt);
1354: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1355: FND_DSQL.do_binds;
1356: l_ignore := DBMS_SQL.execute(l_ins_csr);
1357: */
1358:
1359: --kvattiku updated

Line 1384: FND_DSQL.init;

1380: l_sql_str := l_sql_str || p_resource_id || ','''||'PROD'',''' || p_product_attribute || ''',';
1381: l_sql_str := l_sql_str || p_attribute2 || ',''' || p_alert_type || ''')';
1382:
1383: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1384: FND_DSQL.init;
1385: FND_DSQL.add_text(l_sql_str);
1386: l_ins_csr := DBMS_SQL.open_cursor;
1387: FND_DSQL.set_cursor(l_ins_csr);
1388: l_stmt := FND_DSQL.get_text(FALSE);

Line 1385: FND_DSQL.add_text(l_sql_str);

1381: l_sql_str := l_sql_str || p_attribute2 || ',''' || p_alert_type || ''')';
1382:
1383: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1384: FND_DSQL.init;
1385: FND_DSQL.add_text(l_sql_str);
1386: l_ins_csr := DBMS_SQL.open_cursor;
1387: FND_DSQL.set_cursor(l_ins_csr);
1388: l_stmt := FND_DSQL.get_text(FALSE);
1389:

Line 1387: FND_DSQL.set_cursor(l_ins_csr);

1383: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1384: FND_DSQL.init;
1385: FND_DSQL.add_text(l_sql_str);
1386: l_ins_csr := DBMS_SQL.open_cursor;
1387: FND_DSQL.set_cursor(l_ins_csr);
1388: l_stmt := FND_DSQL.get_text(FALSE);
1389:
1390: FND_FILE.PUT_LINE(FND_FILE.LOG,'product INS query: '|| l_stmt);
1391: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

Line 1388: l_stmt := FND_DSQL.get_text(FALSE);

1384: FND_DSQL.init;
1385: FND_DSQL.add_text(l_sql_str);
1386: l_ins_csr := DBMS_SQL.open_cursor;
1387: FND_DSQL.set_cursor(l_ins_csr);
1388: l_stmt := FND_DSQL.get_text(FALSE);
1389:
1390: FND_FILE.PUT_LINE(FND_FILE.LOG,'product INS query: '|| l_stmt);
1391: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1392: FND_DSQL.do_binds;

Line 1392: FND_DSQL.do_binds;

1388: l_stmt := FND_DSQL.get_text(FALSE);
1389:
1390: FND_FILE.PUT_LINE(FND_FILE.LOG,'product INS query: '|| l_stmt);
1391: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1392: FND_DSQL.do_binds;
1393: l_ignore := DBMS_SQL.execute(l_ins_csr);
1394:
1395: WHEN OTHERS THEN
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1443: FND_DSQL.init;

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;
1442:
1443: FND_DSQL.init;
1444: FND_DSQL.add_text(l_sql_str);
1445: l_ins_csr := DBMS_SQL.open_cursor;
1446: FND_DSQL.set_cursor(l_ins_csr);
1447: l_stmt := FND_DSQL.get_text(FALSE);

Line 1444: FND_DSQL.add_text(l_sql_str);

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;
1442:
1443: FND_DSQL.init;
1444: FND_DSQL.add_text(l_sql_str);
1445: l_ins_csr := DBMS_SQL.open_cursor;
1446: FND_DSQL.set_cursor(l_ins_csr);
1447: l_stmt := FND_DSQL.get_text(FALSE);
1448:

Line 1446: FND_DSQL.set_cursor(l_ins_csr);

1442:
1443: FND_DSQL.init;
1444: FND_DSQL.add_text(l_sql_str);
1445: l_ins_csr := DBMS_SQL.open_cursor;
1446: FND_DSQL.set_cursor(l_ins_csr);
1447: l_stmt := FND_DSQL.get_text(FALSE);
1448:
1449: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1450: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

Line 1447: l_stmt := FND_DSQL.get_text(FALSE);

1443: FND_DSQL.init;
1444: FND_DSQL.add_text(l_sql_str);
1445: l_ins_csr := DBMS_SQL.open_cursor;
1446: FND_DSQL.set_cursor(l_ins_csr);
1447: l_stmt := FND_DSQL.get_text(FALSE);
1448:
1449: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1450: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1451: FND_DSQL.do_binds;

Line 1451: FND_DSQL.do_binds;

1447: l_stmt := FND_DSQL.get_text(FALSE);
1448:
1449: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1450: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1451: FND_DSQL.do_binds;
1452: l_ignore := DBMS_SQL.execute(l_ins_csr);
1453: */
1454:
1455: --added by kvattiku

Line 1481: FND_DSQL.init;

1477: l_sql_str := l_sql_str || p_resource_id || ','''||'CUST'',''' || p_cust_account_id || ''',';
1478: l_sql_str := l_sql_str || p_attribute2 || ',''' || p_alert_type || ''')';
1479:
1480: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1481: FND_DSQL.init;
1482: FND_DSQL.add_text(l_sql_str);
1483: l_ins_csr := DBMS_SQL.open_cursor;
1484: FND_DSQL.set_cursor(l_ins_csr);
1485: l_stmt := FND_DSQL.get_text(FALSE);

Line 1482: FND_DSQL.add_text(l_sql_str);

1478: l_sql_str := l_sql_str || p_attribute2 || ',''' || p_alert_type || ''')';
1479:
1480: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1481: FND_DSQL.init;
1482: FND_DSQL.add_text(l_sql_str);
1483: l_ins_csr := DBMS_SQL.open_cursor;
1484: FND_DSQL.set_cursor(l_ins_csr);
1485: l_stmt := FND_DSQL.get_text(FALSE);
1486:

Line 1484: FND_DSQL.set_cursor(l_ins_csr);

1480: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_sql_str ::::::::::' || l_sql_str );
1481: FND_DSQL.init;
1482: FND_DSQL.add_text(l_sql_str);
1483: l_ins_csr := DBMS_SQL.open_cursor;
1484: FND_DSQL.set_cursor(l_ins_csr);
1485: l_stmt := FND_DSQL.get_text(FALSE);
1486:
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER INS query: '|| l_stmt);
1488: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

Line 1485: l_stmt := FND_DSQL.get_text(FALSE);

1481: FND_DSQL.init;
1482: FND_DSQL.add_text(l_sql_str);
1483: l_ins_csr := DBMS_SQL.open_cursor;
1484: FND_DSQL.set_cursor(l_ins_csr);
1485: l_stmt := FND_DSQL.get_text(FALSE);
1486:
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER INS query: '|| l_stmt);
1488: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1489: FND_DSQL.do_binds;

Line 1489: FND_DSQL.do_binds;

1485: l_stmt := FND_DSQL.get_text(FALSE);
1486:
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER INS query: '|| l_stmt);
1488: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1489: FND_DSQL.do_binds;
1490: l_ignore := DBMS_SQL.execute(l_ins_csr);
1491:
1492: WHEN OTHERS THEN
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1538: FND_DSQL.init;

1534: l_sql_str := 'UPDATE OZF_DASHB_DAILY_KPI SET alert_type = ''' || l_new_alert_type;
1535: l_sql_str := l_sql_str || ''' WHERE report_date = trunc(SYSDATE) AND resource_id = ' || p_resource_id;
1536: l_sql_str := l_sql_str || ' AND sequence_number = ' || p_attribute2;
1537:
1538: FND_DSQL.init;
1539: FND_DSQL.add_text(l_sql_str);
1540: l_ins_csr := DBMS_SQL.open_cursor;
1541: FND_DSQL.set_cursor(l_ins_csr);
1542: l_stmt := FND_DSQL.get_text(FALSE);

Line 1539: FND_DSQL.add_text(l_sql_str);

1535: l_sql_str := l_sql_str || ''' WHERE report_date = trunc(SYSDATE) AND resource_id = ' || p_resource_id;
1536: l_sql_str := l_sql_str || ' AND sequence_number = ' || p_attribute2;
1537:
1538: FND_DSQL.init;
1539: FND_DSQL.add_text(l_sql_str);
1540: l_ins_csr := DBMS_SQL.open_cursor;
1541: FND_DSQL.set_cursor(l_ins_csr);
1542: l_stmt := FND_DSQL.get_text(FALSE);
1543:

Line 1541: FND_DSQL.set_cursor(l_ins_csr);

1537:
1538: FND_DSQL.init;
1539: FND_DSQL.add_text(l_sql_str);
1540: l_ins_csr := DBMS_SQL.open_cursor;
1541: FND_DSQL.set_cursor(l_ins_csr);
1542: l_stmt := FND_DSQL.get_text(FALSE);
1543:
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1545: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

Line 1542: l_stmt := FND_DSQL.get_text(FALSE);

1538: FND_DSQL.init;
1539: FND_DSQL.add_text(l_sql_str);
1540: l_ins_csr := DBMS_SQL.open_cursor;
1541: FND_DSQL.set_cursor(l_ins_csr);
1542: l_stmt := FND_DSQL.get_text(FALSE);
1543:
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1545: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1546: FND_DSQL.do_binds;

Line 1546: FND_DSQL.do_binds;

1542: l_stmt := FND_DSQL.get_text(FALSE);
1543:
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);
1545: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);
1546: FND_DSQL.do_binds;
1547: l_ignore := DBMS_SQL.execute(l_ins_csr);
1548: */
1549:
1550: --added by kvattiku