1 PACKAGE AS_ACCESS_CUHK AS
2 /* $Header: asxchacs.pls 120.1 2005/06/05 22:52:08 appldev $ */
3
4 PROCEDURE Create_SalesTeam_Pre(
5 p_api_version_number IN NUMBER,
6 p_init_msg_list IN VARCHAR2
7 := FND_API.G_FALSE,
8 p_validation_level IN VARCHAR2:=FND_API.G_VALID_LEVEL_FULL,
9 p_commit IN VARCHAR2:=FND_API.G_FALSE,
10 p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
11 p_check_access_flag IN VARCHAR2,
12 p_admin_flag IN VARCHAR2,
13 p_admin_group_id IN NUMBER,
14 p_identity_salesforce_id IN NUMBER,
15 p_sales_team_rec IN AS_ACCESS_PVT.SALES_TEAM_REC_TYPE,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2,
19 x_access_id OUT NOCOPY NUMBER
20 );
21
22 PROCEDURE Create_SalesTeam_Post(
23 p_api_version_number IN NUMBER,
24 p_init_msg_list IN VARCHAR2
25 := FND_API.G_FALSE,
26 p_validation_level IN VARCHAR2:=FND_API.G_VALID_LEVEL_FULL,
27 p_commit IN VARCHAR2:=FND_API.G_FALSE,
28 p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
29 p_check_access_flag IN VARCHAR2,
30 p_admin_flag IN VARCHAR2,
31 p_admin_group_id IN NUMBER,
32 p_identity_salesforce_id IN NUMBER,
33 p_sales_team_rec IN AS_ACCESS_PVT.SALES_TEAM_REC_TYPE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2,
37 x_access_id OUT NOCOPY NUMBER
38 );
39
40 PROCEDURE Update_SalesTeam_Pre(
41 p_api_version_number IN NUMBER,
42 p_init_msg_list IN VARCHAR2
43 := FND_API.G_FALSE,
44 p_validation_level IN VARCHAR2:=FND_API.G_VALID_LEVEL_FULL,
45 p_commit IN VARCHAR2:=FND_API.G_FALSE,
46 p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
47 p_check_access_flag IN VARCHAR2,
48 p_admin_flag IN VARCHAR2,
49 p_admin_group_id IN NUMBER,
50 p_identity_salesforce_id IN NUMBER,
51 p_sales_team_rec IN AS_ACCESS_PVT.SALES_TEAM_REC_TYPE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 x_access_id OUT NOCOPY NUMBER
56 );
57
58 PROCEDURE Update_SalesTeam_Post(
59 p_api_version_number IN NUMBER,
60 p_init_msg_list IN VARCHAR2
61 := FND_API.G_FALSE,
62 p_validation_level IN VARCHAR2:=FND_API.G_VALID_LEVEL_FULL,
63 p_commit IN VARCHAR2:=FND_API.G_FALSE,
64 p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
65 p_check_access_flag IN VARCHAR2,
66 p_admin_flag IN VARCHAR2,
67 p_admin_group_id IN NUMBER,
68 p_identity_salesforce_id IN NUMBER,
69 p_sales_team_rec IN AS_ACCESS_PVT.SALES_TEAM_REC_TYPE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 x_access_id OUT NOCOPY NUMBER
74 );
75
76 PROCEDURE Delete_SalesTeam_Pre(
77 p_api_version_number IN NUMBER,
78 p_init_msg_list IN VARCHAR2
79 := FND_API.G_FALSE,
80 p_validation_level IN VARCHAR2:=FND_API.G_VALID_LEVEL_FULL,
81 p_commit IN VARCHAR2:=FND_API.G_FALSE,
82 p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
83 p_check_access_flag IN VARCHAR2,
84 p_admin_flag IN VARCHAR2,
85 p_admin_group_id IN NUMBER,
86 p_identity_salesforce_id IN NUMBER,
87 p_sales_team_rec IN AS_ACCESS_PVT.SALES_TEAM_REC_TYPE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE Delete_SalesTeam_Post(
94 p_api_version_number IN NUMBER,
95 p_init_msg_list IN VARCHAR2
96 := FND_API.G_FALSE,
97 p_validation_level IN VARCHAR2:=FND_API.G_VALID_LEVEL_FULL,
98 p_commit IN VARCHAR2:=FND_API.G_FALSE,
99 p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
100 p_check_access_flag IN VARCHAR2,
101 p_admin_flag IN VARCHAR2,
102 p_admin_group_id IN NUMBER,
103 p_identity_salesforce_id IN NUMBER,
104 p_sales_team_rec IN AS_ACCESS_PVT.SALES_TEAM_REC_TYPE,
105 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
106 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
107 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 );
109
110 END AS_ACCESS_CUHK;