APPS.EAM_ASSET_ATTR_IMPORT_PVT dependencies on DBMS_SQL

Line 566: -- Bug: 2094907, added the following to remove DBMS_SQL

562: ) LOOP
563:
564:
565:
566: -- Bug: 2094907, added the following to remove DBMS_SQL
567: BEGIN
568: -- Bug # 3373134
569: IF (SUBSTR(missing_attr.application_column_name, 1, 1) = 'D') THEN
570: l_sql_stmt1 := 'SELECT to_char(meaav.'|| missing_attr.application_column_name ||', ''yyyy-mm-dd'')' ;

Line 858: IF dbms_sql.is_open(cur) THEN

854:
855:
856: EXCEPTION WHEN OTHERS THEN
857:
858: IF dbms_sql.is_open(cur) THEN
859: dbms_sql.close_cursor(cur);
860: END IF;
861:
862: IF (l_exlog) THEN

Line 859: dbms_sql.close_cursor(cur);

855:
856: EXCEPTION WHEN OTHERS THEN
857:
858: IF dbms_sql.is_open(cur) THEN
859: dbms_sql.close_cursor(cur);
860: END IF;
861:
862: IF (l_exlog) THEN
863: -- bug 2834438