[Home] [Help]
PACKAGE: APPS.PA_ACTION_SETS_DYN
Source
1 PACKAGE pa_action_sets_dyn AUTHID CURRENT_USER AS
2 /*$Header: PARASDYS.pls 120.1 2005/08/19 16:47:55 mwasowic noship $*/
3
4
5 PROCEDURE validate_action_set_line(p_action_set_type_code IN VARCHAR2,
6 p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
7 p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
8 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
9
10
11 PROCEDURE process_action_set(p_action_set_type_code IN VARCHAR2,
12 p_action_set_id IN NUMBER,
13 p_action_set_template_flag IN VARCHAR2,
14 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
15
16 PROCEDURE perform_action_set_line(p_action_set_type_code IN VARCHAR2,
17 p_action_set_details_rec IN pa_action_sets%ROWTYPE,
18 p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
19 p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
20 x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type, -- For 1159 mandate changes bug#2674619
21 x_action_line_result_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
22
23
24 PROCEDURE get_action_set_line_ids( p_action_set_type_code IN VARCHAR2,
25 p_project_number_from IN VARCHAR2,
26 p_project_number_to IN VARCHAR2,
27 x_action_set_line_id_tbl OUT NOCOPY pa_action_set_utils.action_set_line_id_tbl_type, -- For 1159 mandate changes bug#2674619
28 x_object_name_tbl OUT NOCOPY pa_action_set_utils.object_name_tbl_type, -- For 1159 mandate changes bug#2674619
29 x_project_number_tbl OUT NOCOPY pa_action_set_utils.project_number_tbl_type -- For 1159 mandate changes bug#2674619
30 );
31
32 FUNCTION Is_Action_Set_Started_On_Apply(p_action_set_type_code IN VARCHAR2,
33 p_object_type IN VARCHAR2,
34 p_object_id IN NUMBER)
35 RETURN VARCHAR2;
36
37 END;