APPS.CZ_IMP_AC_KRS dependencies on CZ_USER_GROUPS

Line 1122: x_usesurr_usergroup PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_USER_GROUPS',inXFR_GROUP);

1118: nUpdateCount PLS_INTEGER:=0; /*Updates */
1119: nFailed PLS_INTEGER:=0; /*Failed records */
1120: nDups PLS_INTEGER:=0; /*Duplicate records */
1121: x_usesurr_enduser PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_END_USERS',inXFR_GROUP);
1122: x_usesurr_usergroup PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_USER_GROUPS',inXFR_GROUP);
1123:
1124: thisRowId ROWID;
1125:
1126: BEGIN

Line 1162: SELECT USER_GROUP_ID FROM CZ_USER_GROUPS WHERE GROUP_NAME=sFSKUSERGROUP;

1158: CLOSE c_onl_enduser_userid;
1159: END;
1160: DECLARE
1161: CURSOR c_onl_usergroup_groupid IS
1162: SELECT USER_GROUP_ID FROM CZ_USER_GROUPS WHERE GROUP_NAME=sFSKUSERGROUP;
1163: BEGIN
1164: OPEN c_onl_usergroup_groupid ;
1165: nOnlFSKGroupId:=NULL;
1166: FETCH c_onl_usergroup_groupid INTO nOnlFSKGroupId;

Line 1295: CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_USER_GROUPS',inXFR_GROUP);

1291: nUpdateCount PLS_INTEGER:=0; /*Updates */
1292: nFailed PLS_INTEGER:=0; /*Failed records */
1293: nDups PLS_INTEGER:=0; /*Duplicate records */
1294: x_usesurr_usergroup PLS_INTEGER:= /*Use surrogates */
1295: CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_USER_GROUPS',inXFR_GROUP);
1296: nAllocateBlock PLS_INTEGER:=1;
1297: nAllocateCounter PLS_INTEGER;
1298: nNextValue NUMBER;
1299:

Line 1336: SELECT user_GROUP_ID FROM CZ_USER_GROUPS WHERE group_NAME=sImpName;

1332:
1333: /* Check if this is an insert or update */
1334: DECLARE
1335: CURSOR c_onl_usergroup_groupid IS
1336: SELECT user_GROUP_ID FROM CZ_USER_GROUPS WHERE group_NAME=sImpName;
1337: BEGIN
1338: OPEN c_onl_usergroup_groupid ;
1339: nGroupId:=NULL;
1340: FETCH c_onl_usergroup_groupid INTO nGroupId;

Line 1377: SELECT CZ_USER_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;

1373: nInsertCount:=nInsertCount+1;
1374: nAllocateCounter:=nAllocateCounter+1;
1375: IF(nAllocateCounter=nAllocateBlock)THEN
1376: nAllocateCounter:=0;
1377: SELECT CZ_USER_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;
1378: END IF;
1379: END IF;
1380: END;
1381: END IF;