APPS.PER_STARTUP_PERSON_TYPES_PKG dependencies on PER_STARTUP_PERSON_TYPES_TL

Line 192: insert into PER_STARTUP_PERSON_TYPES_TL (

188: from per_person_types_tl
189: where person_type_id = ppt.person_type_id
190: and language = l.language_code);
191:
192: insert into PER_STARTUP_PERSON_TYPES_TL (
193: seeded_person_type_key,
194: USER_PERSON_TYPE,
195: LAST_UPDATE_DATE,
196: LAST_UPDATED_BY,

Line 226: from per_startup_person_types_tl

222: from FND_LANGUAGES L
223: where L.INSTALLED_FLAG in ('I', 'B')
224: and not exists (
225: select null
226: from per_startup_person_types_tl
227: where seeded_person_type_key = X_SEEDED_PERSON_TYPE_KEY
228: and language= l.language_code);
229:
230: hr_general.g_data_migrator_mode :='N';

Line 259: update PER_STARTUP_PERSON_TYPES_TL set

255:
256: -- The following update statement always updates the startup person types
257: -- Since these rows are seeded rows the who columns are always set accordingly
258:
259: update PER_STARTUP_PERSON_TYPES_TL set
260: USER_PERSON_TYPE = X_USER_PERSON_TYPE,
261: CURRENT_APPLICANT_FLAG = X_CURRENT_APPLICANT_FLAG,
262: CURRENT_EMP_OR_APL_FLAG = X_CURRENT_EMP_OR_APL_FLAG,
263: CURRENT_EMPLOYEE_FLAG = X_CURRENT_EMPLOYEE_FLAG,

Line 270: select count(*) into l_count from per_startup_person_types_tl where

266: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
267: where SEEDED_PERSON_TYPE_KEY = X_SEEDED_PERSON_TYPE_KEY
268: and userenv('lang') in (LANGUAGE, SOURCE_LANG);
269:
270: select count(*) into l_count from per_startup_person_types_tl where
271: SEEDED_PERSON_TYPE_KEY = X_SEEDED_PERSON_TYPE_KEY
272: and language = userenv('lang');
273:
274: if l_count =0 then

Line 305: delete from PER_STARTUP_PERSON_TYPES_TL

301: procedure DELETE_ROW (
302: X_SEEDED_PERSON_TYPE_KEY in VARCHAR2
303: ) is
304: begin
305: delete from PER_STARTUP_PERSON_TYPES_TL
306: where SEEDED_PERSON_TYPE_KEY = X_SEEDED_PERSON_TYPE_KEY;
307:
308: if (sql%notfound) then
309: raise no_data_found;

Line 342: from per_startup_person_types_tl

338: l_last_update_date := to_date(x_last_update_date,'DD/MM/YYYY');
339: if g_firstrun = 'Y' then
340: g_firstrun := 'N';
341: select count(*) into l_count
342: from per_startup_person_types_tl
343: where seeded_person_type_key = 'UNKNOWN';
344: if l_count <> 0 then
345: delete from per_startup_person_types_tl;
346: data_upgrade;

Line 345: delete from per_startup_person_types_tl;

341: select count(*) into l_count
342: from per_startup_person_types_tl
343: where seeded_person_type_key = 'UNKNOWN';
344: if l_count <> 0 then
345: delete from per_startup_person_types_tl;
346: data_upgrade;
347: end if;
348: end if;
349: if x_upload_mode = 'FORCE' then

Line 406: update PER_STARTUP_PERSON_TYPES_TL set

402: hr_general.g_data_migrator_mode :='Y';
403: -- The following update statement always updates the startup person types
404: -- Since these rows are seeded rows the who columns are always set accordingly
405:
406: update PER_STARTUP_PERSON_TYPES_TL set
407: USER_PERSON_TYPE = X_USER_PERSON_TYPE,
408: LAST_UPDATE_DATE = sysdate,
409: LAST_UPDATED_BY = 1,
410: LAST_UPDATE_LOGIN = 1,

Line 469: insert into PER_STARTUP_PERSON_TYPES_TL (

465: procedure ADD_LANGUAGE
466: is
467: begin
468: hr_general.g_data_migrator_mode :='Y';
469: insert into PER_STARTUP_PERSON_TYPES_TL (
470: SEEDED_PERSON_TYPE_KEY,
471: USER_PERSON_TYPE,
472: LAST_UPDATE_DATE,
473: LAST_UPDATED_BY,

Line 499: from PER_STARTUP_PERSON_TYPES_TL B, FND_LANGUAGES L

495: B.SYSTEM_PERSON_TYPE,
496: B.CURRENT_APPLICANT_FLAG,
497: L.LANGUAGE_CODE,
498: B.SOURCE_LANG
499: from PER_STARTUP_PERSON_TYPES_TL B, FND_LANGUAGES L
500: where L.INSTALLED_FLAG in ('B','I')
501: and B.LANGUAGE = userenv('LANG')
502: and not exists
503: (select NULL

Line 504: from PER_STARTUP_PERSON_TYPES_TL T

500: where L.INSTALLED_FLAG in ('B','I')
501: and B.LANGUAGE = userenv('LANG')
502: and not exists
503: (select NULL
504: from PER_STARTUP_PERSON_TYPES_TL T
505: where T.SEEDED_PERSON_TYPE_KEY = B.SEEDED_PERSON_TYPE_KEY
506: and T.LANGUAGE = L.LANGUAGE_CODE);
507: hr_general.g_data_migrator_mode :='N';
508: end ADD_LANGUAGE;