APPS.CZ_IMP_ALL dependencies on CZ_PRICE_GROUPS_S

Line 502: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=sOrigSysRef WHERE CURRENT OF C_SET_ID;

498: CLOSE C_GET_ID;
499:
500: IF(bIdFound) THEN
501: BEGIN
502: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=sOrigSysRef WHERE CURRENT OF C_SET_ID;
503: EXCEPTION
504: WHEN OTHERS THEN
505: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_BEFORE_START',11276);
506: END;

Line 621: UPDATE CZ_PRICE_GROUPS SET

617: CLOSE C_GET_RELATED;
618:
619: IF(bRelatedFound)THEN
620: BEGIN
621: UPDATE CZ_PRICE_GROUPS SET
622: DESC_TEXT=P_GET_HOST.DESC_TEXT,
623: CURRENCY=P_GET_HOST.CURRENCY,
624: NAME=P_GET_HOST.NAME,
625: USER_NUM01=P_GET_HOST.USER_NUM01,

Line 641: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL

637: LAST_UPDATED_BY=P_GET_HOST.LAST_UPDATED_BY,
638: SECURITY_MASK=P_GET_HOST.SECURITY_MASK,
639: CHECKOUT_USER=P_GET_HOST.CHECKOUT_USER
640: WHERE PRICE_GROUP_ID=nPriceGroupID;
641: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
642: WHERE CURRENT OF C_GET_HOST;
643: EXCEPTION
644: WHEN OTHERS THEN
645: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

Line 652: SELECT CZ_PRICE_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;

648: BEGIN
649: nAllocateCounter:=nAllocateCounter+1;
650: IF(nAllocateCounter=nAllocateBlock)THEN
651: nAllocateCounter:=0;
652: SELECT CZ_PRICE_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;
653: END IF;
654: INSERT INTO CZ_PRICE_GROUPS
655: (PRICE_GROUP_ID,DESC_TEXT,CURRENCY,ORIG_SYS_REF,
656: NAME,USER_NUM01,USER_NUM02,USER_NUM03,USER_NUM04,

Line 670: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL

666: P_GET_HOST.USER_STR03,P_GET_HOST.USER_STR04,P_GET_HOST.DELETED_FLAG,
667: P_GET_HOST.SECURITY_MASK,
668: P_GET_HOST.CHECKOUT_USER,
669: SYSDATE,SYSDATE,1,1);
670: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
671: WHERE CURRENT OF C_GET_HOST;
672: EXCEPTION
673: WHEN OTHERS THEN
674: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);