APPS.PA_AMOUNT_TYPES_PKG dependencies on PA_AMOUNT_TYPES_TL

Line 50: insert into PA_AMOUNT_TYPES_TL (

46: X_LAST_UPDATED_BY,
47: X_LAST_UPDATE_LOGIN
48: );
49:
50: insert into PA_AMOUNT_TYPES_TL (
51: AMOUNT_TYPE_ID,
52: AMOUNT_TYPE_NAME,
53: LAST_UPDATE_DATE,
54: LAST_UPDATED_BY,

Line 74: from PA_AMOUNT_TYPES_TL T

70: from FND_LANGUAGES L
71: where L.INSTALLED_FLAG in ('I', 'B')
72: and not exists
73: (select NULL
74: from PA_AMOUNT_TYPES_TL T
75: where T.AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
76: and T.LANGUAGE = L.LANGUAGE_CODE);
77:
78: open c;

Line 114: from PA_AMOUNT_TYPES_TL

110:
111: cursor c1 is select
112: AMOUNT_TYPE_NAME,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from PA_AMOUNT_TYPES_TL
115: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of AMOUNT_TYPE_ID nowait;
118: begin

Line 180: update PA_AMOUNT_TYPES_TL set

176: if (sql%notfound) then
177: raise no_data_found;
178: end if;
179:
180: update PA_AMOUNT_TYPES_TL set
181: AMOUNT_TYPE_NAME = X_AMOUNT_TYPE_NAME,
182: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
184: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 198: delete from PA_AMOUNT_TYPES_TL

194: procedure DELETE_ROW (
195: X_AMOUNT_TYPE_ID in NUMBER
196: ) is
197: begin
198: delete from PA_AMOUNT_TYPES_TL
199: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 216: delete from PA_AMOUNT_TYPES_TL T

212:
213: procedure ADD_LANGUAGE
214: is
215: begin
216: delete from PA_AMOUNT_TYPES_TL T
217: where not exists
218: (select NULL
219: from PA_AMOUNT_TYPES_B B
220: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID

Line 223: update PA_AMOUNT_TYPES_TL T set (

219: from PA_AMOUNT_TYPES_B B
220: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID
221: );
222:
223: update PA_AMOUNT_TYPES_TL T set (
224: AMOUNT_TYPE_NAME
225: ) = (select
226: B.AMOUNT_TYPE_NAME
227: from PA_AMOUNT_TYPES_TL B

Line 227: from PA_AMOUNT_TYPES_TL B

223: update PA_AMOUNT_TYPES_TL T set (
224: AMOUNT_TYPE_NAME
225: ) = (select
226: B.AMOUNT_TYPE_NAME
227: from PA_AMOUNT_TYPES_TL B
228: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID
229: and B.LANGUAGE = T.SOURCE_LANG)
230: where (
231: T.AMOUNT_TYPE_ID,

Line 236: from PA_AMOUNT_TYPES_TL SUBB, PA_AMOUNT_TYPES_TL SUBT

232: T.LANGUAGE
233: ) in (select
234: SUBT.AMOUNT_TYPE_ID,
235: SUBT.LANGUAGE
236: from PA_AMOUNT_TYPES_TL SUBB, PA_AMOUNT_TYPES_TL SUBT
237: where SUBB.AMOUNT_TYPE_ID = SUBT.AMOUNT_TYPE_ID
238: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
239: and (SUBB.AMOUNT_TYPE_NAME <> SUBT.AMOUNT_TYPE_NAME
240: ));

Line 242: insert into PA_AMOUNT_TYPES_TL (

238: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
239: and (SUBB.AMOUNT_TYPE_NAME <> SUBT.AMOUNT_TYPE_NAME
240: ));
241:
242: insert into PA_AMOUNT_TYPES_TL (
243: AMOUNT_TYPE_ID,
244: AMOUNT_TYPE_NAME,
245: LAST_UPDATE_DATE,
246: LAST_UPDATED_BY,

Line 262: from PA_AMOUNT_TYPES_TL B, FND_LANGUAGES L

258: B.CREATED_BY,
259: B.LAST_UPDATE_LOGIN,
260: L.LANGUAGE_CODE,
261: B.SOURCE_LANG
262: from PA_AMOUNT_TYPES_TL B, FND_LANGUAGES L
263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL

Line 267: from PA_AMOUNT_TYPES_TL T

263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL
267: from PA_AMOUNT_TYPES_TL T
268: where T.AMOUNT_TYPE_ID = B.AMOUNT_TYPE_ID
269: and T.LANGUAGE = L.LANGUAGE_CODE);
270: end ADD_LANGUAGE;
271:

Line 279: update PA_AMOUNT_TYPES_TL set

275: X_OWNER in VARCHAR2
276: ) is
277: begin
278:
279: update PA_AMOUNT_TYPES_TL set
280: AMOUNT_TYPE_NAME = X_AMOUNT_TYPE_NAME,
281: LAST_UPDATE_DATE = sysdate,
282: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
283: LAST_UPDATE_LOGIN = 0,