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 250: IF p_task_id IS NULL or p_task_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

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

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

362: x_return_status := FND_API.G_RET_STS_ERROR;
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365:
366: IF p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE OR p_as_of_date IS NULL
367: THEN
368: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
369: ,p_msg_name => 'PA_TP_INV_AOD');
370: x_msg_data := 'PA_TP_INV_AOD';

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

372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: /* FPM Dev CR 3
376: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
377: THEN
378: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
379: ,p_msg_name => 'PA_TP_INV_PRG_STAT');
380: x_msg_data := 'PA_TP_INV_PRG_STAT';

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

382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384: */
385: -- FPM Dev CR 3 : Defaulting Progress Status
386: IF p_progress_status_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_progress_status_code IS NULL
387: THEN
388: l_progress_status_code := 'PROGRESS_STAT_ON_TRACK';
389: ELSE
390: l_progress_status_code := p_progress_status_code;

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

389: ELSE
390: l_progress_status_code := p_progress_status_code;
391: END IF;
392:
393: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_del_status IS NULL
394: THEN
395: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
396: ,p_msg_name => 'PA_TP_INV_DLV_STAT'); -- FPM Dev CR 1 : Changed message
397: x_msg_data := 'PA_TP_INV_DLV_STAT';

Line 441: IF p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

437: */
438:
439: -- 3982374 end
440:
441: IF p_percent_complete = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
442: THEN
443: l_percent_complete := 0;
444: ELSE
445: l_percent_complete := nvl(p_percent_complete,0);

Line 448: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

444: ELSE
445: l_percent_complete := nvl(p_percent_complete,0);
446: END IF;
447:
448: IF p_actual_finish_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
449: THEN
450: l_actual_finish_date := null;
451: ELSE
452: l_actual_finish_date := p_actual_finish_date;

Line 456: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

452: l_actual_finish_date := p_actual_finish_date;
453: END IF;
454:
455:
456: IF p_del_status = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
457: THEN
458: l_del_status := null;
459: ELSE
460: l_del_status := p_del_status;

Line 463: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

459: ELSE
460: l_del_status := p_del_status;
461: END IF;
462:
463: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
464: THEN
465: l_pm_product_code := null;
466: ELSE
467: l_pm_product_code := p_pm_product_code;

Line 470: IF p_PROGRESS_COMMENT = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

466: ELSE
467: l_pm_product_code := p_pm_product_code;
468: END IF;
469:
470: IF p_PROGRESS_COMMENT = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471: THEN
472: l_PROGRESS_COMMENT := null;
473: ELSE
474: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT;

Line 477: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

473: ELSE
474: l_PROGRESS_COMMENT := p_PROGRESS_COMMENT;
475: END IF;
476:
477: IF p_brief_overview = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478: THEN
479: l_brief_overview := null;
480: ELSE
481: l_brief_overview := p_brief_overview;

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

952:
953: IF l_db_action = 'CREATE'
954: THEN
955:
956: -- IF p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_percent_complete_id IS NULL
957: --THEN
958: l_percent_complete_id := null;
959: --ELSE
960: -- l_percent_complete_id := p_percent_complete_id;

Line 1358: IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1354: ELSE
1355: l_aod := p_as_of_date;
1356: END IF;
1357:
1358: IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1359: THEN
1360: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
1361: p_project_id => p_project_id
1362: ,p_object_id => p_object_id

Line 1803: Pa_Interface_Utils_Pub.get_messages

1799: end if;
1800:
1801: IF l_msg_count = 1 AND x_msg_data IS NULL
1802: THEN
1803: Pa_Interface_Utils_Pub.get_messages
1804: ( p_encoded => Fnd_Api.G_TRUE
1805: , p_msg_index => 1
1806: , p_msg_count => l_msg_count
1807: , p_msg_data => l_msg_data