DBA Data[Home] [Help]

APPS.PA_ACTION_SET_UTILS dependencies on PA_ACTION_SETS

Line 71: RETURN pa_action_sets%ROWTYPE;

67: FUNCTION get_action_line_conditions (p_action_set_line_id IN NUMBER)
68: RETURN action_line_cond_tbl_type;
69:
70: FUNCTION get_action_set_details (p_action_set_line_id IN NUMBER)
71: RETURN pa_action_sets%ROWTYPE;
72:
73: FUNCTION get_active_audit_lines (p_action_set_line_id IN NUMBER)
74: RETURN audit_lines_tbl_type;
75:

Line 106: PROCEDURE Check_Action_Set_Name_Or_Id (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL

102:
103: FUNCTION get_last_performed_date(p_action_set_line_id IN NUMBER)
104: RETURN DATE;
105:
106: PROCEDURE Check_Action_Set_Name_Or_Id (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
107: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
108: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
109: ,p_check_id_flag IN VARCHAR2
110: ,p_date IN DATE := SYSDATE

Line 107: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE

103: FUNCTION get_last_performed_date(p_action_set_line_id IN NUMBER)
104: RETURN DATE;
105:
106: PROCEDURE Check_Action_Set_Name_Or_Id (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
107: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
108: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
109: ,p_check_id_flag IN VARCHAR2
110: ,p_date IN DATE := SYSDATE
111: ,x_action_set_id OUT NOCOPY pa_action_sets.action_set_id%TYPE --File.Sql.39 bug 4440895

Line 111: ,x_action_set_id OUT NOCOPY pa_action_sets.action_set_id%TYPE --File.Sql.39 bug 4440895

107: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
108: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
109: ,p_check_id_flag IN VARCHAR2
110: ,p_date IN DATE := SYSDATE
111: ,x_action_set_id OUT NOCOPY pa_action_sets.action_set_id%TYPE --File.Sql.39 bug 4440895
112: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
114:
115: PROCEDURE get_line_information_messages(x_line_numbers_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, --File.Sql.39 bug 4440895