eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PERIOD_MASKS_PKG dependencies on PA_PERIOD_MASKS_TL

Line 16: X_NAME IN pa_period_masks_tl.name%type,

12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
16: X_NAME IN pa_period_masks_tl.name%type,
17: X_DESCRIPTION IN pa_period_masks_tl.description%type)
18: IS
19:
20: l_period_mask_id pa_period_masks_b.period_mask_id%type;

Line 17: X_DESCRIPTION IN pa_period_masks_tl.description%type)

13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
16: X_NAME IN pa_period_masks_tl.name%type,
17: X_DESCRIPTION IN pa_period_masks_tl.description%type)
18: IS
19:
20: l_period_mask_id pa_period_masks_b.period_mask_id%type;
21:

Line 58: INSERT INTO PA_PERIOD_MASKS_TL(

54: X_RECORD_VERSION_NUMBER,
55: X_PRE_DEFINED_FLAG
56: );
57:
58: INSERT INTO PA_PERIOD_MASKS_TL(
59: LAST_UPDATE_LOGIN,
60: CREATION_DATE,
61: CREATED_BY,
62: LAST_UPDATE_DATE,

Line 84: FROM PA_PERIOD_MASKS_TL ppmt

80: FROM FND_LANGUAGES L
81: WHERE L.INSTALLED_FLAG in ('I', 'B')
82: AND NOT EXISTS
83: (SELECT NULL
84: FROM PA_PERIOD_MASKS_TL ppmt
85: WHERE ppmt.period_mask_id = l_period_mask_id
86: AND ppmt.language = l.language_code);
87:
88: OPEN c;

Line 113: FROM PA_period_masks_tl

109: cursor c1 is SELECT
110: NAME,
111: DESCRIPTION,
112: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
113: FROM PA_period_masks_tl
114: WHERE period_mask_id = X_PERIOD_MASK_ID
115: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
116: FOR UPDATE OF period_mask_id NOWAIT;
117:

Line 149: X_NAME IN pa_period_masks_tl.name%type,

145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
149: X_NAME IN pa_period_masks_tl.name%type,
150: X_DESCRIPTION IN pa_period_masks_tl.description%type)
151: IS
152: BEGIN
153:

Line 150: X_DESCRIPTION IN pa_period_masks_tl.description%type)

146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
149: X_NAME IN pa_period_masks_tl.name%type,
150: X_DESCRIPTION IN pa_period_masks_tl.description%type)
151: IS
152: BEGIN
153:
154: UPDATE pa_period_masks_b

Line 171: UPDATE PA_PERIOD_MASKS_TL

167: IF (SQL%NOTFOUND) THEN
168: RAISE no_data_found;
169: END IF;
170:
171: UPDATE PA_PERIOD_MASKS_TL
172: SET
173: NAME = X_NAME,
174: DESCRIPTION = X_DESCRIPTION,
175: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 194: DELETE FROM PA_PERIOD_MASKS_TL

190: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type
191: ) IS
192: BEGIN
193:
194: DELETE FROM PA_PERIOD_MASKS_TL
195: WHERE period_mask_id = X_PERIOD_MASK_ID;
196: /* 4397924: Commented the below AND condition as all the records
197: have to be deleted from the _TL table
198: AND USERENV('LANG') IN (SELECT DISTINCT source_lang

Line 199: FROM pa_period_masks_tl); */

195: WHERE period_mask_id = X_PERIOD_MASK_ID;
196: /* 4397924: Commented the below AND condition as all the records
197: have to be deleted from the _TL table
198: AND USERENV('LANG') IN (SELECT DISTINCT source_lang
199: FROM pa_period_masks_tl); */
200:
201: IF (SQL%NOTFOUND) THEN
202: RAISE no_data_found;
203: END IF;

Line 219: DELETE FROM pa_period_masks_tl t

215: PROCEDURE ADD_LANGUAGE IS
216:
217: BEGIN
218:
219: DELETE FROM pa_period_masks_tl t
220: WHERE NOT EXISTS
221: (SELECT null
222: FROM pa_period_masks_b b /* 4397924: Referring to the base table */
223: WHERE b.period_mask_id = t.period_mask_id);

Line 225: UPDATE pa_period_masks_tl t

221: (SELECT null
222: FROM pa_period_masks_b b /* 4397924: Referring to the base table */
223: WHERE b.period_mask_id = t.period_mask_id);
224:
225: UPDATE pa_period_masks_tl t
226: SET (name,description) =
227: (SELECT b.name,
228: b.description
229: FROM pa_period_masks_tl b

Line 229: FROM pa_period_masks_tl b

225: UPDATE pa_period_masks_tl t
226: SET (name,description) =
227: (SELECT b.name,
228: b.description
229: FROM pa_period_masks_tl b
230: WHERE b.period_mask_id = t.period_mask_id
231: AND b.language = t.source_lang)
232: WHERE (t.period_mask_id,
233: t.language) IN (SELECT subt.period_mask_id,

Line 235: FROM pa_period_masks_tl subb,

231: AND b.language = t.source_lang)
232: WHERE (t.period_mask_id,
233: t.language) IN (SELECT subt.period_mask_id,
234: subt.language
235: FROM pa_period_masks_tl subb,
236: pa_period_masks_tl subt
237: WHERE subb.period_mask_id = subt.period_mask_id
238: AND subb.language = subt.source_lang
239: AND (subb.name <> subt.name

Line 236: pa_period_masks_tl subt

232: WHERE (t.period_mask_id,
233: t.language) IN (SELECT subt.period_mask_id,
234: subt.language
235: FROM pa_period_masks_tl subb,
236: pa_period_masks_tl subt
237: WHERE subb.period_mask_id = subt.period_mask_id
238: AND subb.language = subt.source_lang
239: AND (subb.name <> subt.name
240: OR subb.description <> subt.description

Line 244: INSERT INTO pa_period_masks_tl(period_mask_id, /* 4397924: added the NOT NULL column */

240: OR subb.description <> subt.description
241: OR (subb.description IS NULL AND subt.description IS NOT NULL)
242: OR (subb.description IS NOT NULL AND subt.description IS NULL)));
243:
244: INSERT INTO pa_period_masks_tl(period_mask_id, /* 4397924: added the NOT NULL column */
245: name,
246: description,
247: language,
248: source_lang,

Line 264: FROM pa_period_masks_tl b,

260: b.last_updated_by,
261: b.creation_date,
262: b.created_by,
263: b.last_update_login
264: FROM pa_period_masks_tl b,
265: fnd_languages l
266: WHERE l.installed_flag in ('I','B')
267: AND b.language = userenv('LANG')
268: AND NOT EXISTS (SELECT null

Line 269: FROM pa_period_masks_tl t

265: fnd_languages l
266: WHERE l.installed_flag in ('I','B')
267: AND b.language = userenv('LANG')
268: AND NOT EXISTS (SELECT null
269: FROM pa_period_masks_tl t
270: WHERE t.period_mask_id = b.period_mask_id
271: AND t.language = l.language_code);
272:
273: END ADD_LANGUAGE;

Line 279: X_NAME IN pa_period_masks_tl.name%type,

275:
276: PROCEDURE TRANSLATE_ROW(
277: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
278: X_OWNER IN VARCHAR2,
279: X_NAME IN pa_period_masks_tl.name%type,
280: X_DESCRIPTION IN pa_period_masks_tl.description%type
281: ) IS
282: BEGIN
283:

Line 280: X_DESCRIPTION IN pa_period_masks_tl.description%type

276: PROCEDURE TRANSLATE_ROW(
277: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
278: X_OWNER IN VARCHAR2,
279: X_NAME IN pa_period_masks_tl.name%type,
280: X_DESCRIPTION IN pa_period_masks_tl.description%type
281: ) IS
282: BEGIN
283:
284: UPDATE PA_PERIOD_MASKS_TL

Line 284: UPDATE PA_PERIOD_MASKS_TL

280: X_DESCRIPTION IN pa_period_masks_tl.description%type
281: ) IS
282: BEGIN
283:
284: UPDATE PA_PERIOD_MASKS_TL
285: SET
286: NAME = X_NAME,
287: DESCRIPTION = X_DESCRIPTION,
288: LAST_UPDATE_DATE = sysdate,

Line 313: X_NAME IN pa_period_masks_tl.name%type,

309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
313: X_NAME IN pa_period_masks_tl.name%type,
314: X_DESCRIPTION IN pa_period_masks_tl.description%type,
315: X_OWNER IN VARCHAR2 )
316: IS
317:

Line 314: X_DESCRIPTION IN pa_period_masks_tl.description%type,

310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
313: X_NAME IN pa_period_masks_tl.name%type,
314: X_DESCRIPTION IN pa_period_masks_tl.description%type,
315: X_OWNER IN VARCHAR2 )
316: IS
317:
318: user_id NUMBER;