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.XLA_SUBLEDGERS_F_PKG dependencies on XLA_SUBLEDGERS

Line 1: PACKAGE BODY XLA_SUBLEDGERS_F_PKG AS

1: PACKAGE BODY XLA_SUBLEDGERS_F_PKG AS
2: /* $Header: xlatbapp.pkb 120.29 2006/08/25 23:53:28 wychan ship $ */
3: /*======================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_subledgers |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_subledgers |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_subledgers |
13: | |

Line 12: | Forms PL/SQL Wrapper for xla_subledgers |

8: | PACKAGE NAME |
9: | xla_subledgers |
10: | |
11: | DESCRIPTION |
12: | Forms PL/SQL Wrapper for xla_subledgers |
13: | |
14: | HISTORY |
15: | 6/11/2002 W Chan Created. |
16: | 10/09/2003 W Chan Fix bug 3175882 - call security API on update |

Line 40: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_subledgers_f_pkg';

36: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
37: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
38:
39: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
40: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_subledgers_f_pkg';
41:
42: g_debug_flag VARCHAR2(1) :=
43: NVL(fnd_profile.value('XLA_DEBUG_TRACE'),'N');
44:

Line 68: (p_location => 'xla_subledgers_f_pkg.trace');

64: RAISE;
65:
66: WHEN OTHERS THEN
67: xla_exceptions_pkg.raise_message
68: (p_location => 'xla_subledgers_f_pkg.trace');
69: END trace;
70:
71: --=============================================================================
72: --

Line 133: (p_location => 'xla_subledgers_f_pkg.get_schema');

129: RAISE;
130:
131: WHEN OTHERS THEN
132: xla_exceptions_pkg.raise_message
133: (p_location => 'xla_subledgers_f_pkg.get_schema');
134:
135: END get_schema;
136:
137: /*======================================================================+

Line 563: FROM xla_subledgers

559: IS
560:
561: CURSOR c IS
562: SELECT rowid
563: FROM xla_subledgers
564: WHERE application_id = x_application_id;
565:
566: CURSOR c1 IS
567: SELECT rowid

Line 607: INSERT INTO xla_subledgers

603: RAISE NO_DATA_FOUND;
604: end if;
605: CLOSE c2;
606:
607: INSERT INTO xla_subledgers
608: (creation_date
609: ,created_by
610: ,application_id
611: ,application_type_code

Line 820: (p_location => 'xla_subledgers_f_pkg.insert_row');

816: if (c2%ISOPEN) then
817: close c2;
818: end if;
819: xla_exceptions_pkg.raise_message
820: (p_location => 'xla_subledgers_f_pkg.insert_row');
821:
822: END insert_row;
823:
824: /*======================================================================+

Line 850: FROM xla_subledgers

846: ,drilldown_procedure_name
847: ,security_function_name
848: ,control_account_type_code
849: ,alc_enabled_flag
850: FROM xla_subledgers
851: WHERE application_id = x_application_id
852: FOR UPDATE OF application_id NOWAIT;
853:
854: recinfo c%ROWTYPE;

Line 936: UPDATE xla_subledgers

932: p_module => l_log_module,
933: p_level => C_LEVEL_PROCEDURE);
934: END IF;
935:
936: UPDATE xla_subledgers
937: SET
938: last_update_date = x_last_update_date
939: ,application_id = x_application_id
940: ,je_source_name = x_je_source_name

Line 1049: DELETE FROM xla_subledgers

1045:
1046: delete_tpm
1047: (p_application_id => x_application_id);
1048:
1049: DELETE FROM xla_subledgers
1050: WHERE application_id = x_application_id;
1051:
1052: IF (SQL%NOTFOUND) THEN
1053: RAISE NO_DATA_FOUND;

Line 1074: (p_location => 'xla_subledgers_f_pkg.delete_row');

1070:
1071: WHEN OTHERS THEN
1072: ROLLBACK;
1073: xla_exceptions_pkg.raise_message
1074: (p_location => 'xla_subledgers_f_pkg.delete_row');
1075: END delete_row;
1076:
1077: /*======================================================================+
1078: | |

Line 1144: FROM xla_subledgers

1140: BEGIN
1141:
1142: SELECT last_updated_by, last_update_date
1143: INTO db_luby, db_ludate
1144: FROM xla_subledgers
1145: WHERE application_id = l_application_id;
1146:
1147: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, null)) then
1148: xla_subledgers_f_pkg.update_row

Line 1148: xla_subledgers_f_pkg.update_row

1144: FROM xla_subledgers
1145: WHERE application_id = l_application_id;
1146:
1147: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, null)) then
1148: xla_subledgers_f_pkg.update_row
1149: (x_application_id => l_application_id
1150: ,x_je_source_name => l_je_source_name
1151: ,x_valuation_method_flag => p_valuation_method_flag
1152: ,x_drilldown_procedure_name => p_drilldown_procedure_name

Line 1164: xla_subledgers_f_pkg.insert_row

1160: END IF;
1161:
1162: EXCEPTION
1163: WHEN NO_DATA_FOUND THEN
1164: xla_subledgers_f_pkg.insert_row
1165: (x_rowid => l_rowid
1166: ,x_application_id => l_application_id
1167: ,x_application_type_code => p_application_type_code
1168: ,x_je_source_name => l_je_source_name

Line 1206: (p_location => 'xla_subledgers_f_pkg.load_row');

1202: WHEN NO_DATA_FOUND THEN
1203: null;
1204: WHEN OTHERS THEN
1205: xla_exceptions_pkg.raise_message
1206: (p_location => 'xla_subledgers_f_pkg.load_row');
1207:
1208: END load_row;
1209:
1210: --=============================================================================

Line 1227: END xla_subledgers_f_pkg;

1223: g_log_level := C_LEVEL_LOG_DISABLED;
1224: END IF;
1225:
1226:
1227: END xla_subledgers_f_pkg;