eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 16: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

12: p_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
13: p_action IN VARCHAR2 := 'SAVE' ,
14: p_bulk_load_flag IN VARCHAR2 := 'N' ,
15: p_progress_mode IN VARCHAR2 := 'FUTURE' ,
16: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
17: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
18: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_object_type IN VARCHAR2 := 'PA_DELIVERABLES' ,
20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 17: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

13: p_action IN VARCHAR2 := 'SAVE' ,
14: p_bulk_load_flag IN VARCHAR2 := 'N' ,
15: p_progress_mode IN VARCHAR2 := 'FUTURE' ,
16: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
17: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
18: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_object_type IN VARCHAR2 := 'PA_DELIVERABLES' ,
20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 18: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

14: p_bulk_load_flag IN VARCHAR2 := 'N' ,
15: p_progress_mode IN VARCHAR2 := 'FUTURE' ,
16: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
17: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
18: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_object_type IN VARCHAR2 := 'PA_DELIVERABLES' ,
20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

16: p_percent_complete_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
17: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
18: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_object_type IN VARCHAR2 := 'PA_DELIVERABLES' ,
20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

Line 21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

17: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
18: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_object_type IN VARCHAR2 := 'PA_DELIVERABLES' ,
20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

18: p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
19: p_object_type IN VARCHAR2 := 'PA_DELIVERABLES' ,
20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

19: p_object_type IN VARCHAR2 := 'PA_DELIVERABLES' ,
20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,

20: p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

21: p_del_status IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29: p_deliverable_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

Line 26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

22: p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29: p_deliverable_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: p_record_version_number IN NUMBER ,

Line 27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

23: p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29: p_deliverable_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: p_record_version_number IN NUMBER ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

Line 28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

24: p_percent_complete IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29: p_deliverable_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: p_record_version_number IN NUMBER ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,

Line 29: p_deliverable_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,

25: p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
26: p_progress_comment IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29: p_deliverable_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: p_record_version_number IN NUMBER ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
33: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,

27: p_brief_overview IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
28: p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
29: p_deliverable_due_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
30: p_record_version_number IN NUMBER ,
31: p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
32: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
33: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
34: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
35: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 251: IF p_task_id IS NULL or p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

247:
248:
249: -- It is possible to enter deliverable progress records even if it is not associated to a task
250:
251: IF p_task_id IS NULL or p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
252: l_task_id := 0;
253: ELSE
254: l_task_id := p_task_id;
255: END IF;

Line 377: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL

373: x_return_status := FND_API.G_RET_STS_ERROR;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376:
377: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
378: THEN
379: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
380: ,p_msg_name => 'PA_TP_INV_AOD_AMG'
381: ,p_token1 => 'DEL_NAME' -- Bug 6497559

Line 389: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL

385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: /* FPM Dev CR 3
389: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
390: THEN
391: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
392: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
393: x_msg_data := 'PA_TP_INV_PRG_STAT';

Line 399: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL

395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: */
398: -- FPM Dev CR 3 : Defaulting Progress Status
399: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
400: THEN
401: l_progress_status_code := 'PROGRESS_STAT_ON_TRACK';
402: ELSE
403: l_progress_status_code := p_progress_status_code;

Line 406: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_del_status IS NULL

402: ELSE
403: l_progress_status_code := p_progress_status_code;
404: END IF;
405:
406: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_del_status IS NULL
407: THEN
408: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
409: ,p_msg_name => 'PA_TP_INV_DLV_STAT_AMG' -- Bug 6497559
410: ,p_token1 => 'DEL_NAME'

Line 457: IF p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

453: */
454:
455: -- 3982374 end
456:
457: IF p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: THEN
459: l_percent_complete := 0;
460: ELSE
461: l_percent_complete := nvl(p_percent_complete,0);

Line 464: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

460: ELSE
461: l_percent_complete := nvl(p_percent_complete,0);
462: END IF;
463:
464: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
465: THEN
466: l_actual_finish_date := null;
467: ELSE
468: l_actual_finish_date := p_actual_finish_date;

Line 472: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

468: l_actual_finish_date := p_actual_finish_date;
469: END IF;
470:
471:
472: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
473: THEN
474: l_del_status := null;
475: ELSE
476: l_del_status := p_del_status;

Line 479: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

475: ELSE
476: l_del_status := p_del_status;
477: END IF;
478:
479: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480: THEN
481: l_pm_product_code := null;
482: ELSE
483: l_pm_product_code := p_pm_product_code;

Line 486: IF p_PROGRESS_COMMENT = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

482: ELSE
483: l_pm_product_code := p_pm_product_code;
484: END IF;
485:
486: IF p_PROGRESS_COMMENT = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
487: THEN
488: l_PROGRESS_COMMENT := null;
489: ELSE
490: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT;

Line 493: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

489: ELSE
490: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT;
491: END IF;
492:
493: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
494: THEN
495: l_brief_overview := null;
496: ELSE
497: l_brief_overview := p_brief_overview;

Line 987: -- IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_percent_complete_id IS NULL

983:
984: IF l_db_action = 'CREATE'
985: THEN
986:
987: -- IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_percent_complete_id IS NULL
988: --THEN
989: l_percent_complete_id := null;
990: --ELSE
991: -- l_percent_complete_id := p_percent_complete_id;

Line 1389: IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_working_aod IS NULL -- Bug 10225425

1385: ELSE
1386: l_aod := p_as_of_date;
1387: END IF;
1388:
1389: IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR l_working_aod IS NULL -- Bug 10225425
1390: THEN
1391: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
1392: p_project_id => p_project_id
1393: ,p_object_id => p_object_id

Line 1834: Pa_Interface_Utils_Pub.get_messages

1830: end if;
1831:
1832: IF l_msg_count = 1 AND x_msg_data IS NULL
1833: THEN
1834: Pa_Interface_Utils_Pub.get_messages
1835: ( p_encoded => Fnd_Api.G_TRUE
1836: , p_msg_index => 1
1837: , p_msg_count => l_msg_count
1838: , p_msg_data => l_msg_data