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.FV_FACTS_TBAL_TRX dependencies on GL_ACCESS_SET_SECURITY_PKG

Line 774: das_where := gl_access_set_security_pkg.get_security_clause

770: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
771:
772: -- Data Access Security
773: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
774: das_where := gl_access_set_security_pkg.get_security_clause
775: (das_id,
776: gl_access_set_security_pkg.READ_ONLY_ACCESS,
777: gl_access_set_security_pkg.CHECK_LEDGER_ID,
778: to_char(vp_set_of_books_id), 'GLB',

Line 776: gl_access_set_security_pkg.READ_ONLY_ACCESS,

772: -- Data Access Security
773: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
774: das_where := gl_access_set_security_pkg.get_security_clause
775: (das_id,
776: gl_access_set_security_pkg.READ_ONLY_ACCESS,
777: gl_access_set_security_pkg.CHECK_LEDGER_ID,
778: to_char(vp_set_of_books_id), 'GLB',
779: gl_access_set_security_pkg.CHECK_SEGVALS,
780: null, 'GLCC', null);

Line 777: gl_access_set_security_pkg.CHECK_LEDGER_ID,

773: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
774: das_where := gl_access_set_security_pkg.get_security_clause
775: (das_id,
776: gl_access_set_security_pkg.READ_ONLY_ACCESS,
777: gl_access_set_security_pkg.CHECK_LEDGER_ID,
778: to_char(vp_set_of_books_id), 'GLB',
779: gl_access_set_security_pkg.CHECK_SEGVALS,
780: null, 'GLCC', null);
781: IF (das_where IS NOT NULL) THEN

Line 779: gl_access_set_security_pkg.CHECK_SEGVALS,

775: (das_id,
776: gl_access_set_security_pkg.READ_ONLY_ACCESS,
777: gl_access_set_security_pkg.CHECK_LEDGER_ID,
778: to_char(vp_set_of_books_id), 'GLB',
779: gl_access_set_security_pkg.CHECK_SEGVALS,
780: null, 'GLCC', null);
781: IF (das_where IS NOT NULL) THEN
782: vl_main_select := vl_main_select || 'AND ' || das_where;
783: END IF;

Line 2260: das_where := gl_access_set_security_pkg.get_security_clause

2256: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
2257:
2258: -- Data Access Security
2259: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2260: das_where := gl_access_set_security_pkg.get_security_clause
2261: (das_id,
2262: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2263: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2264: to_char(vp_set_of_books_id), 'GLB',

Line 2262: gl_access_set_security_pkg.READ_ONLY_ACCESS,

2258: -- Data Access Security
2259: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2260: das_where := gl_access_set_security_pkg.get_security_clause
2261: (das_id,
2262: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2263: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2264: to_char(vp_set_of_books_id), 'GLB',
2265: gl_access_set_security_pkg.CHECK_SEGVALS,
2266: null, 'GLCC', null);

Line 2263: gl_access_set_security_pkg.CHECK_LEDGER_ID,

2259: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2260: das_where := gl_access_set_security_pkg.get_security_clause
2261: (das_id,
2262: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2263: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2264: to_char(vp_set_of_books_id), 'GLB',
2265: gl_access_set_security_pkg.CHECK_SEGVALS,
2266: null, 'GLCC', null);
2267: IF (das_where IS NOT NULL) THEN

Line 2265: gl_access_set_security_pkg.CHECK_SEGVALS,

2261: (das_id,
2262: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2263: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2264: to_char(vp_set_of_books_id), 'GLB',
2265: gl_access_set_security_pkg.CHECK_SEGVALS,
2266: null, 'GLCC', null);
2267: IF (das_where IS NOT NULL) THEN
2268: vl_bal_select := vl_bal_select || 'AND ' || das_where;
2269: END IF;

Line 2915: das_where := gl_access_set_security_pkg.get_security_clause

2911: AND glb.currency_code = :currency_code ';
2912:
2913: -- Data Access Security
2914: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2915: das_where := gl_access_set_security_pkg.get_security_clause
2916: (das_id,
2917: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2918: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2919: to_char(vp_set_of_books_id), 'GLB',

Line 2917: gl_access_set_security_pkg.READ_ONLY_ACCESS,

2913: -- Data Access Security
2914: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2915: das_where := gl_access_set_security_pkg.get_security_clause
2916: (das_id,
2917: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2918: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2919: to_char(vp_set_of_books_id), 'GLB',
2920: gl_access_set_security_pkg.CHECK_SEGVALS,
2921: null, 'GLCC', null);

Line 2918: gl_access_set_security_pkg.CHECK_LEDGER_ID,

2914: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2915: das_where := gl_access_set_security_pkg.get_security_clause
2916: (das_id,
2917: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2918: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2919: to_char(vp_set_of_books_id), 'GLB',
2920: gl_access_set_security_pkg.CHECK_SEGVALS,
2921: null, 'GLCC', null);
2922: IF (das_where IS NOT NULL) THEN

Line 2920: gl_access_set_security_pkg.CHECK_SEGVALS,

2916: (das_id,
2917: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2918: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2919: to_char(vp_set_of_books_id), 'GLB',
2920: gl_access_set_security_pkg.CHECK_SEGVALS,
2921: null, 'GLCC', null);
2922: IF (das_where IS NOT NULL) THEN
2923: select_stmt := select_stmt || 'AND ' || das_where;
2924: END IF;