37: X_STATUS_LIST_ID,
38: 1,
39: X_PROJECT_STATUS_CODE,
40: sysdate,
41: fnd_global.user_id,
42: sysdate,
43: fnd_global.user_id,
44: fnd_global.user_id,
45: X_STATUS_LIST_ITEM_ID);
39: X_PROJECT_STATUS_CODE,
40: sysdate,
41: fnd_global.user_id,
42: sysdate,
43: fnd_global.user_id,
44: fnd_global.user_id,
45: X_STATUS_LIST_ITEM_ID);
46:
47: open c;
40: sysdate,
41: fnd_global.user_id,
42: sysdate,
43: fnd_global.user_id,
44: fnd_global.user_id,
45: X_STATUS_LIST_ITEM_ID);
46:
47: open c;
48: fetch c into l_rowid;
106: RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER,
107: PROJECT_STATUS_CODE = X_PROJECT_STATUS_CODE,
108: STATUS_LIST_ITEM_ID = X_STATUS_LIST_ITEM_ID,
109: LAST_UPDATE_DATE = sysdate,
110: LAST_UPDATED_BY = fnd_global.user_id,
111: LAST_UPDATE_LOGIN = fnd_global.user_id,
112: CREATION_DATE = X_CREATION_DATE,
113: CREATED_BY = X_CREATED_BY
114: where STATUS_LIST_ITEM_ID = X_STATUS_LIST_ITEM_ID;
107: PROJECT_STATUS_CODE = X_PROJECT_STATUS_CODE,
108: STATUS_LIST_ITEM_ID = X_STATUS_LIST_ITEM_ID,
109: LAST_UPDATE_DATE = sysdate,
110: LAST_UPDATED_BY = fnd_global.user_id,
111: LAST_UPDATE_LOGIN = fnd_global.user_id,
112: CREATION_DATE = X_CREATION_DATE,
113: CREATED_BY = X_CREATED_BY
114: where STATUS_LIST_ITEM_ID = X_STATUS_LIST_ITEM_ID;
115: