APPS.CEP_STANDARD dependencies on DBMS_SQL

Line 461: l_cursor_id := DBMS_SQL.open_cursor;

457: l_exec_id NUMBER;
458: l_row NUMBER;
459: BEGIN
460:
461: l_cursor_id := DBMS_SQL.open_cursor;
462:
463: l_final_query := 'SELECT 1 from fnd_grants grt, fnd_objects obj, wf_user_roles rol, xle_entity_profiles le ' ||
464: 'where grt.object_id = obj.object_id and Trunc(Nvl(grt.end_date,SYSDATE)) >= Trunc(SYSDATE) and obj.obj_name = ''' || p_security_mode || ''' and ' ||
465: 'GRANTEE_TYPE = '''||'GROUP'||''' and GRANTEE_KEY = rol.role_name and ' ||

Line 474: DBMS_SQL.Parse(l_cursor_id,

470: 'and INSTANCE_PK1_VALUE = to_char(le.legal_entity_id) '||
471: 'and le.legal_entity_id = '|| to_char(p_le_id);
472:
473:
474: DBMS_SQL.Parse(l_cursor_id,
475: l_final_query,
476: DBMS_SQL.v7);
477:
478: cep_standard.debug('Parsed sucessfully');

Line 476: DBMS_SQL.v7);

472:
473:
474: DBMS_SQL.Parse(l_cursor_id,
475: l_final_query,
476: DBMS_SQL.v7);
477:
478: cep_standard.debug('Parsed sucessfully');
479:
480: l_exec_id := DBMS_SQL.execute(l_cursor_id);

Line 480: l_exec_id := DBMS_SQL.execute(l_cursor_id);

476: DBMS_SQL.v7);
477:
478: cep_standard.debug('Parsed sucessfully');
479:
480: l_exec_id := DBMS_SQL.execute(l_cursor_id);
481: l_row := DBMS_SQL.FETCH_ROWS(l_cursor_id);
482: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
483:
484: RETURN l_row;

Line 481: l_row := DBMS_SQL.FETCH_ROWS(l_cursor_id);

477:
478: cep_standard.debug('Parsed sucessfully');
479:
480: l_exec_id := DBMS_SQL.execute(l_cursor_id);
481: l_row := DBMS_SQL.FETCH_ROWS(l_cursor_id);
482: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
483:
484: RETURN l_row;
485:

Line 482: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

478: cep_standard.debug('Parsed sucessfully');
479:
480: l_exec_id := DBMS_SQL.execute(l_cursor_id);
481: l_row := DBMS_SQL.FETCH_ROWS(l_cursor_id);
482: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
483:
484: RETURN l_row;
485:
486: EXCEPTION

Line 489: IF DBMS_SQL.IS_OPEN(l_cursor_id) THEN

485:
486: EXCEPTION
487: WHEN OTHERS THEN
488: cep_standard.debug('EXCEPTION - OTHERS: check_bat_security');
489: IF DBMS_SQL.IS_OPEN(l_cursor_id) THEN
490: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
491: cep_standard.debug('Cursor Closed');
492: END IF;
493: RAISE;

Line 490: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

486: EXCEPTION
487: WHEN OTHERS THEN
488: cep_standard.debug('EXCEPTION - OTHERS: check_bat_security');
489: IF DBMS_SQL.IS_OPEN(l_cursor_id) THEN
490: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
491: cep_standard.debug('Cursor Closed');
492: END IF;
493: RAISE;
494: END check_ba_security;