8: X_COMMENT_TEXT in VARCHAR2,
9: X_COMMENTED_BY in NUMBER,
10: X_COMMENT_DATE in DATE,
11: X_CREATION_DATE in DATE DEFAULT sysdate,
12: X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
13: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
14: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
15: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
16: );
10: X_COMMENT_DATE in DATE,
11: X_CREATION_DATE in DATE DEFAULT sysdate,
12: X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
13: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
14: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
15: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
16: );
17:
18: procedure UPDATE_ROW (
11: X_CREATION_DATE in DATE DEFAULT sysdate,
12: X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
13: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
14: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
15: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
16: );
17:
18: procedure UPDATE_ROW (
19: X_COMMENT_ID in NUMBER,
21: X_COMMENT_TEXT in VARCHAR2,
22: X_COMMENTED_BY in NUMBER,
23: X_COMMENT_DATE in DATE,
24: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
25: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
26: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
27: );
28:
29: procedure DELETE_ROW (
22: X_COMMENTED_BY in NUMBER,
23: X_COMMENT_DATE in DATE,
24: X_LAST_UPDATE_DATE in DATE DEFAULT sysdate,
25: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
26: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id
27: );
28:
29: procedure DELETE_ROW (
30: X_COMMENT_ID in NUMBER