1 PACKAGE PA_ROLE_PROFILES_PKG AS
2 -- $Header: PARPRPKS.pls 120.1 2005/08/19 16:59:14 mwasowic noship $
3
4 PROCEDURE Insert_Row1
5 ( p_profile_name IN VARCHAR,
6 p_description IN VARCHAR2,
7 p_effective_start_date IN DATE,
8 p_effective_end_date IN DATE DEFAULT NULL,
9 p_profile_type_code IN VARCHAR2 DEFAULT NULL,
10 p_approval_status_code IN VARCHAR2 DEFAULT NULL,
11 p_business_group_id IN NUMBER DEFAULT NULL,
12 p_organization_id IN NUMBER DEFAULT NULL,
13 p_job_id IN NUMBER DEFAULT NULL,
14 p_position_id IN NUMBER DEFAULT NULL,
15 p_resource_id IN NUMBER DEFAULT NULL,
16 x_profile_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
18
19 PROCEDURE Insert_Row2
20 ( p_profile_id IN NUMBER,
21 p_project_role_id IN NUMBER,
22 p_role_weighting IN NUMBER,
23 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
24
25 PROCEDURE Update_Row
26 ( p_profile_id IN NUMBER,
27 p_profile_name IN VARCHAR,
28 p_description IN VARCHAR2,
29 p_effective_start_date IN DATE,
30 p_effective_end_date IN DATE DEFAULT NULL,
31 --p_profile_type_code IN VARCHAR2 DEFAULT NULL,
32 p_approval_status_code IN VARCHAR2 DEFAULT NULL,
33 p_business_group_id IN NUMBER DEFAULT NULL,
34 p_organization_id IN NUMBER DEFAULT NULL,
35 p_job_id IN NUMBER DEFAULT NULL,
36 p_position_id IN NUMBER DEFAULT NULL,
37 p_resource_id IN NUMBER DEFAULT NULL,
38 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
39
40 /* Angie added code for saving purpose but need to verify/change/test later
41
42 PROCEDURE Validate_Profile_Lines
43 ( p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
44 p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
45 p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
46 x_role_id_tbl OUT SYSTEM.PA_NUM_TBL_TYPE,
47 x_return_status OUT VARCHAR2);
48 -- x_msg_count OUT NUMBER,
49 -- x_msg_data OUT VARCHAR2) ;
50
51
52 PROCEDURE Add_Res_Profiles
53 ( p_resource_id IN NUMBER,
54 p_profile_name IN VARCHAR2,
55 p_profile_type_code IN VARCHAR2,
56 p_description IN VARCHAR2 := NULL,
57 p_effective_start_date IN DATE,
58 p_effective_end_date IN DATE := NULL,
59 p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
60 p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
61 p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 x_return_status OUT VARCHAR2,
64 x_msg_count OUT NUMBER,
65 x_msg_data OUT VARCHAR2) ;
66
67 PROCEDURE Update_Res_Profiles
68 ( p_profile_id IN NUMBER,
69 p_profile_name IN VARCHAR2,
70 p_description IN VARCHAR2 := NULL,
71 p_effective_start_date IN DATE,
72 p_effective_end_date IN DATE := NULL,
73 p_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
74 p_role_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
75 p_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 x_return_status OUT VARCHAR2,
78 x_msg_count OUT NUMBER,
79 x_msg_data OUT VARCHAR2) ;
80 */
81
82 END PA_ROLE_PROFILES_PKG;