1 package PA_TASK_PROG_ACTSET AUTHID CURRENT_USER as
2 /* $Header: PAASTPS.pls 115.7 2003/04/08 18:46:23 mwasowic noship $ */
3 /*=======================================================================*/
4 -- Procedure
5 -- Perform Task Progress (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
10 -- PA_TASK_PROGRESS on an project.
11
12 /*=======================================================================*/
13
14 -- global table to store the audit lines
15 g_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
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 := 'PA_TASK_PROGRESS'
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 PROCEDURE perform_action_set_line(p_action_set_type_code IN VARCHAR2 := 'PA_TASK_PROGRESS',
34 p_action_set_details_rec IN pa_action_sets%ROWTYPE,
35 p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
36 p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
37 x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type,
38 x_action_line_result_code OUT NOCOPY VARCHAR2);
39
40
41 /*=======================================================================*/
42
43 PROCEDURE copy_action_sets(
44 p_project_id_from IN NUMBER
45 ,p_project_id_to IN NUMBER
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2);
49
50
51 FUNCTION validate_action_type_code (
52 p_action_set_type_code IN VARCHAR2
53 ) return BOOLEAN;
54
55 FUNCTION action_allowed_for_status (
56 p_project_id IN NUMBER
57 ,p_project_status IN VARCHAR2
58 ) return BOOLEAN;
59
60 FUNCTION ok_to_perform_action (
61 p_project_id IN NUMBER
62 ,p_proj_start_date IN DATE
63 ) return BOOLEAN;
64
65
66 FUNCTION is_action_repeating(
67 p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type
68 ) return BOOLEAN;
69
70
71 PROCEDURE delete_action_set
72 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
73 ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
74 ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
75 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
76 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
77 ,p_api_version IN NUMBER := 1.0
78 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
79 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
80 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
81 ,x_return_status OUT NOCOPY VARCHAR2
82 ,x_msg_count OUT NOCOPY NUMBER
83 ,x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE update_action_set
87 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
88 ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
89 ,p_object_type IN pa_action_sets.object_type%TYPE := 'PA_PROJECTS'
90 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
91 ,p_perform_action_set_flag IN VARCHAR2 := 'N'
92 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
93 ,p_api_version IN NUMBER := 1.0
94 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
95 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
96 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
97 ,x_new_action_set_id OUT NOCOPY NUMBER
98 ,x_return_status OUT NOCOPY VARCHAR2
99 ,x_msg_count OUT NOCOPY NUMBER
100 ,x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103
104 END;