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_LEDGER_CONFIG_DETAILS

Line 13: FROM gl_ledger_config_details glcd, gl_ledgers ledger

9: x_config_id NUMBER)
10: RETURN VARCHAR2 IS
11: CURSOR c_ledgers IS
12: SELECT DISTINCT ledger.chart_of_accounts_id -- glcd.object_id,
13: FROM gl_ledger_config_details glcd, gl_ledgers ledger
14: WHERE glcd.configuration_id = x_config_id
15: AND glcd.setup_step_code = 'NONE'
16: AND ledger.ledger_id = glcd.object_id;
17:

Line 812: FROM gl_ledger_config_details

808: x_completion_status VARCHAR2(30);
809:
810: CURSOR c_primary_ledgers IS
811: SELECT DISTINCT object_id
812: FROM gl_ledger_config_details
813: WHERE object_type_code = 'PRIMARY'
814: AND setup_step_code = 'NONE'
815: AND configuration_id IN(
816: SELECT configuration_id

Line 817: FROM gl_ledger_config_details

813: WHERE object_type_code = 'PRIMARY'
814: AND setup_step_code = 'NONE'
815: AND configuration_id IN(
816: SELECT configuration_id
817: FROM gl_ledger_config_details
818: WHERE object_type_code = 'SECONDARY'
819: AND setup_step_code = 'NONE'
820: AND object_id = x_ledger_id);
821:

Line 1064: -- the following logic will be moved to a API package for table GL_LEDGER_CONFIG_details

1060: OR ( target_ledger_category_code = 'ALC'
1061: AND relationship_type_code <> 'BALANCE'));
1062: END IF;
1063:
1064: -- the following logic will be moved to a API package for table GL_LEDGER_CONFIG_details
1065: IF ( (x_ledger_category_code = 'PRIMARY')
1066: OR (x_ledger_category_code = 'SECONDARY')) THEN
1067: IF (x_current_name <> x_name) THEN
1068: UPDATE gl_ledger_config_details

Line 1068: UPDATE gl_ledger_config_details

1064: -- the following logic will be moved to a API package for table GL_LEDGER_CONFIG_details
1065: IF ( (x_ledger_category_code = 'PRIMARY')
1066: OR (x_ledger_category_code = 'SECONDARY')) THEN
1067: IF (x_current_name <> x_name) THEN
1068: UPDATE gl_ledger_config_details
1069: SET object_name = x_name
1070: WHERE configuration_id = x_configuration_id
1071: AND object_id = x_ledger_id
1072: AND object_type_code = x_ledger_category_code;

Line 1083: INSERT INTO gl_ledger_config_details

1079: FROM gl_ledgers
1080: WHERE ledger_id = x_ledger_id;
1081:
1082: /* IF (x_current_bsv_option_code <> x_bal_seg_value_option_code) THEN
1083: INSERT INTO gl_ledger_config_details
1084: (configuration_id, object_type_code,
1085: object_id, object_name, setup_step_code,
1086: next_action_code, status_code, created_by,
1087: last_update_login, last_update_date,

Line 1107: INSERT INTO gl_ledger_config_details

1103: IF ( ( (x_current_sla_actg_method_code IS NULL)
1104: AND (x_sla_accounting_method_code IS NOT NULL))
1105: OR ( (x_current_sla_actg_method_type IS NULL)
1106: AND (x_sla_accounting_method_type IS NOT NULL))) THEN
1107: INSERT INTO gl_ledger_config_details
1108: (configuration_id, object_type_code,
1109: object_id, object_name, setup_step_code,
1110: next_action_code, status_code,
1111: created_by, last_update_login,

Line 1144: DELETE FROM gl_ledger_config_details

1140: ELSIF( ( (x_current_sla_actg_method_code IS NOT NULL)
1141: AND (x_sla_accounting_method_code IS NULL))
1142: OR ( (x_current_sla_actg_method_type IS NOT NULL)
1143: AND (x_sla_accounting_method_type IS NULL))) THEN
1144: DELETE FROM gl_ledger_config_details
1145: WHERE configuration_id = x_configuration_id
1146: AND object_type_code = x_ledger_category_code
1147: AND object_id = x_ledger_id
1148: AND object_name = x_name

Line 1156: UPDATE gl_ledger_config_details

1152: ELSIF( (x_current_sla_actg_method_code <>
1153: x_sla_accounting_method_code)
1154: OR (x_current_sla_actg_method_type <>
1155: x_sla_accounting_method_type)) THEN
1156: UPDATE gl_ledger_config_details
1157: SET next_action_code = 'REVIEW_DEFAULTS',
1158: status_code = 'CONFIRMED',
1159: last_update_login = x_last_update_login,
1160: last_update_date = x_last_update_date,

Line 1204: INSERT INTO gl_ledger_config_details

1200: -- bug fix 3175231 insert the CE row in config details
1201: --IF ( (x_acctg_environment_code = 'EXCLUSIVE')
1202: -- OR ( (x_acctg_environment_code = 'SHARED')
1203: -- AND (x_bal_seg_value_option_code = 'I') ) ) THEN
1204: INSERT INTO gl_ledger_config_details
1205: (configuration_id, object_type_code,
1206: object_id, object_name, setup_step_code,
1207: next_action_code, status_code, created_by,
1208: last_update_login, last_update_date,

Line 1218: DELETE gl_ledger_config_details

1214: x_last_updated_by, x_last_update_date);
1215: --END IF;
1216: ELSIF( (x_current_allow_intercom_flag = 'Y')
1217: AND (x_allow_intercompany_post_flag = 'N')) THEN
1218: DELETE gl_ledger_config_details
1219: WHERE configuration_id = x_configuration_id
1220: AND object_id = x_ledger_id
1221: AND setup_step_code = 'INTRA_BAL';
1222: END IF;

Line 1557: from gl_ledger_config_details

1553: update gl_ledger_configurations
1554: set name = x_name
1555: where configuration_id =
1556: (select configuration_id
1557: from gl_ledger_config_details
1558: where object_id = x_ledger_id
1559: and object_type_code = 'PRIMARY'
1560: and setup_step_code = 'NONE');
1561: END IF;

Line 3442: from gl_ledger_config_details cg1, gl_ledger_config_details cg2

3438: PROCEDURE remove_lgr_bsv_for_le(x_le_id NUMBER) IS
3439:
3440: CURSOR PLSLLEDGER IS
3441: select distinct cg1.object_id ledger_id,cg1.object_type_code
3442: from gl_ledger_config_details cg1, gl_ledger_config_details cg2
3443: where cg2.object_id = x_le_id
3444: and cg1.configuration_id = cg2.configuration_id
3445: and cg1.object_type_code in ('PRIMARY','SECONDARY');
3446:

Line 3508: gl_ledger_config_details cd1, gl_ledger_config_details cd2

3504: l_has_le_bsv VARCHAR2(30);
3505: CURSOR get_ledger_id IS
3506: select l.ledger_id, cd2.configuration_id
3507: from gl_ledgers l, gl_le_value_sets lv,
3508: gl_ledger_config_details cd1, gl_ledger_config_details cd2
3509: where lv.legal_entity_id = x_le_id
3510: and lv.flex_value_set_id = x_value_set_id
3511: and cd1.object_id = lv.legal_entity_id
3512: and cd1.object_type_code = 'LEGAL_ENTITY'

Line 3540: from gl_ledger_config_details

3536: select completion_status_code
3537: from gl_ledger_configurations
3538: where configuration_id =
3539: (select configuration_id
3540: from gl_ledger_config_details
3541: where object_id = x_le_id
3542: and object_type_code = 'LEGAL_ENTITY');
3543: BEGIN
3544: OPEN get_complete_status;

Line 3594: insert into gl_ledger_config_details

3590: where ledger_id = l_ledger_id
3591: and segment_type_code = 'B'
3592: and segment_value = x_bsv_value
3593: and segment_value_type_code = 'S';
3594: insert into gl_ledger_config_details
3595: (configuration_id,
3596: object_type_code,
3597: object_id,
3598: object_name,

Line 3620: from gl_ledger_config_details

3616: fnd_global.login_id,
3617: sysdate,
3618: fnd_global.user_id,
3619: sysdate
3620: from gl_ledger_config_details
3621: where object_id = l_ledger_id
3622: and object_type_code <> 'LEGAL_ENTITY'
3623: and setup_step_code = 'NONE'
3624: and configuration_id = l_config_id

Line 3626: from gl_ledger_config_details

3622: and object_type_code <> 'LEGAL_ENTITY'
3623: and setup_step_code = 'NONE'
3624: and configuration_id = l_config_id
3625: and NOT EXISTS(select 1
3626: from gl_ledger_config_details
3627: where object_id = l_ledger_id
3628: and object_type_code <> 'LEGAL_ENTITY'
3629: and setup_step_code = 'INTER_ASSG');
3630: update gl_ledgers

Line 4049: FROM gl_ledger_config_details

4045:
4046: PROCEDURE remove_ou_setup(x_config_id IN NUMBER) IS
4047: CURSOR le_assigned IS
4048: SELECT object_id
4049: FROM gl_ledger_config_details
4050: WHERE configuration_id = x_config_id
4051: AND object_type_code = 'LEGAL_ENTITY';
4052: test NUMBER;
4053: BEGIN

Line 4057: delete from gl_ledger_config_details

4053: BEGIN
4054: OPEN le_assigned;
4055: FETCH le_assigned INTO test;
4056: IF(le_assigned%NOTFOUND) THEN
4057: delete from gl_ledger_config_details
4058: where configuration_id = x_config_id
4059: and object_type_code = 'PRIMARY'
4060: and setup_step_code = 'OU_SETUP';
4061: END IF;