APPS.GL_ACCESS_SET_SECURITY_PKG dependencies on GL_JE_HEADERS

Line 382: 'FROM gl_je_headers sv ' ||

378: -- For write access, just check the other journals in the batch
379: RETURN(retstring || ' '||
380: 'AND NOT EXISTS ' ||
381: '(SELECT ''unwriteable journal'' '||
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 ' ||

Line 426: 'FROM gl_je_segment_values sv, gl_je_headers sv2 ' ||

422:
423: RETURN(retstring || ' '||
424: 'AND NOT EXISTS ' ||
425: '(SELECT ''unwriteable line'' '||
426: 'FROM gl_je_segment_values sv, gl_je_headers sv2 ' ||
427: 'WHERE sv2.je_batch_id = '||journal_table_alias||'.je_batch_id '||
428: 'AND sv.je_header_id = sv2.je_header_id ' ||
429: 'AND sv.segment_type_code = '''||security_code||''' '||
430: 'AND NOT EXISTS '||

Line 483: 'FROM gl_je_headers jeh, ' ||

479: IF (access_privilege_code = gl_access_set_security_pkg.READ_ONLY_ACCESS) THEN
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 ' ||

Line 493: 'FROM gl_je_headers jeh ' ||

489: ELSE -- write access
490: RETURN(
491: 'NOT EXISTS ' ||
492: '(SELECT ''unwriteable journal'' '||
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 ' ||

Line 509: 'FROM gl_je_headers jeh, '||

505: IF (access_privilege_code = gl_access_set_security_pkg.READ_ONLY_ACCESS) THEN
506: RETURN(
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 '||

Line 523: 'FROM gl_je_headers jeh, '||

519: ELSE -- WRITE_ACCESS
520: RETURN(
521: 'NOT EXISTS ' ||
522: '(SELECT ''unwriteable line'' '||
523: 'FROM gl_je_headers jeh, '||
524: 'gl_je_segment_values sv ' ||
525: 'WHERE jeh.je_batch_id = '||batch_table_alias||'.je_batch_id '||
526: 'AND sv.je_header_id = jeh.je_header_id '||
527: 'AND sv.segment_type_code = '''||security_code||''' '||

Line 564: FROM gl_je_headers jeh

560: BEGIN
561: IF (NOT header_only) THEN
562: SELECT 'has lines'
563: INTO dummy
564: FROM gl_je_headers jeh
565: WHERE jeh.je_batch_id = je_id
566: AND rownum = 1;
567: ELSE
568: -- Check for lines

Line 571: FROM gl_je_headers jeh

567: ELSE
568: -- Check for lines
569: SELECT 'has lines'
570: INTO dummy
571: FROM gl_je_headers jeh
572: WHERE jeh.je_header_id = je_id
573: AND rownum = 1;
574: END IF;
575:

Line 590: FROM gl_je_headers jeh

586: IF (NOT lines_exist AND NOT header_only) THEN
587: BEGIN
588: SELECT 'has journals'
589: INTO dummy
590: FROM gl_je_headers jeh
591: WHERE jeh.je_batch_id = je_id
592: AND rownum = 1;
593:
594: EXCEPTION

Line 609: 'FROM gl_je_headers jeh ';

605: sqlbuf := 'SELECT ''no write'' '||
606: 'FROM dual ' ||
607: 'WHERE EXISTS ' ||
608: '(SELECT ''no write'' ' ||
609: 'FROM gl_je_headers jeh ';
610:
611: -- For ledger-only access sets, don't include gl_je_segment_values
612: IF (security_col IS NOT NULL) THEN
613: sqlbuf := sqlbuf ||

Line 681: 'FROM gl_je_headers jeh, ';

677: sqlbuf := 'SELECT ''has read'' '||
678: 'FROM dual ' ||
679: 'WHERE EXISTS ' ||
680: '(SELECT ''has read'' ' ||
681: 'FROM gl_je_headers jeh, ';
682:
683: -- For ledger-only access sets, don't include gl_je_segment_values
684: IF (security_col IS NOT NULL) THEN
685: sqlbuf := sqlbuf ||