APPS.AS_SALES_METHODOLOGY_PKG dependencies on AS_SALES_METHODOLOGY_TL

Line 93: INSERT INTO AS_SALES_METHODOLOGY_TL (

89: X_LAST_UPDATE_LOGIN,
90: 1
91: );
92:
93: INSERT INTO AS_SALES_METHODOLOGY_TL (
94: SALES_METHODOLOGY_ID,
95: SALES_METHODOLOGY_NAME,
96: DESCRIPTION,
97: CREATED_BY,

Line 119: FROM AS_SALES_METHODOLOGY_TL T

115: FROM FND_LANGUAGES L
116: WHERE L.INSTALLED_FLAG IN ('I', 'B')
117: AND NOT EXISTS
118: (SELECT NULL
119: FROM AS_SALES_METHODOLOGY_TL T
120: WHERE T.SALES_METHODOLOGY_ID = X_SALES_METHODOLOGY_ID
121: AND T.LANGUAGE = L.LANGUAGE_CODE);
122:
123: OPEN c;

Line 225: UPDATE AS_SALES_METHODOLOGY_TL SET

221: IF (SQL%NOTFOUND) THEN
222: RAISE no_data_found;
223: END IF;
224:
225: UPDATE AS_SALES_METHODOLOGY_TL SET
226: SALES_METHODOLOGY_NAME = X_SALES_METHODOLOGY_NAME,
227: DESCRIPTION = X_DESCRIPTION,
228: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
229: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 244: DELETE FROM AS_SALES_METHODOLOGY_TL

240: procedure DELETE_ROW (
241: X_SALES_METHODOLOGY_ID in NUMBER
242: ) IS
243: BEGIN
244: DELETE FROM AS_SALES_METHODOLOGY_TL
245: WHERE SALES_METHODOLOGY_ID = X_SALES_METHODOLOGY_ID;
246:
247:
248: IF (SQL%NOTFOUND) THEN

Line 263: DELETE FROM AS_SALES_METHODOLOGY_TL T

259:
260: procedure ADD_LANGUAGE
261: IS
262: BEGIN
263: DELETE FROM AS_SALES_METHODOLOGY_TL T
264: WHERE NOT EXISTS
265: (SELECT NULL
266: FROM AS_SALES_METHODOLOGY_B B
267: WHERE B.SALES_METHODOLOGY_ID = T.SALES_METHODOLOGY_ID

Line 270: update AS_SALES_METHODOLOGY_TL T set (

266: FROM AS_SALES_METHODOLOGY_B B
267: WHERE B.SALES_METHODOLOGY_ID = T.SALES_METHODOLOGY_ID
268: );
269:
270: update AS_SALES_METHODOLOGY_TL T set (
271: SALES_METHODOLOGY_NAME,
272: DESCRIPTION
273: ) = (select
274: B.SALES_METHODOLOGY_NAME,

Line 276: from AS_SALES_METHODOLOGY_TL B

272: DESCRIPTION
273: ) = (select
274: B.SALES_METHODOLOGY_NAME,
275: B.DESCRIPTION
276: from AS_SALES_METHODOLOGY_TL B
277: where B.SALES_METHODOLOGY_ID = T.SALES_METHODOLOGY_ID
278: and B.LANGUAGE = T.SOURCE_LANG)
279: where (
280: T.SALES_METHODOLOGY_ID,

Line 285: from AS_SALES_METHODOLOGY_TL SUBB, AS_SALES_METHODOLOGY_TL SUBT

281: T.LANGUAGE
282: ) in (select
283: SUBT.SALES_METHODOLOGY_ID,
284: SUBT.LANGUAGE
285: from AS_SALES_METHODOLOGY_TL SUBB, AS_SALES_METHODOLOGY_TL SUBT
286: where SUBB.SALES_METHODOLOGY_ID = SUBT.SALES_METHODOLOGY_ID
287: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
288: and (SUBB.SALES_METHODOLOGY_NAME <> SUBT.SALES_METHODOLOGY_NAME
289: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 294: insert into AS_SALES_METHODOLOGY_TL (

290: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
291: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
292: ));
293:
294: insert into AS_SALES_METHODOLOGY_TL (
295: SALES_METHODOLOGY_ID,
296: SALES_METHODOLOGY_NAME,
297: DESCRIPTION,
298: CREATED_BY,

Line 316: from AS_SALES_METHODOLOGY_TL B, FND_LANGUAGES L

312: B.LAST_UPDATE_DATE,
313: B.LAST_UPDATE_LOGIN,
314: L.LANGUAGE_CODE,
315: B.SOURCE_LANG
316: from AS_SALES_METHODOLOGY_TL B, FND_LANGUAGES L
317: where L.INSTALLED_FLAG in ('I', 'B')
318: and B.LANGUAGE = userenv('LANG')
319: and not exists
320: (select NULL

Line 321: from AS_SALES_METHODOLOGY_TL T

317: where L.INSTALLED_FLAG in ('I', 'B')
318: and B.LANGUAGE = userenv('LANG')
319: and not exists
320: (select NULL
321: from AS_SALES_METHODOLOGY_TL T
322: where T.SALES_METHODOLOGY_ID = B.SALES_METHODOLOGY_ID
323: and T.LANGUAGE = L.LANGUAGE_CODE);
324: end ADD_LANGUAGE;
325:

Line 332: update AS_SALES_METHODOLOGY_TL set

328: X_SALES_METHODOLOGY_NAME in varchar2,
329: X_DESCRIPTION in varchar2,
330: X_OWNER in varchar2) is
331: begin
332: update AS_SALES_METHODOLOGY_TL set
333: SALES_METHODOLOGY_NAME= nvl(X_SALES_METHODOLOGY_NAME,SALES_METHODOLOGY_NAME),
334: DESCRIPTION= nvl(X_DESCRIPTION,DESCRIPTION),
335: LAST_UPDATE_DATE = sysdate,
336: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),