DBA Data[Home] [Help]

APPS.CZ_IMP_AC_KRS dependencies on CZ_IMP_USER_GROUP

Line 1273: SELECT DECODE(x_usesurr_usergroup,0, GROUP_NAME,1,USER_STR03), ROWID FROM CZ_IMP_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, ROWID;

1269: ) IS
1270: BEGIN
1271: DECLARE
1272: CURSOR c_imp_usergroup(x_usesurr_usergroup PLS_INTEGER) IS
1273: SELECT DECODE(x_usesurr_usergroup,0, GROUP_NAME,1,USER_STR03), ROWID FROM CZ_IMP_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, ROWID;
1274:
1275:
1276: /* cursor's data found indicators */
1277: sImpName CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;

Line 1277: sImpName CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;

1273: SELECT DECODE(x_usesurr_usergroup,0, GROUP_NAME,1,USER_STR03), ROWID FROM CZ_IMP_USER_GROUP WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, ROWID;
1274:
1275:
1276: /* cursor's data found indicators */
1277: sImpName CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1278: nGroupId CZ_IMP_USER_GROUP.USER_GROUP_ID%TYPE;
1279: sLastFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1280: sThisFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1281: sRecStatus CZ_IMP_USER_GROUP.REC_STATUS%TYPE;

Line 1278: nGroupId CZ_IMP_USER_GROUP.USER_GROUP_ID%TYPE;

1274:
1275:
1276: /* cursor's data found indicators */
1277: sImpName CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1278: nGroupId CZ_IMP_USER_GROUP.USER_GROUP_ID%TYPE;
1279: sLastFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1280: sThisFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1281: sRecStatus CZ_IMP_USER_GROUP.REC_STATUS%TYPE;
1282: sDisposition CZ_IMP_USER_GROUP.DISPOSITION%TYPE;

Line 1279: sLastFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;

1275:
1276: /* cursor's data found indicators */
1277: sImpName CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1278: nGroupId CZ_IMP_USER_GROUP.USER_GROUP_ID%TYPE;
1279: sLastFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1280: sThisFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1281: sRecStatus CZ_IMP_USER_GROUP.REC_STATUS%TYPE;
1282: sDisposition CZ_IMP_USER_GROUP.DISPOSITION%TYPE;
1283: /* Column Vars */

Line 1280: sThisFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;

1276: /* cursor's data found indicators */
1277: sImpName CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1278: nGroupId CZ_IMP_USER_GROUP.USER_GROUP_ID%TYPE;
1279: sLastFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1280: sThisFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1281: sRecStatus CZ_IMP_USER_GROUP.REC_STATUS%TYPE;
1282: sDisposition CZ_IMP_USER_GROUP.DISPOSITION%TYPE;
1283: /* Column Vars */
1284: x_imp_usergroup_f BOOLEAN:=FALSE;

Line 1281: sRecStatus CZ_IMP_USER_GROUP.REC_STATUS%TYPE;

1277: sImpName CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1278: nGroupId CZ_IMP_USER_GROUP.USER_GROUP_ID%TYPE;
1279: sLastFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1280: sThisFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1281: sRecStatus CZ_IMP_USER_GROUP.REC_STATUS%TYPE;
1282: sDisposition CZ_IMP_USER_GROUP.DISPOSITION%TYPE;
1283: /* Column Vars */
1284: x_imp_usergroup_f BOOLEAN:=FALSE;
1285: x_onl_usergroup_groupid_f BOOLEAN:=FALSE;

Line 1282: sDisposition CZ_IMP_USER_GROUP.DISPOSITION%TYPE;

1278: nGroupId CZ_IMP_USER_GROUP.USER_GROUP_ID%TYPE;
1279: sLastFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1280: sThisFSK CZ_IMP_USER_GROUP.GROUP_NAME%TYPE;
1281: sRecStatus CZ_IMP_USER_GROUP.REC_STATUS%TYPE;
1282: sDisposition CZ_IMP_USER_GROUP.DISPOSITION%TYPE;
1283: /* Column Vars */
1284: x_imp_usergroup_f BOOLEAN:=FALSE;
1285: x_onl_usergroup_groupid_f BOOLEAN:=FALSE;
1286: x_error BOOLEAN:=FALSE;

Line 1383: UPDATE CZ_IMP_USER_GROUP SET

1379: END IF;
1380: END;
1381: END IF;
1382:
1383: UPDATE CZ_IMP_USER_GROUP SET
1384: GROUP_NAME=DECODE(sDISPOSITION,'R',GROUP_NAME,sImpName),
1385: USER_GROUP_ID=DECODE(sDISPOSITION,'R',USER_GROUP_ID,'I',
1386: nNextValue+nAllocateCounter,nGroupId),
1387: DISPOSITION=sDisposition, REC_STATUS=sRecStatus