1 PACKAGE FTE_SEL_GROUPS_PKG AUTHID CURRENT_USER AS
2 /* $Header: FTESELGS.pls 120.0 2005/05/26 17:48:59 appldev noship $ */
3
4 --
5 -- PUBLIC FUNCTIONS/PROCEDURES
6 --
7 -- Procedure: Validate_Group
8 --
9 -- 1) Name should be unique
10 -- 2) Start/End dates should not overlap with other assigned groups
11 -- for each and every assignee
12 -- a) CREATE/COPY : 1 assignee
13 -- b) UPDATE : 1 or more assignee
14
15 PROCEDURE Validate_Group(
16 p_group_id IN NUMBER,
17 p_name IN VARCHAR2,
18 p_start_date IN DATE,
19 p_end_date IN DATE,
20 p_assignee_type IN VARCHAR2,
21 p_assignee_id IN NUMBER,
22 p_mode IN VARCHAR2,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2);
26
27 -- Procedure: Copy_Group
28 --
29 -- 1) Copies all the entities composing the group except for FTE_SEL_RESULTS
30
31 PROCEDURE Copy_Group(p_group_id IN NUMBER,
32 x_group_id OUT NOCOPY NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2);
36
37 --
38 -- Procedure: Validate_Shipmethod
39 --
40 -- 1) Checks whether the shipmethod is valid
41
42 PROCEDURE Validate_Shipmethod(p_carrier_id IN NUMBER,
43 p_service_level IN VARCHAR2,
44 p_mode IN VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_data OUT NOCOPY VARCHAR2);
47
48 --
49 -- Procedure: Validate_Assignment
50 --
51 -- 1) Checks whether the group can be assigned to the assignee
52
53 PROCEDURE Validate_Assignment(p_group_name IN VARCHAR2,
54 p_assignee_type IN VARCHAR2,
55 p_assignee_id IN NUMBER,
56 x_group_id OUT NOCOPY NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2);
60
61 --
62 -- Procedure: Delete_Results
63 --
64 -- 1) Delete data from FTE_SEL_RESULTS for Update operation
65 --
66
67 PROCEDURE Delete_Results(p_group_id IN NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2);
71 --
72 -- Procedure: Save_Results
73 --
74 -- 1) Insert data into FTE_SEL_RESULTS for Create/Copy/Update operation
75 --
76
77 PROCEDURE Save_Results( p_group_id IN NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2);
81
82 --
83 -- Function: Is_Valid_Region
84 --
85 -- Purpose: Check if the Rule consists of Regions defined in the current language
86 --
87 --
88 FUNCTION Is_Valid_Region(
89 p_group_id IN NUMBER
90 ) RETURN VARCHAR2;
91
92
93 END FTE_SEL_GROUPS_PKG;