APPS.IEU_PVT dependencies on DBMS_SQL

Line 1376: l_cursor_name := dbms_sql.open_cursor;

1372: -- Execute the sql_stmt to get the count
1373: --
1374:
1375: BEGIN
1376: l_cursor_name := dbms_sql.open_cursor;
1377: DBMS_SQL.PARSE(l_cursor_name,l_sql_stmt , dbms_sql.native);
1378:
1379: If (l_rtnode_bind_var_flag = 'T')
1380: then

Line 1377: DBMS_SQL.PARSE(l_cursor_name,l_sql_stmt , dbms_sql.native);

1373: --
1374:
1375: BEGIN
1376: l_cursor_name := dbms_sql.open_cursor;
1377: DBMS_SQL.PARSE(l_cursor_name,l_sql_stmt , dbms_sql.native);
1378:
1379: If (l_rtnode_bind_var_flag = 'T')
1380: then
1381:

Line 1397: DBMS_SQL.BIND_VARIABLE (

1393: end if;
1394:
1395: if (l_resource_id_flag = 'T')
1396: then
1397: DBMS_SQL.BIND_VARIABLE (
1398: l_cursor_name,
1399: ':resource_id',
1400: p_resource_id );
1401: end if;

Line 1414: DBMS_SQL.BIND_VARIABLE (

1410: -- Ignore bind Var :resource_id here.
1411: If (p_bindvallist(i).bind_var_name <> ':resource_id')
1412: then
1413:
1414: DBMS_SQL.BIND_VARIABLE (
1415: l_cursor_name,
1416: p_bindvallist(i).bind_var_name,
1417: p_bindvallist(i).bind_var_value );
1418: end if;

Line 1429: DBMS_SQL.BIND_VARIABLE (

1425: else
1426:
1427: if (l_enum_bind_var_flag = 'T')
1428: then
1429: DBMS_SQL.BIND_VARIABLE (
1430: l_cursor_name,
1431: ':resource_id',
1432: p_resource_id );
1433: end if;

Line 1438: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);

1434:
1435: end if;
1436:
1437:
1438: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
1439: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
1440: l_rows_processed := dbms_sql.execute(l_cursor_name);
1441:
1442: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)

Line 1439: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);

1435: end if;
1436:
1437:
1438: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
1439: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
1440: l_rows_processed := dbms_sql.execute(l_cursor_name);
1441:
1442: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
1443: THEN

Line 1440: l_rows_processed := dbms_sql.execute(l_cursor_name);

1436:
1437:
1438: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
1439: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
1440: l_rows_processed := dbms_sql.execute(l_cursor_name);
1441:
1442: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
1443: THEN
1444: -- get column values of the row

Line 1442: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)

1438: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
1439: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
1440: l_rows_processed := dbms_sql.execute(l_cursor_name);
1441:
1442: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
1443: THEN
1444: -- get column values of the row
1445: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);
1446: END IF;

Line 1445: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);

1441:
1442: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
1443: THEN
1444: -- get column values of the row
1445: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);
1446: END IF;
1447:
1448: DBMS_SQL.close_cursor(l_cursor_name);
1449:

Line 1448: DBMS_SQL.close_cursor(l_cursor_name);

1444: -- get column values of the row
1445: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);
1446: END IF;
1447:
1448: DBMS_SQL.close_cursor(l_cursor_name);
1449:
1450: EXCEPTION
1451:
1452: WHEN OTHERS THEN

Line 1453: DBMS_SQL.CLOSE_CURSOR(l_cursor_name);

1449:
1450: EXCEPTION
1451:
1452: WHEN OTHERS THEN
1453: DBMS_SQL.CLOSE_CURSOR(l_cursor_name);
1454:
1455: END;
1456:
1457: END IF;