APPS.CZ_IMP_ALL dependencies on CZ_PRICE_GROUPS_S

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

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

Line 618: UPDATE CZ_PRICE_GROUPS SET

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

Line 638: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL

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

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

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

Line 667: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL

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