APPS.CEP_STANDARD dependencies on DBMS_SQL

Line 458: l_cursor_id := DBMS_SQL.open_cursor;

454: l_exec_id NUMBER;
455: l_row NUMBER;
456: BEGIN
457:
458: l_cursor_id := DBMS_SQL.open_cursor;
459:
460: l_final_query := 'SELECT 1 from fnd_grants grt, fnd_objects obj, wf_user_roles rol, xle_entity_profiles le ' ||
461: 'where grt.object_id = obj.object_id and obj.obj_name = ''' || p_security_mode || ''' and ' ||
462: 'GRANTEE_TYPE = '''||'GROUP'||''' and GRANTEE_KEY = rol.role_name and ' ||

Line 471: DBMS_SQL.Parse(l_cursor_id,

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

Line 473: DBMS_SQL.v7);

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

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

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

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

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

Line 479: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

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

Line 486: IF DBMS_SQL.IS_OPEN(l_cursor_id) THEN

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

Line 487: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

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