DBA Data[Home] [Help]

APPS.PER_STARTUP_PERSON_TYPES_PKG dependencies on PER_PERSON_TYPES_S

Line 53: (PER_PERSON_TYPES_S.nextval

49: ,LAST_UPDATE_LOGIN
50: ,LAST_UPDATE_DATE
51: ,CREATION_DATE)
52: Values
53: (PER_PERSON_TYPES_S.nextval
54: ,C1.business_group_id
55: ,p_seeded_person_type_key
56: ,'N'
57: ,'N'

Line 141: PER_PERSON_TYPES_S.nextval

137: ,LAST_UPDATE_LOGIN
138: ,CREATED_BY
139: ,CREATION_DATE
140: )select
141: PER_PERSON_TYPES_S.nextval
142: ,business_group_id
143: ,'Y'
144: ,x_default_flag
145: ,x_seeded_person_type_key

Line 279: update PER_PERSON_TYPES set

275: raise no_data_found;
276: end if;
277:
278: for C_row in c_ppt loop
279: update PER_PERSON_TYPES set
280: USER_PERSON_TYPE = X_USER_PERSON_TYPE,
281: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
282: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
283: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN