APPS.CZ_IMP_ALL dependencies on DUAL

Line 227: SELECT genRun_ID,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS

223:
224: IF(inRun_ID IS NOT NULL)THEN
225: genRun_ID:=inRun_ID;
226: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
227: SELECT genRun_ID,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
228: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=genRun_ID);
229: UPDATE CZ_XFR_RUN_INFOS SET
230: STARTED=SYSDATE,LAST_ACTIVITY=SYSDATE,COMPLETED='0'
231: WHERE RUN_ID=genRun_ID;

Line 249: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;

245: END;
246: END LOOP;
247: CLOSE C_IMPORT_ORDER;
248: ELSE
249: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;
250: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
251: SELECT genRun_ID,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
252: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=genRun_ID);
253: UPDATE CZ_XFR_RUN_INFOS SET

Line 251: SELECT genRun_ID,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS

247: CLOSE C_IMPORT_ORDER;
248: ELSE
249: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;
250: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
251: SELECT genRun_ID,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
252: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=genRun_ID);
253: UPDATE CZ_XFR_RUN_INFOS SET
254: STARTED=SYSDATE,LAST_ACTIVITY=SYSDATE,COMPLETED='0'
255: WHERE RUN_ID=genRun_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 753: from dual where not exists

749:
750: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,
751: copy_addl_child_models,source_server)
752: select nTop_ID,nOrg_ID,'0','OPTIONAL',cz_xfr_project_bills_s.NEXTVAL,COPY_CHILD_MODELS,server_id
753: from dual where not exists
754: (select 1 from cz_xfr_project_bills where organization_id=nOrg_ID and
755: top_item_id=nTop_ID and explosion_type='OPTIONAL' and source_server = server_id);
756: update cz_xfr_project_bills set deleted_flag='0',copy_addl_child_models = COPY_CHILD_MODELS
757: where organization_id=nOrg_ID and

Line 882: SELECT DECODE(COPY_CHILD_MODELS,'Y','0','N','1','YES','0','NO','1','TRUE','0','FALSE','1','T','0','F','1','1','1','0') into v_copy_child_models from dual;

878:
879: CZ_ORAAPPS_INTEGRATE.mERRBUF := '';
880: CZ_ORAAPPS_INTEGRATE.mRETCODE := 0;
881:
882: SELECT DECODE(COPY_CHILD_MODELS,'Y','0','N','1','YES','0','NO','1','TRUE','0','FALSE','1','T','0','F','1','1','1','0') into v_copy_child_models from dual;
883:
884: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
885: WHERE ORGANIZATION_CODE = sOrg_ID;
886:

Line 953: SELECT DECODE(COPY_CHILD_MODELS,'Y','0','N','1','YES','0','NO','1','TRUE','0','FALSE','1','T','0','F','1','1','1','0') into v_copy_child_models from dual;

949:
950: CZ_ORAAPPS_INTEGRATE.mERRBUF := '';
951: CZ_ORAAPPS_INTEGRATE.mRETCODE := 0;
952:
953: SELECT DECODE(COPY_CHILD_MODELS,'Y','0','N','1','YES','0','NO','1','TRUE','0','FALSE','1','T','0','F','1','1','1','0') into v_copy_child_models from dual;
954:
955: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
956: WHERE ORGANIZATION_CODE = sOrg_ID;
957: