1 PACKAGE AS_SALES_LEAD_RANKS_PUB AUTHID CURRENT_USER AS
2 /* #$Header: asxprnks.pls 115.5 2002/11/22 08:03:30 ckapoor ship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_RANKS_PUB
5 -- Purpose : to add ranks into AS_SALES_LEAD_RANKS_B and _TL
6 -- History : 07/24/2000 raverma created
7 -- NOTE :
8 -- End of Comments
9
10 TYPE sales_lead_rank_rec_type IS RECORD (
11 RANK_ID NUMBER ,
12 LAST_UPDATE_DATE DATE ,
13 LAST_UPDATE_LOGIN NUMBER ,
14 CREATED_BY NUMBER ,
15 CREATION_DATE DATE ,
16 LAST_UPDATED_BY NUMBER ,
17 MIN_SCORE NUMBER ,
18 MAX_SCORE NUMBER ,
19 ENABLED_FLAG VARCHAR2(1) ,
20 MEANING VARCHAR2(240) ,
21 DESCRIPTION VARCHAR2(240)
22 );
23 Procedure Create_Rank (p_api_version IN NUMBER := 2.0,
24 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25 p_commit IN VARCHAR2 := FND_API.G_FALSE,
26 p_validation_level IN NUMBER :=
27 FND_API.G_VALID_LEVEL_FULL,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
32 x_sales_lead_rank_id OUT NOCOPY NUMBER);
33
34 Procedure Update_Rank (p_api_version IN NUMBER := 2.0,
35 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36 p_commit IN VARCHAR2 := FND_API.G_FALSE,
37 p_validation_level IN NUMBER :=
38 FND_API.G_VALID_LEVEL_FULL,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type);
43
44 Procedure Delete_Rank (p_api_version IN NUMBER := 2.0,
45 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46 p_commit IN VARCHAR2 := FND_API.G_FALSE,
47 p_validation_level IN NUMBER :=
48 FND_API.G_VALID_LEVEL_FULL,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_sales_lead_rank_id IN NUMBER);
53 END;