APPS.AML_MONITOR_LOG_PVT dependencies on AML_MONITOR_LOG

Line 1: PACKAGE BODY AML_Monitor_Log_PVT as

1: PACKAGE BODY AML_Monitor_Log_PVT as
2: /* $Header: amlvlmlb.pls 115.1 2003/01/20 18:37:37 swkhanna ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name AML_Monitor_Log_PVT

Line 5: -- Package name AML_Monitor_Log_PVT

1: PACKAGE BODY AML_Monitor_Log_PVT as
2: /* $Header: amlvlmlb.pls 115.1 2003/01/20 18:37:37 swkhanna ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name AML_Monitor_Log_PVT
6: -- History
7: -- 11-27-2002 sujrama created
8: -- ===============================================================
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AML_Monitor_Log_PVT';

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AML_Monitor_Log_PVT';

5: -- Package name AML_Monitor_Log_PVT
6: -- History
7: -- 11-27-2002 sujrama created
8: -- ===============================================================
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AML_Monitor_Log_PVT';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amlvlmlb.pls';
11:
12:
13: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 38: SELECT aml_monitor_log_s.NEXTVAL

34: l_org_id NUMBER ; --:= FND_API.G_MISS_NUM;
35: l_monitor_log_id NUMBER;
36: l_dummy NUMBER;
37: CURSOR c_id IS
38: SELECT aml_monitor_log_s.NEXTVAL
39: FROM dual;
40: CURSOR c_id_exists (l_id IN NUMBER) IS
41: SELECT 1
42: FROM AML_MONITOR_LOG

Line 42: FROM AML_MONITOR_LOG

38: SELECT aml_monitor_log_s.NEXTVAL
39: FROM dual;
40: CURSOR c_id_exists (l_id IN NUMBER) IS
41: SELECT 1
42: FROM AML_MONITOR_LOG
43: WHERE monitor_log_id = l_id;
44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT create_monitor_log_pvt;

Line 89: Aml_Monitor_Log_Pkg.Insert_Row(

85: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
86: END IF;
87:
88: -- Invoke table handler(As_Monitor_Log_Pkg.Insert_Row)
89: Aml_Monitor_Log_Pkg.Insert_Row(
90: px_monitor_log_id => l_monitor_log_id,
91: -- p_monitor_execution_id => p_monitor_log_rec.monitor_execution_id,
92: p_last_update_date => SYSDATE,
93: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 195: FROM AML_MONITOR_LOG

191: )
192: IS
193: CURSOR c_get_monitor_log(monitor_log_id NUMBER) IS
194: SELECT *
195: FROM AML_MONITOR_LOG
196: WHERE monitor_log_id = p_monitor_log_rec.monitor_log_id;
197: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Monitor_Log';
198: L_API_VERSION_NUMBER CONSTANT NUMBER := 2.0;
199: -- Local Variables

Line 280: AML_Monitor_Log_Pkg.Update_Row(

276: IF (AS_DEBUG_LOW_ON) THEN
277: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
278: END IF;
279: -- Invoke table handler(As_Monitor_Log_Pkg.Update_Row)
280: AML_Monitor_Log_Pkg.Update_Row(
281: p_monitor_log_id => p_monitor_log_rec.monitor_log_id,
282: -- p_monitor_execution_id => p_monitor_log_rec.monitor_execution_id,
283: p_last_update_date => SYSDATE,
284: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 415: AMl_Monitor_Log_Pkg.Delete_Row(

411: AS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
412: END IF;
413:
414: -- Invoke table handler(As_Monitor_Log_Pkg.Delete_Row)
415: AMl_Monitor_Log_Pkg.Delete_Row(
416: p_monitor_log_id => p_monitor_log_id
417: --, p_object_version_number => p_object_version_number
418: );
419: --

Line 469: END AML_Monitor_Log_PVT;

465: p_count => x_msg_count,
466: p_data => x_msg_data
467: );
468: End Delete_Monitor_Log;
469: END AML_Monitor_Log_PVT;