DBA Data[Home] [Help]

APPS.PA_CI_IMPACTS_PUB dependencies on FND_API

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64: -- record already exists
65: PA_UTILS.Add_Message( p_app_short_name => 'PA'
66: ,p_msg_name => 'PA_TASK_NAME_INVALID');
67:
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: END IF;
70:
71: CLOSE get_task_id; --Bug 3868121
72:

Line 217: p_description IN VARCHAR2 := FND_API.g_miss_char,

213: p_ci_impact_id IN NUMBER:= null,
214: p_ci_id IN NUMBER := null,
215: p_impact_type_code IN VARCHAR2 := null,
216: p_status_code IN VARCHAR2 := null,
217: p_description IN VARCHAR2 := FND_API.g_miss_char,
218: p_implementation_date IN DATE := FND_API.g_miss_date,
219: p_implemented_by IN NUMBER := FND_API.g_miss_num,
220: p_impby_name IN VARCHAR2 := NULL,
221: p_impby_type_id IN NUMBER := null,

Line 218: p_implementation_date IN DATE := FND_API.g_miss_date,

214: p_ci_id IN NUMBER := null,
215: p_impact_type_code IN VARCHAR2 := null,
216: p_status_code IN VARCHAR2 := null,
217: p_description IN VARCHAR2 := FND_API.g_miss_char,
218: p_implementation_date IN DATE := FND_API.g_miss_date,
219: p_implemented_by IN NUMBER := FND_API.g_miss_num,
220: p_impby_name IN VARCHAR2 := NULL,
221: p_impby_type_id IN NUMBER := null,
222: p_implementation_comment IN VARCHAR2 := FND_API.g_miss_char,

Line 219: p_implemented_by IN NUMBER := FND_API.g_miss_num,

215: p_impact_type_code IN VARCHAR2 := null,
216: p_status_code IN VARCHAR2 := null,
217: p_description IN VARCHAR2 := FND_API.g_miss_char,
218: p_implementation_date IN DATE := FND_API.g_miss_date,
219: p_implemented_by IN NUMBER := FND_API.g_miss_num,
220: p_impby_name IN VARCHAR2 := NULL,
221: p_impby_type_id IN NUMBER := null,
222: p_implementation_comment IN VARCHAR2 := FND_API.g_miss_char,
223: p_record_version_number IN NUMBER := null,

Line 222: p_implementation_comment IN VARCHAR2 := FND_API.g_miss_char,

218: p_implementation_date IN DATE := FND_API.g_miss_date,
219: p_implemented_by IN NUMBER := FND_API.g_miss_num,
220: p_impby_name IN VARCHAR2 := NULL,
221: p_impby_type_id IN NUMBER := null,
222: p_implementation_comment IN VARCHAR2 := FND_API.g_miss_char,
223: p_record_version_number IN NUMBER := null,
224: p_impacted_task_id IN NUMBER := FND_API.g_miss_num,
225: p_impacted_task_name IN VARCHAR2 := NULL,
226:

Line 224: p_impacted_task_id IN NUMBER := FND_API.g_miss_num,

220: p_impby_name IN VARCHAR2 := NULL,
221: p_impby_type_id IN NUMBER := null,
222: p_implementation_comment IN VARCHAR2 := FND_API.g_miss_char,
223: p_record_version_number IN NUMBER := null,
224: p_impacted_task_id IN NUMBER := FND_API.g_miss_num,
225: p_impacted_task_name IN VARCHAR2 := NULL,
226:
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,

Line 271: IF (p_impacted_task_id IS NOT NULL and p_impacted_task_id <> FND_API.g_miss_num) THEN

267: x_msg_count := 0;
268: x_msg_data := '';
269:
270: /* Code added for Bug 10396051 */
271: IF (p_impacted_task_id IS NOT NULL and p_impacted_task_id <> FND_API.g_miss_num) THEN
272: l_task_id := p_impacted_task_id;
273: ELSIF p_impacted_task_name IS NOT NULL THEN
274: OPEN get_task_id;
275: FETCH get_task_id INTO l_task_id;

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278: -- record already exists
279: PA_UTILS.Add_Message( p_app_short_name => 'PA'
280: ,p_msg_name => 'PA_TASK_NAME_INVALID');
281:
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: END IF;
284:
285: CLOSE get_task_id; --Bug 3868121
286: ELSE

Line 299: IF p_description = FND_API.g_miss_char then

295:
296:
297:
298: FOR rec IN get_ci_info LOOP
299: IF p_description = FND_API.g_miss_char then
300: l_description := rec.description ;
301: END IF;
302:
303: IF p_implementation_date = FND_API.g_miss_date then

Line 303: IF p_implementation_date = FND_API.g_miss_date then

299: IF p_description = FND_API.g_miss_char then
300: l_description := rec.description ;
301: END IF;
302:
303: IF p_implementation_date = FND_API.g_miss_date then
304: l_implementation_date := rec.implementation_date;
305: END IF;
306:
307: IF p_implemented_by = FND_API.g_miss_num AND p_impby_name IS NULL then

Line 307: IF p_implemented_by = FND_API.g_miss_num AND p_impby_name IS NULL then

303: IF p_implementation_date = FND_API.g_miss_date then
304: l_implementation_date := rec.implementation_date;
305: END IF;
306:
307: IF p_implemented_by = FND_API.g_miss_num AND p_impby_name IS NULL then
308: l_implemented_by := rec.implemented_by;
309: END IF;
310:
311: IF p_implementation_comment = FND_API.g_miss_char then

Line 311: IF p_implementation_comment = FND_API.g_miss_char then

307: IF p_implemented_by = FND_API.g_miss_num AND p_impby_name IS NULL then
308: l_implemented_by := rec.implemented_by;
309: END IF;
310:
311: IF p_implementation_comment = FND_API.g_miss_char then
312: l_implementation_comment := rec.implementation_comment;
313: END IF;
314:
315: IF p_impacted_task_id = FND_API.g_miss_num

Line 315: IF p_impacted_task_id = FND_API.g_miss_num

311: IF p_implementation_comment = FND_API.g_miss_char then
312: l_implementation_comment := rec.implementation_comment;
313: END IF;
314:
315: IF p_impacted_task_id = FND_API.g_miss_num
316: AND p_impacted_task_name IS NULL then
317: l_task_id := rec.impacted_task_id;
318: END IF;
319:

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366: ROLLBACK TO update_ci_impact;
367: END IF;
368:
369: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
370: x_return_status := FND_API.G_RET_STS_ERROR;
371:
372:
373: WHEN OTHERS THEN
374: IF p_commit = 'T' THEN