APPS.AS_SALES_LEAD_RANKS_PVT dependencies on AS_SALES_LEAD_RANKS_B

Line 5: -- Purpose : to add ranks into AS_SALES_LEAD_RANKS_B and _TL

1: PACKAGE BODY AS_SALES_LEAD_RANKS_PVT AS
2: /* #$Header: asxvrnkb.pls 115.24 2004/01/23 23:48:36 chchandr 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:

Line 38: FROM AS_SALES_LEAD_RANKS_B

34: )
35: IS
36: CURSOR C_Get_Ranks (c_min NUMBER, c_max NUMBER) IS
37: SELECT rank_id
38: FROM AS_SALES_LEAD_RANKS_B
39: WHERE enabled_flag = 'Y'
40: and ((min_score <= c_min and max_score >= c_min )
41: or (min_score <= c_max and max_score >= c_max));
42:

Line 45: FROM AS_SALES_LEAD_RANKS_B

41: or (min_score <= c_max and max_score >= c_max));
42:
43: CURSOR c_get_count (c_min NUMBER, c_max NUMBER) IS
44: SELECT count(*)
45: FROM AS_SALES_LEAD_RANKS_B
46: WHERE enabled_flag = 'Y'
47: and ((min_score <= c_min and max_score >= c_min )
48: or (min_score <= c_max and max_score >= c_max));
49:

Line 130: FROM AS_SALES_LEAD_RANKS_B b, AS_SALES_LEAD_RANKS_TL tl

126: )
127: IS
128: CURSOR C_Get_Meaning (c_meaning VARCHAR2) IS
129: SELECT b.rank_id
130: FROM AS_SALES_LEAD_RANKS_B b, AS_SALES_LEAD_RANKS_TL tl
131: WHERE b.rank_id = tl.rank_id
132: and b.enabled_flag = 'Y'
133: and tl.meaning = c_meaning;
134:

Line 194: FROM AS_SALES_LEAD_RANKS_B

190: )
191: IS
192: CURSOR C_Get_Rating (c_precedence NUMBER) IS
193: SELECT rank_id
194: FROM AS_SALES_LEAD_RANKS_B
195: WHERE enabled_flag = 'Y'
196: AND min_score = c_precedence;
197:
198: l_sales_lead_rank_id NUMBER;

Line 403: SELECT 'X' FROM AS_SALES_LEAD_RANKS_B

399: l_new_max_score NUMBER;
400: l_is_old_engine VARCHAR2(1) := 'Y';
401:
402: CURSOR c1 IS
403: SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
404: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;
405:
406: CURSOR c2 IS
407: SELECT MAX(MIN_SCORE) FROM AS_SALES_LEAD_RANKS_B;

Line 407: SELECT MAX(MIN_SCORE) FROM AS_SALES_LEAD_RANKS_B;

403: SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
404: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;
405:
406: CURSOR c2 IS
407: SELECT MAX(MIN_SCORE) FROM AS_SALES_LEAD_RANKS_B;
408:
409:
410: BEGIN
411: -- Standard start of API savepoint

Line 607: SELECT enabled_flag, min_score FROM AS_SALES_LEAD_RANKS_B

603: l_dummy CHAR(1);
604: l_is_old_engine VARCHAR2(1) := 'Y';
605:
606: CURSOR c1 IS
607: SELECT enabled_flag, min_score FROM AS_SALES_LEAD_RANKS_B
608: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;
609: l_enabled_flag VARCHAR(1);
610: l_min_score NUMBER;
611: l_request_id NUMBER;

Line 616: SELECT last_update_date FROM AS_SALES_LEAD_RANKS_B

612:
613: -- 120400 ffang, update API should check if the record has been update by
614: -- someone else or not.
615: CURSOR c_get_last_update IS
616: SELECT last_update_date FROM AS_SALES_LEAD_RANKS_B
617: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;
618: l_last_update_date DATE;
619:
620: BEGIN

Line 873: SELECT 'X' FROM AS_SALES_LEAD_RANKS_B

869: WHERE lead_rank_id = c_sales_lead_rank_id;
870:
871:
872: CURSOR c1 IS
873: SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
874: WHERE rank_id = p_sales_lead_rank_id;
875:
876: BEGIN
877: -- Standard start of API savepoint