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'
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
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