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 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 750: from dual where not exists

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

Line 879: 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;

875:
876: CZ_ORAAPPS_INTEGRATE.mERRBUF := '';
877: CZ_ORAAPPS_INTEGRATE.mRETCODE := 0;
878:
879: 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;
880:
881: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
882: WHERE ORGANIZATION_CODE = sOrg_ID;
883: