APPS.CZ_IMP_AC_KRS dependencies on CZ_ADDRESSES

Line 112: SELECT ADDRESS_ID FROM CZ_ADDRESSES WHERE ORIG_SYS_REF= sFSKaddress;

108: END;
109:
110: DECLARE
111: CURSOR c_onl_address_addressid IS
112: SELECT ADDRESS_ID FROM CZ_ADDRESSES WHERE ORIG_SYS_REF= sFSKaddress;
113: BEGIN
114: OPEN c_onl_address_addressid;
115: nOnladdressId:=NULL;
116: FETCH c_onl_address_addressid INTO nOnladdressId;

Line 451: CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ADDRESSES',inXFR_GROUP);

447: nUpdateCount PLS_INTEGER:=0; /*Updates */
448: nFailed PLS_INTEGER:=0; /*Failed records */
449: nDups PLS_INTEGER:=0; /*Duplicate records */
450: x_usesurr PLS_INTEGER:= /*Use surrogates */
451: CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ADDRESSES',inXFR_GROUP);
452: nAllocateBlock PLS_INTEGER:=1;
453: nAllocateCounter PLS_INTEGER;
454: nNextValue NUMBER;
455:

Line 489: SELECT ADDRESS_ID FROM CZ_ADDRESSES WHERE ORIG_SYS_REF=sImpOrigSysRef;

485:
486: EXIT WHEN NOT x_imp_address_f;
487: DECLARE
488: CURSOR c_onl_address_addressid IS
489: SELECT ADDRESS_ID FROM CZ_ADDRESSES WHERE ORIG_SYS_REF=sImpOrigSysRef;
490: BEGIN
491: OPEN c_onl_address_addressid;
492: nOnlAddressId:=NULL;
493: FETCH c_onl_address_addressid INTO nOnladdressId;

Line 541: SELECT CZ_ADDRESSES_S.NEXTVAL INTO nNextValue FROM DUAL;

537: nInsertCount:=nInsertCount+1;
538: nAllocateCounter:=nAllocateCounter+1;
539: IF(nAllocateCounter=nAllocateBlock)THEN
540: nAllocateCounter:=0;
541: SELECT CZ_ADDRESSES_S.NEXTVAL INTO nNextValue FROM DUAL;
542: END IF;
543: END IF;
544: END;
545: END IF;

Line 666: SELECT address_id FROM CZ_ADDRESSES WHERE orig_sys_ref=sFSKaddress;

662: END;
663:
664: DECLARE
665: CURSOR c_onl_address_addressid IS
666: SELECT address_id FROM CZ_ADDRESSES WHERE orig_sys_ref=sFSKaddress;
667: BEGIN
668: OPEN c_onl_address_addressid;
669: nOnladdressId:=NULL;
670: FETCH c_onl_address_addressid INTO nOnladdressId;