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: );
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:
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);
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
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
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
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
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
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'
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
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
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
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