1 package PA_PROJ_STAT_ACTSET AUTHID CURRENT_USER as
2 /* $Header: PAASPSS.pls 115.12 2003/04/08 18:46:48 mwasowic noship $ */
3 /*=======================================================================*/
4 -- Procedure
5 -- Perform Project Status Report (Reminder) Action Set
6 --
7 -- Purpose
8 -- Invoked by the generic perform action set API to perform action
9 -- lines in the reminder action set of type PA_PROJ_STATUS_REPORT
10 -- or PA_TASK_PROGRESS on an project.
11
12 -- global table to store the audit lines
13 g_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
14
15
16 /*=======================================================================*/
17 -- Procedure
18 -- Process Action Set
19 -- Purpose
20 -- Validate the action set or action lines.
21 -- Invoked when a new action set is created, an existing action
22 -- set or action lines on the requirement are updated, or an action
23 -- set is started on a requirement.
24 /*=======================================================================*/
25 PROCEDURE Process_Action_Set (
26 p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE
27 , p_action_set_id IN NUMBER
28 , p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE :=NULL
29 , x_return_status OUT NOCOPY VARCHAR2
30 );
31
32
33 /*=======================================================================*/
34 PROCEDURE perform_action_set_line /* Default value N added for bug#2463257 */
35 (p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE:='PA_PROJ_STATUS_REPORT',
36 p_action_set_details_rec IN pa_action_sets%ROWTYPE,
37 p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
38 p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
39 x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type,
40 x_action_line_result_code OUT NOCOPY VARCHAR2);
41 /*=======================================================================*/
42 -- Procedure
43 -- Validate Project Status Report (Reminder) Action Set Line
44 --
45 -- Purpose
46 -- Invoked by the generic validate action set API to validate action
47 -- line in the reminder action set of type PA_PROJ_STATUS_REPORT
48 -- or PA_TASK_PROGRESS on an project.
49 /*=======================================================================*/
50 PROCEDURE validate_action_set_line (
51 p_action_set_type_code IN VARCHAR2 := 'PA_PROJ_STATUS_REPORT'
52 , p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
53 , p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
54 , x_return_status OUT NOCOPY VARCHAR2
55 );
56 /*=======================================================================*/
57 -- Procedure
58 -- Validate Project Status Reports (Reminder) Action Set Line
59 --
60 -- Purpose
61 -- Invoked by the generic validate action set API to validate action
62 -- line in the reminder action set of type PA_PROJ_STATUS_REPORT
63 -- or PA_TASK_PROGRESS on an project.
64 /*=======================================================================*/
65 PROCEDURE validate_action_set (
66 p_action_set_type_code IN VARCHAR2 := 'PA_PROJ_STATUS_REPORT'
67 , p_action_set_id IN NUMBER
68 , p_action_set_template_flag IN VARCHAR2
69 , x_return_status OUT NOCOPY VARCHAR2
70 );
71
72 /*=======================================================================*/
73 FUNCTION validate_action_type_code (
74 p_action_set_type_code IN VARCHAR2
75 ) return BOOLEAN;
76
77 /*=======================================================================*/
78 --FUNCTION get_project_id (
79 -- p_action_set_type_code IN VARCHAR2
80 -- ,p_action_set_line_rec IN VARCHAR2
81 -- ) return NUMBER;
82
83 /*=======================================================================*/
84 FUNCTION action_allowed_for_status (
85 p_project_id IN NUMBER
86 ,p_project_status IN VARCHAR2
87 ) return BOOLEAN;
88
89 FUNCTION project_dates_valid (
90 p_project_id IN NUMBER
91 ) return VARCHAR2;
92
93
94 FUNCTION ok_to_perform_action (
95 p_report_date IN pa_object_page_layouts.next_reporting_date%TYPE
96 ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
97 ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
98 ) return BOOLEAN;
99
100 PROCEDURE perform_selected_action(
101 p_project_id IN NUMBER
102 ,p_report_type_id IN NUMBER
103 ,p_layout_id IN NUMBER
104 ,p_action_set_type_code IN VARCHAR2
105 ,p_action_set_line_rec IN pa_action_set_lines%ROWTYPE
106 ,p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
107 ,x_action_performed OUT NOCOPY VARCHAR2
108 ,x_return_status OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY NUMBER
110 ,x_msg_data OUT NOCOPY VARCHAR2);
111
112
113 PROCEDURE copy_action_sets(
114 p_project_id_from IN NUMBER
115 ,p_project_id_to IN NUMBER
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2);
119
120
121 --FUNCTION get_number_of_days(
122 -- p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
123 -- ) return NUMBER;
124
125 FUNCTION is_action_repeating(
126 p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
127 ) return BOOLEAN;
128
129 PROCEDURE delete_action_set
130 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
131 ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
132 ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
133 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
134 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
135 ,p_api_version IN NUMBER := 1.0
136 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
137 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
138 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_msg_count OUT NOCOPY NUMBER
141 ,x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144
145 PROCEDURE update_action_set
146 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
147 ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_PROJ_STATUS_REPORT'
148 ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJ_STATUS_REPORTS'
149 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
150 ,p_perform_action_set_flag IN VARCHAR2 := 'N'
151 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
152 ,p_api_version IN NUMBER := 1.0
153 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
155 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
156 ,x_new_action_set_id OUT NOCOPY NUMBER
157 ,x_return_status OUT NOCOPY VARCHAR2
158 ,x_msg_count OUT NOCOPY NUMBER
159 ,x_msg_data OUT NOCOPY VARCHAR2
160 );
161
162 END;