APPS.PA_ACTION_SET_UTILS dependencies on PA_ACTION_SETS

Line 15: FROM pa_action_sets

11:
12: BEGIN
13:
14: SELECT action_set_id INTO l_action_set_id
15: FROM pa_action_sets
16: WHERE object_type = p_object_type
17: AND object_id = p_object_id
18: AND action_set_type_code = p_action_set_type_code
19: AND status_code IN ('NOT_STARTED', 'STARTED', 'PAUSED', 'RESUMED', 'CLOSED');

Line 184: RETURN pa_action_sets%ROWTYPE

180:
181: END;
182:
183: FUNCTION get_action_set_details (p_action_set_line_id IN NUMBER)
184: RETURN pa_action_sets%ROWTYPE
185: IS
186:
187: l_action_sets_rec pa_action_sets%ROWTYPE;
188:

Line 187: l_action_sets_rec pa_action_sets%ROWTYPE;

183: FUNCTION get_action_set_details (p_action_set_line_id IN NUMBER)
184: RETURN pa_action_sets%ROWTYPE
185: IS
186:
187: l_action_sets_rec pa_action_sets%ROWTYPE;
188:
189: BEGIN
190:
191: SELECT sets.action_set_id,

Line 248: FROM pa_action_sets sets,

244: l_action_sets_rec.attribute12,
245: l_action_sets_rec.attribute13,
246: l_action_sets_rec.attribute14,
247: l_action_sets_rec.attribute15
248: FROM pa_action_sets sets,
249: pa_action_set_lines lines
250: WHERE lines.action_set_line_id = p_action_set_line_id
251: AND lines.action_set_id = sets.action_set_id;
252:

Line 475: FROM pa_action_sets

471: l_name_unique VARCHAR2(1);
472:
473: CURSOR check_name_unique_in_type IS
474: SELECT 'X'
475: FROM pa_action_sets
476: WHERE action_set_name = p_action_set_name
477: AND action_set_type_code = p_action_set_type_code
478: AND action_set_template_flag = 'Y'
479: AND ((action_set_id <> p_action_set_id AND p_action_set_id IS NOT NULL)

Line 515: FROM pa_action_sets

511: l_is_source VARCHAR2(1);
512:
513: CURSOR check_action_set_is_source IS
514: SELECT 'X'
515: FROM pa_action_sets
516: WHERE source_action_set_id = p_action_set_id;
517:
518: BEGIN
519:

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

632: RAISE;
633:
634: END;
635:
636: PROCEDURE Check_Action_Set_Name_Or_Id (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
637: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
638: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
639: ,p_check_id_flag IN VARCHAR2
640: ,p_date IN DATE := SYSDATE

Line 637: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE

633:
634: END;
635:
636: PROCEDURE Check_Action_Set_Name_Or_Id (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
637: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
638: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
639: ,p_check_id_flag IN VARCHAR2
640: ,p_date IN DATE := SYSDATE
641: ,x_action_set_id OUT NOCOPY pa_action_sets.action_set_id%TYPE --File.Sql.39 bug 4440895

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

637: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
638: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
639: ,p_check_id_flag IN VARCHAR2
640: ,p_date IN DATE := SYSDATE
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');

Line 651: FROM pa_action_sets

647: IF p_action_set_id IS NOT NULL THEN
648: IF p_check_id_flag = 'Y' THEN
649: SELECT action_set_id
650: INTO x_action_set_id
651: FROM pa_action_sets
652: WHERE action_set_id = p_action_set_id
653: -- 2767129: Modified select stmt to use action_set_template_flag for
654: -- performance improvement. This is OK because the action set LOV
655: -- only displays template action sets.

Line 668: FROM pa_action_sets

664: END IF;
665: ELSE
666: SELECT action_set_id
667: INTO x_action_set_id
668: FROM pa_action_sets
669: WHERE action_set_name = p_action_set_name
670: -- 2767129: Modified select stmt to use action_set_template_flag for
671: -- performance improvement. This is OK because the action set LOV
672: -- only displays template action sets.

Line 699: x_line_numbers_tbl := pa_action_sets_pvt.g_line_number_msg_tbl;

695: IS
696:
697: BEGIN
698:
699: x_line_numbers_tbl := pa_action_sets_pvt.g_line_number_msg_tbl;
700: x_line_messages_tbl := pa_action_sets_pvt.g_info_msg_tbl;
701:
702: END;
703:

Line 700: x_line_messages_tbl := pa_action_sets_pvt.g_info_msg_tbl;

696:
697: BEGIN
698:
699: x_line_numbers_tbl := pa_action_sets_pvt.g_line_number_msg_tbl;
700: x_line_messages_tbl := pa_action_sets_pvt.g_info_msg_tbl;
701:
702: END;
703:
704: END pa_action_set_utils;