12: -- ---------------------------------------------------------
13: function get_user_id return NUMBER
14: as
15: begin
16: return FND_GLOBAL.USER_ID;
17: end get_user_id;
18:
19:
20: function get_date_format_from_user(p_user_id IN NUMBER) return VARCHAR2
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:
98: l_current_date := sysdate;
99: l_created_by := FND_GLOBAL.user_id;
100: l_login := fnd_global.login_id;
101:
102: --Create Lookup
103: select CS_TP_LOOKUP_S.NEXTVAL into l_lookup_id from dual;
96: END IF;
97:
98: l_current_date := sysdate;
99: l_created_by := FND_GLOBAL.user_id;
100: l_login := fnd_global.login_id;
101:
102: --Create Lookup
103: select CS_TP_LOOKUP_S.NEXTVAL into l_lookup_id from dual;
104:
266: end if;
267:
268: -- Update the question table , note lookup_id is not modified.
269: l_current_date := sysdate;
270: l_last_updated_by := fnd_global.user_id;
271: l_login := fnd_global.login_id;
272:
273: CS_TP_QUESTIONS_PKG.UPDATE_ROW (
274: X_QUESTION_ID => P_One_Question.mQuestionID,
267:
268: -- Update the question table , note lookup_id is not modified.
269: l_current_date := sysdate;
270: l_last_updated_by := fnd_global.user_id;
271: l_login := fnd_global.login_id;
272:
273: CS_TP_QUESTIONS_PKG.UPDATE_ROW (
274: X_QUESTION_ID => P_One_Question.mQuestionID,
275: X_LOOKUP_ID => l_lookup_id,
472: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
473:
474: -- Start API Body
475: l_current_date := sysdate;
476: l_last_updated_by := fnd_global.user_id;
477: l_login := fnd_global.login_id;
478:
479: if (P_Questions.COUNT>0) then
480: for i in P_Questions.FIRST..P_Questions.LAST loop
473:
474: -- Start API Body
475: l_current_date := sysdate;
476: l_last_updated_by := fnd_global.user_id;
477: l_login := fnd_global.login_id;
478:
479: if (P_Questions.COUNT>0) then
480: for i in P_Questions.FIRST..P_Questions.LAST loop
481: open last_updateC (P_Questions(i).mQuestionID);