APPS.CZ_IMP_AC_KRS dependencies on CZ_END_USERS

Line 791: CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_END_USERS',inXFR_GROUP);

787: nUpdateCount PLS_INTEGER:=0; /*Updates */
788: nFailed PLS_INTEGER:=0; /*Failed records */
789: nDups PLS_INTEGER:=0; /*Duplicate records */
790: x_usesurr_enduser PLS_INTEGER:= /*Use surrogates */
791: CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_END_USERS',inXFR_GROUP);
792:
793: thisRowId ROWID;
794:
795: BEGIN

Line 831: SELECT END_USER_ID FROM CZ_END_USERS WHERE LOGIN_NAME=sFSKENDUSER;

827: CLOSE c_onl_CUSTOMER_CUSTOMERid;
828: END;
829: DECLARE
830: CURSOR c_onl_enduser_enduserid IS
831: SELECT END_USER_ID FROM CZ_END_USERS WHERE LOGIN_NAME=sFSKENDUSER;
832: BEGIN
833: OPEN c_onl_enduser_enduserid ;
834: nOnlEnduserId:=NULL;
835: FETCH c_onl_enduser_enduserid INTO nOnlenduserId;

Line 1007: SELECT END_USER_ID FROM CZ_END_USERS WHERE ORIG_SYS_REF=sImpOrigSysRef;

1003:
1004: /* Check if this is an insert or update */
1005: DECLARE
1006: CURSOR c_onl_enduser_userid IS
1007: SELECT END_USER_ID FROM CZ_END_USERS WHERE ORIG_SYS_REF=sImpOrigSysRef;
1008: BEGIN
1009: OPEN c_onl_enduser_userid ;
1010: nUserId:=NULL;
1011: FETCH c_onl_enduser_userid INTO nUserId;

Line 1043: SELECT CZ_END_USERS_S.NEXTVAL INTO nNextValue FROM DUAL;

1039: nInsertCount:=nInsertCount+1;
1040: nAllocateCounter:=nAllocateCounter+1;
1041: IF(nAllocateCounter=nAllocateBlock)THEN
1042: nAllocateCounter:=0;
1043: SELECT CZ_END_USERS_S.NEXTVAL INTO nNextValue FROM DUAL;
1044: END IF;
1045: END IF;
1046: END;
1047: END IF;

Line 1121: x_usesurr_enduser PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_END_USERS',inXFR_GROUP);

1117: nInsertCount PLS_INTEGER:=0; /*Inserts */
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:

Line 1152: SELECT END_USER_ID FROM CZ_END_USERS WHERE ORIG_SYS_REF=sFSKENDUSER;

1148: EXIT WHEN NOT x_imp_endusergroup_f;
1149:
1150: DECLARE
1151: CURSOR c_onl_enduser_userid IS
1152: SELECT END_USER_ID FROM CZ_END_USERS WHERE ORIG_SYS_REF=sFSKENDUSER;
1153: BEGIN
1154: OPEN c_onl_enduser_userid;
1155: nOnlFSKUserId:=NULL;
1156: FETCH c_onl_enduser_userid INTO nOnlFSKUserId;