278: l_dummy NUMBER;
279:
280: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';
281: L_LAST_UPDATE_DATE DATE := sysdate;
282: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
283: L_CREATION_DATE DATE := sysdate;
284: L_CREATED_BY NUMBER := fnd_global.user_id;
285: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
286: L_ROWID VARCHAR2(30);
280: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';
281: L_LAST_UPDATE_DATE DATE := sysdate;
282: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
283: L_CREATION_DATE DATE := sysdate;
284: L_CREATED_BY NUMBER := fnd_global.user_id;
285: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
286: L_ROWID VARCHAR2(30);
287: L_PROGRAM_TYPE VARCHAR2(30);
288:
281: L_LAST_UPDATE_DATE DATE := sysdate;
282: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
283: L_CREATION_DATE DATE := sysdate;
284: L_CREATED_BY NUMBER := fnd_global.user_id;
285: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
286: L_ROWID VARCHAR2(30);
287: L_PROGRAM_TYPE VARCHAR2(30);
288:
289: CURSOR get_period_set_id IS
588: x_loading_status OUT NOCOPY VARCHAR2
589: ) IS
590: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';
591: L_LAST_UPDATE_DATE DATE := sysdate;
592: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
593: L_CREATION_DATE DATE := sysdate;
594: L_CREATED_BY NUMBER := fnd_global.user_id;
595: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
596: L_ROWID VARCHAR2(30);
590: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';
591: L_LAST_UPDATE_DATE DATE := sysdate;
592: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
593: L_CREATION_DATE DATE := sysdate;
594: L_CREATED_BY NUMBER := fnd_global.user_id;
595: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
596: L_ROWID VARCHAR2(30);
597: L_PROGRAM_TYPE VARCHAR2(30);
598: L_OBJECT_VERSION_NUMBER NUMBER;
591: L_LAST_UPDATE_DATE DATE := sysdate;
592: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
593: L_CREATION_DATE DATE := sysdate;
594: L_CREATED_BY NUMBER := fnd_global.user_id;
595: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
596: L_ROWID VARCHAR2(30);
597: L_PROGRAM_TYPE VARCHAR2(30);
598: L_OBJECT_VERSION_NUMBER NUMBER;
599:
1343: x_loading_status OUT NOCOPY VARCHAR2
1344: ) IS
1345: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';
1346: L_LAST_UPDATE_DATE DATE := sysdate;
1347: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1348: L_CREATION_DATE DATE := sysdate;
1349: L_CREATED_BY NUMBER := fnd_global.user_id;
1350: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1351: L_ROWID VARCHAR2(30);
1345: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';
1346: L_LAST_UPDATE_DATE DATE := sysdate;
1347: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1348: L_CREATION_DATE DATE := sysdate;
1349: L_CREATED_BY NUMBER := fnd_global.user_id;
1350: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1351: L_ROWID VARCHAR2(30);
1352: L_PROGRAM_TYPE VARCHAR2(30);
1353: L_OBJECT_VERSION_NUMBER NUMBER;
1346: L_LAST_UPDATE_DATE DATE := sysdate;
1347: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1348: L_CREATION_DATE DATE := sysdate;
1349: L_CREATED_BY NUMBER := fnd_global.user_id;
1350: L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1351: L_ROWID VARCHAR2(30);
1352: L_PROGRAM_TYPE VARCHAR2(30);
1353: L_OBJECT_VERSION_NUMBER NUMBER;
1354: