63: --
64: --
65: BEGIN
66: --
67: SELECT hxt_seqno.nextval
68: INTO l_EXCEP_seqno
69: FROM dual;
70: l_CREATED_BY := FND_GLOBAL.user_id;
71:
163: --
164: BEGIN
165: --
166: --
167: SELECT hxt_seqno.nextval
168: INTO l_EXCEP_seqno
169: FROM dual;
170: l_CREATED_BY := FND_GLOBAL.user_id;
171:
2156: END IF;
2157:
2158: p_valid := 'N';
2159:
2160: SELECT hxt_seqno.nextval
2161: INTO l_EXCEP_seqno
2162: FROM dual;
2163: l_CREATED_BY := FND_GLOBAL.user_id;
2164: l_person_id := GetPersonID(p_TIM_ID); -- ER230