APPS.CS_TP_CHOICES_PVT dependencies on FND_GLOBAL

Line 82: l_created_by := FND_GLOBAL.user_id;

78: end if;
79:
80: --Insert into the Cs_TO_CHOICES_B table, note start_date_active and end_date_active are null
81: l_current_date := sysdate;
82: l_created_by := FND_GLOBAL.user_id;
83: l_login := fnd_global.login_id;
84:
85: select CS_TP_CHOICES_S.NEXTVAL into l_choice_id from dual;
86: CS_TP_CHOICES_PKG.INSERT_ROW (

Line 83: l_login := fnd_global.login_id;

79:
80: --Insert into the Cs_TO_CHOICES_B table, note start_date_active and end_date_active are null
81: l_current_date := sysdate;
82: l_created_by := FND_GLOBAL.user_id;
83: l_login := fnd_global.login_id;
84:
85: select CS_TP_CHOICES_S.NEXTVAL into l_choice_id from dual;
86: CS_TP_CHOICES_PKG.INSERT_ROW (
87: X_ROWID => l_ROWID,

Line 221: l_last_updated_by := fnd_global.user_id;

217: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
218:
219: -- Start API Body
220: l_current_date := sysdate;
221: l_last_updated_by := fnd_global.user_id;
222: l_login := fnd_global.login_id;
223: if (P_Choices.COUNT>0) then
224: for i in P_Choices.FIRST..P_Choices.LAST loop
225: open last_updateC (P_Choices(i).mChoiceID);

Line 222: l_login := fnd_global.login_id;

218:
219: -- Start API Body
220: l_current_date := sysdate;
221: l_last_updated_by := fnd_global.user_id;
222: l_login := fnd_global.login_id;
223: if (P_Choices.COUNT>0) then
224: for i in P_Choices.FIRST..P_Choices.LAST loop
225: open last_updateC (P_Choices(i).mChoiceID);
226: fetch last_updateC into l_last_update_date, l_lookup_id, l_score, l_value;

Line 439: l_last_updated_by := fnd_global.user_id;

435: END IF;
436:
437: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
438:
439: l_last_updated_by := fnd_global.user_id;
440: l_login := fnd_global.login_id;
441: if (P_Choices.COUNT>0) then
442: for i in P_Choices.FIRST..P_Choices.LAST loop
443:

Line 440: l_login := fnd_global.login_id;

436:
437: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
438:
439: l_last_updated_by := fnd_global.user_id;
440: l_login := fnd_global.login_id;
441: if (P_Choices.COUNT>0) then
442: for i in P_Choices.FIRST..P_Choices.LAST loop
443:
444: open last_updateC (P_Choices(i).mChoiceID);

Line 567: l_created_by := FND_GLOBAL.user_id;

563: raise FND_API.G_EXC_UNEXPECTED_ERROR;
564: end if;
565:
566: l_current_date := sysdate;
567: l_created_by := FND_GLOBAL.user_id;
568: l_login := fnd_global.login_id;
569:
570: open FreetextC;
571: fetch FreetextC into l_freetext_update_id;

Line 568: l_login := fnd_global.login_id;

564: end if;
565:
566: l_current_date := sysdate;
567: l_created_by := FND_GLOBAL.user_id;
568: l_login := fnd_global.login_id;
569:
570: open FreetextC;
571: fetch FreetextC into l_freetext_update_id;
572: close FreeTextC;