1 PACKAGE AS_SALES_LEAD_RANKS_PVT AUTHID CURRENT_USER AS
2 /* #$Header: asxvrnks.pls 115.8 2003/06/30 21:27:01 solin ship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_RANKS_PVT
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 /*
11 -- type is declared in Public API this is ONLY for reference
12 TYPE sales_lead_rank_rec_type IS RECORD (
13 RANK_ID NUMBER ,
14 LAST_UPDATE_DATE DATE ,
15 LAST_UPDATE_LOGIN NUMBER ,
16 CREATED_BY NUMBER ,
17 CREATION_DATE DATE ,
18 LAST_UPDATED_BY NUMBER ,
19 MIN_SCORE NUMBER ,
20 MAX_SCORE NUMBER ,
21 ENABLED_FLAG VARCHAR2(1) ,
22 MEANING VARCHAR2(240) ,
23 DESCRIPTION VARCHAR2(240) ,
24 RANK_CODE VARCHAR2(15)
25 );
26 */
27
28
29 PROCEDURE Validate_Score_Range (
30 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
31 P_Validation_mode IN VARCHAR2,
32 p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
33 p_is_old_engine IN VARCHAR2,
34 X_Return_Status OUT NOCOPY VARCHAR2,
35 X_Msg_Count OUT NOCOPY NUMBER,
36 X_Msg_Data OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE Validate_Rank_Meaning (
40 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
41 P_Validation_mode IN VARCHAR2,
42 p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
43 X_Return_Status OUT NOCOPY VARCHAR2,
44 X_Msg_Count OUT NOCOPY NUMBER,
45 X_Msg_Data OUT NOCOPY VARCHAR2
46 );
47
48 Procedure Create_Rank (
49 p_api_version IN NUMBER := 2.0,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE,
52 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
57 x_sales_lead_rank_id OUT NOCOPY NUMBER);
58
59 Procedure Update_Rank (
60 p_api_version IN NUMBER := 2.0,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type);
68
69 Procedure Delete_Rank (
70 p_api_version IN NUMBER := 2.0,
71 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72 p_commit IN VARCHAR2 := FND_API.G_FALSE,
73 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_sales_lead_rank_id IN NUMBER);
78
79 PROCEDURE UPDATE_LEAD_RANK_SCORE(
80 ERRBUF OUT NOCOPY VARCHAR2,
81 RETCODE OUT NOCOPY VARCHAR2,
82 X_LEAD_RANK_ID IN NUMBER,
83 X_LEAD_RANK_SCORE IN NUMBER);
84
85 PROCEDURE Write_Log(p_which NUMBER, p_msg VARCHAR2);
86
87 END AS_SALES_LEAD_RANKS_PVT;