[Home] [Help]
PACKAGE: APPS.PA_PROJ_ELEMENT_SCH_PKG
Source
1 PACKAGE PA_PROJ_ELEMENT_SCH_PKG AUTHID CURRENT_USER AS
2 /* $Header: PATSKT3S.pls 120.1 2005/08/19 17:06:11 mwasowic noship $ */
3
4 PROCEDURE Insert_Row(
5 X_ROW_ID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6 X_PEV_SCHEDULE_ID IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
7 X_ELEMENT_VERSION_ID NUMBER,
8 X_PROJECT_ID NUMBER,
9 X_PROJ_ELEMENT_ID NUMBER,
10 X_SCHEDULED_START_DATE DATE,
11 X_SCHEDULED_FINISH_DATE DATE,
12 X_OBLIGATION_START_DATE DATE,
13 X_OBLIGATION_FINISH_DATE DATE,
14 X_ACTUAL_START_DATE DATE,
15 X_ACTUAL_FINISH_DATE DATE,
16 X_ESTIMATED_START_DATE DATE,
17 X_ESTIMATED_FINISH_DATE DATE,
18 X_DURATION NUMBER,
19 X_EARLY_START_DATE DATE,
20 X_EARLY_FINISH_DATE DATE,
21 X_LATE_START_DATE DATE,
22 X_LATE_FINISH_DATE DATE,
23 X_CALENDAR_ID NUMBER,
24 X_MILESTONE_FLAG VARCHAR2,
25 X_CRITICAL_FLAG VARCHAR2,
26 X_WQ_PLANNED_QUANTITY NUMBER,
27 X_PLANNED_EFFORT NUMBER,
28 X_ACTUAL_DURATION NUMBER,
29 X_ESTIMATED_DURATION NUMBER,
30 --bug 3305199 schedule options
31 X_def_sch_tool_tsk_type_code IN VARCHAR2 := NULL,
32 X_constraint_type_code IN VARCHAR2 := NULL,
33 X_constraint_date IN DATE := NULL,
34 X_free_slack IN NUMBER := NULL,
35 X_total_slack IN NUMBER := NULL,
36 X_effort_driven_flag IN VARCHAR2 := 'N',
37 X_level_assignments_flag IN VARCHAR2 := 'N',
38 --end bug 3305199
39 X_ext_act_duration IN NUMBER := NULL,
40 X_ext_remain_duration IN NUMBER := NULL,
41 X_ext_sch_duration IN NUMBER := NULL,
42 x_source_object_id IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM, --Bug No 3594635 SMukka
43 x_source_object_type IN VARCHAR2:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR, --Bug No 3594635 SMukka
44 X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
45 X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
46 X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
47 X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
48 X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
49 X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
50 X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
51 X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
52 X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
53 X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
54 X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
55 X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
56 X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
57 X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
58 X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
59 X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
60 );
61
62 PROCEDURE Update_Row(
63 X_ROW_ID IN VARCHAR2,
64 X_PEV_SCHEDULE_ID NUMBER,
65 X_ELEMENT_VERSION_ID NUMBER,
66 X_PROJECT_ID NUMBER,
67 X_PROJ_ELEMENT_ID NUMBER,
68 X_SCHEDULED_START_DATE DATE,
69 X_SCHEDULED_FINISH_DATE DATE,
70 X_OBLIGATION_START_DATE DATE,
71 X_OBLIGATION_FINISH_DATE DATE,
72 X_ACTUAL_START_DATE DATE,
73 X_ACTUAL_FINISH_DATE DATE,
74 X_ESTIMATED_START_DATE DATE,
75 X_ESTIMATED_FINISH_DATE DATE,
76 X_DURATION NUMBER,
77 X_EARLY_START_DATE DATE,
78 X_EARLY_FINISH_DATE DATE,
79 X_LATE_START_DATE DATE,
80 X_LATE_FINISH_DATE DATE,
81 X_CALENDAR_ID NUMBER,
82 X_MILESTONE_FLAG VARCHAR2,
83 X_CRITICAL_FLAG VARCHAR2,
84 X_WQ_PLANNED_QUANTITY NUMBER,
85 X_PLANNED_EFFORT NUMBER,
86 X_ACTUAL_DURATION NUMBER,
87 X_ESTIMATED_DURATION NUMBER,
88 --bug 3305199 schedule options
89 X_def_sch_tool_tsk_type_code IN VARCHAR2 := NULL,
90 X_constraint_type_code IN VARCHAR2 := NULL,
91 X_constraint_date IN DATE := NULL,
92 X_free_slack IN NUMBER := NULL,
93 X_total_slack IN NUMBER := NULL,
94 X_effort_driven_flag IN VARCHAR2 := 'N',
95 X_level_assignments_flag IN VARCHAR2 := 'N',
96 --end bug 3305199
97 X_RECORD_VERSION_NUMBER NUMBER,
98 X_ext_act_duration IN NUMBER := NULL,
99 X_ext_remain_duration IN NUMBER := NULL,
100 X_ext_sch_duration IN NUMBER := NULL,
101 X_attribute_category IN pa_proj_elem_ver_schedule.attribute_category%TYPE := NULL,
102 X_attribute1 IN pa_proj_elem_ver_schedule.attribute1%TYPE := NULL,
103 X_attribute2 IN pa_proj_elem_ver_schedule.attribute2%TYPE := NULL,
104 X_attribute3 IN pa_proj_elem_ver_schedule.attribute3%TYPE := NULL,
105 X_attribute4 IN pa_proj_elem_ver_schedule.attribute4%TYPE := NULL,
106 X_attribute5 IN pa_proj_elem_ver_schedule.attribute5%TYPE := NULL,
107 X_attribute6 IN pa_proj_elem_ver_schedule.attribute6%TYPE := NULL,
108 X_attribute7 IN pa_proj_elem_ver_schedule.attribute7%TYPE := NULL,
109 X_attribute8 IN pa_proj_elem_ver_schedule.attribute8%TYPE := NULL,
110 X_attribute9 IN pa_proj_elem_ver_schedule.attribute9%TYPE := NULL,
111 X_attribute10 IN pa_proj_elem_ver_schedule.attribute10%TYPE := NULL,
112 X_attribute11 IN pa_proj_elem_ver_schedule.attribute11%TYPE := NULL,
113 X_attribute12 IN pa_proj_elem_ver_schedule.attribute12%TYPE := NULL,
114 X_attribute13 IN pa_proj_elem_ver_schedule.attribute13%TYPE := NULL,
115 X_attribute14 IN pa_proj_elem_ver_schedule.attribute14%TYPE := NULL,
116 X_attribute15 IN pa_proj_elem_ver_schedule.attribute15%TYPE := NULL
117 );
118
119 PROCEDURE Delete_Row(
120 X_ROW_ID IN VARCHAR2
121 );
122
123 END PA_PROJ_ELEMENT_SCH_PKG;