DBA Data[Home] [Help]

APPS.OKC_TEMPLATE_USAGES_PVT dependencies on FND_GLOBAL

Line 1219: l_created_by := Fnd_Global.User_Id;

1215:
1216: -- Set Internal columns
1217: l_object_version_number := 1;
1218: l_creation_date := Sysdate;
1219: l_created_by := Fnd_Global.User_Id;
1220: l_last_update_date := l_creation_date;
1221: l_last_updated_by := l_created_by;
1222: l_last_update_login := Fnd_Global.Login_Id;
1223:

Line 1222: l_last_update_login := Fnd_Global.Login_Id;

1218: l_creation_date := Sysdate;
1219: l_created_by := Fnd_Global.User_Id;
1220: l_last_update_date := l_creation_date;
1221: l_last_updated_by := l_created_by;
1222: l_last_update_login := Fnd_Global.Login_Id;
1223:
1224: --added for 10+ word integration and deviations report
1225: --Set default value for p_authoring_party_code
1226: l_authoring_party_code := p_authoring_party_code;

Line 1816: l_last_updated_by := FND_GLOBAL.USER_ID;

1812: END IF;
1813:
1814: -- Filling who columns
1815: l_last_update_date := SYSDATE;
1816: l_last_updated_by := FND_GLOBAL.USER_ID;
1817: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1818:
1819: -- Object version increment
1820: IF Nvl(l_object_version_number, 0) >= 0 THEN

Line 1817: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1813:
1814: -- Filling who columns
1815: l_last_update_date := SYSDATE;
1816: l_last_updated_by := FND_GLOBAL.USER_ID;
1817: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1818:
1819: -- Object version increment
1820: IF Nvl(l_object_version_number, 0) >= 0 THEN
1821: l_object_version_number := Nvl(l_object_version_number, 0) + 1;

Line 2344: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2340: END IF;
2341: UPDATE okc_allowed_tmpl_usages
2342: SET template_id = p_new_template_id ,
2343: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2344: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2345: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2346: LAST_UPDATE_DATE = Sysdate
2347: WHERE template_id= p_old_template_id;
2348: --------------------------------------------

Line 2345: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

2341: UPDATE okc_allowed_tmpl_usages
2342: SET template_id = p_new_template_id ,
2343: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2344: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2345: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2346: LAST_UPDATE_DATE = Sysdate
2347: WHERE template_id= p_old_template_id;
2348: --------------------------------------------
2349: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN