147: c.p3 is null then
148: L_LER_ID:=nn;
149: else
150: L_LER_ID :=
151: hr_pump_get.GET_LER_ID
152: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
153: ,P_LIFE_EVENT_REASON => c.p5
154: ,P_EFFECTIVE_DATE => c.p3);
155: end if;
158: c.p3 is null then
159: L_OBJECT_VERSION_NUMBER:=nn;
160: else
161: L_OBJECT_VERSION_NUMBER :=
162: hr_pump_get.GET_LER_OVN
163: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
164: ,P_LIFE_EVENT_REASON => c.p5
165: ,P_EFFECTIVE_DATE => c.p3);
166: end if;