APPS.PAY_ELEMENT_INFO_TYPES_PKG dependencies on PAY_ELEMENT_TYPE_INFO_TYPES

Line 18: cursor C is select ROWID from PAY_ELEMENT_TYPE_INFO_TYPES

14: P_LEGISLATION_CODE in VARCHAR2,
15: P_OBJECT_VERSION_NUMBER in NUMBER,
16: P_DESCRIPTION in VARCHAR2
17: ) is
18: cursor C is select ROWID from PAY_ELEMENT_TYPE_INFO_TYPES
19: where INFORMATION_TYPE = P_INFORMATION_TYPE;
20: begin
21: --
22: insert into PAY_ELEMENT_TYPE_INFO_TYPES

Line 22: insert into PAY_ELEMENT_TYPE_INFO_TYPES

18: cursor C is select ROWID from PAY_ELEMENT_TYPE_INFO_TYPES
19: where INFORMATION_TYPE = P_INFORMATION_TYPE;
20: begin
21: --
22: insert into PAY_ELEMENT_TYPE_INFO_TYPES
23: (
24: INFORMATION_TYPE,
25: ACTIVE_INACTIVE_FLAG,
26: MULTIPLE_OCCURENCES_FLAG,

Line 61: update PAY_ELEMENT_TYPE_INFO_TYPES set

57: P_DESCRIPTION in VARCHAR2
58: ) is
59: begin
60: --
61: update PAY_ELEMENT_TYPE_INFO_TYPES set
62: ACTIVE_INACTIVE_FLAG = P_ACTIVE_INACTIVE_FLAG,
63: MULTIPLE_OCCURENCES_FLAG = P_MULTIPLE_OCCURENCES_FLAG,
64: LEGISLATION_CODE = P_LEGISLATION_CODE,
65: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,

Line 145: update pay_element_type_info_types

141: ,p_user_id => -1
142: );
143: end if;
144: --
145: update pay_element_type_info_types
146: set description = p_description
147: where userenv('LANG') = (select language_code from fnd_languages
148: where installed_flag = 'B')
149: AND information_type = p_information_type;