APPS.AS_SALES_LEAD_RANKS_PKG dependencies on AS_SALES_LEAD_RANKS_B

Line 22: /*cursor C is select ROWID from AS_SALES_LEAD_RANKS_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: /*cursor C is select ROWID from AS_SALES_LEAD_RANKS_B
23: where RANK_ID = X_RANK_ID
24: ;
25: l_rowid number;
26: */

Line 28: insert into AS_SALES_LEAD_RANKS_B (

24: ;
25: l_rowid number;
26: */
27: begin
28: insert into AS_SALES_LEAD_RANKS_B (
29: RANK_ID,
30: MIN_SCORE,
31: MAX_SCORE,
32: ENABLED_FLAG,

Line 102: from AS_SALES_LEAD_RANKS_B

98: cursor c is select
99: MIN_SCORE,
100: MAX_SCORE,
101: ENABLED_FLAG
102: from AS_SALES_LEAD_RANKS_B
103: where RANK_ID = X_RANK_ID
104: for update of RANK_ID nowait;
105: recinfo c%rowtype;
106:

Line 159: update AS_SALES_LEAD_RANKS_B set

155: X_LAST_UPDATED_BY in NUMBER,
156: X_LAST_UPDATE_LOGIN in NUMBER
157: ) is
158: begin
159: update AS_SALES_LEAD_RANKS_B set
160: MIN_SCORE = X_MIN_SCORE,
161: MAX_SCORE = X_MAX_SCORE,
162: ENABLED_FLAG = X_ENABLED_FLAG,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 198: delete from AS_SALES_LEAD_RANKS_B

194: if (sql%notfound) then
195: raise no_data_found;
196: end if;
197:
198: delete from AS_SALES_LEAD_RANKS_B
199: where RANK_ID = X_RANK_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 212: from AS_SALES_LEAD_RANKS_B B

208: begin
209: delete from AS_SALES_LEAD_RANKS_TL T
210: where not exists
211: (select NULL
212: from AS_SALES_LEAD_RANKS_B B
213: where B.RANK_ID = T.RANK_ID
214: );
215:
216: update AS_SALES_LEAD_RANKS_TL T set (

Line 284: FROM AS_SALES_LEAD_RANKS_B

280:
281: -- FFANG 112700 FOR bug 1505582
282: CURSOR c_get_last_updated (c_rank_id NUMBER) IS
283: SELECT last_updated_by
284: FROM AS_SALES_LEAD_RANKS_B
285: WHERE rank_id = c_rank_id;
286: l_last_updated_by NUMBER;
287: -- END FFANG 112700
288: