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.PER_ASSIGNMENT_INFO_TYPES_PKG dependencies on PER_ASSIGNMENT_INFO_TYPES

Line 1: PACKAGE BODY PER_ASSIGNMENT_INFO_TYPES_PKG as

1: PACKAGE BODY PER_ASSIGNMENT_INFO_TYPES_PKG as
2: /* $Header: peait01t.pkb 115.3 99/07/17 18:28:42 porting shi $ */
3: --------------------------------------------------------------------------------
4: g_dummy number(1); -- Dummy for cursor returns which are not needed
5: g_business_group_id number(15); -- For validating translation;

Line 18: from per_assignment_info_types t

14: IS
15: L_DUMMY1 number;
16: CURSOR C1 IS
17: select 1
18: from per_assignment_info_types t
19: where upper(t.description) = upper(P_DESCRIPTION)
20: and nvl(t.legislation_code, nvl(P_LEGISLATION_CODE, 'XXX') )
21: = nvl(P_LEGISLATION_CODE, 'XXX')
22: and (P_ROWID is null

Line 51: cursor C is select ROWID from PER_ASSIGNMENT_INFO_TYPES

47: X_LAST_UPDATE_DATE in DATE,
48: X_LAST_UPDATED_BY in NUMBER,
49: X_LAST_UPDATE_LOGIN in NUMBER
50: ) is
51: cursor C is select ROWID from PER_ASSIGNMENT_INFO_TYPES
52: where INFORMATION_TYPE = X_INFORMATION_TYPE
53: ;
54: begin
55: insert into PER_ASSIGNMENT_INFO_TYPES (

Line 55: insert into PER_ASSIGNMENT_INFO_TYPES (

51: cursor C is select ROWID from PER_ASSIGNMENT_INFO_TYPES
52: where INFORMATION_TYPE = X_INFORMATION_TYPE
53: ;
54: begin
55: insert into PER_ASSIGNMENT_INFO_TYPES (
56: INFORMATION_TYPE,
57: ACTIVE_INACTIVE_FLAG,
58: MULTIPLE_OCCURENCES_FLAG,
59: LEGISLATION_CODE,

Line 81: insert into PER_ASSIGNMENT_INFO_TYPES_TL (

77: X_LAST_UPDATED_BY,
78: X_LAST_UPDATE_LOGIN
79: );
80:
81: insert into PER_ASSIGNMENT_INFO_TYPES_TL (
82: INFORMATION_TYPE,
83: DESCRIPTION,
84: LAST_UPDATE_DATE,
85: LAST_UPDATED_BY,

Line 105: from PER_ASSIGNMENT_INFO_TYPES_TL T

101: from FND_LANGUAGES L
102: where L.INSTALLED_FLAG in ('I', 'B')
103: and not exists
104: (select NULL
105: from PER_ASSIGNMENT_INFO_TYPES_TL T
106: where T.INFORMATION_TYPE = X_INFORMATION_TYPE
107: and T.LANGUAGE = L.LANGUAGE_CODE);
108:
109: open c;

Line 134: from PER_ASSIGNMENT_INFO_TYPES

130: MULTIPLE_OCCURENCES_FLAG,
131: LEGISLATION_CODE,
132: REQUEST_ID,
133: OBJECT_VERSION_NUMBER
134: from PER_ASSIGNMENT_INFO_TYPES
135: where INFORMATION_TYPE = X_INFORMATION_TYPE
136: for update of INFORMATION_TYPE nowait;
137: recinfo c%rowtype;
138:

Line 142: from PER_ASSIGNMENT_INFO_TYPES_TL

138:
139: cursor c1 is select
140: DESCRIPTION,
141: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
142: from PER_ASSIGNMENT_INFO_TYPES_TL
143: where INFORMATION_TYPE = X_INFORMATION_TYPE
144: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
145: for update of INFORMATION_TYPE nowait;
146: begin

Line 198: update PER_ASSIGNMENT_INFO_TYPES set

194: X_LAST_UPDATED_BY in NUMBER,
195: X_LAST_UPDATE_LOGIN in NUMBER
196: ) is
197: begin
198: update PER_ASSIGNMENT_INFO_TYPES set
199: ACTIVE_INACTIVE_FLAG = X_ACTIVE_INACTIVE_FLAG,
200: MULTIPLE_OCCURENCES_FLAG = X_MULTIPLE_OCCURENCES_FLAG,
201: LEGISLATION_CODE = X_LEGISLATION_CODE,
202: REQUEST_ID = X_REQUEST_ID,

Line 213: update PER_ASSIGNMENT_INFO_TYPES_TL set

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: update PER_ASSIGNMENT_INFO_TYPES_TL set
214: DESCRIPTION = X_DESCRIPTION,
215: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
216: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
217: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 231: delete from PER_ASSIGNMENT_INFO_TYPES_TL

227: procedure DELETE_ROW (
228: X_INFORMATION_TYPE in VARCHAR2
229: ) is
230: begin
231: delete from PER_ASSIGNMENT_INFO_TYPES_TL
232: where INFORMATION_TYPE = X_INFORMATION_TYPE;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 238: delete from PER_ASSIGNMENT_INFO_TYPES

234: if (sql%notfound) then
235: raise no_data_found;
236: end if;
237:
238: delete from PER_ASSIGNMENT_INFO_TYPES
239: where INFORMATION_TYPE = X_INFORMATION_TYPE;
240:
241: if (sql%notfound) then
242: raise no_data_found;

Line 256: l_proc VARCHAR2(61) := 'PER_ASSIGNMENT_INFO_TYPES_PKG.LOAD_ROW';

252: ,X_OBJECT_VERSION_NUMBER in number
253: ,X_OWNER in varchar2
254: )
255: is
256: l_proc VARCHAR2(61) := 'PER_ASSIGNMENT_INFO_TYPES_PKG.LOAD_ROW';
257: l_rowid rowid;
258: l_request_id per_assignment_info_types.request_id%TYPE;
259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;
260: l_program_id per_assignment_info_types.program_id%TYPE;

Line 258: l_request_id per_assignment_info_types.request_id%TYPE;

254: )
255: is
256: l_proc VARCHAR2(61) := 'PER_ASSIGNMENT_INFO_TYPES_PKG.LOAD_ROW';
257: l_rowid rowid;
258: l_request_id per_assignment_info_types.request_id%TYPE;
259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;
260: l_program_id per_assignment_info_types.program_id%TYPE;
261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;

Line 259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;

255: is
256: l_proc VARCHAR2(61) := 'PER_ASSIGNMENT_INFO_TYPES_PKG.LOAD_ROW';
257: l_rowid rowid;
258: l_request_id per_assignment_info_types.request_id%TYPE;
259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;
260: l_program_id per_assignment_info_types.program_id%TYPE;
261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;

Line 260: l_program_id per_assignment_info_types.program_id%TYPE;

256: l_proc VARCHAR2(61) := 'PER_ASSIGNMENT_INFO_TYPES_PKG.LOAD_ROW';
257: l_rowid rowid;
258: l_request_id per_assignment_info_types.request_id%TYPE;
259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;
260: l_program_id per_assignment_info_types.program_id%TYPE;
261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;
264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;

Line 261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;

257: l_rowid rowid;
258: l_request_id per_assignment_info_types.request_id%TYPE;
259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;
260: l_program_id per_assignment_info_types.program_id%TYPE;
261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;
264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;
265: l_last_updated_by per_assignment_info_types.last_updated_by%TYPE := 0;

Line 262: l_created_by per_assignment_info_types.created_by%TYPE := 0;

258: l_request_id per_assignment_info_types.request_id%TYPE;
259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;
260: l_program_id per_assignment_info_types.program_id%TYPE;
261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;
264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;
265: l_last_updated_by per_assignment_info_types.last_updated_by%TYPE := 0;
266: l_last_update_login per_assignment_info_types.last_update_login%TYPE := 0;

Line 263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;

259: l_progam_application_id per_assignment_info_types.program_application_id%TYPE;
260: l_program_id per_assignment_info_types.program_id%TYPE;
261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;
264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;
265: l_last_updated_by per_assignment_info_types.last_updated_by%TYPE := 0;
266: l_last_update_login per_assignment_info_types.last_update_login%TYPE := 0;
267: begin

Line 264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;

260: l_program_id per_assignment_info_types.program_id%TYPE;
261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;
264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;
265: l_last_updated_by per_assignment_info_types.last_updated_by%TYPE := 0;
266: l_last_update_login per_assignment_info_types.last_update_login%TYPE := 0;
267: begin
268: -- Translate developer keys to internal parameters

Line 265: l_last_updated_by per_assignment_info_types.last_updated_by%TYPE := 0;

261: l_program_update_date per_assignment_info_types.program_update_date%TYPE;
262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;
264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;
265: l_last_updated_by per_assignment_info_types.last_updated_by%TYPE := 0;
266: l_last_update_login per_assignment_info_types.last_update_login%TYPE := 0;
267: begin
268: -- Translate developer keys to internal parameters
269: if X_OWNER = 'SEED' then

Line 266: l_last_update_login per_assignment_info_types.last_update_login%TYPE := 0;

262: l_created_by per_assignment_info_types.created_by%TYPE := 0;
263: l_creation_date per_assignment_info_types.creation_date%TYPE := SYSDATE;
264: l_last_update_date per_assignment_info_types.last_update_date%TYPE := SYSDATE;
265: l_last_updated_by per_assignment_info_types.last_updated_by%TYPE := 0;
266: l_last_update_login per_assignment_info_types.last_update_login%TYPE := 0;
267: begin
268: -- Translate developer keys to internal parameters
269: if X_OWNER = 'SEED' then
270: l_created_by := 1;

Line 315: UPDATE per_assignment_info_types_tl

311: ,X_OWNER in varchar2
312: )
313: is
314: begin
315: UPDATE per_assignment_info_types_tl
316: SET description = X_DESCRIPTION
317: ,last_update_date = SYSDATE
318: ,last_updated_by = DECODE(X_OWNER,'SEED',1,0)
319: ,last_update_login = 0

Line 328: delete from PER_ASSIGNMENT_INFO_TYPES_TL T

324:
325: procedure ADD_LANGUAGE
326: is
327: begin
328: delete from PER_ASSIGNMENT_INFO_TYPES_TL T
329: where not exists
330: (select NULL
331: from PER_ASSIGNMENT_INFO_TYPES B
332: where B.INFORMATION_TYPE = T.INFORMATION_TYPE

Line 331: from PER_ASSIGNMENT_INFO_TYPES B

327: begin
328: delete from PER_ASSIGNMENT_INFO_TYPES_TL T
329: where not exists
330: (select NULL
331: from PER_ASSIGNMENT_INFO_TYPES B
332: where B.INFORMATION_TYPE = T.INFORMATION_TYPE
333: );
334:
335: update PER_ASSIGNMENT_INFO_TYPES_TL T set (

Line 335: update PER_ASSIGNMENT_INFO_TYPES_TL T set (

331: from PER_ASSIGNMENT_INFO_TYPES B
332: where B.INFORMATION_TYPE = T.INFORMATION_TYPE
333: );
334:
335: update PER_ASSIGNMENT_INFO_TYPES_TL T set (
336: DESCRIPTION
337: ) = (select
338: B.DESCRIPTION
339: from PER_ASSIGNMENT_INFO_TYPES_TL B

Line 339: from PER_ASSIGNMENT_INFO_TYPES_TL B

335: update PER_ASSIGNMENT_INFO_TYPES_TL T set (
336: DESCRIPTION
337: ) = (select
338: B.DESCRIPTION
339: from PER_ASSIGNMENT_INFO_TYPES_TL B
340: where B.INFORMATION_TYPE = T.INFORMATION_TYPE
341: and B.LANGUAGE = T.SOURCE_LANG)
342: where (
343: T.INFORMATION_TYPE,

Line 348: from PER_ASSIGNMENT_INFO_TYPES_TL SUBB, PER_ASSIGNMENT_INFO_TYPES_TL SUBT

344: T.LANGUAGE
345: ) in (select
346: SUBT.INFORMATION_TYPE,
347: SUBT.LANGUAGE
348: from PER_ASSIGNMENT_INFO_TYPES_TL SUBB, PER_ASSIGNMENT_INFO_TYPES_TL SUBT
349: where SUBB.INFORMATION_TYPE = SUBT.INFORMATION_TYPE
350: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
351: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
352: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 356: insert into PER_ASSIGNMENT_INFO_TYPES_TL (

352: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
353: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
354: ));
355:
356: insert into PER_ASSIGNMENT_INFO_TYPES_TL (
357: INFORMATION_TYPE,
358: DESCRIPTION,
359: LAST_UPDATE_DATE,
360: LAST_UPDATED_BY,

Line 376: from PER_ASSIGNMENT_INFO_TYPES_TL B, FND_LANGUAGES L

372: B.CREATED_BY,
373: B.CREATION_DATE,
374: L.LANGUAGE_CODE,
375: B.SOURCE_LANG
376: from PER_ASSIGNMENT_INFO_TYPES_TL B, FND_LANGUAGES L
377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL

Line 381: from PER_ASSIGNMENT_INFO_TYPES_TL T

377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL
381: from PER_ASSIGNMENT_INFO_TYPES_TL T
382: where T.INFORMATION_TYPE = B.INFORMATION_TYPE
383: and T.LANGUAGE = L.LANGUAGE_CODE);
384: end ADD_LANGUAGE;
385: --------------------------------------------------------------------------------

Line 417: FROM per_assignment_info_types_tl aitt,

413: p_description IN VARCHAR2,
414: p_information_type IN VARCHAR2)
415: IS
416: SELECT 1
417: FROM per_assignment_info_types_tl aitt,
418: per_assignment_info_types ait
419: WHERE upper(aitt.description)=upper(p_description)
420: AND aitt.information_type = ait.information_type
421: AND aitt.language = p_language

Line 418: per_assignment_info_types ait

414: p_information_type IN VARCHAR2)
415: IS
416: SELECT 1
417: FROM per_assignment_info_types_tl aitt,
418: per_assignment_info_types ait
419: WHERE upper(aitt.description)=upper(p_description)
420: AND aitt.information_type = ait.information_type
421: AND aitt.language = p_language
422: AND (ait.information_type <> p_information_type

Line 426: l_package_name VARCHAR2(80) := 'PER_ASSIGNMENT_INFO_TYPES_PKG.VALIDATE_TRANSLATION';

422: AND (ait.information_type <> p_information_type
423: OR p_information_type IS NULL)
424: ;
425:
426: l_package_name VARCHAR2(80) := 'PER_ASSIGNMENT_INFO_TYPES_PKG.VALIDATE_TRANSLATION';
427:
428: BEGIN
429: hr_utility.set_location (l_package_name,10);
430: OPEN c_translation(language, description,information_type);

Line 448: END PER_ASSIGNMENT_INFO_TYPES_PKG;

444: END validate_translation;
445: --------------------------------------------------------------------------------
446:
447: --
448: END PER_ASSIGNMENT_INFO_TYPES_PKG;