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 858: das_where := gl_access_set_security_pkg.get_security_clause

854: fv_utility.log_mesg('v_reimb_agree_select ::'||v_reimb_agree_select);
855:
856: -- Data Access Security
857: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
858: das_where := gl_access_set_security_pkg.get_security_clause
859: (das_id,
860: gl_access_set_security_pkg.READ_ONLY_ACCESS,
861: gl_access_set_security_pkg.CHECK_LEDGER_ID,
862: to_char(vp_set_of_books_id), 'GLB',

Line 860: gl_access_set_security_pkg.READ_ONLY_ACCESS,

856: -- Data Access Security
857: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
858: das_where := gl_access_set_security_pkg.get_security_clause
859: (das_id,
860: gl_access_set_security_pkg.READ_ONLY_ACCESS,
861: gl_access_set_security_pkg.CHECK_LEDGER_ID,
862: to_char(vp_set_of_books_id), 'GLB',
863: gl_access_set_security_pkg.CHECK_SEGVALS,
864: null, 'GLCC', null);

Line 861: gl_access_set_security_pkg.CHECK_LEDGER_ID,

857: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
858: das_where := gl_access_set_security_pkg.get_security_clause
859: (das_id,
860: gl_access_set_security_pkg.READ_ONLY_ACCESS,
861: gl_access_set_security_pkg.CHECK_LEDGER_ID,
862: to_char(vp_set_of_books_id), 'GLB',
863: gl_access_set_security_pkg.CHECK_SEGVALS,
864: null, 'GLCC', null);
865: IF (das_where IS NOT NULL) THEN

Line 863: gl_access_set_security_pkg.CHECK_SEGVALS,

859: (das_id,
860: gl_access_set_security_pkg.READ_ONLY_ACCESS,
861: gl_access_set_security_pkg.CHECK_LEDGER_ID,
862: to_char(vp_set_of_books_id), 'GLB',
863: gl_access_set_security_pkg.CHECK_SEGVALS,
864: null, 'GLCC', null);
865: IF (das_where IS NOT NULL) THEN
866: vl_main_select := vl_main_select || 'AND ' || das_where;
867: END IF;

Line 2395: das_where := gl_access_set_security_pkg.get_security_clause

2391: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
2392:
2393: -- Data Access Security
2394: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2395: das_where := gl_access_set_security_pkg.get_security_clause
2396: (das_id,
2397: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2398: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2399: to_char(vp_set_of_books_id), 'GLB',

Line 2397: gl_access_set_security_pkg.READ_ONLY_ACCESS,

2393: -- Data Access Security
2394: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2395: das_where := gl_access_set_security_pkg.get_security_clause
2396: (das_id,
2397: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2398: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2399: to_char(vp_set_of_books_id), 'GLB',
2400: gl_access_set_security_pkg.CHECK_SEGVALS,
2401: null, 'GLCC', null);

Line 2398: gl_access_set_security_pkg.CHECK_LEDGER_ID,

2394: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
2395: das_where := gl_access_set_security_pkg.get_security_clause
2396: (das_id,
2397: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2398: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2399: to_char(vp_set_of_books_id), 'GLB',
2400: gl_access_set_security_pkg.CHECK_SEGVALS,
2401: null, 'GLCC', null);
2402: IF (das_where IS NOT NULL) THEN

Line 2400: gl_access_set_security_pkg.CHECK_SEGVALS,

2396: (das_id,
2397: gl_access_set_security_pkg.READ_ONLY_ACCESS,
2398: gl_access_set_security_pkg.CHECK_LEDGER_ID,
2399: to_char(vp_set_of_books_id), 'GLB',
2400: gl_access_set_security_pkg.CHECK_SEGVALS,
2401: null, 'GLCC', null);
2402: IF (das_where IS NOT NULL) THEN
2403: vl_bal_select := vl_bal_select || 'AND ' || das_where;
2404: END IF;

Line 3126: das_where := gl_access_set_security_pkg.get_security_clause

3122: AND glb.currency_code = :currency_code ';
3123:
3124: -- Data Access Security
3125: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
3126: das_where := gl_access_set_security_pkg.get_security_clause
3127: (das_id,
3128: gl_access_set_security_pkg.READ_ONLY_ACCESS,
3129: gl_access_set_security_pkg.CHECK_LEDGER_ID,
3130: to_char(vp_set_of_books_id), 'GLB',

Line 3128: gl_access_set_security_pkg.READ_ONLY_ACCESS,

3124: -- Data Access Security
3125: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
3126: das_where := gl_access_set_security_pkg.get_security_clause
3127: (das_id,
3128: gl_access_set_security_pkg.READ_ONLY_ACCESS,
3129: gl_access_set_security_pkg.CHECK_LEDGER_ID,
3130: to_char(vp_set_of_books_id), 'GLB',
3131: gl_access_set_security_pkg.CHECK_SEGVALS,
3132: null, 'GLCC', null);

Line 3129: gl_access_set_security_pkg.CHECK_LEDGER_ID,

3125: das_id := fnd_profile.value('GL_ACCESS_SET_ID');
3126: das_where := gl_access_set_security_pkg.get_security_clause
3127: (das_id,
3128: gl_access_set_security_pkg.READ_ONLY_ACCESS,
3129: gl_access_set_security_pkg.CHECK_LEDGER_ID,
3130: to_char(vp_set_of_books_id), 'GLB',
3131: gl_access_set_security_pkg.CHECK_SEGVALS,
3132: null, 'GLCC', null);
3133: IF (das_where IS NOT NULL) THEN

Line 3131: gl_access_set_security_pkg.CHECK_SEGVALS,

3127: (das_id,
3128: gl_access_set_security_pkg.READ_ONLY_ACCESS,
3129: gl_access_set_security_pkg.CHECK_LEDGER_ID,
3130: to_char(vp_set_of_books_id), 'GLB',
3131: gl_access_set_security_pkg.CHECK_SEGVALS,
3132: null, 'GLCC', null);
3133: IF (das_where IS NOT NULL) THEN
3134: select_stmt := select_stmt || 'AND ' || das_where;
3135: END IF;