3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_CALC_POPULATE_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvcpopb.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) := 'cnvcpopb.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: g_calc_type VARCHAR2(30);
13: g_org_id NUMBER;
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: g_calc_type VARCHAR2(30);
13: g_org_id NUMBER;
14:
500: 'ROLL',
501: cl.processed_date,
502: cl.processed_period_id,
503: cl.trx_type,
504: fnd_global.user_id,
505: sysdate,
506: g_org_id,
507: 0
508: from cn_commission_lines_all cl