APPS.CZ_IMP_AC_KRS dependencies on CZ_CUSTOMERS

Line 101: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS WHERE ORIG_SYS_REF= sFSKcustomer;

97: END;
98:
99: DECLARE
100: CURSOR c_onl_customer_customerid IS
101: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS WHERE ORIG_SYS_REF= sFSKcustomer;
102: BEGIN
103: OPEN c_onl_customer_customerid;
104: nOnlcustomerId:=NULL;
105: FETCH c_onl_customer_customerid INTO nOnlcustomerId;

Line 295: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS

291: EXIT WHEN NOT x_imp_CUSTOMER_f;
292: /* Check Online Dbase */
293: DECLARE
294: CURSOR c_onl_CUSTOMER IS
295: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS
296: WHERE ORIG_SYS_REF=sImpOrigSysref;
297: BEGIN
298: OPEN c_onl_CUSTOMER;
299: nOnlCUSTOMERId:=NULL;

Line 378: SELECT CZ_CUSTOMERS_S.NEXTVAL INTO nNextValue FROM DUAL;

374: nInsertCount:=nInsertCount+1;
375: nAllocateCounter:=nAllocateCounter+1;
376: IF(nAllocateCounter=nAllocateBlock)THEN
377: nAllocateCounter:=0;
378: SELECT CZ_CUSTOMERS_S.NEXTVAL INTO nNextValue FROM DUAL;
379: END IF;
380: END IF;
381: END;
382: END IF;

Line 499: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS WHERE ORIG_SYS_REF=sFSKCUSTOMER11;

495: CLOSE c_onl_address_addressid;
496: END;
497: DECLARE
498: CURSOR c_onl_CUSTOMER_CUSTOMERid IS
499: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS WHERE ORIG_SYS_REF=sFSKCUSTOMER11;
500: BEGIN
501: OPEN c_onl_CUSTOMER_CUSTOMERid ;
502: nOnlFSKCUSTOMERId:=NULL;
503: FETCH c_onl_CUSTOMER_CUSTOMERid INTO nOnlFSKCUSTOMERId;

Line 821: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS WHERE ORIG_SYS_REF=sFSKCUSTOMER;

817: EXIT WHEN NOT x_imp_CUSTOMERenduser_f;
818:
819: DECLARE
820: CURSOR c_onl_CUSTOMER_CUSTOMERid IS
821: SELECT CUSTOMER_ID FROM CZ_CUSTOMERS WHERE ORIG_SYS_REF=sFSKCUSTOMER;
822: BEGIN
823: OPEN c_onl_CUSTOMER_CUSTOMERid;
824: nOnlCUSTOMERId:=NULL;
825: FETCH c_onl_CUSTOMER_CUSTOMERid INTO nOnlCUSTOMERId;