DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_DYN dependencies on PA_ACTION_SET_UTILS

Line 7: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,

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,

Line 19: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,

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:

Line 20: x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type, -- For 1159 mandate changes bug#2674619

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,

Line 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

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:

Line 28: x_object_name_tbl OUT NOCOPY pa_action_set_utils.object_name_tbl_type, -- For 1159 mandate changes bug#2674619

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,

Line 29: x_project_number_tbl OUT NOCOPY pa_action_set_utils.project_number_tbl_type -- For 1159 mandate changes bug#2674619

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,