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 DBMS_SQL

Line 1349: l_ins_csr := DBMS_SQL.open_cursor;

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:
1353: FND_FILE.PUT_LINE(FND_FILE.LOG,'product UPD query: '|| l_stmt);

Line 1354: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

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;
1356: l_ignore := DBMS_SQL.execute(l_ins_csr);
1357: */
1358:

Line 1356: l_ignore := DBMS_SQL.execute(l_ins_csr);

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
1360: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;

Line 1386: l_ins_csr := DBMS_SQL.open_cursor;

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:
1390: FND_FILE.PUT_LINE(FND_FILE.LOG,'product INS query: '|| l_stmt);

Line 1391: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

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;
1393: l_ignore := DBMS_SQL.execute(l_ins_csr);
1394:
1395: WHEN OTHERS THEN

Line 1393: l_ignore := DBMS_SQL.execute(l_ins_csr);

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;
1397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1445: l_ins_csr := DBMS_SQL.open_cursor;

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:
1449: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);

Line 1450: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

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;
1452: l_ignore := DBMS_SQL.execute(l_ins_csr);
1453: */
1454:

Line 1452: l_ignore := DBMS_SQL.execute(l_ins_csr);

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
1456: l_sql_str := 'UPDATE OZF_QUOTA_ALERTS SET ' || p_select_attribute;

Line 1483: l_ins_csr := DBMS_SQL.open_cursor;

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:
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER INS query: '|| l_stmt);

Line 1488: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

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;
1490: l_ignore := DBMS_SQL.execute(l_ins_csr);
1491:
1492: WHEN OTHERS THEN

Line 1490: l_ignore := DBMS_SQL.execute(l_ins_csr);

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;
1494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1540: l_ins_csr := DBMS_SQL.open_cursor;

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:
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'CUSTOMER UPD query: '|| l_stmt);

Line 1545: DBMS_SQL.parse(l_ins_csr, l_stmt, DBMS_SQL.native);

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;
1547: l_ignore := DBMS_SQL.execute(l_ins_csr);
1548: */
1549:

Line 1547: l_ignore := DBMS_SQL.execute(l_ins_csr);

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
1551: l_sql_str := 'UPDATE OZF_DASHB_DAILY_KPI SET alert_type = :1';