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.PA_RESOURCE_PUB dependencies on DBMS_SQL

Line 1524: l_cursor := dbms_sql.open_cursor;

1520: CLOSE l_lock_row_list_csr;
1521:
1522: -- Execute UPDATE
1523:
1524: l_cursor := dbms_sql.open_cursor;
1525: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1526:
1527: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1528: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

Line 1525: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);

1521:
1522: -- Execute UPDATE
1523:
1524: l_cursor := dbms_sql.open_cursor;
1525: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1526:
1527: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1528: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1529: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))

Line 1531: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xName',p_new_list_name );

1527: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1528: AND (nvl(p_new_list_name, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1529: nvl(l_name_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1530: THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xName',p_new_list_name );
1532: END IF;
1533:
1534: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1535: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>

Line 1538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xGRTID',l_resource_type_id );

1534: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1535: AND ( nvl(l_resource_type_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <>
1536: nvl(l_group_resource_type_id_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM))
1537: THEN
1538: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xGRTID',l_resource_type_id );
1539: END IF;
1540:
1541: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1542: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>

Line 1545: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xDescription', p_description);

1541: IF (p_description <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
1542: AND (nvl(p_description, PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) <>
1543: nvl(l_description_old,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR))
1544: THEN
1545: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xDescription', p_description);
1546:
1547: END IF;
1548:
1549: l_rows := dbms_sql.execute(l_cursor);

Line 1549: l_rows := dbms_sql.execute(l_cursor);

1545: DBMS_SQL.BIND_VARIABLE(l_cursor, ':xDescription', p_description);
1546:
1547: END IF;
1548:
1549: l_rows := dbms_sql.execute(l_cursor);
1550: IF (dbms_sql.is_open(l_cursor) ) THEN
1551: dbms_sql.close_cursor(l_cursor);
1552: END IF;
1553: END IF;

Line 1550: IF (dbms_sql.is_open(l_cursor) ) THEN

1546:
1547: END IF;
1548:
1549: l_rows := dbms_sql.execute(l_cursor);
1550: IF (dbms_sql.is_open(l_cursor) ) THEN
1551: dbms_sql.close_cursor(l_cursor);
1552: END IF;
1553: END IF;
1554: -- -----------------------------------------------------------------------

Line 1551: dbms_sql.close_cursor(l_cursor);

1547: END IF;
1548:
1549: l_rows := dbms_sql.execute(l_cursor);
1550: IF (dbms_sql.is_open(l_cursor) ) THEN
1551: dbms_sql.close_cursor(l_cursor);
1552: END IF;
1553: END IF;
1554: -- -----------------------------------------------------------------------
1555: -- Resource List MEMBERS

Line 2824: l_cursor := dbms_sql.open_cursor;

2820: CLOSE l_lock_row_member_csr;
2821:
2822: -- Execute Update
2823:
2824: l_cursor := dbms_sql.open_cursor;
2825: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
2826: l_rows := dbms_sql.EXECUTE(l_cursor);
2827: IF (dbms_sql.is_open(l_cursor) ) THEN
2828: dbms_sql.close_cursor(l_cursor);

Line 2825: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);

2821:
2822: -- Execute Update
2823:
2824: l_cursor := dbms_sql.open_cursor;
2825: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
2826: l_rows := dbms_sql.EXECUTE(l_cursor);
2827: IF (dbms_sql.is_open(l_cursor) ) THEN
2828: dbms_sql.close_cursor(l_cursor);
2829: END IF;

Line 2826: l_rows := dbms_sql.EXECUTE(l_cursor);

2822: -- Execute Update
2823:
2824: l_cursor := dbms_sql.open_cursor;
2825: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
2826: l_rows := dbms_sql.EXECUTE(l_cursor);
2827: IF (dbms_sql.is_open(l_cursor) ) THEN
2828: dbms_sql.close_cursor(l_cursor);
2829: END IF;
2830: END IF;

Line 2827: IF (dbms_sql.is_open(l_cursor) ) THEN

2823:
2824: l_cursor := dbms_sql.open_cursor;
2825: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
2826: l_rows := dbms_sql.EXECUTE(l_cursor);
2827: IF (dbms_sql.is_open(l_cursor) ) THEN
2828: dbms_sql.close_cursor(l_cursor);
2829: END IF;
2830: END IF;
2831:

Line 2828: dbms_sql.close_cursor(l_cursor);

2824: l_cursor := dbms_sql.open_cursor;
2825: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
2826: l_rows := dbms_sql.EXECUTE(l_cursor);
2827: IF (dbms_sql.is_open(l_cursor) ) THEN
2828: dbms_sql.close_cursor(l_cursor);
2829: END IF;
2830: END IF;
2831:
2832: IF FND_API.to_boolean( p_commit )