APPS.PER_JOB_BUS dependencies on DBMS_SQL

Line 1375: l_sql_cursor := dbms_sql.open_cursor;

1371: ||' ) ';
1372: --
1373: -- Open Cursor for Processing Sql statment.
1374: --
1375: l_sql_cursor := dbms_sql.open_cursor;
1376: --
1377: --
1378: -- Parse SQL statement.
1379: --

Line 1380: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

1376: --
1377: --
1378: -- Parse SQL statement.
1379: --
1380: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
1381: --
1382: -- Map the local variables to each returned Column
1383: --
1384: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);

Line 1384: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);

1380: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
1381: --
1382: -- Map the local variables to each returned Column
1383: --
1384: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
1385: --
1386: -- Execute the SQL statement.
1387: --
1388: l_rows_fetched := dbms_sql.execute(l_sql_cursor);

Line 1388: l_rows_fetched := dbms_sql.execute(l_sql_cursor);

1384: dbms_sql.define_column(l_sql_cursor, 1,l_oci_out,1);
1385: --
1386: -- Execute the SQL statement.
1387: --
1388: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
1389: --
1390: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
1391: then
1392: fnd_message.set_name('PAY','HR_6048_PO_POS_DEL_POS_CONT');

Line 1390: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)

1386: -- Execute the SQL statement.
1387: --
1388: l_rows_fetched := dbms_sql.execute(l_sql_cursor);
1389: --
1390: if (dbms_sql.fetch_rows(l_sql_cursor) > 0)
1391: then
1392: fnd_message.set_name('PAY','HR_6048_PO_POS_DEL_POS_CONT');
1393: fnd_message.raise_error;
1394: end if;

Line 1398: dbms_sql.close_cursor(l_sql_cursor);

1394: end if;
1395: --
1396: -- Close cursor used for processing SQL statement.
1397: --
1398: dbms_sql.close_cursor(l_sql_cursor);
1399: end;
1400: end if;
1401: end if;
1402: --