[Home] [Help]
PACKAGE: APPS.PVX_CHANNEL_TYPE_PVT
Source
1 PACKAGE pvx_channel_type_pvt AUTHID CURRENT_USER AS
2 /* $Header: pvxchnls.pls 115.6 2002/11/20 02:06:01 pklin ship $ */
3
4 TYPE channel_type_rec_type is RECORD
5 (
6 CHANNEL_TYPE_ID NUMBER,
7 CHANNEL_LOOKUP_TYPE VARCHAR2(30),
8 CHANNEL_LOOKUP_CODE VARCHAR2(30),
9 INDIRECT_CHANNEL_FLAG VARCHAR2(1),
10 LAST_UPDATE_DATE DATE,
11 LAST_UPDATED_BY NUMBER,
12 CREATION_DATE DATE,
13 CREATED_BY NUMBER,
14 LAST_UPDATE_LOGIN NUMBER,
15 OBJECT_VERSION_NUMBER NUMBER,
16 RANK NUMBER
17 );
18
19
20 PROCEDURE Create_channel_type(
21 p_api_version IN NUMBER := 1.0
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 ,p_channel_type_rec IN channel_type_rec_type
26 ,x_channel_type_id OUT NOCOPY NUMBER
27 ,x_return_status OUT NOCOPY VARCHAR2
28 ,x_msg_count OUT NOCOPY NUMBER
29 ,x_msg_data OUT NOCOPY VARCHAR2
30 );
31
32
33 PROCEDURE Delete_channel_type(
34 p_api_version IN NUMBER
35 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
36 ,p_commit IN VARCHAR2 := FND_API.g_false
37 ,p_channel_type_id IN NUMBER
38 ,p_object_version IN NUMBER
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44
45 PROCEDURE Update_channel_type(
46 p_api_version IN NUMBER := 1.0
47 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
48 ,p_commit IN VARCHAR2 := FND_API.g_false
49 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
50 ,p_channel_type_rec IN channel_type_rec_type
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE Complete_channel_type_rec(
57 p_channel_type_rec IN channel_type_rec_type
58 ,x_complete_rec OUT NOCOPY channel_type_rec_type
59 );
60
61 END pvx_channel_type_pvt;