eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_ACCESS_SET_SECURITY_PKG dependencies on GL_ACCESS_SET_ASSIGNMENTS

Line 242: 'FROM gl_access_set_assignments acc ' ||

238: ELSIF (segval_mode = gl_access_set_security_pkg.CHECK_SEGVALS) THEN
239: RETURN ('(' || ledger_table || ledger_context || ', ' ||
240: segval_table || security_col || ') IN ( ' ||
241: 'SELECT acc.ledger_id, acc.segment_value ' ||
242: 'FROM gl_access_set_assignments acc ' ||
243: 'WHERE acc.access_set_id = ' || to_char(access_set_id) || ' '||
244: gl_access_set_security_pkg.build_privilege_clause(access_privilege_code) ||
245: gl_access_set_security_pkg.build_date_clause(edate) || ')' );
246: END IF;

Line 273: 'FROM gl_access_set_assignments acc ' ||

269: RETURN ('');
270: ELSIF (segval_mode = gl_access_set_security_pkg.CHECK_SEGVALS) THEN
271: RETURN (segval_table || security_col || ' IN ( ' ||
272: 'SELECT acc.segment_value ' ||
273: 'FROM gl_access_set_assignments acc ' ||
274: 'WHERE acc.access_set_id = ' || to_char(access_set_id) || ' '||
275: 'AND acc.ledger_id = ' || ledger_context || ' ' ||
276: gl_access_set_security_pkg.build_privilege_clause(access_privilege_code) ||
277: gl_access_set_security_pkg.build_date_clause(edate) || ')' );

Line 286: 'FROM gl_access_set_assignments acc ' ||

282: RETURN ('');
283: ELSIF (segval_mode = gl_access_set_security_pkg.CHECK_SEGVALS) THEN
284: RETURN (segval_table || security_col || ' IN ( ' ||
285: 'SELECT acc.segment_value ' ||
286: 'FROM gl_access_set_assignments acc ' ||
287: 'WHERE acc.access_set_id = ' || to_char(access_set_id) || ' '||
288: gl_access_set_security_pkg.build_privilege_clause(access_privilege_code) ||
289: gl_access_set_security_pkg.build_date_clause(edate) || ')' );
290: END IF;

Line 408: 'gl_access_set_assignments acc ' ||

404: RETURN(retstring || ' '||
405: 'AND EXISTS ' ||
406: '(SELECT ''readable line'' '||
407: 'FROM gl_je_segment_values sv, ' ||
408: 'gl_access_set_assignments acc ' ||
409: 'WHERE sv.je_header_id = '||journal_table_alias||'.je_header_id '||
410: 'AND sv.segment_type_code = '''||security_code||''' '||
411: 'AND acc.access_set_id = '||to_char(access_set_id)|| ' '||
412: 'AND acc.ledger_id = '||journal_table_alias||'.ledger_id '||

Line 432: 'FROM gl_access_set_assignments acc ' ||

428: 'AND sv.je_header_id = sv2.je_header_id ' ||
429: 'AND sv.segment_type_code = '''||security_code||''' '||
430: 'AND NOT EXISTS '||
431: '(SELECT ''unwriteable line'' ' ||
432: 'FROM gl_access_set_assignments acc ' ||
433: 'WHERE acc.access_set_id = '||to_char(access_set_id)|| ' '||
434: 'AND acc.ledger_id = sv2.ledger_id '||
435: 'AND acc.segment_value = sv.segment_value '||
436: 'AND acc.access_privilege_code = ''B'' '||

Line 511: 'gl_access_set_assignments acc ' ||

507: 'EXISTS ' ||
508: '(SELECT ''readable line'' '||
509: 'FROM gl_je_headers jeh, '||
510: 'gl_je_segment_values sv, ' ||
511: 'gl_access_set_assignments acc ' ||
512: 'WHERE jeh.je_batch_id = '||batch_table_alias||'.je_batch_id '||
513: 'AND sv.je_header_id = jeh.je_header_id '||
514: 'AND sv.segment_type_code = '''||security_code||''' '||
515: 'AND acc.access_set_id = '||to_char(access_set_id)|| ' '||

Line 530: 'FROM gl_access_set_assignments acc ' ||

526: 'AND sv.je_header_id = jeh.je_header_id '||
527: 'AND sv.segment_type_code = '''||security_code||''' '||
528: 'AND NOT EXISTS '||
529: '(SELECT ''unwriteable line'' ' ||
530: 'FROM gl_access_set_assignments acc ' ||
531: 'WHERE acc.access_set_id = '||to_char(access_set_id)|| ' '||
532: 'AND acc.ledger_id = jeh.ledger_id '||
533: 'AND acc.segment_value = sv.segment_value '||
534: 'AND acc.access_privilege_code = ''B'' '||

Line 635: 'FROM gl_access_set_assignments asa ' ||

631:
632: sqlbuf := sqlbuf ||
633: 'AND NOT EXISTS ' ||
634: '(SELECT ''write row'' '||
635: 'FROM gl_access_set_assignments asa ' ||
636: 'WHERE asa.access_set_id = :access_set_id ' ||
637: 'AND asa.ledger_id = jeh.ledger_id ' ||
638: 'AND asa.access_privilege_code = ''B'' ';
639:

Line 690: 'gl_access_set_assignments asa ';

686: 'gl_je_segment_values sv, ';
687: END IF;
688:
689: sqlbuf := sqlbuf ||
690: 'gl_access_set_assignments asa ';
691:
692: IF (header_only) THEN
693: sqlbuf := sqlbuf ||
694: 'WHERE jeh.je_header_id = :object_id ';

Line 833: FROM gl_access_set_assignments

829:
830: CURSOR check_access_segment IS
831: SELECT decode(max(decode(access_privilege_code, 'B', 2, 1)),
832: 1, 'R', 2, 'B', 'N')
833: FROM gl_access_set_assignments
834: WHERE access_set_id = x_access_set_id
835: AND segment_value = seg_val
836: AND ( (x_edate IS NULL)
837: OR (trunc(x_edate) BETWEEN nvl(trunc(start_date), trunc(x_edate)-1)

Line 842: FROM gl_access_set_assignments

838: AND nvl(trunc(end_date), trunc(x_edate)+1)));
839:
840: CURSOR check_access_ls IS
841: SELECT access_privilege_code
842: FROM gl_access_set_assignments
843: WHERE access_set_id = x_access_set_id
844: AND ledger_id = x_ledger_id
845: AND segment_value = seg_val
846: AND ( (x_edate IS NULL)