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_LEDGERS_PKG dependencies on GL_ACCESS_SETS

Line 80: gl_access_sets_pkg.create_implicit_access_set

76: v_secured_seg_value_set_id := NULL;
77:
78: BEGIN
79: x_access_set_id :=
80: gl_access_sets_pkg.create_implicit_access_set
81: (x_name => x_name,
82: x_security_segment_code => v_security_segment_code,
83: x_chart_of_accounts_id => x_chart_of_accounts_id,
84: x_period_set_name => x_period_set_name,

Line 346: gl_access_sets_pkg.create_implicit_access_set(

342: /*
343: v_security_segment_code := 'F';
344: v_secured_seg_value_set_id := NULL; -- X_Mgt_Seg_Value_Set_Id;
345: x_access_set_id :=
346: gl_access_sets_pkg.create_implicit_access_set(
347: x_name => x_name,
348: x_security_segment_code => v_security_segment_code,
349: x_chart_of_accounts_id => x_chart_of_accounts_id,
350: x_period_set_name => x_period_set_name,

Line 1544: gl_access_sets_pkg.update_implicit_access_set

1540: END IF; -- IF (x_alc_ledger_type_coe = 'SOURCE')
1541:
1542: -- Update the implicit access set name for the ledger
1543: IF (x_implicit_access_set_id IS NOT NULL) THEN
1544: gl_access_sets_pkg.update_implicit_access_set
1545: (x_access_set_id => x_implicit_access_set_id,
1546: x_name => x_name,
1547: x_last_update_date => x_last_update_date,
1548: x_last_updated_by => x_last_updated_by,

Line 1691: FROM gl_access_sets a

1687: WHERE l.NAME = x_name AND(x_rowid IS NULL OR l.ROWID <> x_rowid);
1688:
1689: CURSOR c_dup2 IS
1690: SELECT 'Duplicate'
1691: FROM gl_access_sets a
1692: WHERE a.NAME = x_name AND a.automatically_created_flag <> 'Y';
1693:
1694: dummy VARCHAR2(100);
1695: BEGIN

Line 2014: gl_access_sets_pkg.create_implicit_access_set

2010: --IF (X_Le_Ledger_Type_Code = 'M') THEN
2011: v_security_segment_code := 'F';
2012: v_secured_seg_value_set_id := NULL; -- X_Mgt_Seg_Value_Set_Id;
2013: x_access_set_id :=
2014: gl_access_sets_pkg.create_implicit_access_set
2015: (x_name => x_name,
2016: x_security_segment_code => v_security_segment_code,
2017: x_chart_of_accounts_id => x_chart_of_accounts_id,
2018: x_period_set_name => x_period_set_name,

Line 2572: gl_access_sets_pkg.update_implicit_access_set

2568: RAISE NO_DATA_FOUND;
2569: END IF;
2570:
2571: -- Update the implicit access set name for the ledger
2572: gl_access_sets_pkg.update_implicit_access_set
2573: (x_access_set_id => x_implicit_access_set_id,
2574: x_name => x_name,
2575: x_last_update_date => x_last_update_date,
2576: x_last_updated_by => x_last_updated_by,

Line 2788: gl_access_sets_pkg.create_implicit_access_set

2784: l_mgt_seg_value_set_id,
2785: l_chart_of_accounts_id);
2786: -- Create an implicit access set header
2787: x_access_set_id :=
2788: gl_access_sets_pkg.create_implicit_access_set
2789: (x_name => x_name, x_security_segment_code => 'F',
2790: x_chart_of_accounts_id => x_chart_of_accounts_id,
2791: x_period_set_name => x_period_set_name,
2792: x_accounted_period_type => x_accounted_period_type,

Line 3049: gl_access_sets_pkg.update_implicit_access_set

3045: RAISE NO_DATA_FOUND;
3046: END IF;
3047:
3048: -- Update the implicit access set name for the ledger
3049: gl_access_sets_pkg.update_implicit_access_set
3050: (x_access_set_id => x_access_set_id,
3051: x_name => x_name,
3052: x_last_update_date => x_last_update_date,
3053: x_last_updated_by => x_last_updated_by,

Line 3057: UPDATE gl_access_sets

3053: x_last_updated_by => x_last_updated_by,
3054: x_last_update_login => x_last_update_login);
3055:
3056: -- Only when updating ledger sets could the default ledger be changed.
3057: UPDATE gl_access_sets
3058: SET default_ledger_id = x_default_ledger_id
3059: WHERE access_set_id = x_access_set_id;
3060: END update_set;
3061:

Line 3292: l_access_set_id := GL_ACCESS_SETS_PKG.create_implicit_access_set

3288: l_mgt_seg_value_set_id,
3289: l_chart_of_accounts_id);
3290:
3291: -- Create an implicit access set header
3292: l_access_set_id := GL_ACCESS_SETS_PKG.create_implicit_access_set
3293: (x_name => x_name,
3294: x_security_segment_code => 'F',
3295: x_chart_of_accounts_id => x_chart_of_accounts_id,
3296: x_period_set_name => x_period_set_name,

Line 3424: GL_ACCESS_SETS_PKG.update_implicit_access_set

3420: RAISE NO_DATA_FOUND;
3421: END IF;
3422:
3423: -- Update the implicit access set name to the same as the ledger set
3424: GL_ACCESS_SETS_PKG.update_implicit_access_set
3425: (x_access_set_id => l_access_set_id,
3426: x_name => x_name,
3427: x_last_update_date => x_date,
3428: x_last_updated_by => x_user_id,

Line 3432: UPDATE GL_ACCESS_SETS

3428: x_last_updated_by => x_user_id,
3429: x_last_update_login => x_login_id);
3430:
3431: -- Only when updating ledger sets could the default ledger be changed
3432: UPDATE GL_ACCESS_SETS
3433: SET default_ledger_id = x_default_ledger_id
3434: WHERE access_set_id = l_access_set_id;
3435: END update_set;
3436:

Line 3851: from GL_ACCESS_SETS ACCESS_SETS

3847: where LEDGERS.NAME = x_object_name
3848: and LEDGERS.LEDGER_ID <> x_object_id
3849: UNION
3850: select 'Duplicate'
3851: from GL_ACCESS_SETS ACCESS_SETS
3852: where ACCESS_SETS.NAME = x_object_name
3853: and ACCESS_SETS.AUTOMATICALLY_CREATED_FLAG <> 'Y'
3854: UNION
3855: select 'Duplicate'

Line 3917: FROM GL_ACCESS_SETS a

3913: WHERE name = x_target_ledger_name
3914: AND ledger_id <> NVL(x_ledger_id,-1)
3915: UNION
3916: SELECT 'Duplicate'
3917: FROM GL_ACCESS_SETS a
3918: WHERE a.name = x_target_ledger_name
3919: AND a.automatically_created_flag <> 'Y';
3920: test VARCHAR2(20);
3921: BEGIN