DBA Data[Home] [Help]

APPS.PA_PERF_RULES_PVT dependencies on PA_PERF_RULES_PKG

Line 92: PA_PERF_RULES_PKG.insert_row(

88: RAISE duplicate_name;
89: END IF;
90: CLOSE CHECK_RULE_NAME;
91:
92: PA_PERF_RULES_PKG.insert_row(
93: X_ROWID => l_rowid,
94: X_RULE_ID => P_RULE_ID,
95: X_RULE_NAME => P_RULE_NAME,
96: X_RULE_DESCRIPTION => P_RULE_DESCRIPTION,

Line 274: PA_PERF_RULES_PKG.LOCK_ROW (

270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level3);
272: END IF;
273:
274: PA_PERF_RULES_PKG.LOCK_ROW (
275: X_RULE_ID => P_RULE_ID,
276: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER );
277:
278: IF l_debug_mode = 'Y' THEN

Line 291: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.UPDATE_ROW';

287: Raise Invalid_Ret_Status;
288: end if;
289:
290: IF l_debug_mode = 'Y' THEN
291: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.UPDATE_ROW';
292: pa_debug.write(g_module_name,pa_debug.g_err_stage,
293: l_debug_level3);
294: END IF;
295:

Line 296: PA_PERF_RULES_PKG.UPDATE_ROW(

292: pa_debug.write(g_module_name,pa_debug.g_err_stage,
293: l_debug_level3);
294: END IF;
295:
296: PA_PERF_RULES_PKG.UPDATE_ROW(
297: X_RULE_ID => P_RULE_ID,
298: X_RULE_NAME => P_RULE_NAME,
299: X_RULE_DESCRIPTION => P_RULE_DESCRIPTION,
300: X_RULE_TYPE => P_RULE_TYPE,

Line 453: PA_PERF_RULES_PKG.LOCK_ROW

449: pa_debug.write(g_module_name,pa_debug.g_err_stage,
450: l_debug_level3);
451: END IF;
452:
453: PA_PERF_RULES_PKG.LOCK_ROW
454: (
455: X_RULE_ID => P_RULE_ID,
456: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER
457: );

Line 465: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.delete_row';

461: Raise Invalid_Ret_Status;
462: end if;
463:
464: IF l_debug_mode = 'Y' THEN
465: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.delete_row';
466: pa_debug.write(g_module_name,pa_debug.g_err_stage,
467: l_debug_level3);
468: END IF;
469:

Line 519: PA_PERF_RULES_PKG.DELETE_ROW

515:
516: END LOOP;
517:
518: -- Delete Rule
519: PA_PERF_RULES_PKG.DELETE_ROW
520: ( X_RULE_ID => P_RULE_ID);
521:
522: IF l_debug_mode = 'Y' THEN
523: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.delete_rule';