3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_OVER_ASSIGN_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvoasgb.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvoasgb.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
12: TYPE quota_amount_rec_type IS RECORD
13: ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
12: TYPE quota_amount_rec_type IS RECORD
13: ( quota_category_id cn_srp_quota_cates.quota_category_id%TYPE,
14: quota_amount cn_srp_quota_cates.amount%TYPE,