DBA Data[Home] [Help]

APPS.PA_STATUS_LISTS_PVT dependencies on PA_STATUS_LISTS_PKG

Line 79: PA_STATUS_LISTS_PKG.INSERT_ROW

75:
76: -- Initialize the return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: PA_STATUS_LISTS_PKG.INSERT_ROW
80: (
81: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
82: X_STATUS_LIST_ID => P_STATUS_LIST_ID,
83: X_STATUS_TYPE => P_STATUS_TYPE,

Line 177: PA_STATUS_LISTS_PKG.LOCK_ROW

173: pa_debug.g_err_stage:= 'about to call lock row method';
174: pa_debug.write(g_module_name,pa_debug.g_err_stage,
175: l_debug_level3);
176: END IF;
177: PA_STATUS_LISTS_PKG.LOCK_ROW
178: (
179: X_STATUS_LIST_ID => P_STATUS_LIST_ID,
180: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER
181: );

Line 192: pa_debug.g_err_stage:= 'about to call PA_STATUS_LISTS_PKG.UPDATE_ROW';

188: if(l_msg_count<>0) then
189: Raise Invalid_Ret_Status;
190: end if;
191: IF l_debug_mode = 'Y' THEN
192: pa_debug.g_err_stage:= 'about to call PA_STATUS_LISTS_PKG.UPDATE_ROW';
193: pa_debug.write(g_module_name,pa_debug.g_err_stage,
194: l_debug_level3);
195: END IF;
196: PA_STATUS_LISTS_PKG.UPDATE_ROW

Line 196: PA_STATUS_LISTS_PKG.UPDATE_ROW

192: pa_debug.g_err_stage:= 'about to call PA_STATUS_LISTS_PKG.UPDATE_ROW';
193: pa_debug.write(g_module_name,pa_debug.g_err_stage,
194: l_debug_level3);
195: END IF;
196: PA_STATUS_LISTS_PKG.UPDATE_ROW
197: (X_STATUS_LIST_ID => P_STATUS_LIST_ID,
198: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
199: X_STATUS_TYPE => P_STATUS_TYPE,
200: X_NAME => P_NAME,

Line 287: PA_STATUS_LISTS_PKG.LOCK_ROW

283:
284: -- Initialize the return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286:
287: PA_STATUS_LISTS_PKG.LOCK_ROW
288: (
289: X_STATUS_LIST_ID => P_STATUS_LIST_ID,
290: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER
291: );

Line 299: PA_STATUS_LISTS_PKG.DELETE_ROW

295: Raise Invalid_Ret_Status;
296: end if;
297:
298: -- Delete Role
299: PA_STATUS_LISTS_PKG.DELETE_ROW
300: ( X_STATUS_LIST_ID => P_STATUS_LIST_ID,
301: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER
302: );
303: