APPS.AS_SALES_LEAD_RANKS_PUB dependencies on AS_SALES_LEAD_RANKS_PUB

Line 1: PACKAGE BODY AS_SALES_LEAD_RANKS_PUB AS

1: PACKAGE BODY AS_SALES_LEAD_RANKS_PUB AS
2: /* #$Header: asxprnkb.pls 120.0 2005/06/09 17:39:49 appldev noship $ */
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

Line 4: -- Package name : AS_SALES_LEAD_RANKS_PUB

1: PACKAGE BODY AS_SALES_LEAD_RANKS_PUB AS
2: /* #$Header: asxprnkb.pls 120.0 2005/06/09 17:39:49 appldev noship $ */
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

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_SALES_LEAD_RANKS_PUB';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_SALES_LEAD_RANKS_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxprnkb.pls';
13: /*
14: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

Line 35: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,

31: FND_API.G_VALID_LEVEL_FULL,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
36: x_sales_lead_rank_id OUT NOCOPY NUMBER) IS
37:
38: l_api_name CONSTANT VARCHAR2(30) := 'Create_Rank';
39: l_api_version CONSTANT NUMBER := 2.0;

Line 43: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;

39: l_api_version CONSTANT NUMBER := 2.0;
40: l_return_status VARCHAR2(1);
41: l_msg_count NUMBER;
42: l_msg_data VARCHAR2(32767);
43: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;
44: l_rank_id NUMBER;
45: l_dummy CHAR(1);
46:
47: CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B

Line 118: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type) IS

114: FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type) IS
119:
120: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rank';
121: l_api_version CONSTANT NUMBER := 2.0;
122: l_return_status VARCHAR2(1);

Line 125: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;

121: l_api_version CONSTANT NUMBER := 2.0;
122: l_return_status VARCHAR2(1);
123: l_msg_count NUMBER;
124: l_msg_data VARCHAR2(32767);
125: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;
126: l_dummy CHAR(1);
127:
128: CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
129: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;