DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_DYN dependencies on PA_ACTION_SET_UTILS

Line 4: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,

1: PACKAGE BODY PA_ACTION_SETS_DYN AS
2: PROCEDURE validate_action_set_line(p_action_set_type_code IN VARCHAR2,
3: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
4: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
5: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
6: IS
7: BEGIN
8: NULL;

Line 72: x_action_set_line_id_tbl OUT NOCOPY pa_action_set_utils.action_set_line_id_tbl_type, -- For 1159 mandate changes bug#2674619

68: END;
69: PROCEDURE get_action_set_line_ids( p_action_set_type_code IN VARCHAR2,
70: p_project_number_from IN VARCHAR2,
71: p_project_number_to IN VARCHAR2,
72: x_action_set_line_id_tbl OUT NOCOPY pa_action_set_utils.action_set_line_id_tbl_type, -- For 1159 mandate changes bug#2674619
73: x_object_name_tbl OUT NOCOPY pa_action_set_utils.object_name_tbl_type, -- For 1159 mandate changes bug#2674619
74: x_project_number_tbl OUT NOCOPY pa_action_set_utils.project_number_tbl_type -- For 1159 mandate changes bug#2674619
75: )
76: IS

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

69: PROCEDURE get_action_set_line_ids( p_action_set_type_code IN VARCHAR2,
70: p_project_number_from IN VARCHAR2,
71: p_project_number_to IN VARCHAR2,
72: x_action_set_line_id_tbl OUT NOCOPY pa_action_set_utils.action_set_line_id_tbl_type, -- For 1159 mandate changes bug#2674619
73: x_object_name_tbl OUT NOCOPY pa_action_set_utils.object_name_tbl_type, -- For 1159 mandate changes bug#2674619
74: x_project_number_tbl OUT NOCOPY pa_action_set_utils.project_number_tbl_type -- For 1159 mandate changes bug#2674619
75: )
76: IS
77: BEGIN

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

70: p_project_number_from IN VARCHAR2,
71: p_project_number_to IN VARCHAR2,
72: x_action_set_line_id_tbl OUT NOCOPY pa_action_set_utils.action_set_line_id_tbl_type, -- For 1159 mandate changes bug#2674619
73: x_object_name_tbl OUT NOCOPY pa_action_set_utils.object_name_tbl_type, -- For 1159 mandate changes bug#2674619
74: x_project_number_tbl OUT NOCOPY pa_action_set_utils.project_number_tbl_type -- For 1159 mandate changes bug#2674619
75: )
76: IS
77: BEGIN
78: NULL;

Line 320: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,

316: END;
317: PROCEDURE perform_action_set_line(p_action_set_type_code IN VARCHAR2,
318: p_action_set_details_rec IN pa_action_sets%ROWTYPE,
319: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
320: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
321: x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type, -- For 1159 mandate changes bug#2674619
322: x_action_line_result_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
323: IS
324: BEGIN

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

317: PROCEDURE perform_action_set_line(p_action_set_type_code IN VARCHAR2,
318: p_action_set_details_rec IN pa_action_sets%ROWTYPE,
319: p_action_set_line_rec IN pa_action_set_lines%ROWTYPE,
320: p_action_line_conditions_tbl IN pa_action_set_utils.action_line_cond_tbl_type,
321: x_action_line_audit_tbl OUT NOCOPY pa_action_set_utils.insert_audit_lines_tbl_type, -- For 1159 mandate changes bug#2674619
322: x_action_line_result_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
323: IS
324: BEGIN
325: NULL;