1 package PA_Client_Extn_PM as
2 /* $Header: PAPMGCES.pls 120.3 2006/07/24 11:52:52 dthakker noship $ */
3 /*#
4 * This extension is used to substitute dates used by external systems for the standard Oracle Projects
5 * project and task start and completion dates.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Project and Task Date Extension
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_TASK
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15
16 /*#
17 * This procedure is used to map a different set of dates for the project/ and task start dates.
18 * @param p_pm_project_reference The rerference code that uniquely identifies the project in the external system
19 * @param p_pm_task_reference The rerference code that uniquely identifies the task in the external system
20 * @param p_project_id The rerference code that uniquely identifies the project in Oracle Projects
21 * @param p_task_id The rerference code that uniquely identifies the task in Oracle Projects
22 * @param p_pm_product_code The product code of the external system
23 * @rep:paraminfo {@rep:required}
24 * @param p_in_start_date The default start date
25 * @rep:paraminfo {@rep:required}
26 * @param p_in_completion_date The default completion date
27 * @rep:paraminfo {@rep:required}
28 * @param p_actual_start_date The actual start date
29 * @param p_actual_finish_date The actual finish date
30 * @param p_early_start_date The early start date
31 * @param p_early_finish_date The early finish date
32 * @param p_late_start_date The late start date
33 * @param p_late_finish_date The late finish date
34 * @param p_scheduled_start_date The scheduled start date
35 * @param p_scheduled_finish_date The scheduled finish date
36 * @param p_out_start_date The output start date
37 * @rep:paraminfo {@rep:required}
38 * @param p_out_completion_date The output completion date
39 * @rep:paraminfo {@rep:required}
40 * @param p_error_code API standard: error code
41 * @rep:paraminfo {@rep:required}
42 * @param p_error_message API standard: error message
43 * @rep:paraminfo {@rep:required}
44 * @rep:scope public
45 * @rep:lifecycle active
46 * @rep:displayname Customize Dates
47 * @rep:compatibility S
48 */
49 Procedure customize_dates (
50 p_pm_project_reference IN VARCHAR2 := NULL,
51 p_pm_task_reference IN VARCHAR2 := NULL,
52 p_project_id IN NUMBER := NULL,
53 p_task_id IN NUMBER := NULL,
54 p_pm_product_code IN VARCHAR2,
55 p_in_start_date IN DATE,
56 p_in_completion_date IN DATE,
57 p_actual_start_date IN DATE := NULL,
58 p_actual_finish_date IN DATE := NULL,
59 p_early_start_date IN DATE := NULL,
60 p_early_finish_date IN DATE := NULL,
61 p_late_start_date IN DATE := NULL,
62 p_late_finish_date IN DATE := NULL,
63 p_scheduled_start_date IN DATE := NULL,
64 p_scheduled_finish_date IN DATE := NULL,
65 p_out_start_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
66 p_out_completion_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
67 p_error_code OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
68 p_error_message OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
69
70
71 end PA_Client_Extn_PM;