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_UTILS dependencies on PA_INTERFACE_UTILS_PUB

Line 409: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

405: /* ==============3435905 : FP M : Deliverables Changes For AMG START ========*/
406: Procedure Validate_Deliverable
407: (
408: p_deliverable_id IN NUMBER
409: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
413: , p_dlvr_owner_name IN VARCHAR2 := NULL

Line 410: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

406: Procedure Validate_Deliverable
407: (
408: p_deliverable_id IN NUMBER
409: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
413: , p_dlvr_owner_name IN VARCHAR2 := NULL
414: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 411: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

407: (
408: p_deliverable_id IN NUMBER
409: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
410: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
413: , p_dlvr_owner_name IN VARCHAR2 := NULL
414: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 414: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

410: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
411: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
412: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895
413: , p_dlvr_owner_name IN VARCHAR2 := NULL
414: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
416: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
417: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
418: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 418: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

414: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
415: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
416: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
417: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
418: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
419: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
420: , p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
421: , p_calling_mode IN VARCHAR2 := 'INSERT'
422: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 447: p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

443: ) RETURN NUMBER;
444:
445: PROCEDURE is_dlvr_reference_unique
446: (
447: p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
448: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
449: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
450: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
451: );

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

444:
445: PROCEDURE is_dlvr_reference_unique
446: (
447: p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
448: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
449: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
450: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
451: );
452:

Line 455: p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

451: );
452:
453: PROCEDURE Convert_pm_dlvrref_to_id
454: (
455: p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
457: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: ,p_out_deliverable_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
459: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 456: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

452:
453: PROCEDURE Convert_pm_dlvrref_to_id
454: (
455: p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
457: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: ,p_out_deliverable_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
459: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
460: );

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

453: PROCEDURE Convert_pm_dlvrref_to_id
454: (
455: p_deliverable_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
456: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
457: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
458: ,p_out_deliverable_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
459: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
460: );
461:

Line 482: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

478: ) RETURN NUMBER;
479:
480: PROCEDURE is_action_reference_unique
481: (
482: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
484: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
485: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
486: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 483: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

479:
480: PROCEDURE is_action_reference_unique
481: (
482: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
484: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
485: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
486: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
487: );

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

480: PROCEDURE is_action_reference_unique
481: (
482: p_action_reference IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
484: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
485: ,x_unique_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
486: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
487: );
488:

Line 491: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

487: );
488:
489: PROCEDURE Convert_pm_actionref_to_id
490: (
491: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
493: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
495: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 492: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

488:
489: PROCEDURE Convert_pm_actionref_to_id
490: (
491: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
493: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
495: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
496: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 493: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

489: PROCEDURE Convert_pm_actionref_to_id
490: (
491: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
493: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
495: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
496: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
497: );

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

490: (
491: p_action_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492: ,p_action_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
493: ,p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
495: ,p_out_action_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
496: ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
497: );
498:

Line 501: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

497: );
498:
499: PROCEDURE Progress_Enabled_Validation
500: (
501: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
502: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
504: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
505: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895

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

498:
499: PROCEDURE Progress_Enabled_Validation
500: (
501: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
502: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
504: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
505: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
506: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895

Line 503: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

499: PROCEDURE Progress_Enabled_Validation
500: (
501: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
502: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
503: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
504: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
505: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
506: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
507: , p_calling_Mode IN VARCHAR2 := 'INSERT'