APPS.PAY_UPGRADE_DEFINITIONS_PKG dependencies on PAY_UPGRADE_DEFINITIONS_TL

Line 299: insert into PAY_UPGRADE_DEFINITIONS_TL (

295: p_last_update_date,
296: p_last_updated_by,
297: p_last_update_login );
298:
299: insert into PAY_UPGRADE_DEFINITIONS_TL (
300: UPGRADE_DEFINITION_ID,
301: LANGUAGE,
302: SOURCE_LANG,
303: NAME,

Line 327: from PAY_UPGRADE_DEFINITIONS_TL T

323: from FND_LANGUAGES L
324: where L.INSTALLED_FLAG in ('I', 'B')
325: and not exists
326: (select NULL
327: from PAY_UPGRADE_DEFINITIONS_TL T
328: where T.UPGRADE_DEFINITION_ID = l_UPGRADE_DEFINITION_ID
329: and T.LANGUAGE = L.LANGUAGE_CODE);
330:
331:

Line 410: update PAY_UPGRADE_DEFINITIONS_TL set

406: if (sql%notfound) then
407: raise no_data_found;
408: end if;
409:
410: update PAY_UPGRADE_DEFINITIONS_TL set
411: description = p_description,
412: additional_info = p_additional_info,
413: last_update_date = p_last_update_date,
414: last_updated_by = p_last_updated_by,

Line 467: from PAY_UPGRADE_DEFINITIONS_TL

463: select
464: NAME,
465: DESCRIPTION,
466: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
467: from PAY_UPGRADE_DEFINITIONS_TL
468: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID
469: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
470: for update of UPGRADE_DEFINITION_ID nowait;
471: --

Line 548: delete from PAY_UPGRADE_DEFINITIONS_TL

544:
545: delete from PAY_UPGRADE_LEGISLATIONS
546: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID;
547:
548: delete from PAY_UPGRADE_DEFINITIONS_TL
549: where UPGRADE_DEFINITION_ID = P_UPGRADE_DEFINITION_ID;
550:
551: if (sql%notfound) then
552: raise no_data_found;

Line 570: delete from PAY_UPGRADE_DEFINITIONS_TL T

566: procedure ADD_LANGUAGE
567: is
568: BEGIN
569: --
570: delete from PAY_UPGRADE_DEFINITIONS_TL T
571: where not exists
572: (select NULL
573: from PAY_UPGRADE_DEFINITIONS B
574: where B.UPGRADE_DEFINITION_ID = T.UPGRADE_DEFINITION_ID

Line 577: update PAY_UPGRADE_DEFINITIONS_TL T set (

573: from PAY_UPGRADE_DEFINITIONS B
574: where B.UPGRADE_DEFINITION_ID = T.UPGRADE_DEFINITION_ID
575: );
576:
577: update PAY_UPGRADE_DEFINITIONS_TL T set (
578: NAME,
579: DESCRIPTION
580: ) = (select
581: B.NAME,

Line 583: from PAY_UPGRADE_DEFINITIONS_TL B

579: DESCRIPTION
580: ) = (select
581: B.NAME,
582: B.DESCRIPTION
583: from PAY_UPGRADE_DEFINITIONS_TL B
584: where B.UPGRADE_DEFINITION_ID = T.UPGRADE_DEFINITION_ID
585: and B.LANGUAGE = T.SOURCE_LANG)
586: where (
587: T.UPGRADE_DEFINITION_ID,

Line 592: from PAY_UPGRADE_DEFINITIONS_TL SUBB, PAY_UPGRADE_DEFINITIONS_TL SUBT

588: T.LANGUAGE
589: ) in (select
590: SUBT.UPGRADE_DEFINITION_ID,
591: SUBT.LANGUAGE
592: from PAY_UPGRADE_DEFINITIONS_TL SUBB, PAY_UPGRADE_DEFINITIONS_TL SUBT
593: where SUBB.UPGRADE_DEFINITION_ID = SUBT.UPGRADE_DEFINITION_ID
594: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
595: and (SUBB.NAME <> SUBT.NAME
596: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 599: insert into PAY_UPGRADE_DEFINITIONS_TL (

595: and (SUBB.NAME <> SUBT.NAME
596: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
597: ));
598:
599: insert into PAY_UPGRADE_DEFINITIONS_TL (
600: DESCRIPTION,
601: LAST_UPDATE_DATE,
602: LAST_UPDATED_BY,
603: LAST_UPDATE_LOGIN,

Line 621: from PAY_UPGRADE_DEFINITIONS_TL B, FND_LANGUAGES L

617: B.UPGRADE_DEFINITION_ID,
618: B.NAME,
619: L.LANGUAGE_CODE,
620: B.SOURCE_LANG
621: from PAY_UPGRADE_DEFINITIONS_TL B, FND_LANGUAGES L
622: where L.INSTALLED_FLAG in ('I', 'B')
623: and B.LANGUAGE = userenv('LANG')
624: and not exists
625: (select NULL

Line 626: from PAY_UPGRADE_DEFINITIONS_TL T

622: where L.INSTALLED_FLAG in ('I', 'B')
623: and B.LANGUAGE = userenv('LANG')
624: and not exists
625: (select NULL
626: from PAY_UPGRADE_DEFINITIONS_TL T
627: where T.UPGRADE_DEFINITION_ID = B.UPGRADE_DEFINITION_ID
628: and T.LANGUAGE = L.LANGUAGE_CODE);
629: --
630: END ADD_LANGUAGE;

Line 803: UPDATE pay_upgrade_definitions_tl

799: l_last_update_login := fnd_global.login_id;
800: l_last_update_date := sysdate;
801: --
802:
803: UPDATE pay_upgrade_definitions_tl
804: SET name = nvl(p_name,name),
805: description = nvl(p_description,description),
806: additional_info = nvl(p_additional_info, additional_info),
807: last_update_date = l_last_update_date,