1 PACKAGE ast_WebSwitch_CUHK AUTHID CURRENT_USER AS
2 /* $Header: astvwsus.pls 115.3 2002/02/06 11:21:35 pkm ship $ */
3
4 PROCEDURE Create_WebSwitch_Pre(
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8 p_validation_level IN NUMBER DEFAULT
9 FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT VARCHAR2,
11 x_msg_count OUT NUMBER,
12 x_msg_data OUT VARCHAR2,
13 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
14 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
15 );
16
17 PROCEDURE Create_WebSwitch_Post(
18 p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21 p_validation_level IN NUMBER DEFAULT
22 FND_API.G_VALID_LEVEL_FULL,
23 x_return_status OUT VARCHAR2,
24 x_msg_count OUT NUMBER,
25 x_msg_data OUT VARCHAR2,
26 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
27 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
28 );
29
30 PROCEDURE Update_WebSwitch_Pre(
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
33 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34 p_validation_level IN NUMBER DEFAULT
35 FND_API.G_VALID_LEVEL_FULL,
36 x_return_status OUT VARCHAR2,
37 x_msg_count OUT NUMBER,
38 x_msg_data OUT VARCHAR2,
39 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
40 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
41 );
42
43 PROCEDURE Update_WebSwitch_Post(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
47 p_validation_level IN NUMBER DEFAULT
48 FND_API.G_VALID_LEVEL_FULL,
49 x_return_status OUT VARCHAR2,
50 x_msg_count OUT NUMBER,
51 x_msg_data OUT VARCHAR2,
52 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
53 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
54 );
55
56 PROCEDURE Lock_WebSwitch_Pre(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60 p_validation_level IN NUMBER DEFAULT
61 FND_API.G_VALID_LEVEL_FULL,
62 x_return_status OUT VARCHAR2,
63 x_msg_count OUT NUMBER,
64 x_msg_data OUT VARCHAR2,
65 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
66 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
67 );
68
69 PROCEDURE Lock_WebSwitch_Post(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73 p_validation_level IN NUMBER DEFAULT
74 FND_API.G_VALID_LEVEL_FULL,
75 x_return_status OUT VARCHAR2,
76 x_msg_count OUT NUMBER,
77 x_msg_data OUT VARCHAR2,
78 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
79 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
80 );
81
82 PROCEDURE Delete_WebSwitch_Pre(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86 p_validation_level IN NUMBER DEFAULT
87 FND_API.G_VALID_LEVEL_FULL,
88 x_return_status OUT VARCHAR2,
89 x_msg_count OUT NUMBER,
90 x_msg_data OUT VARCHAR2,
91 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
92 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
93 );
94
95 PROCEDURE Delete_WebSwitch_Post(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99 p_validation_level IN NUMBER DEFAULT
100 FND_API.G_VALID_LEVEL_FULL,
101 x_return_status OUT VARCHAR2,
102 x_msg_count OUT NUMBER,
103 x_msg_data OUT VARCHAR2,
104 p_cgi_switch_rec IN ast_WebSwitch_PVT.cgi_switch_rec_type,
105 p_switch_data_rec IN ast_WebSwitch_PVT.switch_data_rec_type
106 );
107
108
109 FUNCTION OK_TO_LAUNCH_WORKFLOW(
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
120 FUNCTION OK_TO_GENERATE_MSG(
121 p_api_version IN NUMBER := 1.0,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 p_commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER :=
125 FND_API.G_VALID_LEVEL_FULL,
126 x_return_status OUT VARCHAR2,
127 x_msg_count OUT NUMBER,
128 x_msg_data OUT VARCHAR2) RETURN BOOLEAN;
129
130 END ast_WebSwitch_CUHK;