DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_RANKS_PVT dependencies on AS_SALES_LEAD_RANKS_PUB

Line 29: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,

25:
26: PROCEDURE Validate_Score_Range (
27: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
28: P_Validation_mode IN VARCHAR2,
29: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
30: p_is_old_engine IN VARCHAR2,
31: X_Return_Status OUT NOCOPY VARCHAR2,
32: X_Msg_Count OUT NOCOPY NUMBER,
33: X_Msg_Data OUT NOCOPY VARCHAR2

Line 122: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,

118:
119: PROCEDURE Validate_Rank_Meaning (
120: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
121: P_Validation_mode IN VARCHAR2,
122: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
123: X_Return_Status OUT NOCOPY VARCHAR2,
124: X_Msg_Count OUT NOCOPY NUMBER,
125: X_Msg_Data OUT NOCOPY VARCHAR2
126: )

Line 386: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,

382: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type,
387: x_sales_lead_rank_id OUT NOCOPY NUMBER)
388: IS
389: l_api_name CONSTANT VARCHAR2(30) := 'Create_Rank';
390: l_api_version CONSTANT NUMBER := 2.0;

Line 395: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;

391: l_return_status VARCHAR2(1);
392: l_msg_count NUMBER;
393: l_msg_data VARCHAR2(32767);
394: l_commit VARCHAR2(1);
395: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;
396: l_rank_id NUMBER;
397: l_dummy CHAR(1);
398: l_new_min_score NUMBER;
399: l_new_max_score NUMBER;

Line 595: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type)

591: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
592: x_return_status OUT NOCOPY VARCHAR2,
593: x_msg_count OUT NOCOPY NUMBER,
594: x_msg_data OUT NOCOPY VARCHAR2,
595: p_sales_lead_rank_rec IN AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type)
596: IS
597: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rank';
598: l_api_version CONSTANT NUMBER := 2.0;
599: l_return_status VARCHAR2(1);

Line 602: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;

598: l_api_version CONSTANT NUMBER := 2.0;
599: l_return_status VARCHAR2(1);
600: l_msg_count NUMBER;
601: l_msg_data VARCHAR2(32767);
602: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;
603: l_dummy CHAR(1);
604: l_is_old_engine VARCHAR2(1) := 'Y';
605:
606: CURSOR c1 IS