DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 602: p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE

598: -- 3622126 added for action dates not in synch with billing txn date
599:
600: PROCEDURE GET_BILLING_DETAILS
601: (
602: p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
603: ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
604: ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895
605: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
606: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 603: ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895

599:
600: PROCEDURE GET_BILLING_DETAILS
601: (
602: p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
603: ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
604: ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895
605: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
606: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
607: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 626: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895

622: (
623: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
624: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
625: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
626: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
627: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
628: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
629: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
630: );

Line 629: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895

625: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
626: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
627: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
628: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
629: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
630: );
631:
632: END PA_DELIVERABLE_UTILS;
633: