1: PACKAGE BODY CN_ROLE_PLANS_PKG AS
2: /* $Header: cntrlplb.pls 120.0 2005/07/13 00:41:51 chanthon noship $ */
3:
4: G_LAST_UPDATE_DATE DATE := sysdate;
5: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
6: G_CREATION_DATE DATE := sysdate;
7: G_CREATED_BY NUMBER := fnd_global.user_id;
8: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
9:
3:
4: G_LAST_UPDATE_DATE DATE := sysdate;
5: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
6: G_CREATION_DATE DATE := sysdate;
7: G_CREATED_BY NUMBER := fnd_global.user_id;
8: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
9:
10:
11: procedure INSERT_ROW
4: G_LAST_UPDATE_DATE DATE := sysdate;
5: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
6: G_CREATION_DATE DATE := sysdate;
7: G_CREATED_BY NUMBER := fnd_global.user_id;
8: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
9:
10:
11: procedure INSERT_ROW
12: (X_ROWID IN OUT NOCOPY VARCHAR2, -- required