4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_AGGRT_TRX_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnagtrxb.pls';
6:
7: G_LAST_UPDATE_DATE DATE := sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
12:
6:
7: G_LAST_UPDATE_DATE DATE := sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
12:
13: G_ROWID VARCHAR2(30);
14: G_PROGRAM_TYPE VARCHAR2(30);
7: G_LAST_UPDATE_DATE DATE := sysdate;
8: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
9: G_CREATION_DATE DATE := sysdate;
10: G_CREATED_BY NUMBER := fnd_global.user_id;
11: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
12:
13: G_ROWID VARCHAR2(30);
14: G_PROGRAM_TYPE VARCHAR2(30);
15: g_system_rollup_flag VARCHAR2(1);