23: USAGE_TYPE,
24: CREATION_DATE
25: ) values
26: (
27: FND_GLOBAL.LOGIN_ID,
28: 1,
29: SYSDATE,
30: FND_GLOBAL.USER_ID,
31: FND_GLOBAL.USER_ID,
26: (
27: FND_GLOBAL.LOGIN_ID,
28: 1,
29: SYSDATE,
30: FND_GLOBAL.USER_ID,
31: FND_GLOBAL.USER_ID,
32: X_LIFECYCLE_USAGE_ID,
33: X_LIFECYCLE_ID,
34: X_USAGE_TYPE,
27: FND_GLOBAL.LOGIN_ID,
28: 1,
29: SYSDATE,
30: FND_GLOBAL.USER_ID,
31: FND_GLOBAL.USER_ID,
32: X_LIFECYCLE_USAGE_ID,
33: X_LIFECYCLE_ID,
34: X_USAGE_TYPE,
35: SYSDATE
89: LIFECYCLE_ID = X_LIFECYCLE_ID,
90: USAGE_TYPE = X_USAGE_TYPE,
91: LIFECYCLE_USAGE_ID = X_LIFECYCLE_USAGE_ID,
92: LAST_UPDATE_DATE = SYSDATE,
93: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
94: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
95: where LIFECYCLE_USAGE_ID = X_LIFECYCLE_USAGE_ID;
96:
97: if (sql%notfound) then
90: USAGE_TYPE = X_USAGE_TYPE,
91: LIFECYCLE_USAGE_ID = X_LIFECYCLE_USAGE_ID,
92: LAST_UPDATE_DATE = SYSDATE,
93: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
94: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
95: where LIFECYCLE_USAGE_ID = X_LIFECYCLE_USAGE_ID;
96:
97: if (sql%notfound) then
98: raise no_data_found;