APPS.PA_AMOUNT_TYPES_PKG dependencies on PA_AMOUNT_TYPES_TL

Line 45: insert into PA_AMOUNT_TYPES_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into PA_AMOUNT_TYPES_TL (
46: AMOUNT_TYPE_ID,
47: AMOUNT_TYPE_NAME,
48: LAST_UPDATE_DATE,
49: LAST_UPDATED_BY,

Line 69: from PA_AMOUNT_TYPES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from PA_AMOUNT_TYPES_TL T
70: where T.AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 104: from PA_AMOUNT_TYPES_TL

100:
101: cursor c1 is select
102: AMOUNT_TYPE_NAME,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from PA_AMOUNT_TYPES_TL
105: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of AMOUNT_TYPE_ID nowait;
108: begin

Line 170: update PA_AMOUNT_TYPES_TL set

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: update PA_AMOUNT_TYPES_TL set
171: AMOUNT_TYPE_NAME = X_AMOUNT_TYPE_NAME,
172: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
173: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
174: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 188: delete from PA_AMOUNT_TYPES_TL

184: procedure DELETE_ROW (
185: X_AMOUNT_TYPE_ID in NUMBER
186: ) is
187: begin
188: delete from PA_AMOUNT_TYPES_TL
189: where AMOUNT_TYPE_ID = X_AMOUNT_TYPE_ID;
190:
191: if (sql%notfound) then
192: raise no_data_found;

Line 206: delete from PA_AMOUNT_TYPES_TL T

202:
203: procedure ADD_LANGUAGE
204: is
205: begin
206: delete from PA_AMOUNT_TYPES_TL T
207: where not exists
208: (select NULL
209: from PA_AMOUNT_TYPES_B B
210: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID

Line 213: update PA_AMOUNT_TYPES_TL T set (

209: from PA_AMOUNT_TYPES_B B
210: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID
211: );
212:
213: update PA_AMOUNT_TYPES_TL T set (
214: AMOUNT_TYPE_NAME
215: ) = (select
216: B.AMOUNT_TYPE_NAME
217: from PA_AMOUNT_TYPES_TL B

Line 217: from PA_AMOUNT_TYPES_TL B

213: update PA_AMOUNT_TYPES_TL T set (
214: AMOUNT_TYPE_NAME
215: ) = (select
216: B.AMOUNT_TYPE_NAME
217: from PA_AMOUNT_TYPES_TL B
218: where B.AMOUNT_TYPE_ID = T.AMOUNT_TYPE_ID
219: and B.LANGUAGE = T.SOURCE_LANG)
220: where (
221: T.AMOUNT_TYPE_ID,

Line 226: from PA_AMOUNT_TYPES_TL SUBB, PA_AMOUNT_TYPES_TL SUBT

222: T.LANGUAGE
223: ) in (select
224: SUBT.AMOUNT_TYPE_ID,
225: SUBT.LANGUAGE
226: from PA_AMOUNT_TYPES_TL SUBB, PA_AMOUNT_TYPES_TL SUBT
227: where SUBB.AMOUNT_TYPE_ID = SUBT.AMOUNT_TYPE_ID
228: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
229: and (SUBB.AMOUNT_TYPE_NAME <> SUBT.AMOUNT_TYPE_NAME
230: ));

Line 232: insert into PA_AMOUNT_TYPES_TL (

228: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
229: and (SUBB.AMOUNT_TYPE_NAME <> SUBT.AMOUNT_TYPE_NAME
230: ));
231:
232: insert into PA_AMOUNT_TYPES_TL (
233: AMOUNT_TYPE_ID,
234: AMOUNT_TYPE_NAME,
235: LAST_UPDATE_DATE,
236: LAST_UPDATED_BY,

Line 252: from PA_AMOUNT_TYPES_TL B, FND_LANGUAGES L

248: B.CREATED_BY,
249: B.LAST_UPDATE_LOGIN,
250: L.LANGUAGE_CODE,
251: B.SOURCE_LANG
252: from PA_AMOUNT_TYPES_TL B, FND_LANGUAGES L
253: where L.INSTALLED_FLAG in ('I', 'B')
254: and B.LANGUAGE = userenv('LANG')
255: and not exists
256: (select NULL

Line 257: from PA_AMOUNT_TYPES_TL T

253: where L.INSTALLED_FLAG in ('I', 'B')
254: and B.LANGUAGE = userenv('LANG')
255: and not exists
256: (select NULL
257: from PA_AMOUNT_TYPES_TL T
258: where T.AMOUNT_TYPE_ID = B.AMOUNT_TYPE_ID
259: and T.LANGUAGE = L.LANGUAGE_CODE);
260: end ADD_LANGUAGE;
261:

Line 269: update PA_AMOUNT_TYPES_TL set

265: X_OWNER in VARCHAR2
266: ) is
267: begin
268:
269: update PA_AMOUNT_TYPES_TL set
270: AMOUNT_TYPE_NAME = X_AMOUNT_TYPE_NAME,
271: LAST_UPDATE_DATE = sysdate,
272: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
273: LAST_UPDATE_LOGIN = 0,