APPS.CZ_IMP_SINGLE dependencies on DUAL

Line 3213: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;

3209: BEGIN
3210:
3211: IF(inCopyRootModel = '1')THEN
3212:
3213: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3214:
3215: INSERT INTO CZ_XFR_PROJECT_BILLS
3216: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3217: source_server)

Line 3219: FROM DUAL;

3215: INSERT INTO CZ_XFR_PROJECT_BILLS
3216: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3217: source_server)
3218: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3219: FROM DUAL;
3220:
3221: ELSE
3222:
3223: IF(inRefreshModelId IS NULL OR inRefreshModelId = -1)THEN

Line 3251: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;

3247: WHERE model_ps_node_id = nModelId;
3248:
3249: ELSE
3250:
3251: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3252:
3253: INSERT INTO CZ_XFR_PROJECT_BILLS
3254: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3255: source_server)

Line 3257: FROM DUAL;

3253: INSERT INTO CZ_XFR_PROJECT_BILLS
3254: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3255: source_server)
3256: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3257: FROM DUAL;
3258:
3259: END IF;
3260:
3261: ELSE

Line 3269: FROM DUAL WHERE NOT EXISTS

3265: INSERT INTO CZ_XFR_PROJECT_BILLS
3266: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3267: source_server)
3268: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3269: FROM DUAL WHERE NOT EXISTS
3270: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = inRefreshModelId);
3271:
3272: UPDATE cz_xfr_project_bills SET
3273: deleted_flag = '0',

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

3593: allowDecimalOptionClass := 0;
3594: END;
3595:
3596: BEGIN
3597: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;
3598: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
3599: VALUES (genRun_ID,SYSDATE,SYSDATE,'0');
3600: x_run_id := genRun_ID;
3601: EXCEPTION

Line 3640: INTO dDateFormat FROM DUAL;

3636: END;
3637:
3638: SELECT DECODE(SUBSTR(sVersion,1,INSTR(sVersion,'.',1,2)-1),
3639: '11.5','YYYY/MM/DD HH24:MI','DD-MON-RR HH24:MI')
3640: INTO dDateFormat FROM DUAL;
3641:
3642: BEGIN
3643:
3644: v_settings_id := 'COMMITSIZE';