DBA Data[Home] [Help]

APPS.CS_TP_QUESTIONS_PVT dependencies on FND_GLOBAL

Line 16: return FND_GLOBAL.USER_ID;

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

Line 99: l_created_by := FND_GLOBAL.user_id;

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;

Line 100: l_login := fnd_global.login_id;

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:

Line 270: l_last_updated_by := fnd_global.user_id;

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,

Line 271: l_login := fnd_global.login_id;

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,

Line 476: l_last_updated_by := fnd_global.user_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

Line 477: l_login := fnd_global.login_id;

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);