APPS.GL_LEDGERS_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 823: FROM gl_ledger_relationships rs, gl_ledgers lg

819: -- Modified by LPOON on 11/21/03: Join with GL_LEDGERS table to make
820: -- sure the ALC ledger which has been created already
821: CURSOR c_alc_ledgers IS
822: SELECT DISTINCT rs.target_ledger_id
823: FROM gl_ledger_relationships rs, gl_ledgers lg
824: WHERE rs.source_ledger_id = x_ledger_id
825: AND rs.application_id = 101
826: AND rs.target_ledger_category_code = 'ALC'
827: AND rs.relationship_type_code in ('JOURNAL', 'SUBLEDGER')

Line 1041: UPDATE gl_ledger_relationships

1037: WHERE ledger_id = x_ledger_id;
1038:
1039: IF (x_current_name <> x_name) THEN
1040: -- Added where clauses to exclude ALC balance level relationships
1041: UPDATE gl_ledger_relationships
1042: SET target_ledger_name = x_name
1043: WHERE target_ledger_id = x_ledger_id
1044: AND ( target_ledger_category_code <> 'ALC'
1045: OR ( target_ledger_category_code = 'ALC'

Line 1051: UPDATE gl_ledger_relationships

1047: END IF;
1048:
1049: IF (x_current_short_name <> x_short_name) THEN
1050: -- Added where clauses to exclude ALC balance level relationships
1051: UPDATE gl_ledger_relationships
1052: SET target_ledger_short_name = x_short_name
1053: WHERE target_ledger_id = x_ledger_id
1054: AND ( target_ledger_category_code <> 'ALC'
1055: OR ( target_ledger_category_code = 'ALC'

Line 1093: FROM gl_ledger_relationships

1089: UPDATE gl_ledgers
1090: SET bal_seg_value_option_code = x_bal_seg_value_option_code
1091: WHERE ledger_id IN(
1092: SELECT DISTINCT target_ledger_id
1093: FROM gl_ledger_relationships
1094: WHERE source_ledger_id = x_ledger_id
1095: AND target_ledger_category_code = 'ALC');
1096: END IF;*/
1097:

Line 1185: FROM gl_ledger_relationships

1181: SET future_enterable_periods_limit =
1182: x_future_enterable_periods_lmt
1183: WHERE ledger_id IN(
1184: SELECT DISTINCT target_ledger_id
1185: FROM gl_ledger_relationships
1186: WHERE source_ledger_id = x_ledger_id
1187: --AND target_ledger_id <> source_ledger_id
1188: AND target_ledger_category_code = 'ALC'); */
1189: IF ( (x_current_allow_intercom_flag = 'N')

Line 1529: FROM gl_ledger_relationships

1525: FROM gl_ledgers srclg
1526: WHERE ledger_id = x_ledger_id)
1527: WHERE ledger_id IN(
1528: SELECT target_ledger_id
1529: FROM gl_ledger_relationships
1530: WHERE source_ledger_id = x_ledger_id
1531: AND target_ledger_category_code = 'ALC'
1532: AND relationship_type_code IN('SUBLEDGER', 'JOURNAL'));
1533: END IF; -- IF (x_alc_ledger_type_coe = 'SOURCE')

Line 3581: from gl_ledger_relationships

3577: update gl_ledgers
3578: set bal_seg_value_option_code = 'I'
3579: where ledger_id in
3580: (select target_ledger_id
3581: from gl_ledger_relationships
3582: where source_ledger_id = l_ledger_id
3583: and target_ledger_category_code = 'ALC'
3584: and relationship_type_code in ('JOURNAL','SUBLEDGER') )
3585: and bal_seg_value_option_code = 'A';

Line 3609: from gl_ledger_relationships

3605: update gl_ledgers
3606: set bal_seg_value_option_code = 'A'
3607: where ledger_id in
3608: (select target_ledger_id
3609: from gl_ledger_relationships
3610: where source_ledger_id = l_ledger_id
3611: and target_ledger_category_code = 'ALC'
3612: and relationship_type_code in ('JOURNAL','SUBLEDGER') )
3613: and bal_seg_value_option_code = 'I';

Line 3799: from GL_LEDGER_RELATIONSHIPS

3795: where ACCESS_SETS.NAME = x_object_name
3796: and ACCESS_SETS.AUTOMATICALLY_CREATED_FLAG <> 'Y'
3797: UNION
3798: select 'Duplicate'
3799: from GL_LEDGER_RELATIONSHIPS
3800: where target_ledger_category_code = 'ALC'
3801: and relationship_type_code = 'BALANCE'
3802: and target_ledger_name = x_object_name;
3803: test VARCHAR2(20);

Line 3825: from GL_LEDGER_RELATIONSHIPS

3821: where GL_LEDGERS.SHORT_NAME = x_ledger_short_name
3822: and GL_LEDGERS.LEDGER_ID <> x_ledger_id
3823: UNION
3824: select 'Duplicate'
3825: from GL_LEDGER_RELATIONSHIPS
3826: where target_ledger_category_code = 'ALC'
3827: and relationship_type_code = 'BALANCE'
3828: and target_ledger_short_name = x_ledger_short_name;
3829: test VARCHAR2(20);

Line 3847: FROM gl_ledger_relationships

3843: x_ledger_id IN NUMBER,
3844: x_dupl_flag OUT NOCOPY VARCHAR2) IS
3845: CURSOR get_duplicate IS
3846: SELECT 'Duplicate'
3847: FROM gl_ledger_relationships
3848: WHERE application_id = 101
3849: AND target_ledger_name = x_target_ledger_name
3850: AND relationship_type_code <> 'NONE'
3851: AND relationship_id <> x_relationship_id

Line 3881: FROM gl_ledger_relationships

3877: x_ledger_id IN NUMBER,
3878: x_dupl_flag OUT NOCOPY VARCHAR2) IS
3879: CURSOR get_duplicate IS
3880: SELECT 'Duplicate'
3881: FROM gl_ledger_relationships
3882: WHERE application_id = 101
3883: AND target_ledger_short_name = x_ledger_short_name
3884: AND relationship_type_code <> 'NONE'
3885: AND relationship_id <> x_relationship_id