APPS.PAY_ELEMENT_SETS_PKG dependencies on PAY_ELEMENT_SETS_TL

Line 614: delete from PAY_ELEMENT_SETS_TL T

610: --
611: procedure ADD_LANGUAGE
612: is
613: begin
614: delete from PAY_ELEMENT_SETS_TL T
615: where not exists
616: (select NULL
617: from PAY_ELEMENT_SETS B
618: where B.ELEMENT_SET_ID = T.ELEMENT_SET_ID

Line 620: update PAY_ELEMENT_SETS_TL T

616: (select NULL
617: from PAY_ELEMENT_SETS B
618: where B.ELEMENT_SET_ID = T.ELEMENT_SET_ID
619: );
620: update PAY_ELEMENT_SETS_TL T
621: set (ELEMENT_SET_NAME) =
622: (select B.ELEMENT_SET_NAME
623: from PAY_ELEMENT_SETS_TL B
624: where B.ELEMENT_SET_ID = T.ELEMENT_SET_ID

Line 623: from PAY_ELEMENT_SETS_TL B

619: );
620: update PAY_ELEMENT_SETS_TL T
621: set (ELEMENT_SET_NAME) =
622: (select B.ELEMENT_SET_NAME
623: from PAY_ELEMENT_SETS_TL B
624: where B.ELEMENT_SET_ID = T.ELEMENT_SET_ID
625: and B.LANGUAGE = T.SOURCE_LANG)
626: where (T.ELEMENT_SET_ID,T.LANGUAGE) in
627: (select SUBT.ELEMENT_SET_ID,SUBT.LANGUAGE

Line 628: from PAY_ELEMENT_SETS_TL SUBB, PAY_ELEMENT_SETS_TL SUBT

624: where B.ELEMENT_SET_ID = T.ELEMENT_SET_ID
625: and B.LANGUAGE = T.SOURCE_LANG)
626: where (T.ELEMENT_SET_ID,T.LANGUAGE) in
627: (select SUBT.ELEMENT_SET_ID,SUBT.LANGUAGE
628: from PAY_ELEMENT_SETS_TL SUBB, PAY_ELEMENT_SETS_TL SUBT
629: where SUBB.ELEMENT_SET_ID = SUBT.ELEMENT_SET_ID
630: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
631: and (SUBB.ELEMENT_SET_NAME <> SUBT.ELEMENT_SET_NAME
632: ));

Line 634: insert into PAY_ELEMENT_SETS_TL (

630: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
631: and (SUBB.ELEMENT_SET_NAME <> SUBT.ELEMENT_SET_NAME
632: ));
633:
634: insert into PAY_ELEMENT_SETS_TL (
635: ELEMENT_SET_ID,
636: ELEMENT_SET_NAME,
637: LAST_UPDATE_DATE,
638: LAST_UPDATED_BY,

Line 654: from PAY_ELEMENT_SETS_TL B, FND_LANGUAGES L

650: B.CREATED_BY,
651: B.CREATION_DATE,
652: L.LANGUAGE_CODE,
653: B.SOURCE_LANG
654: from PAY_ELEMENT_SETS_TL B, FND_LANGUAGES L
655: where L.INSTALLED_FLAG in ('I', 'B')
656: and B.LANGUAGE = userenv('LANG')
657: and not exists
658: (select NULL

Line 659: from PAY_ELEMENT_SETS_TL T

655: where L.INSTALLED_FLAG in ('I', 'B')
656: and B.LANGUAGE = userenv('LANG')
657: and not exists
658: (select NULL
659: from PAY_ELEMENT_SETS_TL T
660: where T.ELEMENT_SET_ID = B.ELEMENT_SET_ID
661: and T.LANGUAGE = L.LANGUAGE_CODE);
662: end ADD_LANGUAGE;
663:

Line 670: UPDATE PAY_ELEMENT_SETS_TL

666: X_B_LEGISLATION_CODE in VARCHAR2,
667: X_ELEMENT_SET_NAME in VARCHAR2,
668: X_OWNER in VARCHAR2) is
669: begin
670: UPDATE PAY_ELEMENT_SETS_TL
671: SET ELEMENT_SET_NAME = nvl(X_ELEMENT_SET_NAME,ELEMENT_SET_NAME),
672: last_update_date = SYSDATE,
673: last_updated_by = decode(x_owner,'SEED',1,0),
674: last_update_login = 0,

Line 721: FROM pay_element_sets_tl est,

717: p_element_set_id IN NUMBER,
718: p_bus_grp_id IN NUMBER,
719: p_leg_code IN varchar2) IS
720: SELECT 1
721: FROM pay_element_sets_tl est,
722: pay_element_sets els
723: WHERE upper(est.element_set_name)=upper(p_element_set_name)
724: AND est.element_set_id = els.element_set_id
725: AND est.language = p_language