29: X_CURRENT_FLAG in VARCHAR2,
30: X_INCLUDED_IN_SCORING in VARCHAR2,
31: X_RECORD_VERSION_NUMBER in NUMBER DEFAULT 1,
32: X_CREATION_DATE in DATE DEFAULT sysdate ,
33: X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
34: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
35: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
36: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
37: );
31: X_RECORD_VERSION_NUMBER in NUMBER DEFAULT 1,
32: X_CREATION_DATE in DATE DEFAULT sysdate ,
33: X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
34: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
35: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
36: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
37: );
38:
39: procedure LOCK_ROW (
32: X_CREATION_DATE in DATE DEFAULT sysdate ,
33: X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
34: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
35: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
36: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
37: );
38:
39: procedure LOCK_ROW (
40: X_PERF_TXN_ID in NUMBER,
68: X_CURRENT_FLAG in VARCHAR2,
69: X_INCLUDED_IN_SCORING in VARCHAR2,
70: X_RECORD_VERSION_NUMBER in NUMBER,
71: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
72: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
73: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
74: );
75:
76: procedure DELETE_ROW (
69: X_INCLUDED_IN_SCORING in VARCHAR2,
70: X_RECORD_VERSION_NUMBER in NUMBER,
71: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
72: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
73: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
74: );
75:
76: procedure DELETE_ROW (
77: X_PERF_TXN_ID in NUMBER