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.12010000.2 2009/12/28 09:23:33 vkasina 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 937: UPDATE xla_subledgers

933: p_module => l_log_module,
934: p_level => C_LEVEL_PROCEDURE);
935: END IF;
936:
937: UPDATE xla_subledgers
938: SET
939: last_update_date = x_last_update_date
940: ,application_type_code = nvl(x_application_type_code,application_type_code)
941: ,je_source_name = x_je_source_name

Line 1050: DELETE FROM xla_subledgers

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

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

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

Line 1145: FROM xla_subledgers

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

Line 1149: xla_subledgers_f_pkg.update_row

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

Line 1166: xla_subledgers_f_pkg.insert_row

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

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

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

Line 1229: END xla_subledgers_f_pkg;

1225: g_log_level := C_LEVEL_LOG_DISABLED;
1226: END IF;
1227:
1228:
1229: END xla_subledgers_f_pkg;