DBA Data[Home] [Help]

APPS.CN_FORMULA_INPUTS_PKG dependencies on FND_GLOBAL

Line 32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

28: X_ATTRIBUTE13 IN CN_FORMULA_INPUTS.ATTRIBUTE13%TYPE := NULL,
29: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := NULL,
30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:

Line 34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

30: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := NULL,
31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS
38: where FORMULA_INPUT_ID = x_formula_input_id;

Line 35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

31: X_CREATION_DATE IN CN_FORMULA_INPUTS.CREATION_DATE%TYPE := SYSDATE,
32: X_CREATED_BY IN CN_FORMULA_INPUTS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
33: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
34: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
35: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
36:
37: cursor C is select formula_input_id from CN_FORMULA_INPUTS
38: where FORMULA_INPUT_ID = x_formula_input_id;
39:

Line 182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

178: X_ATTRIBUTE14 IN CN_FORMULA_INPUTS.ATTRIBUTE14%TYPE := CN_API.G_MISS_CHAR,
179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:
185: BEGIN
186: update CN_FORMULA_INPUTS set

Line 183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS

179: X_ATTRIBUTE15 IN CN_FORMULA_INPUTS.ATTRIBUTE15%TYPE := CN_API.G_MISS_CHAR,
180: X_OBJECT_VERSION_NUMBER IN CN_FORMULA_INPUTS.OBJECT_VERSION_NUMBER%TYPE,
181: X_LAST_UPDATE_DATE IN CN_FORMULA_INPUTS.LAST_UPDATE_DATE%TYPE := SYSDATE,
182: X_LAST_UPDATED_BY IN CN_FORMULA_INPUTS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
183: X_LAST_UPDATE_LOGIN IN CN_FORMULA_INPUTS.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.LOGIN_ID) IS
184:
185: BEGIN
186: update CN_FORMULA_INPUTS set
187: CALC_SQL_EXP_ID = Decode(X_CALC_SQL_EXP_ID, fnd_api.g_miss_num, calc_sql_exp_id, x_calc_sql_exp_id),