[Home] [Help]
PACKAGE: APPS.PA_PRJ_PROGRESS_REPORTS_PKG
Source
1 PACKAGE PA_PRJ_PROGRESS_REPORTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PAPJXPRS.pls 120.1 2005/08/19 16:41:30 mwasowic noship $ */
3 /* APIs for Project exchange progress table */
4 /* Public API */
5 /**
6 PROCEDURE update_progress_report(
7 P_USER_ID IN NUMBER
8 ,P_COMMIT_FLAG IN VARCHAR2 default 'N'
9 ,P_DEBUG_MODE IN VARCHAR2 default 'N'
10 ,P_PROJECT_ID_OLD NUMBER := null
11 ,P_TASK_ID_OLD NUMBER := null
12 ,P_PROGRESS_STATUS_CODE_OLD VARCHAR2 := null
13 ,P_SHORT_DESCRIPTION_OLD VARCHAR2 := null
14 ,P_PROGRESS_ASOF_DATE_OLD VARCHAR2 := null
15 ,P_LONG_DESCRIPTION_OLD VARCHAR2 := null
16 ,P_ISSUES_OLD VARCHAR2 := null
17 ,P_ESTIMATED_START_DATE_OLD VARCHAR2 := null
18 ,P_ESTIMATED_END_DATE_OLD VARCHAR2 := null
19 ,P_ACTUAL_START_DATE_OLD VARCHAR2 := null
20 ,P_ACTUAL_END_DATE_OLD VARCHAR2 := null
21 ,P_PERCENT_COMPLETE_OLD NUMBER := null
22 ,P_ESTIMATE_TO_COMPLETE_OLD NUMBER := null
23 ,P_UNIT_TYPE_OLD VARCHAR2 := null
24 ,p_wf_status_code_old VARCHAR2 := null
25 ,p_wf_item_type_old VARCHAR2 := null
26 ,p_wf_item_key_old NUMBER := NULL
27 ,p_wf_process_old VARCHAR2 := null
28 ,P_PROJECT_ID_NEW NUMBER := null
29 ,P_TASK_ID_NEW NUMBER := null
30 ,P_PROGRESS_STATUS_CODE_NEW VARCHAR2 := null
31 ,P_SHORT_DESCRIPTION_NEW VARCHAR2 := null
32 ,P_PROGRESS_ASOF_DATE_NEW VARCHAR2 := null
33 ,P_LONG_DESCRIPTION_NEW VARCHAR2 := null
34 ,P_ISSUES_NEW VARCHAR2 := null
35 ,P_ESTIMATED_START_DATE_NEW VARCHAR2 := null
36 ,P_ESTIMATED_END_DATE_NEW VARCHAR2 := null
37 ,P_ACTUAL_START_DATE_NEW VARCHAR2 := null
38 ,P_ACTUAL_END_DATE_NEW VARCHAR2 := null
39 ,P_PERCENT_COMPLETE_NEW NUMBER := null
40 ,P_ESTIMATE_TO_COMPLETE_NEW NUMBER := null
41 ,P_UNIT_TYPE_NEW VARCHAR2 := null
42 ,p_wf_status_code_new VARCHAR2 := null
43 ,p_wf_item_type_new VARCHAR2 := null
44 ,p_wf_item_key_new NUMBER := null
45 ,p_wf_process_new VARCHAR2 := null
46 ,p_create_item_key_flag VARCHAR2 := 'N'
47 ,x_item_key OUT number
48 ,X_RETURN_STATUS OUT VARCHAR2
49 ,X_MSG_COUNT IN OUT NUMBER
50 ,X_MSG_DATA IN OUT pa_vc_1000_2000
51 );
52 ***/
53
54 /* Private APIs */
55 PROCEDURE Insert_Row(
56 -- P_ROWID IN OUT VARCHAR2
57 P_PROGRESS_REPORT_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
58 ,P_RECORD_VERSION_NUMBER NUMBER DEFAULT 1
59 ,P_PROJECT_ID NUMBER
60 ,P_TASK_ID NUMBER default 0
61 ,P_PROGRESS_STATUS_CODE VARCHAR2 default 'ON_TRACK'
62 ,P_SHORT_DESCRIPTION VARCHAR2 default null
63 ,P_PROGRESS_ASOF_DATE DATE default sysdate
64 ,P_LONG_DESCRIPTION VARCHAR2 default null
65 ,P_ISSUES VARCHAR2 default null
66 ,P_ESTIMATED_START_DATE DATE default null
67 ,P_ESTIMATED_END_DATE DATE default null
68 ,P_ACTUAL_START_DATE DATE default null
69 ,P_ACTUAL_END_DATE DATE default null
70 ,P_PERCENT_COMPLETE NUMBER default null
71 ,P_ESTIMATE_TO_COMPLETE NUMBER default null
72 ,P_UNIT_TYPE VARCHAR2 default null
73 ,P_PLANNED_ACTIVITIES VARCHAR2 DEFAULT NULL
74 ,P_REPORT_STATUS VARCHAR2 DEFAULT 'WIP'
75 ,P_CREATED_BY NUMBER default -1
76 ,P_CREATION_DATE DATE default sysdate
77 ,P_LAST_UPDATED_BY NUMBER default -1
78 ,P_LAST_UPDATE_DATE DATE default sysdate
79 ,P_LAST_UPDATE_LOGIN NUMBER default -1
80 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
82 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
83 PROCEDURE Update_Row(
84 P_PROGRESS_REPORT_ID NUMBER
85 ,P_RECORD_VERSION_NUMBER NUMBER
86 ,P_PROJECT_ID NUMBER
87 ,P_TASK_ID NUMBER
88 ,P_PROGRESS_STATUS_CODE VARCHAR2
89 ,P_SHORT_DESCRIPTION VARCHAR2
90 ,P_PROGRESS_ASOF_DATE DATE
91 ,P_LONG_DESCRIPTION VARCHAR2
92 ,P_ISSUES VARCHAR2
93 ,P_ESTIMATED_START_DATE DATE default trunc(to_date('01/01/1851','DD/MM/YYYY'))
94 ,P_ESTIMATED_END_DATE DATE default trunc(to_date('01/01/1851','DD/MM/YYYY'))
95 ,P_ACTUAL_START_DATE DATE default trunc(to_date('01/01/1851','DD/MM/YYYY'))
96 ,P_ACTUAL_END_DATE DATE default trunc(to_date('01/011851','DD/MM/YYYY'))
97 ,P_PERCENT_COMPLETE NUMBER default -9999
98 ,P_ESTIMATE_TO_COMPLETE NUMBER default -9999
99 ,P_UNIT_TYPE VARCHAR2 default '####'
100 ,P_PLANNED_ACTIVITIES VARCHAR2 default '####'
101 ,P_REPORT_STATUS VARCHAR2 default '####'
102 ,p_wf_status_code VARCHAR2 default '####'
103 ,p_wf_item_type VARCHAR2 default '####'
104 ,p_wf_item_key NUMBER default -9999
105 ,p_wf_process VARCHAR2 default '####'
106 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
108 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
109 );
110
111 PROCEDURE Delete_Row( P_PROGRESS_REPORT_ID NUMBER
112 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115 );
116 PROCEDURE Copy_lastpublished_report(
117 P_PROJECT_ID NUMBER
118 );
119
120 END PA_PRJ_PROGRESS_REPORTS_PKG;