1 PACKAGE ast_PHONE_ASSIST_CUHK AUTHID CURRENT_USER AS
2 /* $Header: astvpaus.pls 115.3 2002/02/06 11:44:11 pkm ship $ */
3
4 PROCEDURE Insert_Phone_Assist_PRE(
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 x_return_status OUT VARCHAR2,
10 x_msg_count OUT NUMBER,
11 x_msg_data OUT VARCHAR2,
12 p_name IN VARCHAR2,
13 p_description IN VARCHAR2,
14 p_enabled_flag IN VARCHAR2,
15 p_phone_country_code IN VARCHAR2,
16 p_phone_area_code IN VARCHAR2,
17 p_phone_number IN VARCHAR2,
18 p_phone_extension IN VARCHAR2);
19
20 PROCEDURE Insert_Phone_Assist_POST(
21 p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23 p_commit IN VARCHAR2 := FND_API.G_FALSE,
24 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25 x_return_status OUT VARCHAR2,
26 x_msg_count OUT NUMBER,
27 x_msg_data OUT VARCHAR2,
28 p_name IN VARCHAR2,
29 p_description IN VARCHAR2,
30 p_enabled_flag IN VARCHAR2,
31 p_phone_country_code IN VARCHAR2,
32 p_phone_area_code IN VARCHAR2,
33 p_phone_number IN VARCHAR2,
34 p_phone_extension IN VARCHAR2);
35
36 PROCEDURE Update_Phone_Assist_PRE(
37 p_api_version IN NUMBER,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE,
40 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41 x_return_status OUT VARCHAR2,
42 x_msg_count OUT NUMBER,
43 x_msg_data OUT VARCHAR2,
44 p_phone_assist_id IN NUMBER,
45 p_contact_point_id IN NUMBER,
46 p_name IN VARCHAR2,
47 p_description IN VARCHAR2,
48 p_enabled_flag IN VARCHAR2,
49 p_phone_country_code IN VARCHAR2,
50 p_phone_area_code IN VARCHAR2,
51 p_phone_number IN VARCHAR2,
52 p_phone_extension IN VARCHAR2);
53
54 PROCEDURE Update_Phone_Assist_POST(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 x_return_status OUT VARCHAR2,
60 x_msg_count OUT NUMBER,
61 x_msg_data OUT VARCHAR2,
62 p_phone_assist_id IN NUMBER,
63 p_contact_point_id IN NUMBER,
64 p_name IN VARCHAR2,
65 p_description IN VARCHAR2,
66 p_enabled_flag IN VARCHAR2,
67 p_phone_country_code IN VARCHAR2,
68 p_phone_area_code IN VARCHAR2,
69 p_phone_number IN VARCHAR2,
70 p_phone_extension IN VARCHAR2);
71
72 PROCEDURE Delete_Phone_Assist_PRE(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77 x_return_status OUT VARCHAR2,
78 x_msg_count OUT NUMBER,
79 x_msg_data OUT VARCHAR2,
80 p_phone_assist_id IN NUMBER,
81 p_contact_point_id IN NUMBER,
82 p_party_id IN NUMBER,
83 p_assist_id IN NUMBER);
84
85 PROCEDURE Delete_Phone_Assist_POST(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_commit IN VARCHAR2 := FND_API.G_FALSE,
89 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90 x_return_status OUT VARCHAR2,
91 x_msg_count OUT NUMBER,
92 x_msg_data OUT VARCHAR2,
93 p_phone_assist_id IN NUMBER,
94 p_contact_point_id IN NUMBER,
95 p_party_id IN NUMBER,
96 p_assist_id IN NUMBER);
97
98 FUNCTION OK_TO_LAUNCH_WORKFLOW(
99 p_api_version IN NUMBER := 1.0,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER :=
103 FND_API.G_VALID_LEVEL_FULL,
104 x_return_status OUT VARCHAR2,
105 x_msg_count OUT NUMBER,
106 x_msg_data OUT VARCHAR2) RETURN BOOLEAN;
107
108
109 FUNCTION OK_TO_GENERATE_MSG(
110 p_api_version IN NUMBER := 1.0,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER :=
114 FND_API.G_VALID_LEVEL_FULL,
115 x_return_status OUT VARCHAR2,
116 x_msg_count OUT NUMBER,
117 x_msg_data OUT VARCHAR2) RETURN BOOLEAN;
118
119 END ast_PHONE_ASSIST_CUHK;