193:
194: l_no_sequence :=l_no_sequence +1;
195:
196: CREATION_DATE := SYSDATE;
197: CREATED_BY := FND_GLOBAL.USER_ID;
198: LAST_UPDATE_DATE :=SYSDATE;
199: LAST_UPDATE_BY :=FND_GLOBAL.USER_ID;
200: LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
201:
195:
196: CREATION_DATE := SYSDATE;
197: CREATED_BY := FND_GLOBAL.USER_ID;
198: LAST_UPDATE_DATE :=SYSDATE;
199: LAST_UPDATE_BY :=FND_GLOBAL.USER_ID;
200: LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
201:
202: OPEN C_Prompt_Multi (l_prompt );
203: FETCH C_Prompt_Multi INTO L_PROMPT_MULTI;
196: CREATION_DATE := SYSDATE;
197: CREATED_BY := FND_GLOBAL.USER_ID;
198: LAST_UPDATE_DATE :=SYSDATE;
199: LAST_UPDATE_BY :=FND_GLOBAL.USER_ID;
200: LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
201:
202: OPEN C_Prompt_Multi (l_prompt );
203: FETCH C_Prompt_Multi INTO L_PROMPT_MULTI;
204: CLOSE C_Prompt_Multi;