APPS.GL_ACCESS_SET_SECURITY_PKG dependencies on GL_ACCESS_SET_LEDGERS

Line 234: 'FROM gl_access_set_ledgers acc ' ||

230:
231: IF (segval_mode = gl_access_set_security_pkg.NO_SEG_VALIDATION) THEN
232: RETURN (ledger_table || ledger_context || ' IN ( ' ||
233: 'SELECT acc.ledger_id ' ||
234: 'FROM gl_access_set_ledgers acc ' ||
235: 'WHERE acc.access_set_id = ' || to_char(access_set_id) || ' '||
236: gl_access_set_security_pkg.build_privilege_clause(access_privilege_code) ||
237: gl_access_set_security_pkg.build_date_clause(edate) || ')' );
238: ELSIF (segval_mode = gl_access_set_security_pkg.CHECK_SEGVALS) THEN

Line 358: 'FROM gl_access_set_ledgers acc ' ||

354: -- We know that the ledger is good, we just need to check the date.
355: RETURN(retstring || ' '||
356: 'AND EXISTS ' ||
357: '(SELECT ''valid date'' '||
358: 'FROM gl_access_set_ledgers acc ' ||
359: 'WHERE acc.access_set_id = ' || to_char(access_set_id) || ' '||
360: 'AND acc.ledger_id = '||journal_table_alias||'.ledger_id '||
361: 'AND '||journal_table_alias||'.default_effective_date ' ||
362: 'BETWEEN nvl(acc.start_date, '||

Line 386: 'FROM gl_access_set_ledgers acc ' ||

382: 'FROM gl_je_headers sv ' ||
383: 'WHERE sv.je_batch_id = '||journal_table_alias||'.je_batch_id '||
384: 'AND NOT EXISTS ' ||
385: '(SELECT ''no access'' ' ||
386: 'FROM gl_access_set_ledgers acc ' ||
387: 'WHERE acc.access_set_id = ' || to_char(access_set_id) || ' '||
388: 'AND acc.ledger_id = sv.ledger_id '||
389: 'AND acc.access_privilege_code IN (''B'', ''F'') '||
390: edatestr || '))');

Line 484: 'gl_access_set_ledgers acc ' ||

480: RETURN(
481: 'EXISTS ' ||
482: '(SELECT ''readable journal'' '||
483: 'FROM gl_je_headers jeh, ' ||
484: 'gl_access_set_ledgers acc ' ||
485: 'WHERE jeh.je_batch_id = '||batch_table_alias||'.je_batch_id '||
486: 'AND acc.access_set_id = '||to_char(access_set_id)||' '||
487: 'AND acc.ledger_id = jeh.ledger_id ' ||
488: edatestr || ') ');

Line 497: 'FROM gl_access_set_ledgers acc ' ||

493: 'FROM gl_je_headers jeh ' ||
494: 'WHERE jeh.je_batch_id = '||batch_table_alias||'.je_batch_id '||
495: 'AND NOT EXISTS ' ||
496: '(SELECT ''unwriteable journal'' '||
497: 'FROM gl_access_set_ledgers acc ' ||
498: 'WHERE acc.access_set_id = '||to_char(access_set_id)||' '||
499: 'AND acc.ledger_id = jeh.ledger_id ' ||
500: 'AND acc.access_privilege_code IN (''B'', ''F'') '||
501: edatestr || ')) ');

Line 750: FROM gl_access_set_ledgers asl

746: x_access_privilege_code VARCHAR2 )
747: RETURN NUMBER IS
748: CURSOR sdl IS
749: SELECT asl.ledger_id
750: FROM gl_access_set_ledgers asl
751: WHERE asl.access_set_id = x_access_set_id
752: AND asl.ledger_id = (select gas.default_ledger_id
753: from gl_access_sets gas
754: where gas.access_set_id = asl.access_set_id)

Line 765: FROM gl_access_set_ledgers

761: OR (x_access_privilege_code = 'R'));
762:
763: CURSOR gdl IS
764: SELECT DISTINCT ledger_id
765: FROM gl_access_set_ledgers
766: WHERE access_set_id = x_access_set_id
767: AND ( ( (x_access_privilege_code
768: = gl_access_set_security_pkg.FULL_ACCESS)
769: AND (access_privilege_code = 'F'))

Line 823: FROM gl_access_set_ledgers

819: sql_stmt VARCHAR2(100);
820:
821: CURSOR check_access_ledger IS
822: SELECT access_privilege_code
823: FROM gl_access_set_ledgers
824: WHERE access_set_id = x_access_set_id
825: AND ledger_id = x_ledger_id
826: AND ( (x_edate IS NULL)
827: OR (trunc(x_edate) BETWEEN nvl(trunc(start_date), trunc(x_edate)-1)