DBA Data[Home] [Help]

APPS.PA_PERF_THRESHOLDS_PVT dependencies on PA_PERF_THRESHOLDS_PKG

Line 67: PA_PERF_THRESHOLDS_PKG.insert_row(

63: l_debug_level3);
64: END IF;
65:
66:
67: PA_PERF_THRESHOLDS_PKG.insert_row(
68: X_ROWID => l_rowid,
69: X_THRESHOLD_ID => P_THRESHOLD_ID,
70: X_RULE_TYPE => P_RULE_TYPE,
71: X_THRES_OBJ_ID => P_THRES_OBJ_ID,

Line 192: PA_PERF_THRESHOLDS_PKG.LOCK_ROW (

188: pa_debug.write(g_module_name,pa_debug.g_err_stage,
189: l_debug_level3);
190: END IF;
191:
192: PA_PERF_THRESHOLDS_PKG.LOCK_ROW (
193: X_THRESHOLD_ID => P_THRESHOLD_ID,
194: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER );
195:
196: IF l_debug_mode = 'Y' THEN

Line 209: pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PKG.UPDATE_ROW';

205: Raise Invalid_Ret_Status;
206: end if;
207:
208: IF l_debug_mode = 'Y' THEN
209: pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PKG.UPDATE_ROW';
210: pa_debug.write(g_module_name,pa_debug.g_err_stage,
211: l_debug_level3);
212: END IF;
213:

Line 214: PA_PERF_THRESHOLDS_PKG.UPDATE_ROW(

210: pa_debug.write(g_module_name,pa_debug.g_err_stage,
211: l_debug_level3);
212: END IF;
213:
214: PA_PERF_THRESHOLDS_PKG.UPDATE_ROW(
215: X_THRESHOLD_ID => P_THRESHOLD_ID,
216: X_RULE_TYPE => P_RULE_TYPE,
217: X_THRES_OBJ_ID => P_THRES_OBJ_ID,
218: X_FROM_VALUE => P_FROM_VALUE,

Line 336: PA_PERF_THRESHOLDS_PKG.LOCK_ROW

332: pa_debug.write(g_module_name,pa_debug.g_err_stage,
333: l_debug_level3);
334: END IF;
335:
336: PA_PERF_THRESHOLDS_PKG.LOCK_ROW
337: (
338: X_THRESHOLD_ID => P_THRESHOLD_ID,
339: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER
340: );

Line 348: pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PKG.delete_row';

344: Raise Invalid_Ret_Status;
345: end if;
346:
347: IF l_debug_mode = 'Y' THEN
348: pa_debug.g_err_stage:= 'about to call PA_PERF_THRESHOLDS_PKG.delete_row';
349: pa_debug.write(g_module_name,pa_debug.g_err_stage,
350: l_debug_level3);
351: END IF;
352:

Line 354: PA_PERF_THRESHOLDS_PKG.DELETE_ROW

350: l_debug_level3);
351: END IF;
352:
353: -- Delete Role
354: PA_PERF_THRESHOLDS_PKG.DELETE_ROW
355: (X_THRESHOLD_ID => P_THRESHOLD_ID);
356:
357: IF l_debug_mode = 'Y' THEN
358: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PVT.delete_rule_det';