APPS.AS_SALES_LEAD_RANKS_PKG dependencies on AS_SALES_LEAD_RANKS_TL

Line 50: insert into AS_SALES_LEAD_RANKS_TL (

46: X_LAST_UPDATED_BY,
47: X_LAST_UPDATE_LOGIN
48: );
49:
50: insert into AS_SALES_LEAD_RANKS_TL (
51: RANK_ID,
52: LAST_UPDATE_DATE,
53: LAST_UPDATED_BY,
54: CREATION_DATE,

Line 76: from AS_SALES_LEAD_RANKS_TL T

72: from FND_LANGUAGES L
73: where L.INSTALLED_FLAG in ('I', 'B')
74: and not exists
75: (select NULL
76: from AS_SALES_LEAD_RANKS_TL T
77: where T.RANK_ID = X_RANK_ID
78: and T.LANGUAGE = L.LANGUAGE_CODE);
79:
80: /*

Line 110: from AS_SALES_LEAD_RANKS_TL

106:
107: cursor c1 is select
108: MEANING,
109: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
110: from AS_SALES_LEAD_RANKS_TL
111: where RANK_ID = X_RANK_ID
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of RANK_ID nowait;
114: begin

Line 172: update AS_SALES_LEAD_RANKS_TL set

168: if (sql%notfound) then
169: raise no_data_found;
170: end if;
171:
172: update AS_SALES_LEAD_RANKS_TL set
173: MEANING = X_MEANING,
174: DESCRIPTION = X_DESCRIPTION,
175: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
176: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 191: delete from AS_SALES_LEAD_RANKS_TL

187: procedure DELETE_ROW (
188: X_RANK_ID in NUMBER
189: ) is
190: begin
191: delete from AS_SALES_LEAD_RANKS_TL
192: where RANK_ID = X_RANK_ID;
193:
194: if (sql%notfound) then
195: raise no_data_found;

Line 209: delete from AS_SALES_LEAD_RANKS_TL T

205:
206: procedure ADD_LANGUAGE
207: is
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

Line 216: update AS_SALES_LEAD_RANKS_TL T set (

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 (
217: MEANING
218: ) = (select
219: B.MEANING
220: from AS_SALES_LEAD_RANKS_TL B

Line 220: from AS_SALES_LEAD_RANKS_TL B

216: update AS_SALES_LEAD_RANKS_TL T set (
217: MEANING
218: ) = (select
219: B.MEANING
220: from AS_SALES_LEAD_RANKS_TL B
221: where B.RANK_ID = T.RANK_ID
222: and B.LANGUAGE = T.SOURCE_LANG)
223: where (
224: T.RANK_ID,

Line 229: from AS_SALES_LEAD_RANKS_TL SUBB, AS_SALES_LEAD_RANKS_TL SUBT

225: T.LANGUAGE
226: ) in (select
227: SUBT.RANK_ID,
228: SUBT.LANGUAGE
229: from AS_SALES_LEAD_RANKS_TL SUBB, AS_SALES_LEAD_RANKS_TL SUBT
230: where SUBB.RANK_ID = SUBT.RANK_ID
231: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
232: and (SUBB.MEANING <> SUBT.MEANING
233: ));

Line 235: insert into AS_SALES_LEAD_RANKS_TL (

231: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
232: and (SUBB.MEANING <> SUBT.MEANING
233: ));
234:
235: insert into AS_SALES_LEAD_RANKS_TL (
236: --SECURITY_GROUP_ID,
237: RANK_ID,
238: LAST_UPDATE_DATE,
239: LAST_UPDATED_BY,

Line 259: from AS_SALES_LEAD_RANKS_TL B, FND_LANGUAGES L

255: B.MEANING,
256: B.DESCRIPTION,
257: L.LANGUAGE_CODE,
258: B.SOURCE_LANG
259: from AS_SALES_LEAD_RANKS_TL B, FND_LANGUAGES L
260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL

Line 264: from AS_SALES_LEAD_RANKS_TL T

260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL
264: from AS_SALES_LEAD_RANKS_TL T
265: where T.RANK_ID = B.RANK_ID
266: and T.LANGUAGE = L.LANGUAGE_CODE);
267: end ADD_LANGUAGE;
268:

Line 340: UPDATE AS_SALES_LEAD_RANKS_TL SET

336: P_owner IN VARCHAR2) IS
337: BEGIN
338:
339: -- only UPDATE rows that have not been altered by user
340: UPDATE AS_SALES_LEAD_RANKS_TL SET
341: meaning = p_meaning,
342: source_lang = userenv('LANG'),
343: last_update_date = sysdate,
344: last_updated_by = decode(p_owner, 'SEED', -1, 0),