1: PACKAGE BODY pa_action_set_utils AS
2: /*$Header: PARASUTB.pls 120.2 2008/05/02 13:05:38 jcgeorge ship $*/
3: --
4:
5: FUNCTION get_action_set_id(p_action_set_type_code IN VARCHAR2,
30: FUNCTION get_action_set_lines(p_action_set_id IN NUMBER)
31: RETURN action_set_lines_tbl_type
32: IS
33:
34: l_action_set_lines_tbl pa_action_set_utils.action_set_lines_tbl_type;
35:
36: TYPE number_tbl_type IS TABLE OF NUMBER
37: INDEX BY BINARY_INTEGER;
38:
257: FUNCTION get_action_line_conditions (p_action_set_line_id IN NUMBER)
258: RETURN action_line_cond_tbl_type
259: IS
260:
261: l_action_line_cond_tbl pa_action_set_utils.action_line_cond_tbl_type;
262:
263: TYPE number_tbl_type IS TABLE OF NUMBER
264: INDEX BY BINARY_INTEGER;
265:
641: ,x_action_set_id OUT NOCOPY pa_action_sets.action_set_id%TYPE --File.Sql.39 bug 4440895
642: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
643: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
644: BEGIN
645: pa_debug.init_err_stack ('pa_action_set_utils.Check_Action_Set_Name_Or_Id');
646:
647: IF p_action_set_id IS NOT NULL THEN
648: IF p_check_id_flag = 'Y' THEN
649: SELECT action_set_id
700: x_line_messages_tbl := pa_action_sets_pvt.g_info_msg_tbl;
701:
702: END;
703:
704: END pa_action_set_utils;